| 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 |
75 |
|
|
|
|
|
|
|
|
| ItemInventoryAssemblyRef_ListID |
12 |
VARCHAR |
36 |
True |
False |
False |
False |
%s |
ListID
|
1.0 |
US, CA, UK |
| ItemInventoryAssemblyRef_FullName |
12 |
VARCHAR |
159 |
True |
False |
False |
False |
%s |
FullName
|
1.0 |
US, CA, UK |
| TxnDate |
91 |
DATE |
10 |
True |
False |
False |
False |
CCCC-MM-DD |
|
1.0 |
US, CA, UK |
| QuantityCanBuild |
4 |
INTEGER |
9 |
True |
False |
False |
False |
%10.5f |
|
1.0 |
US, CA, UK |