material
Core TableMaterials & Procurement
Inventory of materials and supplies including stock levels, reorder points and classifications.
Primary Key
material_code
Record Type
Operational
Log Tables
material_quantity_log
Summary Views
monthly_material_consumption_summary
Last Updated
May 20, 2026
AI Usefulness
4.3
/ 5.0
High value for AI analytics, prediction and automation.
All (6)Key (1)Calculated (2)
| Field Code | Caption | Data Type | Length | PK | Calculated | Description |
|---|---|---|---|---|---|---|
| material_code | Material Code | Varchar | 50 | — | Unique code for each material. | |
| material_name | Material Name | Varchar | 255 | — | — | Name of the material. |
| material_type_code | Material Type Code | Varchar | 50 | — | — | Reference to material_type. |
| uom_code | UOM Code | Varchar | 50 | — | — | Unit of measure. |
| reorder_level | Reorder Level | Decimal | 18,2 | — | — | Minimum stock to trigger reorder. |
| current_stock | Current Stock | Decimal | 18,2 | — | — | Current available stock quantity. |
Showing 6 of 6 (36 total in schema)
Relationships (Links to)
- material_type N:1Material classification.
- uom N:1Unit of measure.
- supplier N:1Default supplier.
Operational Meaning
Backbone of procurement and consumption tracking — links work orders to inventory and spend.
AI Opportunities
- Demand forecasting
- Stock optimization
- Reorder recommendation
- Supplier performance analysis
Suggested Queries
- "List materials below reorder level by warehouse."
- "Forecast next month's HVAC filter demand."
- "Show top 10 consumed materials by trade."