Customer Table

Back to list of tables.

ColumnData typeData type nameLengthCan be queried?Can be updated?Can be inserted?Mandatory when inserting?FormatRefers ToVersion introduced inEdition available in
ListID12VARCHAR36TrueFalseFalseFalse%sListID1.0US, CA, UK
TimeCreated93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ1.0US, CA, UK
TimeModified93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ1.0US, CA, UK
EditSequence12VARCHAR16TrueFalseFalseFalse%s1.0US, CA, UK
Name12VARCHAR41TrueTrueTrueTrue%s1.0US, CA, UK
FullName12VARCHAR209TrueFalseFalseFalse%s1.0US, CA, UK
IsActive-7BIT2TrueTrueTrueFalse
1
0
true
false
1.0US, CA, UK
ParentRef_ListID12VARCHAR36TrueTrueTrueFalse%s1.0US, CA, UK
ParentRef_FullName12VARCHAR159TrueTrueTrueFalse%s1.0US, CA, UK
ClassRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID12.0US, CA, UK
ClassRef_FullName12VARCHAR209TrueTrueTrueFalse%sFullName12.0US, CA, UK
Sublevel4INTEGER9TrueFalseFalseFalse%11.0f1.0US, CA, UK
CompanyName12VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
Salutation12VARCHAR15TrueTrueTrueFalse%s1.0US, CA, UK
FirstName12VARCHAR25TrueTrueTrueFalse%s1.0US, CA, UK
MiddleName12VARCHAR5TrueTrueTrueFalse%s1.0US, CA, UK
LastName12VARCHAR25TrueTrueTrueFalse%s1.0US, CA, UK
JobTitle12VARCHAR14%s12.0US, CA, UK
BillAddress_Addr112VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
BillAddress_Addr212VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
BillAddress_Addr312VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
BillAddress_Addr412VARCHAR41TrueTrueTrueFalse%s2.0US, CA, UK
BillAddress_Addr512VARCHAR41TrueTrueTrueFalse%s6.0US, CA, UK
BillAddress_City12VARCHAR31TrueTrueTrueFalse%s1.0US, CA, UK
BillAddress_State12VARCHAR21TrueTrueTrueFalse%s1.0US, CA, UK
BillAddress_PostalCode12VARCHAR13TrueTrueTrueFalse%s1.0US, CA, UK
BillAddress_Country12VARCHAR31TrueTrueTrueFalse%s1.0US, CA, UK
BillAddress_Note12VARCHAR41TrueTrueTrueFalse%s6.0US, CA, UK
BillAddressBlock_Addr112VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
BillAddressBlock_Addr212VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
BillAddressBlock_Addr312VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
BillAddressBlock_Addr412VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
BillAddressBlock_Addr512VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
ShipAddress_Addr112VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
ShipAddress_Addr212VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
ShipAddress_Addr312VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
ShipAddress_Addr412VARCHAR41TrueTrueTrueFalse%s2.0US, CA, UK
ShipAddress_Addr512VARCHAR41TrueTrueTrueFalse%s6.0US, CA, UK
ShipAddress_City12VARCHAR31TrueTrueTrueFalse%s1.0US, CA, UK
ShipAddress_State12VARCHAR21TrueTrueTrueFalse%s1.0US, CA, UK
ShipAddress_PostalCode12VARCHAR13TrueTrueTrueFalse%s1.0US, CA, UK
ShipAddress_Country12VARCHAR31TrueTrueTrueFalse%s1.0US, CA, UK
ShipAddress_Note12VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
ShipAddressBlock_Addr112VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
ShipAddressBlock_Addr212VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
ShipAddressBlock_Addr312VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
ShipAddressBlock_Addr412VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
ShipAddressBlock_Addr512VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
Phone12VARCHAR21TrueTrueTrueFalse%s1.0US, CA, UK
AltPhone12VARCHAR21TrueTrueTrueFalse%s1.0US, CA, UK
Fax12VARCHAR21TrueTrueTrueFalse%s1.0US, CA, UK
Email12VARCHAR1023TrueTrueTrueFalse%s1.0US, CA, UK
Cc12VARCHAR1023TrueTrueTrueFalse%s1.0US, CA, UK
Contact12VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
AltContact12VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
AdditionalContactRef_ContactName112VARCHAR4012.0US, CA, UK
AdditionalContactRef_ContactValue112VARCHAR25512.0US, CA, UK
AdditionalContactRef_ContactName212VARCHAR4012.0US, CA, UK
AdditionalContactRef_ContactValue212VARCHAR25512.0US, CA, UK
AdditionalContactRef_ContactName312VARCHAR4012.0US, CA, UK
AdditionalContactRef_ContactValue312VARCHAR25512.0US, CA, UK
AdditionalContactRef_ContactName412VARCHAR4012.0US, CA, UK
AdditionalContactRef_ContactValue412VARCHAR25512.0US, CA, UK
AdditionalContactRef_ContactName512VARCHAR4012.0US, CA, UK
AdditionalContactRef_ContactValue512VARCHAR25512.0US, CA, UK
AdditionalContactRef_ContactName612VARCHAR4012.0US, CA, UK
AdditionalContactRef_ContactValue612VARCHAR25512.0US, CA, UK
AdditionalContactRef_ContactName712VARCHAR4012.0US, CA, UK
AdditionalContactRef_ContactValue712VARCHAR25512.0US, CA, UK
AdditionalContactRef_ContactName812VARCHAR4012.0US, CA, UK
AdditionalContactRef_ContactValue812VARCHAR25512.0US, CA, UK
CustomerTypeRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID1.0US, CA, UK
CustomerTypeRef_FullName12VARCHAR159TrueTrueTrueFalse%sFullName1.0US, CA, UK
TermsRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID1.0US, CA, UK
TermsRef_FullName12VARCHAR31TrueTrueTrueFalse%sName1.0US, CA, UK
SalesRepRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID1.0US, CA, UK
SalesRepRef_FullName12VARCHAR5TrueTrueTrueFalse%sInitial1.0US, CA, UK
OpenBalance2NUMERIC14TrueFalseTrueFalse%10.2f1.0US, CA, UK
Balance2NUMERIC14TrueFalseFalseFalse%10.2f1.0US, CA, UK
TotalBalance2NUMERIC14TrueFalseFalseFalse%10.2f1.0US, CA, UK
OpenBalanceDate91DATE10TrueFalseTrueFalseCCCC-MM-DD1.0US, CA, UK
SalesTaxCodeRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID1.0US, CA, UK
SalesTaxCodeRef_FullName12VARCHAR3TrueTrueTrueFalse%sName1.0US, CA, UK
ItemSalesTaxRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID1.0US, CA, UK
ItemSalesTaxRef_FullName12VARCHAR31TrueTrueTrueFalse%sName1.0US, CA, UK
ResaleNumber12VARCHAR15TrueTrueTrueFalse%s1.0US, CA, UK
AccountNumber12VARCHAR99TrueTrueTrueFalse%s1.0US, CA, UK
CreditLimit2NUMERIC14TrueTrueTrueFalse%10.2f1.0US, CA, UK
PreferredPaymentMethodRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID3.0US, CA, UK
PreferredPaymentMethodRef_FullName12VARCHAR31TrueTrueTrueFalse%sName3.0US, CA, UK
CreditCardInfo_CreditCardNumber12VARCHAR25TrueTrueTrueFalse%s3.0US, CA, UK
CreditCardInfo_ExpirationMonth4INTEGER9TrueTrueTrueFalse%13.0f3.0US, CA, UK
CreditCardInfo_ExpirationYear4INTEGER9TrueTrueTrueFalse%13.0f3.0US, CA, UK
CreditCardInfo_NameOnCard12VARCHAR41TrueTrueTrueFalse%s3.0US, CA, UK
CreditCardInfo_CreditCardAddress12VARCHAR41TrueTrueTrueFalse%s3.0US, CA, UK
CreditCardInfo_CreditCardPostalCode12VARCHAR41TrueTrueTrueFalse%s3.0US, CA, UK
JobStatus12VARCHAR10TrueTrueTrueFalse
None
Pending
Awarded
InProgress
Closed
NotAwarded
3.0US, CA, UK
JobStartDate91DATE10TrueTrueTrueFalseCCCC-MM-DD1.0US, CA, UK
JobProjectedEndDate91DATE10TrueTrueTrueFalseCCCC-MM-DD1.0US, CA, UK
JobEndDate91DATE10TrueTrueTrueFalseCCCC-MM-DD1.0US, CA, UK
JobDesc12VARCHAR99TrueTrueTrueFalse%s1.0US, CA, UK
JobTypeRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID1.0US, CA, UK
JobTypeRef_FullName12VARCHAR159TrueTrueTrueFalse%sFullName1.0US, CA, UK
Notes12VARCHAR4095TrueTrueTrueFalse%s1.0US, CA, UK
PreferredDeliveryMethod12VARCHAR10TrueTrueTrueTrue
None
Email
Fax
12.0US, CA, UK
PriceLevelRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID4.0US, CA, UK
PriceLevelRef_FullName12VARCHAR31TrueTrueTrueFalse%sName4.0US, CA, UK
ExternalGUID12VARCHAR40TrueFalseTrueFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}8.0US, CA, UK
CurrencyRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID8.0US, CA, UK
CurrencyRef_FullName12VARCHAR64TrueTrueTrueFalse%sName8.0US, CA, UK
CFBDay12VARCHAR255TrueTrueTrueFalse%s1.0US, CA, UK
CFContract12VARCHAR255TrueTrueTrueFalse%s1.0US, CA, UK
CFSpousesName12VARCHAR255TrueTrueTrueFalse%s1.0US, CA, UK

Back to list of tables.