TABLE DETAIL REFERENCE: CustomerShipToAddress
(USA VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
Name12 VARCHAR 41TrueFalseFalseTrue%s
FullName12 VARCHAR 209TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ClassRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ClassRefFullName12 VARCHAR 209TrueFalseFalseFalse%s Yes
ParentRefListID12 VARCHAR 36TrueFalseFalseFalse%s
ParentRefFullName12 VARCHAR 209TrueFalseFalseFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f
CompanyName12 VARCHAR 41TrueFalseFalseFalse%s
Salutation12 VARCHAR 15TrueFalseFalseFalse%s
FirstName12 VARCHAR 25TrueFalseFalseFalse%s
MiddleName12 VARCHAR 5TrueFalseFalseFalse%s
LastName12 VARCHAR 25TrueFalseFalseFalse%s
JobTitle12 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr512 VARCHAR 41TrueFalseFalseFalse%s
BillAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
BillAddressState12 VARCHAR 21TrueFalseFalseFalse%s
BillAddressProvince12 VARCHAR 21TrueFalseFalseFalse%s
BillAddressCounty12 VARCHAR 21TrueFalseFalseFalse%s
BillAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
BillAddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
BillAddressNote12 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
ShipAddressState12 VARCHAR 21TrueFalseFalseFalse%s
ShipAddressProvince12 VARCHAR 21TrueFalseFalseFalse%s
ShipAddressCounty12 VARCHAR 21TrueFalseFalseFalse%s
ShipAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
ShipAddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
ShipAddressNote12 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipToAddressName12 VARCHAR 41TrueFalseFalseFalse%s
ShipToAddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipToAddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipToAddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipToAddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipToAddressAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipToAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
ShipToAddressState12 VARCHAR 21TrueFalseFalseFalse%s
ShipToAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
ShipToAddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
ShipToAddressNote12 VARCHAR 41TrueFalseFalseFalse%s
ShipToAddressDefaultShipTo-7 BIT 1TrueFalseFalseFalse
1
0
true
false
Phone12 VARCHAR 21TrueFalseFalseFalse%s
AltPhone12 VARCHAR 21TrueFalseFalseFalse%s
Fax12 VARCHAR 21TrueFalseFalseFalse%s
Email12 VARCHAR 1023TrueFalseFalseFalse%s
Cc12 VARCHAR 1023TrueFalseFalseFalse%s
Contact12 VARCHAR 41TrueFalseFalseFalse%s
AltContact12 VARCHAR 41TrueFalseFalseFalse%s
CustomerTypeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CustomerTypeRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
TermsRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TermsRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
SalesRepRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesRepRefFullName12 VARCHAR 5TrueFalseFalseFalse%s Yes
Balance3 DECIMAL 15TrueFalseFalseFalse%10.2f
TotalBalance3 DECIMAL 15TrueFalseFalseFalse%10.2f
OpenBalance3 DECIMAL 15TrueFalseFalseFalse%10.2f
OpenBalanceDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ItemSalesTaxRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ItemSalesTaxRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
SalesTaxCountry12 VARCHAR 31TrueFalseFalseFalse
Australia
Canada
UK
ResaleNumber12 VARCHAR 15TrueFalseFalseFalse%s
AccountNumber12 VARCHAR 99TrueFalseFalseFalse%s
BusinessNumber12 VARCHAR 99TrueFalseFalseFalse%s
CreditLimit3 DECIMAL 15TrueFalseFalseFalse%10.2f
PreferredPaymentMethodRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PreferredPaymentMethodRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
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 10TrueFalseFalseTrue
None
Email
Fax
IsUsingCustomerTaxCode-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PriceLevelRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PriceLevelRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
ExternalGUID12 VARCHAR 40TrueFalseFalseFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
TaxRegistrationNumber12 VARCHAR 30TrueFalseFalseFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey