MASTER_PRODUCTION_SCHEDULE
Master Production Schedule
tableMANMASTER
MASTER_PRODUCTION_SCHEDULE — Master Production Schedule. MAN table in the standard Ross ERP 8.0 schema: 51 columns, used by 41 programs. Columns, data types, keys, foreign keys and relationships.
Open MASTER_PRODUCTION_SCHEDULE in the interactive Data Dictionary →Part of Other tables & objects · all tables, views & procedures
Columns
| # | Column | Type | Key | Description |
|---|---|---|---|---|
| 1 | GEM_DBKEY | int | GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one. | |
| 2 | COMPANY_CODE | varchar(10) | Company Code | |
| 3 | FACTORY | varchar(2) | Factory Code | |
| 4 | PLANNING_LEVEL_CODE | smallint | Planning Level | |
| 5 | PLANNING_ID | varchar(20) | Planning Ident | |
| 6 | BASE_DATE | datetime | Planning Base Date | |
| 7 | PLANNING_PRODUCT | varchar(15) | ||
| 8 | PLANNING_SPEC | varchar(15) | Planning Specification | |
| 9 | BUCKET_OFFSET | int | Time Bucket Offset | |
| 10 | SALES_ORDER_QTY | numeric(20,6) | Sales Order Quantity | |
| 11 | SALES_FORECAST_QTY | numeric(20,6) | Sales Forecast Quantity | |
| 12 | PURCHASE_ORDER_QTY | numeric(20,6) | Purchase Order or Warehouse Transfer Quantity | |
| 13 | PURCHASE_FORECAST_QTY | numeric(20,6) | Purchase Forecast Quantity | |
| 14 | PRODUCTION_QTY | numeric(20,6) | Production Qty | |
| 15 | ADJUSTMENT_QTY | numeric(20,6) | Planning Adjustment | |
| 16 | SYSTEM_DATE | datetime | System Date Transaction Made | |
| 17 | MPS_VERSION | smallint | Master Production Schedule Version | |
| 18 | PLANNING_DATE | datetime | Planning Date | |
| 19 | UNIT_OF_MEASURE | varchar(4) | Unit of Measure | |
| 20 | QTY_AVAILABLE | numeric(20,6) | Qty Available | |
| 21 | SALES_QTY | numeric(20,6) | Sales Qty | |
| 22 | PURCHASE_QTY | numeric(20,6) | Purchase Qty | |
| 23 | PRODUCTION_PROFILE_QTY | numeric(20,6) | Production Profile Qty | |
| 24 | DEMAND_QTY | numeric(20,6) | Demand Qty | |
| 25 | CALENDAR_OPTION_CODE | varchar(4) | Calendar Option | |
| 26 | PLANNING_CALENDAR_CODE | varchar(8) | Planning Calendar Code | |
| 27 | BUCKET_OFFSET_DATE | datetime | ||
| 28 | DEMAND_FENCE_DATE | datetime | ||
| 29 | ORIGINAL_PRODUCTION_QTY | numeric(20,6) | ||
| 30 | FORECAST_ITERATION | varchar(6) | Planning Forecast Iteration Code | |
| 31 | INVENTORY_FORECAST_CODE | varchar(6) | Inventory Forecast Code | |
| 32 | PROCESS_SPEC | varchar(15) | Process Specification | |
| 33 | NUMBER_OF_BATCHES | int | Number Of Production Batches | |
| 34 | PRODUCTION_DEMAND_QTY | numeric(20,6) | Production Demand Quantity | |
| 35 | BATCH_SIZE | numeric(20,6) | Manufacturing Batch Size | |
| 36 | OUTPUT_BUCKET_OFFSET | int | ||
| 37 | MPS_SEQUENCE | int | MPS Sequence Number | |
| 38 | START_TIME | numeric(20,0) | Start Time | |
| 39 | END_TIME | numeric(20,0) | End Time | |
| 40 | CHECKED | varchar(1) | MPS creation internal flag | |
| 41 | OUTPUT_MPS_SEQUENCE | int | ||
| 42 | PLANNED_QTY | numeric(20,6) | Planned Production Qty | |
| 43 | PP_DEPENDANT_DEMAND | numeric(20,6) | Dependant Demand | |
| 44 | PP_LEVEL_CODE | smallint | Low Level Code | |
| 45 | PP_LIVE_PRODUCTION_DEMAND | numeric(20,6) | Live demand for production of Intermediate Quantities | |
| 46 | WAREHOUSE | varchar(2) | Warehouse Code | |
| 47 | TRANSFERS_IN_QTY | numeric(20,6) | Transfers In Qty | |
| 48 | TRANSFERS_OUT_QTY | numeric(20,6) | Transfers Out Qty | |
| 49 | PP_JOB_RUN_NUMBER | varchar(6) | Job Run Number | |
| 50 | STATUS_FLAG | varchar(1) | Status Flag | |
| 51 | PM_DEPARTMENT | varchar(6) | Department |