FIELD NAMEFIELD NAME (old)QUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
TxnIDtruefalsetruefalsefalse
TimeCreatedtruefalsetruefalsefalse
TimeModifiedtruefalsetruefalsefalse
EditSequencetruefalsetruefalsefalse
TxnNumbertruefalsefalsefalsefalse
CustomerRef_ListIDtruetrueoptionaltruetrue
CustomerRef_FullNametruetrueoptionaltruetrue
ClassRef_ListIDtruetrueoptionaltrueoptional
ClassRef_FullNametruetrueoptionaltrueoptional
TemplateRef_ListIDtruetrueoptionaltrueoptional
TemplateRef_FullNametruetrueoptionaltrueoptional
TxnDatetruetrueoptionaltrueoptional
RefNumbertruetrueoptionaltrueoptional
BillAddress_Addr1truetrueoptionaltrueoptional
BillAddress_Addr2truetrueoptionaltrueoptional
BillAddress_Addr3truetrueoptionaltrueoptional
BillAddress_Addr4truetrueoptionaltrueoptional
BillAddress_Addr5truetrueoptionaltrueoptional
BillAddress_Citytruetrueoptionaltrueoptional
BillAddress_Statetruetrueoptionaltrueoptional
BillAddress_PostalCodetruetrueoptionaltrueoptional
BillAddress_Countrytruetrueoptionaltrueoptional
BillAddress_Notetruetrueoptionaltrueoptional
ShipAddress_Addr1truetrueoptionaltrueoptional
ShipAddress_Addr2truetrueoptionaltrueoptional
ShipAddress_Addr3truetrueoptionaltrueoptional
ShipAddress_Addr4truetrueoptionaltrueoptional
ShipAddress_Addr5truetrueoptionaltrueoptional
ShipAddress_Citytruetrueoptionaltrueoptional
ShipAddress_Statetruetrueoptionaltrueoptional
ShipAddress_PostalCodetruetrueoptionaltrueoptional
ShipAddress_Countrytruetrueoptionaltrueoptional
ShipAddress_Notetruetrueoptionaltrueoptional
IsActivetruetrueoptionaltrueoptional
PONumbertruetrueoptionaltrueoptional
TermsRef_ListIDtruetrueoptionaltrueoptional
TermsRef_FullNametruetrueoptionaltrueoptional
DueDatetruetrueoptionaltrueoptional
SalesRepRef_ListIDtruetrueoptionaltrueoptional
SalesRepRef_FullNametruetrueoptionaltrueoptional
FOBtruetrueoptionaltrueoptional
Subtotaltruefalsefalsefalsefalse
ItemSalesTaxRef_ListIDtruetrueoptionaltrueoptional
ItemSalesTaxRef_FullNametruetrueoptionaltrueoptional
SalesTaxPercentagetruefalsefalsefalsefalse
SalesTaxTotaltruefalsefalsefalsefalse
TotalAmounttruefalsefalsefalsefalse
CurrencyRef_ListIDtruefalsefalsefalsefalse
CurrencyRef_FullNametruefalsefalsefalsefalse
ExchangeRatetruetrueoptionaltrueoptional
TotalAmountInHomeCurrencytruefalsefalsefalsefalse
Memotruetrueoptionaltrueoptional
CustomerMsgRef_ListIDtruetrueoptionaltrueoptional
CustomerMsgRef_FullNametruetrueoptionaltrueoptional
IsToBeEmailedtruetrueoptionaltrueoptional
IsTaxIncludedtruetrueoptionaltrueoptional
CustSalesTaxCodeRef_ListIDtruetrueoptionaltrueoptional
CustSalesTaxCodeRef_FullNametruetrueoptionaltrueoptional
Othertruetrueoptionaltrueoptional
CustomField1truetrueoptionaltrueoptional
CustomField2truetrueoptionaltrueoptional
CustomField3truetrueoptionaltrueoptional
CustomField4truetrueoptionaltrueoptional
CustomField5truetrueoptionaltrueoptional
CustomField6truetrueoptionaltrueoptional
CustomField7truetrueoptionaltrueoptional
CustomField8truetrueoptionaltrueoptional
CustomField9truetrueoptionaltrueoptional
CustomField10truetrueoptionaltrueoptional
CustomField11truetrueoptionaltrueoptional
CustomField12truetrueoptionaltrueoptional
CustomField13truetrueoptionaltrueoptional
CustomField14truetrueoptionaltrueoptional
CustomField15truetrueoptionaltrueoptional
ExternalGUID
UserDatauser field
Operationadd,update,delete
  • LinkedTxnRet
  • EstimateLineRet
  • EstimateLineGroupRet

Powered by BetterDocs