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