REPET_TASK_EQUIP_LINE_ITEM
Repetitive Task Line Item Master
tableMANREPET
REPET_TASK_EQUIP_LINE_ITEM — Repetitive Task Line Item Master. MAN table in the standard Ross ERP 8.0 schema: 33 columns, used by 16 programs. Columns, data types, keys, foreign keys and relationships.
Open REPET_TASK_EQUIP_LINE_ITEM in the interactive Data Dictionary →Part of Other 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_CODE | varchar(2) | PK | Factory Code |
| 4 | TEL_EQP_ID | varchar(20) | PK | Equipment Id |
| 5 | TEL_TSK_ID | varchar(15) | PK FK→REPET_TASK_EQUIP_TASK_MASTER | Task Id |
| 6 | TEL_TSK_LN_NUM | numeric(20,0) | PK | Task Step |
| 7 | TEL_OWN_ID | varchar(12) | Company/Factory Id | |
| 8 | TEL_TRDE_ID | varchar(5) | FK→PERSONNEL_TRADE_CODES | Trade Id |
| 9 | TEL_SEQ | numeric(20,0) | Sequence Number | |
| 10 | TEL_CRW_ID | varchar(2) | FK→PERSONNEL_CREW_CODES | Crew Id |
| 11 | TEL_SHIFT_ID | varchar(1) | FK→PERSONNEL_SHIFT_CODES | Shift Id |
| 12 | TEL_EST_LBR_HR | numeric(20,2) | Estimated Labor Hours | |
| 13 | TEL_EST_MN | numeric(20,0) | Estimated Workers | |
| 14 | TEL_WRK_DSC1 | varchar(72) | WO Description - Line 1 | |
| 15 | TEL_WRK_DSC2 | varchar(72) | WO Description - Line 2 | |
| 16 | INS_UID | varchar(20) | User Id who Inserted Row | |
| 17 | INS_DTE | datetime | Date of Row Insertion | |
| 18 | INS_TME | varchar(4) | Time of Row Insertion | |
| 19 | TEL_DN_TME | numeric(20,2) | Equipment Dowm Time | |
| 20 | LABOUR_CLASS | varchar(4) | Labor Class Code | |
| 21 | MM_CHARGE_ACCOUNT_ID | varchar(20) | Charge Account ID | |
| 22 | WOL_WO_LN_DSC | varchar(50) | Step Description | |
| 23 | WOL_BOM_ID | varchar(20) | BILL OF MATERIAL ID | |
| 24 | WOL_BOM_TYP | varchar(1) | BILL OF MATERIAL TYPE | |
| 25 | NBK_NB_ID | varchar(20) | Notebook ID | |
| 26 | NBK_NB_TYP | varchar(5) | Notebook Type | |
| 27 | MM_STEP_INSTRUCTIONS | text | Step_Instructions | |
| 28 | MM_SCH_FLAG | varchar(1) | Maintenance schedule flag | |
| 29 | APS_RESOURCE | varchar(25) | Actual Resource selected by the APS system | |
| 30 | EVENT_STATUS_FLAG | varchar(1) | Event Status Flag | |
| 31 | APS_SETUP_START_DATE | datetime | APS Setup Start Date | |
| 32 | MM_SCH_CMPL_DATE | datetime | Maintenance schedule completion date/time | |
| 33 | MM_EARLY_START_DATE | datetime | Maintenance schedule early start date/time |