MRP_TOTALS_BY_DATE
MRP Totals by Date
tableMANMRP
MRP_TOTALS_BY_DATE — MRP Totals by Date. MAN table in the standard Ross ERP 8.0 schema: 37 columns, used by 7 programs. Columns, data types, keys, foreign keys and relationships.
Open MRP_TOTALS_BY_DATE 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 | PART_CODE | varchar(15) | PK | Product |
| 5 | WAREHOUSE | varchar(2) | PK | Warehouse Code |
| 6 | REQUIRED_DATE | datetime | PK | Required Date |
| 7 | SALES_ORDER_QTY | numeric(20,6) | Sales Order Quantity | |
| 8 | SALES_FORECAST_QTY | numeric(20,6) | Sales Forecast Quantity | |
| 9 | SALES_QTY | numeric(20,6) | Sales Qty | |
| 10 | PRODUCTION_QTY | numeric(20,6) | Production Qty | |
| 11 | PLANNED_PRODUCTION_QTY | numeric(20,6) | ||
| 12 | PRODUCTION_REQUIREMENTS | numeric(20,6) | ||
| 13 | PLANNED_PRODUCTION_REQUIREMENTS | numeric(20,6) | ||
| 14 | SUGGESTED_PURCHASES | numeric(20,6) | ||
| 15 | TOTAL_INPUTS_BEFORE | numeric(20,6) | ||
| 16 | TOTAL_INPUTS_AFTER | numeric(20,6) | ||
| 17 | EXPIRY_QTY | numeric(20,6) | ||
| 18 | TOTAL_OUTPUTS | numeric(20,6) | ||
| 19 | INPUT_QTY_PROCESSED | numeric(20,6) | ||
| 20 | OUTPUT_QTY_PROCESSED | numeric(20,6) | ||
| 21 | QTY_ON_HAND | numeric(20,6) | Quantity on Hand | |
| 22 | PURCHASE_ORDER_QTY_BEFORE | numeric(20,6) | ||
| 23 | PURCHASE_FORECAST_QTY_BEFORE | numeric(20,6) | ||
| 24 | FIRM_PLANNED_PURCHASES_BEFORE | numeric(20,6) | ||
| 25 | PURCHASE_QTY_BEFORE | numeric(20,6) | ||
| 26 | PURCHASE_ORDER_QTY_AFTER | numeric(20,6) | ||
| 27 | PURCHASE_FORECAST_QTY_AFTER | numeric(20,6) | ||
| 28 | FIRM_PLANNED_PURCHASES_AFTER | numeric(20,6) | ||
| 29 | PURCHASE_QTY_AFTER | numeric(20,6) | ||
| 30 | QTY_AVAILABLE | numeric(20,6) | Qty Available | |
| 31 | TRANSFER_QTY_BEFORE | numeric(20,6) | ||
| 32 | TRANSFER_QTY_AFTER | numeric(20,6) | ||
| 33 | SUGGESTED_TRANSFERS | numeric(20,6) | ||
| 34 | FIRM_PLAN_TRANSF_IN_BEFORE | numeric(20,6) | ||
| 35 | FIRM_PLAN_TRANSF_IN_AFTER | numeric(20,6) | ||
| 36 | FIRM_PLAN_TRANSF_OUT_BEFORE | numeric(20,6) | ||
| 37 | FIRM_PLAN_TRANSF_OUT_AFTER | numeric(20,6) |