| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | MRP_ACC_SHORTAGE | All shortages that are accepted | 12 | MRPPLANNINGSEGMENTTYPE | Material requirements planning segment | nvarchar | 2 | 0 | | |
2 | MRP_BUF_DEM_ITEM | Supply demand items and uncovered demand items | 5 | MRPPLANNINGSEGMENTTYPE | Material Rquirements Planning Segment | nvarchar | 2 | 0 | | |
3 | MRP_BUF_PLAN_SG1 | Buffer Table Planning Segment | 5 | MRPPLANNINGSEGMENTTYPE | Material Rquirements Planning Segment | nvarchar | 2 | 0 | | |
4 | MRP_BUF_SDIV_TOT | Supply Demand Items View Totals | 5 | MRPPLANNINGSEGMENTTYPE | Material Rquirements Planning Segment | nvarchar | 2 | 0 | | |
5 | MRP_BUF_SHORT_ST | Buffer Table Shortage Statistics | 5 | MRPPLANNINGSEGMENTTYPE | Material Rquirements Planning Segment | nvarchar | 2 | 0 | | |
6 | MRP_BUF_SUPPLIER | Buffer Table Supplier | 5 | MRPPLANNINGSEGMENTTYPE | Material Rquirements Planning Segment | nvarchar | 2 | 0 | | |
7 | MRP_REQ_NOTE | Requests and Notes for MRP Cockpit | 11 | MRPPLANNINGSEGMENTTYPE | Material requirements planning segment | nvarchar | 2 | 0 | | |
8 | PPH_CACHE_ITEM | Supply demand items and uncovered demand items | 5 | MRPPLANNINGSEGMENTTYPE | Material requirements planning segment | nvarchar | 2 | 0 | | |
9 | PPH_CACHE_PLSEG | Cache Table Planning Segment | 5 | MRPPLANNINGSEGMENTTYPE | Material Rquirements Planning Segment | nvarchar | 2 | 0 | | |
10 | PPH_CACHE_SDIVTO | Supply Demand Items View Totals | 5 | MRPPLANNINGSEGMENTTYPE | Material Rquirements Planning Segment | nvarchar | 2 | 0 | | |
11 | PPH_CACHE_SHRTST | Cache Table Shortage Statistics | 5 | MRPPLANNINGSEGMENTTYPE | Material Rquirements Planning Segment | nvarchar | 2 | 0 | | |
12 | PPH_CACHE_SUPPL | Cache Table Supplier | 5 | MRPPLANNINGSEGMENTTYPE | Material Rquirements Planning Segment | nvarchar | 2 | 0 | | |