CIMPLICITYA. ItemTypes Table
| Column | Data Type | Length | Description | Allow Nulls | ||
| 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