TABLE DETAIL REFERENCE:
  
(US VERSION)
FIELD NAME TYPE LENGTH QRY MOD INS REQ INS VALIDATE REL
ListID Varchar 36 True False False N/A String
TimeCreated Timestamp 27 True False False N/A CCCC-MM-DDThh:mm:ssZ
TimeModified Timestamp 27 True False False N/A CCCC-MM-DDThh:mm:ssZ
EditSequence Varchar 16 True False False N/A String
Name Varchar 41 True True True Yes String
FullName Varchar 209 True False False N/A String
IsActive Bit 5 True True True No 1 0 true false
ParentRefListID Varchar 36 True False True No String
ParentRefFullName Varchar 209 True True True No String
Sublevel Integer 13 True False False N/A 11.0
CompanyName Varchar 41 True True True No String
Salutation Varchar 15 True True True No String
FirstName Varchar 25 True True True No String
MiddleName Varchar 5 True True True No String
LastName Varchar 25 True True True No String
BillAddressAddr1 Varchar 41 True True True No String
BillAddressAddr2 Varchar 41 True True True No String
BillAddressAddr3 Varchar 41 True True True No String
BillAddressAddr4 Varchar 41 True True True No String
BillAddressAddr5 Varchar 41 True True True No String
BillAddressCity Varchar 31 True True True No String
BillAddressState Varchar 21 True True True No String
BillAddressPostalCode Varchar 13 True True True No String
BillAddressCountry Varchar 31 True True True No String
BillAddressNote Varchar 41 True True True No String
BillAddressBlockAddr1 Varchar 41 True False False N/A String
BillAddressBlockAddr2 Varchar 41 True False False N/A String
BillAddressBlockAddr3 Varchar 41 True False False N/A String
BillAddressBlockAddr4 Varchar 41 True False False N/A String
BillAddressBlockAddr5 Varchar 41 True False False N/A String
ShipAddressAddr1 Varchar 41 True True True No String
ShipAddressAddr2 Varchar 41 True True True No String
ShipAddressAddr3 Varchar 41 True True True No String
ShipAddressAddr4 Varchar 41 True True True No String
ShipAddressAddr5 Varchar 41 True True True No String
ShipAddressCity Varchar 31 True True True No String
ShipAddressState Varchar 21 True True True No String
ShipAddressPostalCode Varchar 13 True True True No String
ShipAddressCountry Varchar 31 True True True No String
ShipAddressNote Varchar 41 True True True No String
ShipAddressBlockAddr1 Varchar 41 True False False N/A String
ShipAddressBlockAddr2 Varchar 41 True False False N/A String
ShipAddressBlockAddr3 Varchar 41 True False False N/A String
ShipAddressBlockAddr4 Varchar 41 True False False N/A String
ShipAddressBlockAddr5 Varchar 41 True False False N/A String
Phone Varchar 21 True True True No String
AltPhone Varchar 21 True True True No String
Fax Varchar 21 True True True No String
Email Varchar 1023 True True True No String
Contact Varchar 41 True True True No String
AltContact Varchar 41 True True True No String
CustomerTypeRefListID Varchar 36 True False True No String
CustomerTypeRefFullName Varchar 159 True True True No String
TermsRefListID Varchar 36 True False True No String
TermsRefFullName Varchar 31 True True True No String
SalesRepRefListID Varchar 36 True False True No String
SalesRepRefFullName Varchar 5 True True True No String
Balance Decimal 11 True False False N/A 8.2
TotalBalance Decimal 11 True False False N/A 8.2
OpenBalance Decimal 11 True False True No 8.2
OpenBalanceDate Date 10 True False True No CCCC-MM-DD
SalesTaxCodeRefListID Varchar 36 True False True No String
SalesTaxCodeRefFullName Varchar 3 True True True No String
ItemSalesTaxRefListID Varchar 36 True False True No String
ItemSalesTaxRefFullName Varchar 31 True True True No String
ResaleNumber Varchar 15 True True True No String
AccountNumber Varchar 99 True True True No String
CreditLimit Decimal 11 True True True No 8.2
PreferredPaymentMethodRefListID Varchar 36 True False True No String
PreferredPaymentMethodRefFullName Varchar 31 True True True No String
CreditCardInfoCreditCardNumber Varchar 25 True True True No String
CreditCardInfoExpirationMonth Integer 13 True True True No 11.0
CreditCardInfoExpirationYear Integer 13 True True True No 11.0
CreditCardInfoNameOnCard Varchar 41 True True True No String
CreditCardInfoCreditCardAddress Varchar 41 True True True No String
CreditCardInfoCreditCardPostalCode Varchar 41 True True True No String
JobStatus Varchar 10 True True True No None Pending Awarded InProgress Closed NotAwarded
JobStartDate Date 10 True True True No CCCC-MM-DD
JobProjectedEndDate Date 10 True True True No CCCC-MM-DD
JobEndDate Date 10 True True True No CCCC-MM-DD
JobDesc Varchar 99 True True True No String
JobTypeRefListID Varchar 36 True False True No String
JobTypeRefFullName Varchar 159 True True True No String
Notes Varchar 4095 True True True No String
PriceLevelRefListID Varchar 36 True False True No String
PriceLevelRefFullName Varchar 31 True True True No String