| FIELD NAME | FIELD NAME (old) | QUERYABLE | UPDATEABLE | REQUIRED ON UPDATE | INSERTABLE | REQUIRED ON INSERT |
| TxnID | true | |||||
| TimeCreated | true | |||||
| TimeModified | true | |||||
| EditSequence | true | |||||
| TxnNumber | true | |||||
| TxnDate | true | |||||
| TransferFromAccountRef_ListID | true | |||||
| TransferFromAccountRef_FullName | true | |||||
| FromAccountBalance | true | |||||
| TransferToAccountRef_ListID | true | |||||
| TransferToAccountRef_FullName | true | |||||
| ToAccountBalance | true | |||||
| ClassRef_ListID | true | |||||
| ClassRef_FullName | true | |||||
| Amount | true | |||||
| Memo | true | |||||
| UserData | user field | |||||
| Operation | add,update,delete |