Details:Customer

TABLE DETAIL REFERENCE: Customer

(Online VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE	RELATES TO
ListID	12	VARCHAR	36	True	False	False	False	%s	Yes
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
EditSequence	12	VARCHAR	10	True	False	False	False	%s
Name	12	VARCHAR	100	True	True	True	True	%s
FullName	12	VARCHAR	1000	True	False	False	False	%s
IsActive	-7	BIT	1	True	True	False	False	1 0 true false
ParentRefListID	12	VARCHAR	36	True	True	True	False	%s
ParentRefFullName	12	VARCHAR	1000	True	True	True	False	%s
Sublevel	4	INTEGER	4	True	False	False	False	%11.0f
CompanyName	12	VARCHAR	50	True	True	True	False	%s
Salutation	12	VARCHAR	15	True	True	True	False	%s
FirstName	12	VARCHAR	25	True	True	True	False	%s
MiddleName	12	VARCHAR	25	True	True	True	False	%s
LastName	12	VARCHAR	25	True	True	True	False	%s
Suffix	12	VARCHAR	10	True	True	True	False	%s
BillAddressID	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr1	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr2	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr3	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr4	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr5	12	VARCHAR	500	True	True	True	False	%s
BillAddressCity	12	VARCHAR	255	True	True	True	False	%s
BillAddressState	12	VARCHAR	255	True	True	True	False	%s
BillAddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
BillAddressCountry	12	VARCHAR	255	True	True	True	False	%s
BillAddressNote	12	VARCHAR	500	True	True	True	False	%s
ShipAddressID	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr1	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr2	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr3	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr4	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr5	12	VARCHAR	500	True	True	True	False	%s
ShipAddressCity	12	VARCHAR	255	True	True	True	False	%s
ShipAddressState	12	VARCHAR	255	True	True	True	False	%s
ShipAddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
ShipAddressCountry	12	VARCHAR	255	True	True	True	False	%s
ShipAddressNote	12	VARCHAR	500	True	True	True	False	%s
PrintAs	12	VARCHAR	110	True	True	True	False	%s
Phone	12	VARCHAR	21	True	True	True	False	%s
Mobile	12	VARCHAR	21	True	True	True	False	%s
Pager	12	VARCHAR	21	True	True	True	False	%s
AltPhone	12	VARCHAR	21	True	True	True	False	%s
Fax	12	VARCHAR	21	True	True	True	False	%s
Email	12	VARCHAR	100	True	True	True	False	%s
TermsRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TermsRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
Balance	3	DECIMAL	15	True	False	False	False	%11.2f
TotalBalance	3	DECIMAL	15	True	False	False	False	%11.2f
OpenBalance	3	DECIMAL	13	True	False	True	False	%11.2f
OpenBalanceDate	9	DATE	6	True	False	True	False	CCCC-MM-DD
ResaleNumber	12	VARCHAR	16	True	True	True	False	%s
Notes	12	VARCHAR	2000	True	True	True	False	%s
IsStatementWithParent	-7	BIT	1	True	True	True	False	1 0 true false
DeliveryMethod	12	VARCHAR	5	True	True	True	False	Print Fax Email
DefaultTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DefaultTaxCodeRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
Taxable	-7	BIT	1	True	True	True	False	1 0 true false
WebAddressURI	12	VARCHAR	1000	True	True	True	False	%s
Job	-7	BIT	1	True	True	True	False	1 0 true false
PaymentMethodRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PaymentMethodRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
ARAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ARAccountRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TaxExemptionReasonId	12	VARCHAR	5	True	False	False	False	%s
IsProject	-7	BIT	1	True	False	False	False	1 0 true false
BusinessNumber	12	VARCHAR	99	True	False	True	False	%s
GSTIN	12	VARCHAR	99	True	False	True	False	%s
GSTRegistrationType	12	VARCHAR	99	True	False	True	False	%s
IsCISContractor	-7	BIT	1	True	True	True	False	1 0 true false
ClientCompanyId	12	VARCHAR	36	True	True	True	False	%s
ClientEntityId	12	VARCHAR	36	True	True	True	False	%s
OverDueBalance	3	DECIMAL	15	True	False	False	False	%11.2f
Organization	-7	BIT	1	True	True	True	False	1 0 true false
OtherContactInfoType	12	VARCHAR	1000	True	True	True	False	%s
OtherContactInfoTelephone	12	VARCHAR	1000	True	True	True	False	%s
PriceLevelRefListID	12	VARCHAR	36	True	False	False	False	%s
PriceLevelRefFullName	12	VARCHAR	1000	True	False	False	False	%s
RootCustomerRefListID	12	VARCHAR	36	True	False	False	False	%s
RootCustomerRefFullName	12	VARCHAR	1000	True	False	False	False	%s
SalesRepRefListID	12	VARCHAR	36	True	False	False	False	%s
SalesRepRefFullName	12	VARCHAR	1000	True	False	False	False	%s
TotalExpense	3	DECIMAL	15	True	False	False	False	%11.2f
TotalRevenue	3	DECIMAL	15	True	False	False	False	%11.2f
UserId	12	VARCHAR	1000	True	True	True	False	%s
Status	12	VARCHAR	1000	True	True	True	False	%s
CCDetailAmount	4	INTEGER	4	True	False	False	False	%11.0f
CCDetailBillAddrStreet	12	VARCHAR	1000	True	False	False	False	%s
CCDetailExpiryMonth	4	INTEGER	4	True	False	False	False	%11.0f
CCDetailExpiryYear	4	INTEGER	4	True	False	False	False	%11.0f
CCDetailTxnMode	12	VARCHAR	1000	True	False	False	False	%s
CCDetailTxnType	12	VARCHAR	1000	True	False	False	False	%s
CCDetailCommercialCardCode	12	VARCHAR	1000	True	False	False	False	%s
ContactName	12	VARCHAR	1000	True	False	False	False	%s
AltContactName	12	VARCHAR	1000	True	False	False	False	%s
CreditLimit	3	DECIMAL	13	True	True	True	False	%8.2f
CustomerTypeRefListID	12	VARCHAR	36	True	False	False	False	%s
CustomerTypeRefFullName	12	VARCHAR	1000	True	False	False	False	%s
OtherAddrId	12	VARCHAR	36	True	True	True	False	%s
OtherAddr1	12	VARCHAR	100	True	True	True	False	%s
OtherAddr2	12	VARCHAR	100	True	True	True	False	%s
OtherAddr3	12	VARCHAR	100	True	True	True	False	%s
OtherAddr4	12	VARCHAR	100	True	True	True	False	%s
OtherAddr5	12	VARCHAR	100	True	True	True	False	%s
OtherAddrCity	12	VARCHAR	100	True	True	True	False	%s
OtherAddrState	12	VARCHAR	100	True	True	True	False	%s
OtherAddrProvince	12	VARCHAR	100	True	True	True	False	%s
OtherAddrCounty	12	VARCHAR	100	True	True	True	False	%s
OtherAddrPostalCode	12	VARCHAR	100	True	True	True	False	%s
OtherAddrLat	12	VARCHAR	100	True	True	True	False	%s
OtherAddrLong	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoEmailAddress	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoEmailAddressDefault	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoEmailAddressId	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoEmailAddressTag	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoTelephoneNumberAreaCode	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoTelephoneNumberCountryCode	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoTelephoneNumberDeviceType	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoTelephoneNumberDefault	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoTelephoneNumberExchangeCode	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoTelephoneNumberExtension	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoTelephoneNumberTelephone	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoTelephoneNumberId	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoTelephoneNumberTag	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoWebSiteAddressURI	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoWebSiteAddressDefault	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoWebSiteAddressId	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoWebSiteAddressTag	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoGenericContactTypeName	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoGenericContactTypeType	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoGenericContactTypeValue	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoGenericContactTypeDefault	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoGenericContactTypeId	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoGenericContactTypeTag	12	VARCHAR	100	True	True	True	False	%s
UpdateAccountOnTxns	-7	BIT	1	False	True	False	False	1 0 true false

QODBC.com Tools for QuickBooks