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
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
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
UpdateAccountOnTxns-7 BIT 1FalseTrueFalseFalse
1
0
true
false