TABLE DETAIL REFERENCE: Entity
(USA VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
Name12 VARCHAR 209TrueFalseFalseFalse%s
FullName12 VARCHAR 209TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ClassRefListID12 VARCHAR 36TrueFalseFalseFalse%s
ClassRefFullName12 VARCHAR 209TrueFalseFalseFalse%s
ParentRefListID12 VARCHAR 36TrueFalseFalseFalse%s
ParentRefFullName12 VARCHAR 209TrueFalseFalseFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f
CompanyName12 VARCHAR 209TrueFalseFalseFalse%s
Salutation12 VARCHAR 209TrueFalseFalseFalse%s
FirstName12 VARCHAR 209TrueFalseFalseFalse%s
MiddleName12 VARCHAR 209TrueFalseFalseFalse%s
LastName12 VARCHAR 209TrueFalseFalseFalse%s
JobTitle12 VARCHAR 209TrueFalseFalseFalse%s
BillAddressAddr112 VARCHAR 209TrueFalseFalseFalse%s
BillAddressAddr212 VARCHAR 209TrueFalseFalseFalse%s
BillAddressAddr312 VARCHAR 209TrueFalseFalseFalse%s
BillAddressAddr412 VARCHAR 209TrueFalseFalseFalse%s
BillAddressAddr512 VARCHAR 209TrueFalseFalseFalse%s
BillAddressCity12 VARCHAR 209TrueFalseFalseFalse%s
BillAddressState12 VARCHAR 209TrueFalseFalseFalse%s
BillAddressPostalCode12 VARCHAR 209TrueFalseFalseFalse%s
BillAddressCountry12 VARCHAR 209TrueFalseFalseFalse%s
BillAddressNote12 VARCHAR 209TrueFalseFalseFalse%s
BillAddressBlockAddr112 VARCHAR 209TrueFalseFalseFalse%s
BillAddressBlockAddr212 VARCHAR 209TrueFalseFalseFalse%s
BillAddressBlockAddr312 VARCHAR 209TrueFalseFalseFalse%s
BillAddressBlockAddr412 VARCHAR 209TrueFalseFalseFalse%s
BillAddressBlockAddr512 VARCHAR 209TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 209TrueFalseFalseFalse%s
ShipAddressAddr212 VARCHAR 209TrueFalseFalseFalse%s
ShipAddressAddr312 VARCHAR 209TrueFalseFalseFalse%s
ShipAddressAddr412 VARCHAR 209TrueFalseFalseFalse%s
ShipAddressAddr512 VARCHAR 209TrueFalseFalseFalse%s
ShipAddressCity12 VARCHAR 209TrueFalseFalseFalse%s
ShipAddressState12 VARCHAR 209TrueFalseFalseFalse%s
ShipAddressPostalCode12 VARCHAR 209TrueFalseFalseFalse%s
ShipAddressCountry12 VARCHAR 209TrueFalseFalseFalse%s
ShipAddressNote12 VARCHAR 209TrueFalseFalseFalse%s
ShipAddressBlockAddr112 VARCHAR 209TrueFalseFalseFalse%s
ShipAddressBlockAddr212 VARCHAR 209TrueFalseFalseFalse%s
ShipAddressBlockAddr312 VARCHAR 209TrueFalseFalseFalse%s
ShipAddressBlockAddr412 VARCHAR 209TrueFalseFalseFalse%s
ShipAddressBlockAddr512 VARCHAR 209TrueFalseFalseFalse%s
Phone12 VARCHAR 209TrueFalseFalseFalse%s
AltPhone12 VARCHAR 209TrueFalseFalseFalse%s
Fax12 VARCHAR 209TrueFalseFalseFalse%s
Email12 VARCHAR 209TrueFalseFalseFalse%s
Cc12 VARCHAR 209TrueFalseFalseFalse%s
Contact12 VARCHAR 209TrueFalseFalseFalse%s
AltContac12 VARCHAR 209TrueFalseFalseFalse%s
AdditionalContactRefContactName12 VARCHAR 209TrueFalseFalseFalse%s
AdditionalContactRefContactValue12 VARCHAR 209TrueFalseFalseFalse%s
CustomerTypeRefListID12 VARCHAR 36TrueFalseFalseFalse%s
CustomerTypeRefFullName12 VARCHAR 209TrueFalseFalseFalse%s
TermsRefListID12 VARCHAR 36TrueFalseFalseFalse%s
TermsRefFullName12 VARCHAR 209TrueFalseFalseFalse%s
SalesRepRefListID12 VARCHAR 36TrueFalseFalseFalse%s
SalesRepRefFullName12 VARCHAR 209TrueFalseFalseFalse%s
Balance3 DECIMAL 15TrueFalseFalseFalse%10.2f
TotalBalance3 DECIMAL 15TrueFalseFalseFalse%10.2f
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s
SalesTaxCodeRefFullName12 VARCHAR 209TrueFalseFalseFalse%s
ItemSalesTaxRefListID12 VARCHAR 36TrueFalseFalseFalse%s
ItemSalesTaxRefFullName12 VARCHAR 209TrueFalseFalseFalse%s
ResaleNumber12 VARCHAR 15TrueFalseFalseFalse%s
AccountNumber12 VARCHAR 99TrueFalseFalseFalse%s
CreditLimit3 DECIMAL 15TrueFalseFalseFalse%10.2f
PreferredPaymentMethodRefListID12 VARCHAR 36TrueFalseFalseFalse%s
PreferredPaymentMethodRefFullName12 VARCHAR 209TrueFalseFalseFalse%s
CreditCardInfoCreditCardNumber12 VARCHAR 25TrueFalseFalseFalse%s
CreditCardInfoExpirationMonth4 INTEGER 4TrueFalseFalseFalse%11.0f
CreditCardInfoExpirationYear4 INTEGER 4TrueFalseFalseFalse%11.0f
CreditCardInfoNameOnCard12 VARCHAR 41TrueFalseFalseFalse%s
CreditCardInfoCreditCardAddress12 VARCHAR 41TrueFalseFalseFalse%s
CreditCardInfoCreditCardPostalCode12 VARCHAR 41TrueFalseFalseFalse%s
JobStatus12 VARCHAR 10TrueFalseFalseFalse
None
Pending
Awarded
InProgress
Closed
NotAwarded
JobStartDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
JobProjectedEndDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
JobEndDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
JobDesc12 VARCHAR 99TrueFalseFalseFalse%s
JobTypeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
JobTypeRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
Notes12 VARCHAR 4095TrueFalseFalseFalse%s
PreferredDeliveryMethod12 VARCHAR 10TrueFalseFalseFalse
None
Email
Fax
PriceLevelRefListID12 VARCHAR 36TrueFalseFalseFalse%s
PriceLevelRefFullName12 VARCHAR 209TrueFalseFalseFalse%s
ExternalGUID12 VARCHAR 40TrueFalseFalseFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s
CurrencyRefFullName12 VARCHAR 209TrueFalseFalseFalse%s
Type12 VARCHAR 20TrueFalseFalseFalse%s