JOB_STAGE
Job Stages
tableMANJOB
JOB_STAGE — Job Stages. MAN table in the standard Ross ERP 8.0 schema: 63 columns, used by 134 programs. Columns, data types, keys, foreign keys and relationships.
Open JOB_STAGE in the interactive Data Dictionary →Part of JOB 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 | JOB_NUMBER | varchar(10) | PK FK→JOBS | Job Number |
| 5 | PROCESS_STAGE | varchar(6) | PK FK→PROCESS_STAGES | Process Stage |
| 6 | STD_RECIPE | varchar(15) | Standard (preferred) Recipe | |
| 7 | FLOW_SEQUENCE | int | ||
| 8 | PATH_SEQUENCE | int | ||
| 9 | EARLIEST_START | numeric(20,3) | Earliest Start Time | |
| 10 | LATEST_FINISH | numeric(20,3) | Latest Finish Time | |
| 11 | COUNT_STAGE | varchar(1) | Count Stage | |
| 12 | BACKFLUSH_1 | varchar(1) | Backflush Line Type 1 | |
| 13 | BACKFLUSH_2 | varchar(1) | Backflush Line Type 2 | |
| 14 | BACKFLUSH_3 | varchar(1) | Backflush Line Type 3 | |
| 15 | BACKFLUSH_4 | varchar(1) | Backflush Line Type 4 | |
| 16 | BF_INDICATOR | varchar(1) | Backflush & planning indicator | |
| 17 | TOTAL_COST_ACTUAL | numeric(20,4) | Total Cost Actual | |
| 18 | TOTAL_COST_STD | numeric(20,4) | Total Standard Cost | |
| 19 | ACCUMULATED_STD | numeric(20,6) | Accumulated Standard Cost | |
| 20 | ACCUMULATED_ACTUAL | numeric(20,4) | Accumulated Actual Cost | |
| 21 | BATCH_SIZE | numeric(20,6) | Manufacturing Batch Size | |
| 22 | BATCH_QTY | numeric(20,6) | Manufacturing Batch Qty | |
| 23 | STATUS_FLAG | varchar(1) | Status Flag | |
| 24 | SCHEDULE_ES_DATE | datetime | Schedule Earliest Start Date | |
| 25 | SCHEDULE_EF_DATE | datetime | Earliest Finish Date | |
| 26 | SCHEDULE_LS_DATE | datetime | Schedule Latest Start Date | |
| 27 | SCHEDULE_LF_DATE | datetime | Schedule Latest Finish Date | |
| 28 | OUTPUT_RATIO | numeric(20,4) | Output Ratio | |
| 29 | ACTUAL_START_DATE | datetime | Actual Start Date | |
| 30 | COST_CENTER | varchar(3) | Cost Center Code | |
| 31 | ACTUAL_CLOSE_DATE | datetime | Actual Close Date | |
| 32 | PM_RECIPE_VERSION_NUMBER | int | FK→RECIPES | |
| 33 | SYS_TEST_GROUP | varchar(6) | Quality Control Test Group Code | |
| 34 | SYS_QC_OUT_OF_SPEC | varchar(1) | QC Results Out of Specification | |
| 35 | SYS_QC_FINISHED | varchar(1) | Quality Controls Test Finished | |
| 36 | CONTROL_LINE | smallint | Control Line Number | |
| 37 | PROCESS_MTI_QC_FINISHED | varchar(1) | ||
| 38 | MTO_QC_FINISHED | varchar(1) | ||
| 39 | PM_EXEC_APPROVAL_STATUS | varchar(1) | Execution Approval Status | |
| 40 | PM_MFG_APPROVAL_STATUS | varchar(1) | Manufacturing Approval Status | |
| 41 | PM_SHIP_APPROVAL_STATUS | varchar(1) | Shipping Approval Status | |
| 42 | GEM_TRANSACTION_ID | varchar(64) | System transaction identifier stamped by GEMBASE when the row was written. | |
| 43 | ENFORCE_MANU_SEQ | smallint | Enforce Manufacturing Sequence | |
| 44 | RF_JOB_EXPORTED | varchar(1) | Indicates whether the job stage is exported to the factory | |
| 45 | PRE_ASSIGN_LOTS | varchar(1) | Pre-assign Lot Numbers | |
| 46 | TOTAL_COST_STD_AT_ACTUAL | numeric(20,4) | ||
| 47 | ACCUMULATED_STD_AT_ACTUAL | numeric(20,6) | ||
| 48 | BATCH_SIZE_ACTUAL | numeric(20,6) | ||
| 49 | OUTPUT_RATIO_ACTUAL | numeric(20,4) | ||
| 50 | YIELD_UOM | varchar(4) | Yield Unit | |
| 51 | YIELD_INPUTS_STANDARD | numeric(20,6) | Standard yield total input | |
| 52 | YIELD_INPUTS_ACTUAL | numeric(20,6) | Actual Yield Total Input | |
| 53 | YIELD_INPUTS_STD_AT_ACTUAL | numeric(20,6) | Standard at Actual yield total input | |
| 54 | YIELD_OUTPUTS_STANDARD | numeric(20,6) | Standard yield total output | |
| 55 | YIELD_OUTPUTS_ACTUAL | numeric(20,6) | Actual Yield Total Output | |
| 56 | YIELD_OUTPUTS_STD_AT_ACTUAL | numeric(20,6) | Standard at Actual yield total output | |
| 57 | YIELD_PCT_STANDARD | numeric(20,6) | Standard yield percentage | |
| 58 | YIELD_PCT_ACTUAL | numeric(20,6) | Actual yield percentage | |
| 59 | YIELD_PCT_STD_AT_ACTUAL | numeric(20,6) | Standard at actual yield percentage | |
| 60 | DETAIL_DESCRIPTION | text | Detailed Description | |
| 61 | BATCH_UOM | varchar(4) | Batch Process Unit of Measure | |
| 62 | GEM_MODIFY_DATE | datetime | System timestamp of the most recent modification to the row, maintained by GEMBASE. | |
| 63 | GEM_ARCHIVE_FLAG | varchar(20) | System flag indicating whether the row has been archived by the GEMBASE archive process. |
Referenced by · 9 foreign keys
BATCH_TIME_CARDSJOB_DETAIL_COSTSJOB_OUTPUTSJOB_OUTPUT_QTYSJOB_STAGE_COSTSJOB_STAGE_COUNTSJOB_STAGE_LINESMACHINE_TIME_INPUTMISCELLANEOUS_CHARGES