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 |