FIELD NAMEFIELD NAME (old)QUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
ListIDtruefalsetruefalsefalse
TimeCreatedtruefalsetruefalsefalse
TimeModifiedtruefalsetruefalsefalse
EditSequencetruefalsetruefalsefalse
Nametruetrueoptionaltruetrue
IsActivetruetrueoptionaltrueoptional
CompanyNametruetrueoptionaltrueoptional
Salutationtruetrueoptionaltrueoptional
FirstNametruetrueoptionaltrueoptional
MiddleNametruetrueoptionaltrueoptional
LastNametruetrueoptionaltrueoptional
VendorAddress_Addr1truetrueoptionaltrueoptional
VendorAddress_Addr2truetrueoptionaltrueoptional
VendorAddress_Addr3truetrueoptionaltrueoptional
VendorAddress_Addr4truetrueoptionaltrueoptional
VendorAddress_Addr5truetrueoptionaltrueoptional
VendorAddress_Citytruetrueoptionaltrueoptional
VendorAddress_Statetruetrueoptionaltrueoptional
VendorAddress_PostalCodetruetrueoptionaltrueoptional
VendorAddress_Countrytruetrueoptionaltrueoptional
VendorAddress_Notetruetrueoptionaltrueoptional
Phonetruetrueoptionaltrueoptional
Mobiletruetrueoptionaltrueoptional
Pagertruetrueoptionaltrueoptional
AltPhonetruetrueoptionaltrueoptional
Faxtruetrueoptionaltrueoptional
Emailtruetrueoptionaltrueoptional
Cctruetrueoptionaltrueoptional
Contacttruetrueoptionaltrueoptional
AltContacttruetrueoptionaltrueoptional
NameOnChecktruetrueoptionaltrueoptional
Notestruetrueoptionaltrueoptional
AccountNumbertruetrueoptionaltrueoptional
VendorTypeRef_ListIDtruetrueoptionaltrueoptional
VendorTypeRef_FullNametruetrueoptionaltrueoptional
TermsRef_ListIDtruetrueoptionaltrueoptional
TermsRef_FullNametruetrueoptionaltrueoptional
CreditLimittruetrueoptionaltrueoptional
VendorTaxIdenttruetrueoptionaltrueoptional
IsVendorEligibleFor1099truetrueoptionaltrueoptional
Balancetruefalseoptionaltrueoptional
OpenBalanceDatetruefalseoptionaltrueoptional
CurrencyRef_ListIDtruetrueoptionaltrueoptional
CurrencyRef_FullNametruetrueoptionaltrueoptional
BillingRateRef_ListIDtruetrueoptionaltrueoptional
BillingRateRef_FullNametruetrueoptionaltrueoptional
SalesTaxCodeRef_ListIDtruetrueoptionaltrueoptional
SalesTaxCodeRef_FullNametruetrueoptionaltrueoptional
SalesTaxCountrytruetrueoptionaltrueoptional
IsSalesTaxAgencytruetrueoptionaltrueoptional
SalesTaxReturnRef_ListIDtruetrueoptionaltrueoptional
SalesTaxReturnRef_FullNametruetrueoptionaltrueoptional
TaxRegistrationNumbertruetrueoptionaltrueoptional
ReportingPeriodtruetrueoptionaltrueoptional
IsTaxTrackedOnPurchasestruetrueoptionaltrueoptional
TaxOnPurchasesAccountRef_ListIDtruetrueoptionaltrueoptional
TaxOnPurchasesAccountRef_FullNametruetrueoptionaltrueoptional
IsTaxTrackedOnSalestruetrueoptionaltrueoptional
TaxOnSalesAccountRef_ListIDtruetrueoptionaltrueoptional
TaxOnSalesAccountRef_FullNametruetrueoptionaltrueoptional
IsTaxOnTaxtruetrueoptionaltrueoptional
ClassRef_ListIDtruetrueoptionaltrueoptional
ClassRef_FullNametruetrueoptionaltrueoptional
IsTaxAgencytruetrueoptionaltrueoptional
JobTitletruetrueoptionaltrueoptional
ShipAddress_Addr1truetrueoptionaltrueoptional
ShipAddress_Addr2truetrueoptionaltrueoptional
ShipAddress_Addr3truetrueoptionaltrueoptional
ShipAddress_Addr4truetrueoptionaltrueoptional
ShipAddress_Addr5truetrueoptionaltrueoptional
ShipAddress_Citytruetrueoptionaltrueoptional
ShipAddress_Statetruetrueoptionaltrueoptional
ShipAddress_PostalCodetruetrueoptionaltrueoptional
ShipAddress_Countrytruetrueoptionaltrueoptional
ShipAddress_Notetruetrueoptionaltrueoptional
CustomField1truetrueoptionaltrueoptional
CustomField2truetrueoptionaltrueoptional
CustomField3truetrueoptionaltrueoptional
CustomField4truetrueoptionaltrueoptional
CustomField5truetrueoptionaltrueoptional
CustomField6truetrueoptionaltrueoptional
CustomField7truetrueoptionaltrueoptional
CustomField8truetrueoptionaltrueoptional
CustomField9truetrueoptionaltrueoptional
CustomField10truetrueoptionaltrueoptional
CustomField11truetrueoptionaltrueoptional
CustomField12truetrueoptionaltrueoptional
CustomField13truetrueoptionaltrueoptional
CustomField14truetrueoptionaltrueoptional
CustomField15truetrueoptionaltrueoptional
ExternalGUIDtruetrueoptionaltrueoptional
UserDatauser field
Operationadd,update,delete, refresh
  • AdditionalContact
  • AdditionalNotesRet
  • ContactsRet
  • PrefillAccountRet

Powered by BetterDocs