A_JOB_STAGE
Archived Job Stages
tableMANJOB
A_JOB_STAGE — Archived Job Stages. MAN table in the standard Ross ERP 8.0 schema: 46 columns, used by 9 programs. Columns, data types, keys, foreign keys and relationships.
Open A_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 | ARCHIVE_ID | varchar(1) | PK | Prefix Fields for Archive Tables |
| 3 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 4 | FACTORY | varchar(2) | PK | Factory Code |
| 5 | JOB_NUMBER | varchar(10) | PK | Job Number |
| 6 | PROCESS_STAGE | varchar(6) | PK | Process Stage |
| 7 | STD_RECIPE | varchar(15) | Standard (preferred) Recipe | |
| 8 | FLOW_SEQUENCE | int | ||
| 9 | PATH_SEQUENCE | int | ||
| 10 | EARLIEST_START | numeric(20,3) | Earliest Start Time | |
| 11 | LATEST_FINISH | numeric(20,3) | Latest Finish Time | |
| 12 | COUNT_STAGE | varchar(1) | Count Stage | |
| 13 | BACKFLUSH_1 | varchar(1) | Backflush Line Type 1 | |
| 14 | BACKFLUSH_2 | varchar(1) | Backflush Line Type 2 | |
| 15 | BACKFLUSH_3 | varchar(1) | Backflush Line Type 3 | |
| 16 | BACKFLUSH_4 | varchar(1) | Backflush Line Type 4 | |
| 17 | BF_INDICATOR | varchar(1) | Backflush & planning indicator | |
| 18 | TOTAL_COST_ACTUAL | numeric(20,4) | Total Cost Actual | |
| 19 | TOTAL_COST_STD | numeric(20,4) | Total Standard Cost | |
| 20 | ACCUMULATED_STD | numeric(20,6) | Accumulated Standard Cost | |
| 21 | ACCUMULATED_ACTUAL | numeric(20,4) | Accumulated Actual Cost | |
| 22 | BATCH_SIZE | numeric(20,6) | Manufacturing Batch Size | |
| 23 | BATCH_QTY | numeric(20,6) | Manufacturing Batch Qty | |
| 24 | STATUS_FLAG | varchar(1) | Status Flag | |
| 25 | SCHEDULE_ES_DATE | datetime | Schedule Earliest Start Date | |
| 26 | SCHEDULE_EF_DATE | datetime | Earliest Finish Date | |
| 27 | SCHEDULE_LS_DATE | datetime | Schedule Latest Start Date | |
| 28 | SCHEDULE_LF_DATE | datetime | Schedule Latest Finish Date | |
| 29 | OUTPUT_RATIO | numeric(20,4) | Output Ratio | |
| 30 | ACTUAL_START_DATE | datetime | Actual Start Date | |
| 31 | COST_CENTER | varchar(3) | Cost Center Code | |
| 32 | ACTUAL_CLOSE_DATE | datetime | Actual Close Date | |
| 33 | PM_RECIPE_VERSION_NUMBER | int | ||
| 34 | SYS_TEST_GROUP | varchar(6) | Quality Control Test Group Code | |
| 35 | SYS_QC_OUT_OF_SPEC | varchar(1) | QC Results Out of Specification | |
| 36 | SYS_QC_FINISHED | varchar(1) | Quality Controls Test Finished | |
| 37 | CONTROL_LINE | smallint | Control Line Number | |
| 38 | PROCESS_MTI_QC_FINISHED | varchar(1) | ||
| 39 | MTO_QC_FINISHED | varchar(1) | ||
| 40 | PM_EXEC_APPROVAL_STATUS | varchar(1) | Execution Approval Status | |
| 41 | PM_MFG_APPROVAL_STATUS | varchar(1) | Manufacturing Approval Status | |
| 42 | PM_SHIP_APPROVAL_STATUS | varchar(1) | Shipping Approval Status | |
| 43 | ARCHIVE_DATE | datetime | Archive Date | |
| 44 | ARCHIVE_USERNAME | varchar(20) | Username recorded when the row was moved to the archive. | |
| 45 | ENFORCE_MANU_SEQ | smallint | Enforce Manufacturing Sequence | |
| 46 | GEM_ARCHIVE_FLAG | varchar(20) | System flag indicating whether the row has been archived by the GEMBASE archive process. |