A. ItemTypes Table

Column Data Type   Length   Description Allow Nulls
P pKey bigint 8 Item Type primary key
  • Automatically generated
  • Internally used only
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