FIELD NAMEFIELD NAME (old)QUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
TxnIDtruefalsefalsefalsefalse
TimeCreatedtruefalsefalsefalsefalse
TimeModifiedtruefalsefalsefalsefalse
EditSequencetruefalsefalsefalsefalse
TxnNumbertruefalsefalsefalsefalse
VendorRef_ListIDtruetrueoptionaltruetrue
VendorRef_FullNametruetrueoptionaltruetrue
APAccountRef_ListIDtruetrueoptionaltrueoptional
APAccountRef_FullNametruetrueoptionaltrueoptional
TxnDatetruetrueoptionaltrueoptional
DueDatetruetrueoptionaltrueoptional
AmountDuetruefalsefalsefalsefalse
CurrencyRef_ListIDtruefalsefalsefalsefalse
CurrencyRef_FullNametruefalsefalsefalsefalse
ExchangeRatetruetrueoptionaltrueoptional
ClearExpenseLinestruetrueoptionaltrueoptional
ClearItemLinestruetrueoptionaltrueoptional
AmountDueInHomeCurrencytruefalsefalsefalsefalse
RefNumbertruetrueoptionaltrueoptional
TermsRef_ListIDtruetrueoptionaltrueoptional
TermsRef_FullNametruetrueoptionaltrueoptional
Memotruetrueoptionaltrueoptional
IsTaxIncludedtruetrueoptionaltrueoptional
SalesTaxCodeRef_ListIDtruetrueoptionaltrueoptional
SalesTaxCodeRef_FullNametruetrueoptionaltrueoptional
IsPaidtruefalsefalsefalsefalse
VendorAddress_Addr1truetrueoptionaltrueoptional
VendorAddress_Addr2truetrueoptionaltrueoptional
VendorAddress_Addr3truetrueoptionaltrueoptional
VendorAddress_Addr4truetrueoptionaltrueoptional
VendorAddress_Addr5truetrueoptionaltrueoptional
VendorAddress_Citytruetrueoptionaltrueoptional
VendorAddress_Statetruetrueoptionaltrueoptional
VendorAddress_PostalCodetruetrueoptionaltrueoptional
VendorAddress_Countrytruetrueoptionaltrueoptional
VendorAddress_Notetruetrueoptionaltrueoptional
OpenAmounttruefalsefalsefalsefalse
ExternalGUIDtruefalsefalseoptional
UserDatauser field
Operationadd,update,delete
  • LinkedTxnRet
  • ExpenseLineRet
  • ItemLineRet
  • ItemGroupLineRet

Powered by BetterDocs