DataExt Table
Back to list of tables.
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 |
ID |
12 |
VARCHAR |
81 |
|
|
|
|
|
|
|
|
OwnerID |
12 |
VARCHAR |
50 |
|
|
|
|
|
|
2.0 |
US, CA, UK |
DataExtName |
12 |
VARCHAR |
31 |
|
|
|
|
|
|
2.0 |
US, CA, UK |
DataExtType |
12 |
VARCHAR |
12 |
|
|
|
|
|
|
2.0 |
US, CA, UK |
ListDataExtType |
12 |
VARCHAR |
23 |
|
|
|
|
|
|
2.0 |
US, CA, UK |
ListObjRef_ListID |
12 |
VARCHAR |
36 |
|
|
|
|
|
|
2.0 |
US, CA, UK |
ListObjRef_FullName |
12 |
VARCHAR |
159 |
|
|
|
|
|
|
2.0 |
US, CA, UK |
TxnDataExtType |
12 |
VARCHAR |
255 |
|
|
|
|
|
|
2.0 |
US, CA, UK |
TxnID |
12 |
VARCHAR |
36 |
|
|
|
|
|
|
2.0 |
US, CA, UK |
TxnLineID |
12 |
VARCHAR |
36 |
|
|
|
|
|
|
2.0 |
US, CA, UK |
OtherDataExtType |
12 |
VARCHAR |
255 |
|
|
|
|
|
|
2.0 |
US, CA, UK |
TimeDeleted |
93 |
TIMESTAMP |
23 |
|
|
|
|
|
|
2.0 |
US, CA, UK |
DataExtValue |
12 |
VARCHAR |
255 |
|
|
|
|
|
|
2.0 |
US, CA, UK |