TABLE DETAIL REFERENCE: Vendor
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 100TrueTrueTrueTrue%s
IsActive-7 BIT 1TrueTrueFalseFalse
1
0
true
false
CompanyName12 VARCHAR 50TrueTrueTrueFalse%s
Salutation12 VARCHAR 15TrueTrueTrueFalse%s
FirstName12 VARCHAR 25TrueTrueTrueFalse%s
MiddleName12 VARCHAR 25TrueTrueTrueFalse%s
LastName12 VARCHAR 25TrueTrueTrueFalse%s
Suffix12 VARCHAR 10TrueTrueTrueFalse%s
VendorAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
VendorAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
VendorAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
VendorAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
VendorAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
VendorAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
VendorAddressState12 VARCHAR 255TrueTrueTrueFalse%s
VendorAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
VendorAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
Phone12 VARCHAR 21TrueTrueTrueFalse%s
Mobile12 VARCHAR 21TrueTrueTrueFalse%s
AltPhone12 VARCHAR 21TrueTrueTrueFalse%s
Fax12 VARCHAR 21TrueTrueTrueFalse%s
Email12 VARCHAR 100TrueTrueTrueFalse%s
WebAddressURI12 VARCHAR 1000TrueTrueTrueFalse%s
OtherContactInfoType12 VARCHAR 1000TrueTrueTrueFalse%s
OtherContactInfoTelephone12 VARCHAR 1000TrueTrueTrueFalse%s
NameOnCheck12 VARCHAR 110TrueTrueTrueFalse%s
AccountNumber12 VARCHAR 99TrueTrueTrueFalse%s
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
VendorTaxIdent12 VARCHAR 20TrueTrueTrueFalse%s
IsVendorEligibleFor1099-7 BIT 1TrueFalseTrueFalse
1
0
true
false
OpenBalance3 DECIMAL 13TrueFalseTrueFalse%11.2f
OpenBalanceDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
Balance3 DECIMAL 13TrueFalseFalseFalse%11.2f
CurrencyRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueTrueTrueFalse%s Yes
TaxReportingBasis12 VARCHAR 1000TrueTrueTrueFalse%s
APAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 64TrueTrueTrueFalse%s Yes
UpdateAccountOnTxns-7 BIT 1FalseTrueFalseFalse
1
0
true
false