TABLE DETAIL REFERENCE: Vendor
(USA 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 16TrueFalseFalseFalse%s
Name12 VARCHAR 41TrueTrueTrueTrue%s
IsActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
IsTaxAgency-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
VendorAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
VendorAddressState12 VARCHAR 21TrueTrueTrueFalse%s
VendorAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
VendorAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
VendorAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
VendorAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
VendorAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
VendorAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
VendorAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
VendorAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
VendorAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
ShipAddressState12 VARCHAR 21TrueFalseFalseFalse%s
ShipAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
ShipAddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
ShipAddressNote12 VARCHAR 41TrueFalseFalseFalse%s
Phone12 VARCHAR 21TrueTrueTrueFalse%s
AltPhone12 VARCHAR 21TrueTrueTrueFalse%s
Fax12 VARCHAR 21TrueTrueTrueFalse%s
Email12 VARCHAR 1023TrueTrueTrueFalse%s
Cc12 VARCHAR 1023TrueTrueTrueFalse%s
Contact12 VARCHAR 41TrueTrueTrueFalse%s
AltContact12 VARCHAR 41TrueTrueTrueFalse%s
NameOnCheck12 VARCHAR 41TrueTrueTrueFalse%s
AccountNumber12 VARCHAR 99TrueTrueTrueFalse%s
Notes12 VARCHAR 4095TrueTrueTrueFalse%s
VendorTypeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
VendorTypeRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
CreditLimit3 DECIMAL 15TrueTrueTrueFalse%10.2f
VendorTaxIdent12 VARCHAR 15TrueTrueTrueFalse%s
IsVendorEligibleFor1099-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsVendorEligibleForT4A-7 BIT 1TrueTrueTrueFalse
1
0
true
false
OpenBalance3 DECIMAL 15TrueFalseTrueFalse%10.2f
OpenBalanceDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
Balance3 DECIMAL 15TrueFalseFalseFalse%10.2f
BillingRateRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
BillingRateRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
PrefillAccount1RefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PrefillAccount1RefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
PrefillAccount2RefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PrefillAccount2RefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
PrefillAccount3RefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PrefillAccount3RefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ExternalGUID12 VARCHAR 40TrueFalseTrueFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
BusinessNumber12 VARCHAR 99TrueFalseFalseFalse%s
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
SalesTaxCountry12 VARCHAR 100TrueFalseFalseFalse%s
IsSalesTaxAgency-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesTaxReturnRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxReturnRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueTrueTrueFalse%s Yes