Details:Customer

TABLE DETAIL REFERENCE: Customer

(POS VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
ListID	12	VARCHAR	36	True	False	False	False	%s
TimeCreated	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
TimeModified	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
AccountBalance	3	DECIMAL	16	True	False	False	False	%8.5f
AccountLimit	3	DECIMAL	16	True	False	False	False	%8.5f
AmountPastDue	3	DECIMAL	16	True	False	False	False	%8.5f
CompanyName	12	VARCHAR	48	True	True	True	False	%s
CustomerDiscPercent	3	DECIMAL	13	True	True	True	False	%8.2f
CustomerDiscType	12	VARCHAR	10	True	True	True	False	None PriceLevel Percentage
CustomerType	12	VARCHAR	15	True	True	True	False	%s
CustomerID	12	VARCHAR	41	True	True	True	False	%s
DefaultShipAddress	12	VARCHAR	20	True	True	True	False	%s
EMail	12	VARCHAR	99	True	True	True	False	%s
FirstName	12	VARCHAR	30	True	True	True	False	%s
FullName	12	VARCHAR	200	True	False	False	False	%s
IsAcceptingChecks	-7	BIT	1	True	True	True	False	1 0 true false
IsNoShipToBilling	-7	BIT	1	True	True	True	False	1 0 true false
IsOkToEMail	-7	BIT	1	True	True	True	False	1 0 true false
IsRewardsMember	-7	BIT	1	True	True	True	False	1 0 true false
IsUsingChargeAccount	-7	BIT	1	True	True	True	False	1 0 true false
IsUsingWithQB	-7	BIT	1	True	True	True	False	1 0 true false
LastName	12	VARCHAR	30	True	True	True	True	%s
LastSale	9	DATE	6	True	False	False	False	CCCC-MM-DD
Notes	12	VARCHAR	245	True	True	True	False	%s
Phone	12	VARCHAR	40	True	True	True	False	%s
Phone2	12	VARCHAR	40	True	True	True	False	%s
Phone3	12	VARCHAR	40	True	True	True	False	%s
Phone4	12	VARCHAR	40	True	True	True	False	%s
PriceLevelNumber	12	VARCHAR	1	True	True	True	False	1 2 3 4
Salutation	12	VARCHAR	15	True	True	True	False	%s
StoreExchangeStatus	12	VARCHAR	12	True	False	False	False	Modified Sent Acknowledged
TaxCategory	12	VARCHAR	20	True	True	True	False	%s
WebNumber	12	VARCHAR	20	True	True	True	False	%s
BillAddressCity	12	VARCHAR	31	True	True	True	False	%s
BillAddressCountry	12	VARCHAR	31	True	True	True	False	%s
BillAddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
BillAddressState	12	VARCHAR	21	True	True	True	False	%s
BillAddressStreet	12	VARCHAR	41	True	True	True	False	%s
BillAddressStreet2	12	VARCHAR	41	True	True	True	False	%s
CustomFieldOther	12	VARCHAR	30	True	False	False	False	%s
CustomFieldSalesLocation	12	VARCHAR	30	True	True	True	False	%s
CustomFieldSerial	12	VARCHAR	30	True	True	True	False	%s
CustomFieldSerial1	12	VARCHAR	30	True	True	True	False	%s
CustomFieldSerial2	12	VARCHAR	30	True	True	True	False	%s

QODBC.com Tools for QuickBooks