REPET_TASK_EQUIP_TASK_MASTER
Equipment Repetitive Task Master
tableMANREPET
REPET_TASK_EQUIP_TASK_MASTER — Equipment Repetitive Task Master. MAN table in the standard Ross ERP 8.0 schema: 52 columns, used by 27 programs. Columns, data types, keys, foreign keys and relationships.
Open REPET_TASK_EQUIP_TASK_MASTER 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 | TEM_OWN_ID | varchar(12) | Company/Factory Id | |
| 3 | TEM_TSK_ID | varchar(15) | PK | Task Id |
| 4 | TEM_DPT_ID | varchar(5) | FK→PERSONNEL_DEPARTMENT_CODES | Department Id |
| 5 | TEM_TSK_IND | varchar(1) | FK→SV_ACTIVE | Task Active/Inactive Indicator |
| 6 | TEM_CUR_WO_ID | numeric(20,0) | Current Work Order | |
| 7 | TEM_EQP_ID | varchar(20) | PK FK→EQUIPMENT_MASTER | Equipment Id |
| 8 | TEM_TRDE_ID | varchar(5) | Trade Id | |
| 9 | TEM_STAT | varchar(1) | FK→SV_TASK_JOB_STATUS | Task WO Status |
| 10 | TEM_LF_DTE | datetime | Late Finish Date | |
| 11 | TEM_CLS_ID | varchar(3) | Classification Id | |
| 12 | TEM_DUE_DTE | datetime | Next Date Task Due | |
| 13 | TEM_ES_DTE | datetime | Early Start Date | |
| 14 | TEM_TSK_DSC | varchar(50) | Task WO Description | |
| 15 | TEM_WRK_DSC1 | varchar(72) | Work Description - Line 1 | |
| 16 | TEM_WRK_DSC2 | varchar(72) | Work Description - Line 2 | |
| 17 | TEM_WRK_DSC3 | varchar(72) | Work Description - Line 3 | |
| 18 | TEM_CLS_CMT1 | varchar(60) | Closing Comments - Line 1 | |
| 19 | TEM_CLS_CMT2 | varchar(60) | Closing Comments - Line 2 | |
| 20 | TEM_BOM_ID | varchar(20) | Bill of Materials | |
| 21 | TEM_CLS_CMT3 | varchar(72) | Closing Comments - Line 3 | |
| 22 | TEM_TSK_TYP | varchar(2) | FK→SV_TASK_TYPE | Task Type |
| 23 | TEM_LST_CMPL | datetime | Last Date Task Completed | |
| 24 | TEM_BOM_TYP | varchar(1) | Bill of Material Type | |
| 25 | TEM_FRQ_ID | varchar(3) | FK→REPET_TASK_FREQUENCY_MASTER | Task Frequency Id |
| 26 | TEM_DLV_ADR | varchar(40) | Delivery Address for Material | |
| 27 | TEM_METR_ID | varchar(20) | FK→REPET_TASK_METER_MASTER | Meter Id |
| 28 | TEM_LST_WO_ID | numeric(20,0) | Last Work Order | |
| 29 | TEM_METR_TRIG | numeric(20,0) | Meter's Trigger Value | |
| 30 | TEM_ROUT_SEQ | numeric(20,0) | Routing Sequence | |
| 31 | TEM_METR_INCR | numeric(20,0) | Meter's Increment Value | |
| 32 | TEM_LST_READ | numeric(20,0) | Latest Meter Reading | |
| 33 | TEM_PRI_ID | varchar(1) | Priority Code | |
| 34 | INS_UID | varchar(20) | User Id who Inserted Row | |
| 35 | INS_DTE | datetime | Date of Row Insertion | |
| 36 | INS_TME | varchar(4) | Time of Row Insertion | |
| 37 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 38 | DIVISION | varchar(2) | Division | |
| 39 | NBK_NB_ID | varchar(20) | Notebook ID | |
| 40 | NBK_NB_TYP | varchar(5) | Notebook Type | |
| 41 | FACTORY_CODE | varchar(2) | PK FK→WORK_ORDER_PRIORITY_CODES | Factory Code |
| 42 | LABOUR_CLASS | varchar(4) | Labor Class Code | |
| 43 | COST_CENTER | varchar(3) | Cost Center Code | |
| 44 | MM_CHARGE_ACCOUNT_ID | varchar(20) | Charge Account ID | |
| 45 | MM_HEADER_INSTRUCTIONS | text | Instructions at the Header Level | |
| 46 | MM_SCH_FLAG | varchar(1) | Maintenance schedule flag | |
| 47 | COMPLETE_ONCE_START | varchar(1) | Complete Once Started Flag | |
| 48 | APS_RESOURCE | varchar(25) | Actual Resource selected by the APS system | |
| 49 | EVENT_STATUS_FLAG | varchar(1) | Event Status Flag | |
| 50 | APS_SETUP_START_DATE | datetime | APS Setup Start Date | |
| 51 | MM_SCH_CMPL_DATE | datetime | Maintenance schedule completion date/time | |
| 52 | MM_EARLY_START_DATE | datetime | Maintenance schedule early start date/time |