MATERIAL GROUP Table
Contains codes and descriptions of material groups used in categorizing items ordered through Purchase Orders.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
MATERIAL_GROUP |
A code, usually four digit, defining a Material Group for Purchase Orders to enable reporting by Material Group categories. See also Material Group Description: this latter field gives the text name of the material group defined by the code. |
VARCHAR2 |
9 |
MATERIAL_GROUP_DESCRIPTION |
Description of a Material Group, e.g., Office Supplies, Laboratory Supplies, Maintenance Contract, etc. This is a method of categorizing items on Purchase Orders etc. to enable reporting by Material Group category. |
VARCHAR2 |
20 |
MATERIAL_GROUP_KEY |
Key identifying which Material Group an ordered item belongs to. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
9 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |