VendorAdditionalNotes Table

Back to list of tables.

ColumnData typeData type nameLengthCan be queried?Can be updated?Can be inserted?Mandatory when inserting?FormatRefers ToVersion introduced inEdition available in
ID12VARCHAR75
ListID12VARCHAR36TrueFalseFalseFalse%s1.0US, CA, UK
TimeCreated93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ1.0US, CA, UK
TimeModified93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ1.0US, CA, UK
EditSequence12VARCHAR16TrueFalseFalseFalse%s1.0US, CA, UK
Name12VARCHAR41TrueTrueTrueTrue%s1.0US, CA, UK
IsActive-7BIT2TrueTrueTrueFalse
1
0
true
false
1.0US, CA, UK
ClassRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID12.0US, CA, UK
ClassRef_FullName12VARCHAR159TrueTrueTrueFalse%sFullName12.0US, CA, UK
CompanyName12VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
Salutation12VARCHAR15TrueTrueTrueFalse%s1.0US, CA, UK
FirstName12VARCHAR25TrueTrueTrueFalse%s1.0US, CA, UK
MiddleName12VARCHAR5TrueTrueTrueFalse%s1.0US, CA, UK
LastName12VARCHAR25TrueTrueTrueFalse%s1.0US, CA, UK
JobTitle12VARCHAR41TrueTrueTrueFalse%s12.0US, CA, UK
VendorAddress_Addr112VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
VendorAddress_Addr212VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
VendorAddress_Addr312VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
VendorAddress_Addr412VARCHAR41TrueTrueTrueFalse%s2.0US, CA, UK
VendorAddress_Addr512VARCHAR41TrueTrueTrueFalse%s6.0US, CA, UK
VendorAddress_City12VARCHAR31TrueTrueTrueFalse%s1.0US, CA, UK
VendorAddress_State12VARCHAR21TrueTrueTrueFalse%s1.0US, CA, UK
VendorAddress_PostalCode12VARCHAR13TrueTrueTrueFalse%s1.0US, CA, UK
VendorAddress_Country12VARCHAR31TrueTrueTrueFalse%s1.0US, CA, UK
VendorAddress_Note12VARCHAR41TrueTrueTrueFalse%s6.0US, CA, UK
VendorAddressBlock_Addr112VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
VendorAddressBlock_Addr212VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
VendorAddressBlock_Addr312VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
VendorAddressBlock_Addr412VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
VendorAddressBlock_Addr512VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
ShipAddress_Addr112VARCHAR41TrueFalseFalseFalse%s11.0US, CA, UK
ShipAddress_Addr212VARCHAR41TrueFalseFalseFalse%s1.0US, CA, UK
ShipAddress_Addr312VARCHAR41TrueFalseFalseFalse%s1.0US, CA, UK
ShipAddress_Addr412VARCHAR41TrueFalseFalseFalse%s2.0US, CA, UK
ShipAddress_Addr512VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
ShipAddress_City12VARCHAR31TrueFalseFalseFalse%s1.0US, CA, UK
ShipAddress_State12VARCHAR21TrueFalseFalseFalse%s1.0US, CA, UK
ShipAddress_PostalCode12VARCHAR13TrueFalseFalseFalse%s1.0US, CA, UK
ShipAddress_Country12VARCHAR31TrueFalseFalseFalse%s1.0US, CA, UK
ShipAddress_Note12VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
Phone12VARCHAR21TrueTrueTrueFalse%s1.0US, CA, UK
AltPhone12VARCHAR21TrueTrueTrueFalse%s1.0US, CA, UK
Fax12VARCHAR21TrueTrueTrueFalse%s1.0US, CA, UK
Email12VARCHAR1023TrueTrueTrueFalse%s1.0US, CA, UK
Cc12VARCHAR1023TrueTrueTrueFalse%s12.0US, CA, UK
Contact12VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
AltContact12VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
NameOnCheck12VARCHAR41TrueTrueTrueFalse%s1.0US, CA, UK
AccountNumber12VARCHAR99TrueTrueTrueFalse%s1.0US, CA, UK
Notes12VARCHAR4095TrueTrueTrueFalse%s1.0US, CA, UK
AdditionalNotes_NoteID4INTEGER9TrueTrueFalseFalse%11.0f12.0US, CA, UK
AdditionalNotes_Date91DATE10TrueFalseFalseFalseCCCC-MM-DD12.0US, CA, UK
AdditionalNotes_Note12VARCHAR4095TrueTrueTrueFalse%s12.0US, CA, UK
VendorTypeRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID1.0US, CA, UK
VendorTypeRef_FullName12VARCHAR159TrueTrueTrueFalse%sFullName1.0US, CA, UK
TermsRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID1.0US, CA, UK
TermsRef_FullName12VARCHAR31TrueTrueTrueFalse%sName1.0US, CA, UK
CreditLimit2NUMERIC15TrueTrueTrueFalse%10.2f1.0US, CA, UK
VendorTaxIdent12VARCHAR15TrueTrueTrueFalse%s1.0US, CA, UK
IsVendorEligibleFor1099-7BIT2TrueTrueTrueFalse
1
0
true
false
1.0US, CA, UK
OpenBalance2NUMERIC15TrueFalseTrueFalse%10.2f1.0US, CA, UK
OpenBalanceDate91DATE10TrueFalseTrueFalseCCCC-MM-DD1.0US, CA, UK
Balance2NUMERIC15TrueFalseFalseFalse%10.2f1.0US, CA, UK
BillingRateRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID6.0US, CA, UK
BillingRateRef_FullName12VARCHAR31TrueTrueTrueFalse%sFullName6.0US, CA, UK
ExternalGUID12VARCHAR40TrueFalseTrueFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}8.0US, CA, UK
PrefillAccount_ListID112VARCHAR36TrueTrueTrueFalse%sListID8.0US, CA, UK
PrefillAccount_FullName112VARCHAR159TrueTrueTrueFalse%sFullName8.0US, CA, UK
PrefillAccount_ListID212VARCHAR36TrueTrueTrueFalse%sListID8.0US, CA, UK
PrefillAccount_FullName212VARCHAR159TrueTrueTrueFalse%sFullName8.0US, CA, UK
PrefillAccount_ListID312VARCHAR36TrueTrueTrueFalse%sListID8.0US, CA, UK
PrefillAccount_FullName312VARCHAR159TrueTrueTrueFalse%sFullName8.0US, CA, UK
CurrencyRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID8.0US, CA, UK
CurrencyRef_FullName12VARCHAR64TrueTrueTrueFalse%sName8.0US, CA, UK
RQUseCachedID-7BIT2
CFDDiscountAvailable12VARCHAR30TrueTrueTrueFalse%s1.0US, CA, UK

Back to list of tables.