| Column | Data type | Data type name | Length | Can be queried? | Can be updated? | Can be inserted? | Mandatory when inserting? | Format | Refers To | Version introduced in | Edition available in |
|---|
| TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | | 12.0 | US, CA, UK |
| TimeCreated | 11 | TIMESTAMP | 23 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | | 12.0 | US, CA, UK |
| TimeModified | 93 | TIMESTAMP | 23 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | | 12.0 | US, CA, UK |
| EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | | 12.0 | US, CA, UK |
| TxnNumber | 4 | INTEGER | 9 | True | False | False | False | %112.0f | | 12.0 | US, CA, UK |
| TxnDate | 91 | DATE | 10 | True | True | True | False | CCCC-MM-DD | | 12.0 | US, CA, UK |
| TransferFromAccountRef_ListID | 12 | VARCHAR | 36 | True | True | True | False | %s | | 12.0 | US, CA, UK |
| TransferFromAccountRef_FullName | 12 | VARCHAR | 159 | True | True | True | False | %s | | 12.0 | US, CA, UK |
| FromAccountBalance | 2 | NUMERIC | 15 | True | False | False | False | %10.2f | | 12.0 | US, CA, UK |
| TransferToAccountRef_ListID | 12 | VARCHAR | 36 | True | True | True | False | %s | | 12.0 | US, CA, UK |
| TransferToAccountRef_FullName | 12 | VARCHAR | 159 | True | True | True | False | %s | | 12.0 | US, CA, UK |
| ToAccountBalance | 2 | NUMERIC | 15 | True | True | False | False | %10.2f | | 12.0 | US, CA, UK |
| ClassRef_ListID | 12 | VARCHAR | 36 | True | True | True | False | %s | | 12.0 | US, CA, UK |
| ClassRef_FullName | 12 | VARCHAR | 159 | True | True | True | False | %s | | 12.0 | US, CA, UK |
| Amount | 2 | NUMERIC | 15 | True | True | True | False | %10.2f | | 12.0 | US, CA, UK |
| Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | | 12.0 | US, CA, UK |
