A_WORK_ORDER_LINE_ITEM_MASTER
ARCHIVED WORK ORDER LINE ITEM MASTER
tableMANWORK
A_WORK_ORDER_LINE_ITEM_MASTER — ARCHIVED WORK ORDER LINE ITEM MASTER. MAN table in the standard Ross ERP 8.0 schema: 69 columns, used by 6 programs. Columns, data types, keys, foreign keys and relationships.
Open A_WORK_ORDER_LINE_ITEM_MASTER in the interactive Data Dictionary →Part of WORK 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 | WOL_OWN_ID | varchar(12) | Company/Factory Id | |
| 4 | WOL_WO_ID | numeric(20,0) | PK | Work Order |
| 5 | WOL_WO_LN_NUM | numeric(20,0) | PK | WO Step Number |
| 6 | WOL_WO_LN_DSC | varchar(50) | Step Description | |
| 7 | WOL_SHIFT_ID | varchar(1) | Shift Id | |
| 8 | WOL_SEQ | numeric(20,0) | Sequence Number | |
| 9 | WOL_EFF_ID | varchar(3) | Effect of Failure | |
| 10 | WOL_TRDE_ID | varchar(5) | Trade Id | |
| 11 | WOL_CRW_ID | varchar(2) | Crew Id | |
| 12 | WOL_REMN_HR | numeric(20,2) | Remaining Hours | |
| 13 | WOL_CLBCK_RQD | varchar(1) | Call Back Required | |
| 14 | WOL_CMPL_TME | varchar(4) | WO Step Completion Time | |
| 15 | WOL_SCH_DTE | datetime | Scheduled Start Date | |
| 16 | WOL_PCT_CMPL | numeric(20,0) | Percent Completed | |
| 17 | WOL_UAPRV_UID | varchar(16) | User Id who Unapproved Step | |
| 18 | WOL_ACTV_CLO | varchar(1) | Active/Closed WO Indicator | |
| 19 | WOL_CMPL_DTE | datetime | Step Completion Date | |
| 20 | WOL_CMPL_NM | varchar(25) | Step Completed by Name | |
| 21 | WOL_DN_TME_HR | numeric(20,2) | Equipment Down Time in Hours | |
| 22 | WOL_RDY_APRV | varchar(1) | Step Ready for Approval Indicator | |
| 23 | WOL_EST_MN | numeric(20,0) | Estimated Workers | |
| 24 | WOL_CAU_ID | varchar(3) | Cause of Failure Id | |
| 25 | WOL_RL_DEF | varchar(1) | Defer Indicator | |
| 26 | WOL_PLN_UID | varchar(16) | User Id who Planned Step | |
| 27 | WOL_STAT | varchar(2) | WO Step Status | |
| 28 | WOL_PLN_DTE | datetime | Step Planned Date | |
| 29 | WOL_NEED_DTE | datetime | WO End Date | |
| 30 | WOL_APRV_DTE | datetime | Step Approval Date | |
| 31 | WOL_APRV_UID | varchar(16) | User Id who Approved Step | |
| 32 | WOL_SCH_PRI_ID | varchar(2) | Scheduled Priority Id | |
| 33 | WOL_PRNT_IND | varchar(1) | Step Print Indicator | |
| 34 | WOL_EST_LBR_HR | numeric(20,2) | Estimated Labor Hours | |
| 35 | WOL_EST_LBR_CST | numeric(20,4) | Estimated Labor Cost | |
| 36 | WOL_EST_STK_CST | numeric(20,4) | Estimated Stock Cost | |
| 37 | WOL_EST_NSTK_CST | numeric(20,4) | Estimated Nonstock Material Cost | |
| 38 | WOL_EST_ADD_CST | numeric(20,4) | Estimated Additional Cost | |
| 39 | WOL_ACT_LBR_HR | numeric(20,2) | Actual Labor Hours | |
| 40 | WOL_ACT_LBR_CST | numeric(20,4) | Actual Labor Cost | |
| 41 | WOL_ACT_STK_CST | numeric(20,4) | Actual Stock Cost | |
| 42 | WOL_ACT_NSTK_CST | numeric(20,4) | Actual Nonstock Material Cost | |
| 43 | WOL_ACT_ADD_CST | numeric(20,4) | Actual Additional Cost | |
| 44 | WOL_WRK_DSC1 | varchar(72) | Work Description - Line 1 | |
| 45 | WOL_WRK_DSC2 | varchar(72) | Work Description - Line 2 | |
| 46 | WOL_WRK_DSC3 | varchar(72) | Work Description - Line 3 | |
| 47 | WOL_CMPL_CMT1 | varchar(72) | Completion Comments - Line 1 | |
| 48 | WOL_CMPL_CMT2 | varchar(72) | Completion Comments - Line 2 | |
| 49 | WOL_CMPL_CMT3 | varchar(72) | Completion Comments - Line 3 | |
| 50 | INS_UID | varchar(20) | User Id who Inserted Row | |
| 51 | INS_DTE | datetime | Date of Row Insertion | |
| 52 | INS_TME | varchar(4) | Time of Row Insertion | |
| 53 | WOL_MATL_IND | varchar(1) | Reserved Material Indicator | |
| 54 | IRL_MR_ID | varchar(15) | Material Request Id | |
| 55 | PRM_PR_ID | varchar(8) | Purchase Request ID | |
| 56 | NBK_NB_ID | varchar(20) | Notebook ID | |
| 57 | NBK_NB_TYP | varchar(5) | Notebook Type | |
| 58 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 59 | FACTORY_CODE | varchar(2) | PK | Factory Code |
| 60 | WOL_BOM_ID | varchar(20) | BILL OF MATERIAL ID | |
| 61 | WOL_BOM_TYP | varchar(1) | BILL OF MATERIAL TYPE | |
| 62 | LABOUR_CLASS | varchar(4) | Labor Class Code | |
| 63 | MM_CHARGE_ACCOUNT_ID | varchar(20) | Charge Account ID | |
| 64 | MM_COMPLETION_REMARKS | text | Completion or Cancellation Remarks | |
| 65 | MM_STEP_INSTRUCTIONS | text | Step_Instructions | |
| 66 | RCS_CONVERSION_STATUS | varchar(1) | Ren/CS Data Conversion Status | |
| 67 | ARCHIVE_DATE | datetime | Archive Date | |
| 68 | ARCHIVE_USERNAME | varchar(20) | Username recorded when the row was moved to the archive. | |
| 69 | GEM_ARCHIVE_FLAG | varchar(20) | System flag indicating whether the row has been archived by the GEMBASE archive process. |