| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | MRP_ACC_SHORTAGE | All shortages that are accepted | 10 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |
2 | MRP_BUFFER_RUN | Buffer Run Lock table | 2 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |
3 | MRP_BUFFER_RUN03 | Buffer Run Lock table | 2 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |
4 | MRP_BUF_DEM_ITEM | Supply demand items and uncovered demand items | 2 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |
5 | MRP_BUF_MATERIAL | Buffer Table Material | 4 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |
6 | MRP_BUF_PLANT_DT | Current dates of Plant | 2 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |
7 | MRP_BUF_PLANT_TH | Time horizons of MRP buffer | 2 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |
8 | MRP_BUF_PLAN_SG1 | Buffer Table Planning Segment | 2 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |
9 | MRP_BUF_SDIV_TOT | Supply Demand Items View Totals | 2 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |
10 | MRP_BUF_SHORT_ST | Buffer Table Shortage Statistics | 2 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |
11 | MRP_BUF_SUPPLIER | Buffer Table Supplier | 2 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |
12 | MRP_REQ_NOTE | Requests and Notes for MRP Cockpit | 9 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |
13 | PPH_CACHE_ITEM | Supply demand items and uncovered demand items | 2 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |
14 | PPH_CACHE_MAT | Cache Table Material | 4 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |
15 | PPH_CACHE_PLSEG | Cache Table Planning Segment | 2 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |
16 | PPH_CACHE_PLT_DT | Current dates of Plant | 2 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |
17 | PPH_CACHE_PLT_TH | Time horizons of MRP buffer | 2 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |
18 | PPH_CACHE_SDIVTO | Supply Demand Items View Totals | 2 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |
19 | PPH_CACHE_SHRTST | Cache Table Shortage Statistics | 2 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |
20 | PPH_CACHE_SUPPL | Cache Table Supplier | 2 | MRPPLANT | Plant | nvarchar | 4 | 0 | | |