FIELD NAME | FIELD NAME (old) | QUERYABLE | UPDATEABLE | REQUIRED ON UPDATE | INSERTABLE | REQUIRED ON INSERT |
TxnID | true | |||||
TimeCreated | true | |||||
TimeModified | true | |||||
EditSequence | true | |||||
TxnNumber | true | |||||
CustomerRef_ListID | true | |||||
CustomerRef_FullName | true | |||||
ClassRef_ListID | true | |||||
ClassRef_FullName | true | |||||
TemplateRef_ListID | true | |||||
TemplateRef_FullName | true | |||||
TxnDate | true | |||||
RefNumber | true | |||||
BillAddress_Addr1 | true | |||||
BillAddress_Addr2 | true | |||||
BillAddress_Addr3 | true | |||||
BillAddress_Addr4 | true | |||||
BillAddress_Addr5 | true | |||||
BillAddress_City | true | |||||
BillAddress_State | true | |||||
BillAddress_PostalCode | true | |||||
BillAddress_Country | true | |||||
BillAddress_Note | true | |||||
ShipAddress_Addr1 | true | |||||
ShipAddress_Addr2 | true | |||||
ShipAddress_Addr3 | true | |||||
ShipAddress_Addr4 | true | |||||
ShipAddress_Addr5 | true | |||||
ShipAddress_City | true | |||||
ShipAddress_State | true | |||||
ShipAddress_PostalCode | true | |||||
ShipAddress_Country | true | |||||
ShipAddress_Note | true | |||||
IsActive | true | |||||
PONumber | true | |||||
TermsRef_ListID | true | |||||
TermsRef_FullName | true | |||||
DueDate | true | |||||
SalesRepRef_ListID | true | |||||
SalesRepRef_FullName | true | |||||
FOB | true | |||||
Subtotal | true | |||||
ItemSalesTaxRef_ListID | true | |||||
ItemSalesTaxRef_FullName | true | |||||
SalesTaxPercentage | true | |||||
SalesTaxTotal | true | |||||
TotalAmount | true | |||||
CurrencyRef_ListID | true | |||||
CurrencyRef_FullName | true | |||||
ExchangeRate | true | |||||
TotalAmountInHomeCurrency | true | |||||
Memo | true | |||||
CustomerMsgRef_ListID | true | |||||
CustomerMsgRef_FullName | true | |||||
IsToBeEmailed | true | |||||
IsTaxIncluded | true | |||||
CustSalesTaxCodeRef_ListID | true | |||||
CustSalesTaxCodeRef_FullName | true | |||||
Other | true | |||||
CustomField1 | true | |||||
CustomField2 | true | |||||
CustomField3 | true | |||||
CustomField4 | true | |||||
CustomField5 | true | |||||
CustomField6 | true | |||||
CustomField7 | true | |||||
CustomField8 | true | |||||
CustomField9 | true | |||||
CustomField10 | true | |||||
CustomField11 | true | |||||
CustomField12 | true | |||||
CustomField13 | true | |||||
CustomField14 | true | |||||
CustomField15 | true | |||||
ExternalGUID | ||||||
UserData | user field | |||||
Operation | add,update,delete |
- LinkedTxnRet
- EstimateLineRet
- EstimateLineGroupRet