TABLE DETAIL REFERENCE: Customer
(Online 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 10TrueFalseFalseFalse%s
Name12 VARCHAR 100TrueTrueTrueTrue%s
FullName12 VARCHAR 1000TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueTrueFalseFalse
1
0
true
false
ParentRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ParentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f
CompanyName12 VARCHAR 50TrueTrueTrueFalse%s
Salutation12 VARCHAR 15TrueTrueTrueFalse%s
FirstName12 VARCHAR 25TrueTrueTrueFalse%s
MiddleName12 VARCHAR 25TrueTrueTrueFalse%s
LastName12 VARCHAR 25TrueTrueTrueFalse%s
Suffix12 VARCHAR 10TrueTrueTrueFalse%s
BillAddressID12 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressID12 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
PrintAs12 VARCHAR 110TrueTrueTrueFalse%s
Phone12 VARCHAR 21TrueTrueTrueFalse%s
Mobile12 VARCHAR 21TrueTrueTrueFalse%s
Pager12 VARCHAR 21TrueTrueTrueFalse%s
AltPhone12 VARCHAR 21TrueTrueTrueFalse%s
Fax12 VARCHAR 21TrueTrueTrueFalse%s
Email12 VARCHAR 100TrueTrueTrueFalse%s
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
Balance3 DECIMAL 15TrueFalseFalseFalse%11.2f
TotalBalance3 DECIMAL 15TrueFalseFalseFalse%11.2f
OpenBalance3 DECIMAL 13TrueFalseTrueFalse%11.2f
OpenBalanceDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
ResaleNumber12 VARCHAR 16TrueTrueTrueFalse%s
Notes12 VARCHAR 2000TrueTrueTrueFalse%s
IsStatementWithParent-7 BIT 1TrueTrueTrueFalse
1
0
true
false
DeliveryMethod12 VARCHAR 5TrueTrueTrueFalse
Print
Fax
Email
DefaultTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DefaultTaxCodeRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
Taxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
WebAddressURI12 VARCHAR 1000TrueTrueTrueFalse%s
Job-7 BIT 1TrueTrueTrueFalse
1
0
true
false
PaymentMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PaymentMethodRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CurrencyRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
ARAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ARAccountRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
TaxExemptionReasonId12 VARCHAR 5TrueFalseFalseFalse%s
IsProject-7 BIT 1TrueFalseFalseFalse
1
0
true
false
BusinessNumber12 VARCHAR 99TrueFalseTrueFalse%s
GSTIN12 VARCHAR 99TrueFalseTrueFalse%s
GSTRegistrationType12 VARCHAR 99TrueFalseTrueFalse%s
IsCISContractor-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ClientCompanyId12 VARCHAR 36TrueTrueTrueFalse%s
ClientEntityId12 VARCHAR 36TrueTrueTrueFalse%s
OverDueBalance3 DECIMAL 15TrueFalseFalseFalse%11.2f
Organization-7 BIT 1TrueTrueTrueFalse
1
0
true
false
OtherContactInfoType12 VARCHAR 1000TrueTrueTrueFalse%s
OtherContactInfoTelephone12 VARCHAR 1000TrueTrueTrueFalse%s
PriceLevelRefListID12 VARCHAR 36TrueFalseFalseFalse%s
PriceLevelRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s
RootCustomerRefListID12 VARCHAR 36TrueFalseFalseFalse%s
RootCustomerRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s
SalesRepRefListID12 VARCHAR 36TrueFalseFalseFalse%s
SalesRepRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s
TotalExpense3 DECIMAL 15TrueFalseFalseFalse%11.2f
TotalRevenue3 DECIMAL 15TrueFalseFalseFalse%11.2f
UserId12 VARCHAR 1000TrueTrueTrueFalse%s
Status12 VARCHAR 1000TrueTrueTrueFalse%s
CCDetailAmount4 INTEGER 4TrueFalseFalseFalse%11.0f
CCDetailBillAddrStreet12 VARCHAR 1000TrueFalseFalseFalse%s
CCDetailExpiryMonth4 INTEGER 4TrueFalseFalseFalse%11.0f
CCDetailExpiryYear4 INTEGER 4TrueFalseFalseFalse%11.0f
CCDetailTxnMode12 VARCHAR 1000TrueFalseFalseFalse%s
CCDetailTxnType12 VARCHAR 1000TrueFalseFalseFalse%s
CCDetailCommercialCardCode12 VARCHAR 1000TrueFalseFalseFalse%s
ContactName12 VARCHAR 1000TrueFalseFalseFalse%s
AltContactName12 VARCHAR 1000TrueFalseFalseFalse%s
CreditLimit3 DECIMAL 13TrueTrueTrueFalse%8.2f
CustomerTypeRefListID12 VARCHAR 36TrueFalseFalseFalse%s
CustomerTypeRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s
OtherAddrId12 VARCHAR 36TrueTrueTrueFalse%s
OtherAddr112 VARCHAR 100TrueTrueTrueFalse%s
OtherAddr212 VARCHAR 100TrueTrueTrueFalse%s
OtherAddr312 VARCHAR 100TrueTrueTrueFalse%s
OtherAddr412 VARCHAR 100TrueTrueTrueFalse%s
OtherAddr512 VARCHAR 100TrueTrueTrueFalse%s
OtherAddrCity12 VARCHAR 100TrueTrueTrueFalse%s
OtherAddrState12 VARCHAR 100TrueTrueTrueFalse%s
OtherAddrProvince12 VARCHAR 100TrueTrueTrueFalse%s
OtherAddrCounty12 VARCHAR 100TrueTrueTrueFalse%s
OtherAddrPostalCode12 VARCHAR 100TrueTrueTrueFalse%s
OtherAddrLat12 VARCHAR 100TrueTrueTrueFalse%s
OtherAddrLong12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoEmailAddress12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoEmailAddressDefault12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoEmailAddressId12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoEmailAddressTag12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoTelephoneNumberAreaCode12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoTelephoneNumberCountryCode12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoTelephoneNumberDeviceType12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoTelephoneNumberDefault12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoTelephoneNumberExchangeCode12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoTelephoneNumberExtension12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoTelephoneNumberTelephone12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoTelephoneNumberId12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoTelephoneNumberTag12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoWebSiteAddressURI12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoWebSiteAddressDefault12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoWebSiteAddressId12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoWebSiteAddressTag12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoGenericContactTypeName12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoGenericContactTypeType12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoGenericContactTypeValue12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoGenericContactTypeDefault12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoGenericContactTypeId12 VARCHAR 100TrueTrueTrueFalse%s
OtherContactInfoGenericContactTypeTag12 VARCHAR 100TrueTrueTrueFalse%s
UpdateAccountOnTxns-7 BIT 1FalseTrueFalseFalse
1
0
true
false