RECIPE_LINES
Recipe Lines
tableMANRECIPE
RECIPE_LINES — Recipe Lines. MAN table in the standard Ross ERP 8.0 schema: 101 columns, used by 108 programs. Columns, data types, keys, foreign keys and relationships.
Open RECIPE_LINES 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) | PK | Company Code |
| 3 | FACTORY | varchar(2) | PK | Factory Code |
| 4 | RECIPE_CODE | varchar(15) | PK | Recipe |
| 5 | RECIPE_LINE_NUMBER | smallint | PK | Recipe Line Sequence Number |
| 6 | RECIPE_LINE_TYPE | varchar(1) | Recipe Line Type Code | |
| 7 | RECIPE_MANU_ORDER_SEQ | smallint | Recipe Manufacturing Order Sequence | |
| 8 | COST_CATEGORY | varchar(2) | FK→COST_CATEGORIES | Cost Category |
| 9 | DESCRIPTION | varchar(60) | Description | |
| 10 | DESCRIPTION_CODE | varchar(10) | Description Code | |
| 11 | DETAIL_DESCRIPTION | text | Detailed Description | |
| 12 | BACKFLUSH | varchar(1) | Backflush Required | |
| 13 | STATUS_FLAG | varchar(1) | Status Flag | |
| 14 | SOURCE_TYPE | varchar(1) | FK→SOURCE_TYPES | Source Type |
| 15 | PART_CODE | varchar(15) | Product | |
| 16 | WAREHOUSE | varchar(2) | FK→PART_MASTER_M | Warehouse Code |
| 17 | PART_CODE_ALT | varchar(15) | FK→PART_MASTER_M | Alternate Part Code |
| 18 | INPUT_PRODUCT | varchar(15) | Input Product Code | |
| 19 | INPUT_QTY | numeric(20,6) | Input Quantity | |
| 20 | INPUT_UNIT | varchar(4) | Input Unit of Measure | |
| 21 | MATERIAL_SETUP_QTY | numeric(20,6) | Material Setup Quantity | |
| 22 | YIELD | numeric(5,2) | Percentage Yield | |
| 23 | LABOUR_CLASS | varchar(4) | FK→LABOUR_CLASSES | Labor Class Code |
| 24 | SETUP_TIME_STD | numeric(20,3) | Standard Setup Time | |
| 25 | RUNTIME_STD | numeric(20,3) | Standard Run Time | |
| 26 | RUN_RATE_STD | numeric(20,3) | Manufacturing Run Rate | |
| 27 | SETUP_TIME_UNIT | varchar(1) | FK→TIME_UNITS | Setup Time Unit |
| 28 | TIME_UNIT | varchar(1) | Time Unit | |
| 29 | TIME_RATE_FLAG | varchar(1) | Time Rate Flag | |
| 30 | COMPLETE_ONCE_START | varchar(1) | Complete Once Started Flag | |
| 31 | MACHINE_LABOUR_RATIO | numeric(5,2) | Machine to Labor Ratio | |
| 32 | RATIO_INDIC | varchar(1) | Ratio Indicator | |
| 33 | MACHINE_CODE | varchar(8) | FK→MACHINES | Machine Code |
| 34 | MACHINE_CODE_ALT | varchar(8) | Alternative Machine Code | |
| 35 | CONTINUOUS_FLAG | varchar(1) | Continuous Process Flag | |
| 36 | PROCESS_LINE_CODE | varchar(6) | FK→PROCESS_LINES | Process Line Code |
| 37 | UNIT_COST | numeric(20,6) | Unit Cost | |
| 38 | FIXED_COST | numeric(20,4) | Fixed Cost | |
| 39 | MOVE_TIME | numeric(20,3) | Move Time | |
| 40 | DESTINATION_TYPE | varchar(1) | FK→DESTINATION_TYPES | Destination Type (I-Inv,C-Cust,S-Interstage) |
| 41 | OUTPUT_PRODUCT | varchar(15) | Output Product (Inventory) | |
| 42 | OUTPUT_QTY | numeric(20,6) | Output Quantity | |
| 43 | OUTPUT_UNIT | varchar(4) | Output Unit of Measure | |
| 44 | FINAL_PRODUCT_FLAG | varchar(1) | Final or By Product Indicator | |
| 45 | COST_ALLOCATION_PERCENT | numeric(5,2) | Cost Allocation Percent | |
| 46 | CREDIT_JOB_WITH_BYPRODUCT | varchar(1) | Credit Job with Byproduct | |
| 47 | INPUT_PRODUCT_DESC | varchar(60) | Input Product Description | |
| 48 | OUTPUT_PRODUCT_DESC | varchar(60) | Output Product Description | |
| 49 | OH_COST_CATEGORY | varchar(2) | FK→COST_CATEGORIES | Overhead Cost Category |
| 50 | CONV_TO_PLANNING_UNIT | numeric(20,4) | Conversion to Planning UOM | |
| 51 | LINE_QUEUE_FLAG | varchar(1) | Line Queue Allowed | |
| 52 | THRUPUT_TIME | numeric(20,3) | Process Line Thruput Time | |
| 53 | CLEANDOWN_TIME | numeric(20,3) | Process Line Clean Down time | |
| 54 | WORK_CENTER | varchar(6) | Work Center | |
| 55 | CONTROLLING_INPUT | varchar(1) | Controlling Input | |
| 56 | VENDOR_NUMBER | varchar(12) | Supplier Number (or ID) | |
| 57 | RESOURCE_GROUP_CODE | varchar(6) | FK→RESOURCE_GROUPS | Resource Group |
| 58 | GL_PURCH_CODE | varchar(6) | Gl Purchase Expense Short Code | |
| 59 | GL_PURCH_ACCOUNT | varchar(50) | Gl Purchase Expense Account | |
| 60 | QUEUE_IN_MACHINE | varchar(1) | Queue in machine flag | |
| 61 | USE_PROCESS_LINE_RATE | varchar(1) | Use process line rate flag | |
| 62 | MAX_QUEUE_TIME | numeric(20,3) | Maximum allowable time for queuing | |
| 63 | QUEUE_TIME_UOM | varchar(1) | Maximum Queue Time Units | |
| 64 | GL_MISC_REC_ACCOUNT | varchar(50) | Miscellaneous Recovery Account | |
| 65 | GL_MISC_REC_CODE | varchar(6) | GL Miscellaneous Recovery Code | |
| 66 | LABOUR_UNITS | numeric(10,3) | Labour Required | |
| 67 | CONTROLLING_LINE_NUMBER | smallint | ||
| 68 | SYS_VERSION_NUMBER | int | PK FK→RECIPES | Version Number |
| 69 | PM_JOB_CONTROL_AREA | varchar(6) | FK→PM_JOB_CONTROL_AREAS | Job Control Area |
| 70 | PM_DESCRIPTION_VERSION_NUMBER | int | FK→DESCRIPTION_CODES | |
| 71 | SYS_TEST_GROUP | varchar(6) | Quality Control Test Group Code | |
| 72 | PM_COMPLETE_STAGE | varchar(1) | Needed for Complete Stage Recipe Types | |
| 73 | LINE_INTER_DEPENDENCY | varchar(1) | Line Inter-Dependency | |
| 74 | PM_POT_LINE_NUMBER | smallint | ||
| 75 | PM_POT_STAGE | varchar(6) | ||
| 76 | PM_POTENCY_SORT_SEQUENCE | smallint | Potency Sort Sequence | |
| 77 | PM_LOT_MIXING_ALLOWED | varchar(1) | Lot Mixing Allowed | |
| 78 | HAZARDOUS_INGREDIENT | varchar(1) | ||
| 79 | PM_NOMINATED_UNIT | varchar(4) | Nominated unit of measure in PM | |
| 80 | PM_PACKED_UNIT | varchar(4) | A packaged unit of measure | |
| 81 | PM_FORMULA_CODE | varchar(6) | Formula code for UOM conversions and dependency. | |
| 82 | PM_DEPENDENCY_CODE | varchar(6) | ||
| 83 | GL_MISC_REC_OFFSET_ACCT | varchar(50) | ||
| 84 | GL_MISC_REC_OFFSET_CODE | varchar(6) | ||
| 85 | RCS_CONVERSION_STATUS | varchar(1) | Ren/CS Data Conversion Status | |
| 86 | APS_EXPORT_OPERATION | varchar(1) | Export Job Line to APS | |
| 87 | EXEMPT_LINE | varchar(1) | Exempt Line Flag | |
| 88 | LABOR_IN_SCM | varchar(1) | ||
| 89 | INPUT_QTY_NET | numeric(20,6) | ||
| 90 | INHERIT_EXPIRY | varchar(1) | Inherit Best Before | |
| 91 | PASS_ON_EXPIRY | varchar(1) | Pass On Best Before | |
| 92 | YIELD_ENABLED | varchar(1) | Yield calculation enabled flag | |
| 93 | MACHINE_LABOUR_SETUP_RATIO | numeric(5,2) | ||
| 94 | SETUP_RATIO_INDIC | varchar(1) | ||
| 95 | LABOUR_SETUP_UNITS | numeric(10,3) | ||
| 96 | EXPORT_TO_PT | varchar(1) | Export To PlanetTogether | |
| 97 | PRIMARY_PT_RESOURCE | varchar(1) | Primary PT Resouce | |
| 98 | CONSTRAINT_TYPE | varchar(12) | Constraint Type | |
| 99 | CONSTRAINT_QTY | numeric(20,6) | Constraint Quantity Per Standard Batch | |
| 100 | SCALABLE | varchar(1) | Scalable Flag | |
| 101 | GEM_MODIFY_DATE | datetime | System timestamp of the most recent modification to the row, maintained by GEMBASE. |