PROCESS_SPEC_INPUT_QTYS
Process Specification Input Planning Quantities
tableMANPROCESS
PROCESS_SPEC_INPUT_QTYS — Process Specification Input Planning Quantities. MAN table in the standard Ross ERP 8.0 schema: 42 columns, used by 14 programs. Columns, data types, keys, foreign keys and relationships.
Open PROCESS_SPEC_INPUT_QTYS in the interactive Data Dictionary →Part of PROCESS 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 | FACTORY | varchar(2) | PK | Factory Code |
| 4 | PROCESS_SPEC | varchar(15) | PK | Process Specification |
| 5 | SYS_VERSION_NUMBER | int | PK | Version Number |
| 6 | PROCESS_STAGE | varchar(6) | PK | Process Stage |
| 7 | RECIPE_CODE | varchar(15) | PK | Recipe |
| 8 | PM_RECIPE_VERSION_NUMBER | int | PK | |
| 9 | RECIPE_LINE_NUMBER | smallint | PK | Recipe Line Sequence Number |
| 10 | RECIPE_LINE_TYPE | varchar(1) | Recipe Line Type Code | |
| 11 | COST_CATEGORY | varchar(2) | Cost Category | |
| 12 | OH_COST_CATEGORY | varchar(2) | Overhead Cost Category | |
| 13 | SOURCE_TYPE | varchar(1) | Source Type | |
| 14 | INPUT_PRODUCT | varchar(15) | Input Product Code | |
| 15 | INPUT_UNIT | varchar(4) | Input Unit of Measure | |
| 16 | INPUT_QTY | numeric(20,6) | Input Quantity | |
| 17 | PLANNING_QTY | numeric(20,6) | Planning Quantity | |
| 18 | LABOUR_CLASS | varchar(4) | Labor Class Code | |
| 19 | SETUP_TIME_STD | numeric(20,3) | Standard Setup Time | |
| 20 | SETUP_TIME_UNIT | varchar(1) | FK→TIME_UNITS | Setup Time Unit |
| 21 | RUNTIME_STD | numeric(20,3) | Standard Run Time | |
| 22 | RUN_RATE_STD | numeric(20,3) | Manufacturing Run Rate | |
| 23 | TIME_UNIT | varchar(1) | Time Unit | |
| 24 | TIME_RATE_FLAG | varchar(1) | Time Rate Flag | |
| 25 | RUNTIME_PLAN | numeric(20,3) | ||
| 26 | MACHINE_CODE | varchar(8) | Machine Code | |
| 27 | MACHINE_LABOUR_RATIO | numeric(5,2) | Machine to Labor Ratio | |
| 28 | RATIO_INDIC | varchar(1) | Ratio Indicator | |
| 29 | MACHINE_LABOUR_PLAN | numeric(20,3) | ||
| 30 | RECIPE_MANU_ORDER_SEQ | smallint | Recipe Manufacturing Order Sequence | |
| 31 | MOVE_TIME | numeric(20,3) | Move Time | |
| 32 | INPUT_COST_STD | numeric(20,6) | Standard Input Cost (material, misc) | |
| 33 | SETUP_COST_STD | numeric(20,6) | Setup Cost Std | |
| 34 | RUNTIME_COST_STD | numeric(20,6) | Run time cost | |
| 35 | OVERHEAD_COST_STD | numeric(20,6) | Overhead Costs Standard | |
| 36 | RECIPE_SCALING_FACTOR | numeric(10,5) | Recipe Scaling Factor | |
| 37 | CONTROLLING_INPUT | varchar(1) | Controlling Input | |
| 38 | EXCESS_QTY | numeric(20,6) | Excess Quantity | |
| 39 | CONV_TO_PLANNING_UNIT | numeric(20,4) | Conversion to Planning UOM | |
| 40 | RESOURCE_GROUP_CODE | varchar(6) | Resource Group | |
| 41 | LABOUR_UNITS | numeric(10,3) | Labour Required | |
| 42 | PM_NOMINATED_UNIT | varchar(4) | Nominated unit of measure in PM |