PROCESS_SPEC_RES_COSTS
Process Spec Resource Costs
tableMANPROCESS
PROCESS_SPEC_RES_COSTS — Process Spec Resource Costs. MAN table in the standard Ross ERP 8.0 schema: 38 columns, used by 13 programs. Columns, data types, keys, foreign keys and relationships.
Open PROCESS_SPEC_RES_COSTS 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 | COST_TYPE | smallint | PK | Cost Type |
| 11 | EFFECTIVE_ON_DATE | datetime | PK | Effectivity On Date |
| 12 | COST_CATEGORY | varchar(2) | PK | Cost Category |
| 13 | BOM_LOW_LEVEL_CODE | smallint | BOM Low Level Code | |
| 14 | RECIPE_LINE_TYPE | varchar(1) | Recipe Line Type Code | |
| 15 | WAREHOUSE | varchar(2) | Warehouse Code | |
| 16 | RESOURCE_DESC | varchar(60) | ||
| 17 | INPUT_COST_STD | numeric(20,6) | Standard Input Cost (material, misc) | |
| 18 | INPUT_QTY | numeric(20,6) | Input Quantity | |
| 19 | INPUT_UNIT | varchar(4) | Input Unit of Measure | |
| 20 | UNIT_COST | numeric(20,6) | Unit Cost | |
| 21 | SOURCE_TYPE | varchar(1) | Source Type | |
| 22 | FLOW_SEQUENCE | int | ||
| 23 | PATH_SEQUENCE | int | ||
| 24 | SETUP_COST_STD | numeric(20,6) | Setup Cost Std | |
| 25 | RUNTIME_COST_STD | numeric(20,6) | Run time cost | |
| 26 | OVERHEAD_COST_STD | numeric(20,6) | Overhead Costs Standard | |
| 27 | MAKE_BUY | varchar(1) | PK | Make, Buy or Transfer flag |
| 28 | INPUT_RESOURCE | varchar(15) | ||
| 29 | RUN_VARIABLE_COST | numeric(20,6) | Recipe Runtime Variable Cost | |
| 30 | RUN_FIXED_COST | numeric(20,6) | Recipe Runtime Fixed Cost | |
| 31 | OH_VARIABLE_COST | numeric(20,6) | Recipe Overhead Variable Cost | |
| 32 | OH_FIXED_COST | numeric(20,6) | Recipe Overhead Fixed Cost | |
| 33 | DIRECT_COST_ALLOC_FLAG | varchar(1) | Direct Cost Allocation Flag | |
| 34 | DIRECT_ALLOCATION_COST | numeric(20,6) | Direct Allocation Cost | |
| 35 | OH_ALLOCATION_FLAG | varchar(1) | Overhead Allocation Flag | |
| 36 | OH_ALLOCATION_COST | numeric(20,4) | Overhead Allocation Cost | |
| 37 | COST_ALLOCATION_UOM | varchar(4) | Cost Allocation UOM | |
| 38 | FIXED_COST | numeric(20,4) | Fixed Cost |