TABLE DETAIL REFERENCE: OtherName
(Australia ,New Zealand,Singapore Southeast Asia 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 41TrueTrueTrueTrue%s
IsActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
CompanyName12 VARCHAR 41TrueTrueTrueFalse%s
Salutation12 VARCHAR 15TrueTrueTrueFalse%s
FirstName12 VARCHAR 25TrueTrueTrueFalse%s
MiddleName12 VARCHAR 5TrueTrueTrueFalse%s
LastName12 VARCHAR 25TrueTrueTrueFalse%s
OtherNameAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
OtherNameAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
OtherNameAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
OtherNameAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
OtherNameAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
OtherNameAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
OtherNameAddressState12 VARCHAR 21TrueTrueTrueFalse%s
OtherNameAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
OtherNameAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
OtherNameAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
OtherNameAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
OtherNameAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
OtherNameAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
OtherNameAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
OtherNameAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
OtherNameAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
OtherNameAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
Phone12 VARCHAR 21TrueTrueTrueFalse%s
AltPhone12 VARCHAR 21TrueTrueTrueFalse%s
Fax12 VARCHAR 21TrueTrueTrueFalse%s
Email12 VARCHAR 1023TrueTrueTrueFalse%s
Contact12 VARCHAR 41TrueTrueTrueFalse%s
AltContact12 VARCHAR 41TrueTrueTrueFalse%s
AccountNumber12 VARCHAR 99TrueTrueTrueFalse%s
BusinessNumber12 VARCHAR 99TrueFalseFalseFalse%s
Notes12 VARCHAR 4095TrueTrueTrueFalse%s
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s