|
|
|
Data |
|
Description |
Allow |
|
|
P |
pKey |
bigint |
8 |
Item Type primary key
|
|
|
|
|
id |
varchar |
16 |
Item Type identifier |
|
|
|
|
description |
varchar |
40 |
User description of the Item Type |
|
|
|
|
code |
char |
10 |
Item Type code used for Type Detector in Translation Type Code. |
|
|
|
|
class |
varchar |
16 |
Item Type class |
|
|
|
|
deleted |
bit |
1 |
Flag to indicate the Item Type has been deleted (Internally used only in Historical TADB configuration) |
|
|
|
|
tracking_type |
int |
4 |
Item Type Tracking Type code |
|
|
|
|
|
|
|
1 |
Serialized |
|
|
|
|
|
|
2 |
Non-serialized |
|
P = Primary key
|
|
2. TADB SQL table structure overview. |
