| 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 |