TABLE DETAIL REFERENCE: CustomerShipToAddress
(Australia ,New Zealand,Singapore Southeast Asia VERSION)
| FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
|---|---|---|---|---|---|---|---|---|---|
| ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
| Name | 12 | VARCHAR | 41 | True | False | False | True | %s | |
| FullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| IsActive | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| ParentRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| ParentRefFullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| Sublevel | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| CompanyName | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| Salutation | 12 | VARCHAR | 15 | True | False | False | False | %s | |
| FirstName | 12 | VARCHAR | 25 | True | False | False | False | %s | |
| MiddleName | 12 | VARCHAR | 5 | True | False | False | False | %s | |
| LastName | 12 | VARCHAR | 25 | True | False | False | False | %s | |
| JobTitle | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| BillAddressAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| BillAddressAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| BillAddressAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| BillAddressAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| BillAddressAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| BillAddressCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
| BillAddressState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| BillAddressProvince | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| BillAddressCounty | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| BillAddressPostalCode | 12 | VARCHAR | 13 | True | False | False | False | %s | |
| BillAddressCountry | 12 | VARCHAR | 31 | True | False | False | False | %s | |
| BillAddressNote | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| BillAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| BillAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| BillAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| BillAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| BillAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
| ShipAddressState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| ShipAddressProvince | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| ShipAddressCounty | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| ShipAddressPostalCode | 12 | VARCHAR | 13 | True | False | False | False | %s | |
| ShipAddressCountry | 12 | VARCHAR | 31 | True | False | False | False | %s | |
| ShipAddressNote | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipToAddressName | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipToAddressAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipToAddressAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipToAddressAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipToAddressAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipToAddressAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipToAddressCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
| ShipToAddressState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| ShipToAddressPostalCode | 12 | VARCHAR | 13 | True | False | False | False | %s | |
| ShipToAddressCountry | 12 | VARCHAR | 31 | True | False | False | False | %s | |
| ShipToAddressNote | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipToAddressDefaultShipTo | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| Phone | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| AltPhone | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| Fax | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| 12 | VARCHAR | 1023 | True | False | False | False | %s | ||
| Contact | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| AltContact | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| CustomerTypeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| CustomerTypeRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
| TermsRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| TermsRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
| SalesRepRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| SalesRepRefFullName | 12 | VARCHAR | 5 | True | False | False | False | %s | Yes |
| Balance | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| TotalBalance | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| OpenBalance | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| OpenBalanceDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| SalesTaxCodeRefFullName | 12 | VARCHAR | 6 | True | False | False | False | %s | Yes |
| TaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| TaxCodeRefFullName | 12 | VARCHAR | 6 | True | False | False | False | %s | Yes |
| ItemSalesTaxRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| ItemSalesTaxRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
| SalesTaxCountry | 12 | VARCHAR | 31 | True | False | False | False | Australia Canada UK | |
| ResaleNumber | 12 | VARCHAR | 15 | True | False | False | False | %s | |
| AccountNumber | 12 | VARCHAR | 99 | True | False | False | False | %s | |
| BusinessNumber | 12 | VARCHAR | 99 | True | False | False | False | %s | |
| CreditLimit | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| PreferredPaymentMethodRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| PreferredPaymentMethodRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
| CreditCardInfoCreditCardNumber | 12 | VARCHAR | 25 | True | False | False | False | %s | |
| CreditCardInfoExpirationMonth | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| CreditCardInfoExpirationYear | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| CreditCardInfoNameOnCard | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| CreditCardInfoCreditCardAddress | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| CreditCardInfoCreditCardPostalCode | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| JobStatus | 12 | VARCHAR | 10 | True | False | False | False | None Pending Awarded InProgress Closed NotAwarded | |
| JobStartDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| JobProjectedEndDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| JobEndDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| JobDesc | 12 | VARCHAR | 99 | True | False | False | False | %s | |
| JobTypeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| JobTypeRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
| Notes | 12 | VARCHAR | 4095 | True | False | False | False | %s | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| CurrencyRefFullName | 12 | VARCHAR | 64 | True | False | False | False | %s | |
| IsUsingCustomerTaxCode | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| PriceLevelRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| PriceLevelRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
| FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |