Vendor Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
ListID 12 VARCHAR 36 True False False False %s 1.0 US, CA, UK
TimeCreated 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 1.0 US, CA, UK
TimeModified 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 1.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 1.0 US, CA, UK
Name 12 VARCHAR 41 True True True True %s 1.0 US, CA, UK
IsActive -7 BIT 2 True True True False
1
0
true
false
 1.0 US, CA, UK
CompanyName 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
Salutation 12 VARCHAR 15 True True True False %s 1.0 US, CA, UK
FirstName 12 VARCHAR 25 True True True False %s 1.0 US, CA, UK
MiddleName 12 VARCHAR 5 True True True False %s 1.0 US, CA, UK
LastName 12 VARCHAR 25 True True True False %s 1.0 US, CA, UK
JobTitle 12 VARCHAR 41 True True True False %s 12.0 US, CA, UK
ClassRef_ListID 12 VARCHAR 36 True True True False %s ListID 12.0 US, CA, UK
ClassRef_FullName 12 VARCHAR 159 True True True False %s FullName 12.0 US, CA, UK
VendorAddress_Addr1 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
VendorAddress_Addr2 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
VendorAddress_Addr3 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
VendorAddress_Addr4 12 VARCHAR 41 True True True False %s 2.0 US, CA, UK
VendorAddress_Addr5 12 VARCHAR 41 True True True False %s 6.0 US, CA, UK
VendorAddress_City 12 VARCHAR 31 True True True False %s 1.0 US, CA, UK
VendorAddress_State 12 VARCHAR 21 True True True False %s 1.0 US, CA, UK
VendorAddress_PostalCode 12 VARCHAR 13 True True True False %s 1.0 US, CA, UK
VendorAddress_Country 12 VARCHAR 31 True True True False %s 1.0 US, CA, UK
VendorAddress_Note 12 VARCHAR 41 True True True False %s 6.0 US, CA, UK
VendorAddressBlock_Addr1 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
VendorAddressBlock_Addr2 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
VendorAddressBlock_Addr3 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
VendorAddressBlock_Addr4 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
VendorAddressBlock_Addr5 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
ShipAddress_Addr1 12 VARCHAR 41 True False False False %s 11.0 US, CA, UK
ShipAddress_Addr2 12 VARCHAR 41 True False False False %s 1.0 US, CA, UK
ShipAddress_Addr3 12 VARCHAR 41 True False False False %s 1.0 US, CA, UK
ShipAddress_Addr4 12 VARCHAR 41 True False False False %s 2.0 US, CA, UK
ShipAddress_Addr5 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
ShipAddress_City 12 VARCHAR 31 True False False False %s 1.0 US, CA, UK
ShipAddress_State 12 VARCHAR 21 True False False False %s 1.0 US, CA, UK
ShipAddress_PostalCode 12 VARCHAR 13 True False False False %s 1.0 US, CA, UK
ShipAddress_Country 12 VARCHAR 31 True False False False %s 1.0 US, CA, UK
ShipAddress_Note 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
Phone 12 VARCHAR 21 True True True False %s 1.0 US, CA, UK
AltPhone 12 VARCHAR 21 True True True False %s 1.0 US, CA, UK
Fax 12 VARCHAR 21 True True True False %s 1.0 US, CA, UK
Email 12 VARCHAR 1023 True True True False %s 1.0 US, CA, UK
Cc 12 VARCHAR 1023 True True True False %s 12.0 US, CA, UK
Contact 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
AltContact 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
AdditionalContactRef_ContactName1 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue1 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName2 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue2 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName3 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue3 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName4 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue4 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName5 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue5 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName6 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue6 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName7 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue7 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName8 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue8 12 VARCHAR 255 12.0 US, CA, UK
NameOnCheck 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
AccountNumber 12 VARCHAR 99 True True True False %s 1.0 US, CA, UK
Notes 12 VARCHAR 4095 True True True False %s 1.0 US, CA, UK
VendorTypeRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
VendorTypeRef_FullName 12 VARCHAR 159 True True True False %s FullName 1.0 US, CA, UK
TermsRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
TermsRef_FullName 12 VARCHAR 31 True True True False %s Name 1.0 US, CA, UK
CreditLimit 2 NUMERIC 15 True True True False %10.2f 1.0 US, CA, UK
VendorTaxIdent 12 VARCHAR 15 True True True False %s 1.0 US, CA, UK
IsVendorEligibleFor1099 -7 BIT 2 True True True False
1
0
true
false
 1.0 US, CA, UK
OpenBalance 2 NUMERIC 15 True False True False %10.2f 1.0 US, CA, UK
OpenBalanceDate 91 DATE 10 True False True False CCCC-MM-DD 1.0 US, CA, UK
Balance 2 NUMERIC 15 True False False False %10.2f 1.0 US, CA, UK
BillingRateRef_ListID 12 VARCHAR 36 True True True False %s ListID 6.0 US, CA, UK
BillingRateRef_FullName 12 VARCHAR 31 True True True False %s FullName 6.0 US, CA, UK
ExternalGUID 12 VARCHAR 40 True False True False {XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX} 8.0 US, CA, UK
PrefillAccount_ListID1 12 VARCHAR 36 True True True False %s 8.0 US, CA, UK
PrefillAccount_FullName1 12 VARCHAR 159 True True True False %s 8.0 US, CA, UK
PrefillAccount_ListID2 12 VARCHAR 36 True True True False %s 8.0 US, CA, UK
PrefillAccount_FullName2 12 VARCHAR 159 True True True False %s 8.0 US, CA, UK
PrefillAccount_ListID3 12 VARCHAR 36 True True True False %s 8.0 US, CA, UK
PrefillAccount_FullName3 12 VARCHAR 159 True True True False %s 8.0 US, CA, UK
CurrencyRef_ListID 12 VARCHAR 36 True True True False %s ListID 8.0 US, CA, UK
CurrencyRef_FullName 12 VARCHAR 64 True True True False %s Name 8.0 US, CA, UK
CFDDiscountAvailable 12 VARCHAR 30 True True True False %s 1.0 US, CA, UK

Back to list of tables.