MRP_VERSION_CONTROL
tableMANMRP
MRP_VERSION_CONTROL — MAN table in the standard Ross ERP 8.0 schema: 22 columns, used by 28 programs. Columns, data types, keys, foreign keys and relationships.
Open MRP_VERSION_CONTROL in the interactive Data Dictionary →Part of MRP 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) | PK | Company Code |
| 3 | MRP_VERSION | int | PK | MRP Version |
| 4 | MRP_SO_FLAG | varchar(1) | MRP Live Sales Orders included flag | |
| 5 | MRP_SF_FLAG | varchar(1) | MRP Sales Forecasts included flag | |
| 6 | MRP_PO_FLAG | varchar(1) | MRP Live Purchase Orders included flag | |
| 7 | MRP_PF_FLAG | varchar(1) | MRP Purchase Forecasts included flag | |
| 8 | MRP_QOH_FLAG | varchar(1) | MRP Current Qty on Hand included flag | |
| 9 | MRP_BUILD_RUN | varchar(1) | MRP Build Run Yes/No | |
| 10 | DAMPING_DAYS | smallint | Damping Days | |
| 11 | DIVISION | varchar(2) | Division | |
| 12 | MRP_JOB_FLAG | varchar(1) | MRP Include Live jobs Y/N | |
| 13 | MRP_FIRM_PLANNED_PO_FLAG | varchar(1) | MRP flag to indicate whether firm planned PO'sinput to MRP | |
| 14 | MRP_SUGGESTED_ORDERS_FLAGGED | varchar(1) | MRP Suggested Orders flagged for Firm Planning | |
| 15 | MRP_SUGGESTED_ORDERS_FIRMED | varchar(1) | MRP Suggested Orders Firmed flag | |
| 16 | QC_RECEIVING_DAYS | smallint | QC Receiving Days | |
| 17 | DEMAND_FENCE_DATE | datetime | ||
| 18 | RUN_DATE | datetime | ||
| 19 | MAX_QC_RECEIVING_DAYS | smallint | ||
| 20 | MRP_START_DATE | datetime | ||
| 21 | MRP_END_DATE | datetime | ||
| 22 | MRP_WT_FLAG | varchar(1) | MRP Warehouse Transfers included flag |