| FIELD NAME | FIELD NAME (old) | QUERYABLE | UPDATEABLE | REQUIRED ON UPDATE | INSERTABLE | REQUIRED ON INSERT |
| TxnID | true | |||||
| TxnType | true | |||||
| TxnLineID | true | |||||
| TimeCreated | true | |||||
| TimeModified | true | |||||
| EntityRef_ListID | true | |||||
| EntityRef_FullName | true | |||||
| AccountRef_ListID | true | |||||
| AccountRef_FullName | true | |||||
| TxnDate | true | |||||
| RefNumber | true | |||||
| Amount | true | |||||
| CurrencyRef_ListID | true | |||||
| CurrencyRef_FullName | true | |||||
| ExchangeRate | true | |||||
| AmountInHomeCurrency | true | |||||
| Memo | true | |||||
| UserData | user field |
