item_class
- Last UpdatedNov 20, 2024
- 2 minute read
The item_class table defines classes of items, which are used to make specific items easier to find.
The item class table contains all the possible classes (types or groups) of items that are referenced by the system. Typical classes would be Cases, Cartons, Beverage, or Cans in a beverage plant for example. Classes may also be used to distinguish raw materials (component items) and finished goods (parent items).
The ‘obsolete’ field is used to specify that the item or class is no longer usable, but that is not deleted to preserve the context of existing data that references it.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
item_class_id |
string40 |
Y |
N |
Identify item class |
|
item_class_desc |
string80 |
N |
N |
Description of item class |
|
produced |
logical |
N |
N |
Is this item class produced here? Default = Yes. |
|
consumed |
logical |
N |
N |
Is this item class consumed here? Default = No. |
|
obsolete |
logical |
N |
N |
Default = No. |
|
purchased |
logical |
N |
N |
Should items of this class default to being purchased? Default = No. |
|
sold |
logical |
N |
N |
Should items of this class default to being sold? Default = Yes. |
|
lot_no_format |
string40 |
N |
Y |
Default lot number format for items in this class |
|
last_lot_no |
string40 |
N |
Y |
Last lot number assigned to any item in this class |
|
sublot_no_format |
string40 |
N |
Y |
Default sublot number format for items in this class |
|
last_sublot_no |
string40 |
N |
Y |
Last sublot number assigned to any item in this class |
|
serial_no_lvl |
int32 |
N |
N |
0 if lot_no is the serial number,> 0 if a particular sublot level is the serial number, and -1 (default) if there are no serial numbers |
|
inv_unique_by_job |
logical |
N |
N |
Initial value for same field in item record for items created for this class; default = No |
|
spare1 |
string80 |
N |
Y |
Use defined by language term 5165 |
|
spare2 |
string80 |
N |
Y |
Use defined by language term 5166 |
|
spare3 |
string80 |
N |
Y |
Use defined by language term 5167 |
|
spare4 |
string80 |
N |
Y |
Use defined by language term 5168 |
|
last_edit_comment |
string254 |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
last_edit_by |
string40 |
N |
Y |
Who last changed this record |
|
last_edit_at |
tdatetime |
N |
N |
When this record was last changed |
|
row_id |
ID 1 |
N |
N |
Unique row identifier, for audit trail. |