A_WORK_ORDER_MASTER
ARCHIVED WORK ORDER MASTER DATABASE TABLE
tableMANWORK
A_WORK_ORDER_MASTER — ARCHIVED WORK ORDER MASTER DATABASE TABLE. MAN table in the standard Ross ERP 8.0 schema: 61 columns, used by 8 programs. Columns, data types, keys, foreign keys and relationships.
Open A_WORK_ORDER_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 | WOM_OWN_ID | varchar(12) | Company/Factory Id | |
| 4 | WOM_WO_ID | numeric(20,0) | PK | Work Order |
| 5 | WOM_WO_DSC | varchar(50) | WO Description | |
| 6 | WOM_CLS_ID | varchar(3) | Classification Id | |
| 7 | WOM_TYP | varchar(1) | WO Type | |
| 8 | WOM_STAT | varchar(2) | WO Status | |
| 9 | WOM_EQP_ID | varchar(20) | Equipment Id | |
| 10 | WOM_TRDE_ID | varchar(5) | Trade Id | |
| 11 | WOM_DPT_ID | varchar(5) | Department Id | |
| 12 | WOM_ACCT_ID | varchar(20) | Charge Account Id | |
| 13 | WOM_CMPL_DTE | datetime | WO Completion Date | |
| 14 | WOM_ACTV_CLO | varchar(1) | Active/Closed WO Indicator | |
| 15 | WOM_CON_NM | varchar(25) | Contact Person | |
| 16 | WOM_DN_TME_HR | numeric(20,2) | Equipment Down Time in Hours | |
| 17 | WOM_TSK_ID | varchar(15) | Associated Task Id | |
| 18 | WOM_RDY_APRV | varchar(1) | WO Ready for Approval Indicator | |
| 19 | WOM_ASSGN_TO | varchar(25) | WO Assigned to | |
| 20 | WOM_PAR_ID | varchar(20) | Parent Equipment Id | |
| 21 | WOM_CAN_REM | varchar(50) | WO Cancellation Remarks | |
| 22 | WOM_CMPL_TME | varchar(4) | Time WO Completed | |
| 23 | WOM_APRV_UID | varchar(16) | User Id who Approved WO | |
| 24 | WOM_VTX_NUM | varchar(10) | Video Text Drawing Number | |
| 25 | WOM_PRI_ID | varchar(1) | Priority Id | |
| 26 | WOM_PROJ_ID | varchar(10) | Project Id | |
| 27 | WOM_PLN_UID | varchar(16) | User Id who Planned WO | |
| 28 | WOM_CMPL_NM | varchar(25) | WO Completed by Name | |
| 29 | WOM_EFF_ID | varchar(3) | Effect of Failure Id | |
| 30 | WOM_APRV_DTE | datetime | WO Approval Date | |
| 31 | WOM_CLO_DTE | datetime | WO Closure Date | |
| 32 | WOM_CLO_UID | varchar(16) | User Id who Closed WO | |
| 33 | WOM_UAPRV_UID | varchar(16) | User Id who Unapproved WO | |
| 34 | WOM_CAU_ID | varchar(3) | Cause of Failure Id | |
| 35 | WOM_REF_ID | varchar(15) | Reference Id | |
| 36 | WOM_NEED_DTE | datetime | WO End Date | |
| 37 | WOM_STD_JOB_IND | varchar(1) | Standard Job Indicator | |
| 38 | WOM_ROLL_IND | varchar(1) | Equipment Cost Rollup Indicator | |
| 39 | WOM_WRK_DSC1 | varchar(72) | Work Description - Line 1 | |
| 40 | WOM_WRK_DSC2 | varchar(72) | Work Description - Line 2 | |
| 41 | WOM_WRK_DSC3 | varchar(72) | Work Description - Line 3 | |
| 42 | WOM_INSTR1 | varchar(72) | Special Instructions - Line 1 | |
| 43 | WOM_INSTR2 | varchar(72) | Special Instructions - Line 2 | |
| 44 | INS_DTE | datetime | Date of Row Insertion | |
| 45 | INS_UID | varchar(20) | User Id who Inserted Row | |
| 46 | INS_TME | varchar(4) | Time of Row Insertion | |
| 47 | WOM_SYS_ID | varchar(3) | EQUIPMENT SYSTEM ID | |
| 48 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 49 | FACTORY_CODE | varchar(2) | PK | Factory Code |
| 50 | JOB_NUMBER | varchar(10) | Job Number | |
| 51 | COST_CENTER | varchar(3) | Cost Center Code | |
| 52 | MM_CHARGE_ACCOUNT_ID | varchar(20) | Charge Account ID | |
| 53 | MM_COMPLETION_REMARKS | text | Completion or Cancellation Remarks | |
| 54 | MM_DESC_OF_PROBLEM | text | Description of the Problem to be corrected or addressed | |
| 55 | MM_HEADER_INSTRUCTIONS | text | Instructions at the Header Level | |
| 56 | MM_MTBF_FLAG | varchar(1) | Mean Time Between Failures and Repairs Flag | |
| 57 | MM_MTBF_DAYS | numeric(20,3) | Mean Time Between Failures in Days | |
| 58 | MM_MTBR_DAYS | numeric(20,3) | Mean Time Between Repairs in Days | |
| 59 | ARCHIVE_DATE | datetime | Archive Date | |
| 60 | ARCHIVE_USERNAME | varchar(20) | Username recorded when the row was moved to the archive. | |
| 61 | GEM_ARCHIVE_FLAG | varchar(20) | System flag indicating whether the row has been archived by the GEMBASE archive process. |