Details:Entity

TABLE DETAIL REFERENCE: Entity

(USA VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE	RELATES TO
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	16	True	False	False	False	%s
Name	12	VARCHAR	209	True	False	False	False	%s
FullName	12	VARCHAR	209	True	False	False	False	%s
IsActive	-7	BIT	1	True	False	False	False	1 0 true false
ClassRefListID	12	VARCHAR	36	True	False	False	False	%s
ClassRefFullName	12	VARCHAR	209	True	False	False	False	%s
ParentRefListID	12	VARCHAR	36	True	False	False	False	%s
ParentRefFullName	12	VARCHAR	209	True	False	False	False	%s
Sublevel	4	INTEGER	4	True	False	False	False	%11.0f
CompanyName	12	VARCHAR	209	True	False	False	False	%s
Salutation	12	VARCHAR	209	True	False	False	False	%s
FirstName	12	VARCHAR	209	True	False	False	False	%s
MiddleName	12	VARCHAR	209	True	False	False	False	%s
LastName	12	VARCHAR	209	True	False	False	False	%s
JobTitle	12	VARCHAR	209	True	False	False	False	%s
BillAddressAddr1	12	VARCHAR	209	True	False	False	False	%s
BillAddressAddr2	12	VARCHAR	209	True	False	False	False	%s
BillAddressAddr3	12	VARCHAR	209	True	False	False	False	%s
BillAddressAddr4	12	VARCHAR	209	True	False	False	False	%s
BillAddressAddr5	12	VARCHAR	209	True	False	False	False	%s
BillAddressCity	12	VARCHAR	209	True	False	False	False	%s
BillAddressState	12	VARCHAR	209	True	False	False	False	%s
BillAddressPostalCode	12	VARCHAR	209	True	False	False	False	%s
BillAddressCountry	12	VARCHAR	209	True	False	False	False	%s
BillAddressNote	12	VARCHAR	209	True	False	False	False	%s
BillAddressBlockAddr1	12	VARCHAR	209	True	False	False	False	%s
BillAddressBlockAddr2	12	VARCHAR	209	True	False	False	False	%s
BillAddressBlockAddr3	12	VARCHAR	209	True	False	False	False	%s
BillAddressBlockAddr4	12	VARCHAR	209	True	False	False	False	%s
BillAddressBlockAddr5	12	VARCHAR	209	True	False	False	False	%s
ShipAddressAddr1	12	VARCHAR	209	True	False	False	False	%s
ShipAddressAddr2	12	VARCHAR	209	True	False	False	False	%s
ShipAddressAddr3	12	VARCHAR	209	True	False	False	False	%s
ShipAddressAddr4	12	VARCHAR	209	True	False	False	False	%s
ShipAddressAddr5	12	VARCHAR	209	True	False	False	False	%s
ShipAddressCity	12	VARCHAR	209	True	False	False	False	%s
ShipAddressState	12	VARCHAR	209	True	False	False	False	%s
ShipAddressPostalCode	12	VARCHAR	209	True	False	False	False	%s
ShipAddressCountry	12	VARCHAR	209	True	False	False	False	%s
ShipAddressNote	12	VARCHAR	209	True	False	False	False	%s
ShipAddressBlockAddr1	12	VARCHAR	209	True	False	False	False	%s
ShipAddressBlockAddr2	12	VARCHAR	209	True	False	False	False	%s
ShipAddressBlockAddr3	12	VARCHAR	209	True	False	False	False	%s
ShipAddressBlockAddr4	12	VARCHAR	209	True	False	False	False	%s
ShipAddressBlockAddr5	12	VARCHAR	209	True	False	False	False	%s
Phone	12	VARCHAR	209	True	False	False	False	%s
AltPhone	12	VARCHAR	209	True	False	False	False	%s
Fax	12	VARCHAR	209	True	False	False	False	%s
Email	12	VARCHAR	209	True	False	False	False	%s
Cc	12	VARCHAR	209	True	False	False	False	%s
Contact	12	VARCHAR	209	True	False	False	False	%s
AltContac	12	VARCHAR	209	True	False	False	False	%s
AdditionalContactRefContactName	12	VARCHAR	209	True	False	False	False	%s
AdditionalContactRefContactValue	12	VARCHAR	209	True	False	False	False	%s
CustomerTypeRefListID	12	VARCHAR	36	True	False	False	False	%s
CustomerTypeRefFullName	12	VARCHAR	209	True	False	False	False	%s
TermsRefListID	12	VARCHAR	36	True	False	False	False	%s
TermsRefFullName	12	VARCHAR	209	True	False	False	False	%s
SalesRepRefListID	12	VARCHAR	36	True	False	False	False	%s
SalesRepRefFullName	12	VARCHAR	209	True	False	False	False	%s
Balance	3	DECIMAL	18	True	False	False	False	%10.2f
TotalBalance	3	DECIMAL	18	True	False	False	False	%10.2f
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s
SalesTaxCodeRefFullName	12	VARCHAR	209	True	False	False	False	%s
ItemSalesTaxRefListID	12	VARCHAR	36	True	False	False	False	%s
ItemSalesTaxRefFullName	12	VARCHAR	209	True	False	False	False	%s
ResaleNumber	12	VARCHAR	15	True	False	False	False	%s
AccountNumber	12	VARCHAR	99	True	False	False	False	%s
CreditLimit	3	DECIMAL	17	True	False	False	False	%10.2f
PreferredPaymentMethodRefListID	12	VARCHAR	36	True	False	False	False	%s
PreferredPaymentMethodRefFullName	12	VARCHAR	209	True	False	False	False	%s
CreditCardInfoCreditCardNumber	12	VARCHAR	25	True	False	False	False	%s
CreditCardInfoExpirationMonth	4	INTEGER	4	True	False	False	False	%11.0f
CreditCardInfoExpirationYear	4	INTEGER	4	True	False	False	False	%11.0f
CreditCardInfoNameOnCard	12	VARCHAR	41	True	False	False	False	%s
CreditCardInfoCreditCardAddress	12	VARCHAR	41	True	False	False	False	%s
CreditCardInfoCreditCardPostalCode	12	VARCHAR	41	True	False	False	False	%s
JobStatus	12	VARCHAR	10	True	False	False	False	None Pending Awarded InProgress Closed NotAwarded
JobStartDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
JobProjectedEndDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
JobEndDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
JobDesc	12	VARCHAR	99	True	False	False	False	%s
JobTypeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
JobTypeRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
Notes	12	VARCHAR	4095	True	False	False	False	%s
PreferredDeliveryMethod	12	VARCHAR	10	True	False	False	False	None Email Fax
PriceLevelRefListID	12	VARCHAR	36	True	False	False	False	%s
PriceLevelRefFullName	12	VARCHAR	209	True	False	False	False	%s
ExternalGUID	12	VARCHAR	40	True	False	False	False	{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s
CurrencyRefFullName	12	VARCHAR	209	True	False	False	False	%s
Type	12	VARCHAR	20	True	False	False	False	%s

QODBC.com Tools for QuickBooks