TABLE DETAIL REFERENCE: Customer
(Online 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 | 10 | True | False | False | False | %s | |
| Name | 12 | VARCHAR | 100 | True | True | True | True | %s | |
| FullName | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| IsActive | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
| ParentRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | |
| ParentRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| Sublevel | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| CompanyName | 12 | VARCHAR | 50 | True | True | True | False | %s | |
| Salutation | 12 | VARCHAR | 15 | True | True | True | False | %s | |
| FirstName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| MiddleName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| LastName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| Suffix | 12 | VARCHAR | 10 | True | True | True | False | %s | |
| BillAddressID | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| BillAddressAddr1 | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| BillAddressAddr2 | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| BillAddressAddr3 | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| BillAddressAddr4 | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| BillAddressAddr5 | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| BillAddressCity | 12 | VARCHAR | 255 | True | True | True | False | %s | |
| BillAddressState | 12 | VARCHAR | 255 | True | True | True | False | %s | |
| BillAddressPostalCode | 12 | VARCHAR | 30 | True | True | True | False | %s | |
| BillAddressCountry | 12 | VARCHAR | 255 | True | True | True | False | %s | |
| BillAddressNote | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| ShipAddressID | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| ShipAddressAddr1 | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| ShipAddressAddr2 | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| ShipAddressAddr3 | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| ShipAddressAddr4 | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| ShipAddressAddr5 | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| ShipAddressCity | 12 | VARCHAR | 255 | True | True | True | False | %s | |
| ShipAddressState | 12 | VARCHAR | 255 | True | True | True | False | %s | |
| ShipAddressPostalCode | 12 | VARCHAR | 30 | True | True | True | False | %s | |
| ShipAddressCountry | 12 | VARCHAR | 255 | True | True | True | False | %s | |
| ShipAddressNote | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| PrintAs | 12 | VARCHAR | 110 | True | True | True | False | %s | |
| Phone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| Mobile | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| Pager | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| AltPhone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| Fax | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| 12 | VARCHAR | 100 | True | True | True | False | %s | ||
| TermsRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| TermsRefFullName | 12 | VARCHAR | 100 | True | True | True | False | %s | Yes |
| Balance | 3 | DECIMAL | 15 | True | False | False | False | %11.2f | |
| TotalBalance | 3 | DECIMAL | 15 | True | False | False | False | %11.2f | |
| OpenBalance | 3 | DECIMAL | 13 | True | False | True | False | %11.2f | |
| OpenBalanceDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
| ResaleNumber | 12 | VARCHAR | 16 | True | True | True | False | %s | |
| Notes | 12 | VARCHAR | 2000 | True | True | True | False | %s | |
| IsStatementWithParent | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| DeliveryMethod | 12 | VARCHAR | 5 | True | True | True | False | Fax | |
| DefaultTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| DefaultTaxCodeRefFullName | 12 | VARCHAR | 100 | True | True | True | False | %s | Yes |
| Taxable | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| WebAddressURI | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| Job | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| PaymentMethodRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| PaymentMethodRefFullName | 12 | VARCHAR | 100 | True | True | True | False | %s | Yes |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| CurrencyRefFullName | 12 | VARCHAR | 100 | True | True | True | False | %s | Yes |
| ARAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| ARAccountRefFullName | 12 | VARCHAR | 100 | True | True | True | False | %s | Yes |
| TaxExemptionReasonId | 12 | VARCHAR | 5 | True | False | False | False | %s | |
| IsProject | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| BusinessNumber | 12 | VARCHAR | 99 | True | False | True | False | %s | |
| GSTIN | 12 | VARCHAR | 99 | True | False | True | False | %s | |
| GSTRegistrationType | 12 | VARCHAR | 99 | True | False | True | False | %s | |
| IsCISContractor | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| ClientCompanyId | 12 | VARCHAR | 36 | True | True | True | False | %s | |
| ClientEntityId | 12 | VARCHAR | 36 | True | True | True | False | %s | |
| OverDueBalance | 3 | DECIMAL | 15 | True | False | False | False | %11.2f | |
| Organization | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| OtherContactInfoType | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| OtherContactInfoTelephone | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| PriceLevelRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| PriceLevelRefFullName | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| RootCustomerRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| RootCustomerRefFullName | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| SalesRepRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| SalesRepRefFullName | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| TotalExpense | 3 | DECIMAL | 15 | True | False | False | False | %11.2f | |
| TotalRevenue | 3 | DECIMAL | 15 | True | False | False | False | %11.2f | |
| UserId | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| Status | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| CCDetailAmount | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| CCDetailBillAddrStreet | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| CCDetailExpiryMonth | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| CCDetailExpiryYear | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| CCDetailTxnMode | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| CCDetailTxnType | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| CCDetailCommercialCardCode | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| ContactName | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| AltContactName | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| CreditLimit | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
| CustomerTypeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| CustomerTypeRefFullName | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherAddrId | 12 | VARCHAR | 36 | True | True | True | False | %s | |
| OtherAddr1 | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddr2 | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddr3 | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddr4 | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddr5 | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddrCity | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddrState | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddrProvince | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddrCounty | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddrPostalCode | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddrLat | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddrLong | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoEmailAddress | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoEmailAddressDefault | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoEmailAddressId | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoEmailAddressTag | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoTelephoneNumberAreaCode | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoTelephoneNumberCountryCode | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoTelephoneNumberDeviceType | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoTelephoneNumberDefault | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoTelephoneNumberExchangeCode | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoTelephoneNumberExtension | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoTelephoneNumberTelephone | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoTelephoneNumberId | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoTelephoneNumberTag | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoWebSiteAddressURI | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoWebSiteAddressDefault | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoWebSiteAddressId | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoWebSiteAddressTag | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoGenericContactTypeName | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoGenericContactTypeType | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoGenericContactTypeValue | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoGenericContactTypeDefault | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoGenericContactTypeId | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherContactInfoGenericContactTypeTag | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| UpdateAccountOnTxns | -7 | BIT | 1 | False | True | False | False | 1 0 true false |