Customer Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
ListID 12 VARCHAR 36 True False False False %s ListID 1.0 US, CA, UK
TimeCreated 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 1.0 US, CA, UK
TimeModified 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 1.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 1.0 US, CA, UK
Name 12 VARCHAR 41 True True True True %s 1.0 US, CA, UK
FullName 12 VARCHAR 209 True False False False %s 1.0 US, CA, UK
IsActive -7 BIT 2 True True True False
1
0
true
false
 1.0 US, CA, UK
ParentRef_ListID 12 VARCHAR 36 True True True False %s 1.0 US, CA, UK
ParentRef_FullName 12 VARCHAR 159 True True True False %s 1.0 US, CA, UK
ClassRef_ListID 12 VARCHAR 36 True True True False %s ListID 12.0 US, CA, UK
ClassRef_FullName 12 VARCHAR 209 True True True False %s FullName 12.0 US, CA, UK
Sublevel 4 INTEGER 9 True False False False %11.0f 1.0 US, CA, UK
CompanyName 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
Salutation 12 VARCHAR 15 True True True False %s 1.0 US, CA, UK
FirstName 12 VARCHAR 25 True True True False %s 1.0 US, CA, UK
MiddleName 12 VARCHAR 5 True True True False %s 1.0 US, CA, UK
LastName 12 VARCHAR 25 True True True False %s 1.0 US, CA, UK
JobTitle 12 VARCHAR 14 %s 12.0 US, CA, UK
BillAddress_Addr1 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
BillAddress_Addr2 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
BillAddress_Addr3 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
BillAddress_Addr4 12 VARCHAR 41 True True True False %s 2.0 US, CA, UK
BillAddress_Addr5 12 VARCHAR 41 True True True False %s 6.0 US, CA, UK
BillAddress_City 12 VARCHAR 31 True True True False %s 1.0 US, CA, UK
BillAddress_State 12 VARCHAR 21 True True True False %s 1.0 US, CA, UK
BillAddress_PostalCode 12 VARCHAR 13 True True True False %s 1.0 US, CA, UK
BillAddress_Country 12 VARCHAR 31 True True True False %s 1.0 US, CA, UK
BillAddress_Note 12 VARCHAR 41 True True True False %s 6.0 US, CA, UK
BillAddressBlock_Addr1 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
BillAddressBlock_Addr2 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
BillAddressBlock_Addr3 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
BillAddressBlock_Addr4 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
BillAddressBlock_Addr5 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
ShipAddress_Addr1 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
ShipAddress_Addr2 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
ShipAddress_Addr3 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
ShipAddress_Addr4 12 VARCHAR 41 True True True False %s 2.0 US, CA, UK
ShipAddress_Addr5 12 VARCHAR 41 True True True False %s 6.0 US, CA, UK
ShipAddress_City 12 VARCHAR 31 True True True False %s 1.0 US, CA, UK
ShipAddress_State 12 VARCHAR 21 True True True False %s 1.0 US, CA, UK
ShipAddress_PostalCode 12 VARCHAR 13 True True True False %s 1.0 US, CA, UK
ShipAddress_Country 12 VARCHAR 31 True True True False %s 1.0 US, CA, UK
ShipAddress_Note 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
ShipAddressBlock_Addr1 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
ShipAddressBlock_Addr2 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
ShipAddressBlock_Addr3 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
ShipAddressBlock_Addr4 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
ShipAddressBlock_Addr5 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
Phone 12 VARCHAR 21 True True True False %s 1.0 US, CA, UK
AltPhone 12 VARCHAR 21 True True True False %s 1.0 US, CA, UK
Fax 12 VARCHAR 21 True True True False %s 1.0 US, CA, UK
Email 12 VARCHAR 1023 True True True False %s 1.0 US, CA, UK
Cc 12 VARCHAR 1023 True True True False %s 1.0 US, CA, UK
Contact 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
AltContact 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
AdditionalContactRef_ContactName1 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue1 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName2 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue2 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName3 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue3 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName4 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue4 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName5 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue5 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName6 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue6 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName7 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue7 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName8 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue8 12 VARCHAR 255 12.0 US, CA, UK
CustomerTypeRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
CustomerTypeRef_FullName 12 VARCHAR 159 True True True False %s FullName 1.0 US, CA, UK
TermsRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
TermsRef_FullName 12 VARCHAR 31 True True True False %s Name 1.0 US, CA, UK
SalesRepRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
SalesRepRef_FullName 12 VARCHAR 5 True True True False %s Initial 1.0 US, CA, UK
OpenBalance 2 NUMERIC 14 True False True False %10.2f 1.0 US, CA, UK
Balance 2 NUMERIC 14 True False False False %10.2f 1.0 US, CA, UK
TotalBalance 2 NUMERIC 14 True False False False %10.2f 1.0 US, CA, UK
OpenBalanceDate 91 DATE 10 True False True False CCCC-MM-DD 1.0 US, CA, UK
SalesTaxCodeRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
SalesTaxCodeRef_FullName 12 VARCHAR 3 True True True False %s Name 1.0 US, CA, UK
ItemSalesTaxRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
ItemSalesTaxRef_FullName 12 VARCHAR 31 True True True False %s Name 1.0 US, CA, UK
ResaleNumber 12 VARCHAR 15 True True True False %s 1.0 US, CA, UK
AccountNumber 12 VARCHAR 99 True True True False %s 1.0 US, CA, UK
CreditLimit 2 NUMERIC 14 True True True False %10.2f 1.0 US, CA, UK
PreferredPaymentMethodRef_ListID 12 VARCHAR 36 True True True False %s ListID 3.0 US, CA, UK
PreferredPaymentMethodRef_FullName 12 VARCHAR 31 True True True False %s Name 3.0 US, CA, UK
CreditCardInfo_CreditCardNumber 12 VARCHAR 25 True True True False %s 3.0 US, CA, UK
CreditCardInfo_ExpirationMonth 4 INTEGER 9 True True True False %13.0f 3.0 US, CA, UK
CreditCardInfo_ExpirationYear 4 INTEGER 9 True True True False %13.0f 3.0 US, CA, UK
CreditCardInfo_NameOnCard 12 VARCHAR 41 True True True False %s 3.0 US, CA, UK
CreditCardInfo_CreditCardAddress 12 VARCHAR 41 True True True False %s 3.0 US, CA, UK
CreditCardInfo_CreditCardPostalCode 12 VARCHAR 41 True True True False %s 3.0 US, CA, UK
JobStatus 12 VARCHAR 10 True True True False
None
Pending
Awarded
InProgress
Closed
NotAwarded
 3.0 US, CA, UK
JobStartDate 91 DATE 10 True True True False CCCC-MM-DD 1.0 US, CA, UK
JobProjectedEndDate 91 DATE 10 True True True False CCCC-MM-DD 1.0 US, CA, UK
JobEndDate 91 DATE 10 True True True False CCCC-MM-DD 1.0 US, CA, UK
JobDesc 12 VARCHAR 99 True True True False %s 1.0 US, CA, UK
JobTypeRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
JobTypeRef_FullName 12 VARCHAR 159 True True True False %s FullName 1.0 US, CA, UK
Notes 12 VARCHAR 4095 True True True False %s 1.0 US, CA, UK
PreferredDeliveryMethod 12 VARCHAR 10 True True True True
None
Email
Fax
 12.0 US, CA, UK
PriceLevelRef_ListID 12 VARCHAR 36 True True True False %s ListID 4.0 US, CA, UK
PriceLevelRef_FullName 12 VARCHAR 31 True True True False %s Name 4.0 US, CA, UK
ExternalGUID 12 VARCHAR 40 True False True False {XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX} 8.0 US, CA, UK
CurrencyRef_ListID 12 VARCHAR 36 True True True False %s ListID 8.0 US, CA, UK
CurrencyRef_FullName 12 VARCHAR 64 True True True False %s Name 8.0 US, CA, UK
CFBDay 12 VARCHAR 255 True True True False %s 1.0 US, CA, UK
CFContract 12 VARCHAR 255 True True True False %s 1.0 US, CA, UK
CFSpousesName 12 VARCHAR 255 True True True False %s 1.0 US, CA, UK

Back to list of tables.