Details:Entity

TABLE DETAIL REFERENCE: Entity

(Online 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
EditSequence	12	VARCHAR	10	True	False	False	False	%s
Name	12	VARCHAR	1000	True	False	False	False	%s
FullName	12	VARCHAR	1000	True	False	False	False	%s
ClassRefListID	12	VARCHAR	36	True	False	False	False	%s
ClassRefFullName	12	VARCHAR	1000	True	False	False	False	%s
ParentRefListID	12	VARCHAR	36	True	False	False	False	%s
ParentRefFullName	12	VARCHAR	1000	True	False	False	False	%s
Sublevel	4	INTEGER	4	True	False	False	False	%11.0f
CompanyName	12	VARCHAR	1000	True	False	False	False	%s
Salutation	12	VARCHAR	1000	True	False	False	False	%s
FirstName	12	VARCHAR	1000	True	False	False	False	%s
MiddleName	12	VARCHAR	1000	True	False	False	False	%s
LastName	12	VARCHAR	1000	True	False	False	False	%s
JobTitle	12	VARCHAR	1000	True	False	False	False	%s
BillAddressAddr1	12	VARCHAR	1000	True	False	False	False	%s
BillAddressAddr2	12	VARCHAR	1000	True	False	False	False	%s
BillAddressAddr3	12	VARCHAR	1000	True	False	False	False	%s
BillAddressAddr4	12	VARCHAR	1000	True	False	False	False	%s
BillAddressAddr5	12	VARCHAR	1000	True	False	False	False	%s
BillAddressCity	12	VARCHAR	1000	True	False	False	False	%s
BillAddressState	12	VARCHAR	1000	True	False	False	False	%s
BillAddressPostalCode	12	VARCHAR	1000	True	False	False	False	%s
BillAddressCountry	12	VARCHAR	1000	True	False	False	False	%s
BillAddressNote	12	VARCHAR	1000	True	False	False	False	%s
BillAddressBlockAddr1	12	VARCHAR	1000	True	False	False	False	%s
BillAddressBlockAddr2	12	VARCHAR	1000	True	False	False	False	%s
BillAddressBlockAddr3	12	VARCHAR	1000	True	False	False	False	%s
BillAddressBlockAddr4	12	VARCHAR	1000	True	False	False	False	%s
BillAddressBlockAddr5	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressAddr1	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressAddr2	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressAddr3	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressAddr4	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressAddr5	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressCity	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressState	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressPostalCode	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressCountry	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressNote	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressBlockAddr1	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressBlockAddr2	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressBlockAddr3	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressBlockAddr4	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressBlockAddr5	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressName	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressAddr1	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressAddr2	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressAddr3	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressAddr4	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressAddr5	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressCity	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressState	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressPostalCode	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressCountry	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressNote	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressDefaultShipTo	-7	BIT	1	True	False	False	False	1 0 true false
Phone	12	VARCHAR	1000	True	False	False	False	%s
AltPhone	12	VARCHAR	1000	True	False	False	False	%s
Fax	12	VARCHAR	1000	True	False	False	False	%s
Email	12	VARCHAR	1000	True	False	False	False	%s
Cc	12	VARCHAR	1000	True	False	False	False	%s
Contact	12	VARCHAR	1000	True	False	False	False	%s
AltContac	12	VARCHAR	1000	True	False	False	False	%s
AdditionalContactRefContactName	12	VARCHAR	1000	True	False	False	False	%s
AdditionalContactRefContactValue	12	VARCHAR	1000	True	False	False	False	%s
ContactsRetListID	12	VARCHAR	36	True	False	False	False	%s
ContactsRetTimeCreated	11	TIMESTAMP	16	True	False	False	False	%s
ContactsRetTimeModified	11	TIMESTAMP	16	True	False	False	False	%s
ContactsRetEditSequence	12	VARCHAR	10	True	False	False	False	%s
ContactsRetContact	12	VARCHAR	1000	True	False	False	False	%s
ContactsRetSalutation	12	VARCHAR	1000	True	False	False	False	%s
ContactsRetFirstName	12	VARCHAR	1000	True	False	False	False	%s
ContactsRetMiddleName	12	VARCHAR	1000	True	False	False	False	%s
ContactsRetLastName	12	VARCHAR	1000	True	False	False	False	%s
ContactsRetJobTitle	12	VARCHAR	1000	True	False	False	False	%s
ContactsRetAdditionalContactRefContactName	12	VARCHAR	1000	True	False	False	False	%s
ContactsRetAdditionalContactRefContactValue	12	VARCHAR	1000	True	False	False	False	%s
CustomerTypeRefListID	12	VARCHAR	36	True	False	False	False	%s
CustomerTypeRefFullName	12	VARCHAR	1000	True	False	False	False	%s
TermsRefListID	12	VARCHAR	36	True	False	False	False	%s
TermsRefFullName	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
Balance	3	DECIMAL	15	True	False	False	False	%11.2f
TotalBalance	3	DECIMAL	15	True	False	False	False	%11.2f
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s
SalesTaxCodeRefFullName	12	VARCHAR	1000	True	False	False	False	%s
ItemSalesTaxRefListID	12	VARCHAR	36	True	False	False	False	%s
ItemSalesTaxRefFullName	12	VARCHAR	1000	True	False	False	False	%s
ResaleNumber	12	VARCHAR	16	True	False	False	False	%s
PreferredPaymentMethodRefListID	12	VARCHAR	36	True	False	False	False	%s
PreferredPaymentMethodRefFullName	12	VARCHAR	1000	True	False	False	False	%s
PriceLevelRefListID	12	VARCHAR	36	True	False	False	False	%s
PriceLevelRefFullName	12	VARCHAR	1000	True	False	False	False	%s
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s
CurrencyRefFullName	12	VARCHAR	1000	True	False	False	False	%s
Type	12	VARCHAR	1000	True	False	False	True	%s

QODBC.com Tools for QuickBooks