MATERIAL TECR Table
View exposing TECR material master reference data including material identifiers, names, and material type attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
MATERIAL_CODE |
Code identifying material. |
VARCHAR2 |
18 |
MATERIAL_KEY |
Surrogate key identifying the material. |
VARCHAR2 |
18 |
MATERIAL_NAME |
Material name associated with the record. |
VARCHAR2 |
50 |
MATERIAL_TYPE |
Material type associated with the record. |
VARCHAR2 |
30 |
MATERIAL_TYPE_CODE |
Code identifying material type. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |