EQUIPMENT_RELOCATION_HISTORY
EQUIPMENT RE-LOCATION HISTORY
tableMANEQUIPMENT
EQUIPMENT_RELOCATION_HISTORY — EQUIPMENT RE-LOCATION HISTORY. MAN table in the standard Ross ERP 8.0 schema: 24 columns, used by 11 programs. Columns, data types, keys, foreign keys and relationships.
Open EQUIPMENT_RELOCATION_HISTORY in the interactive Data Dictionary →Part of EQUIPMENT 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 | ERH_OWN_ID | varchar(12) | Company/Factory Id | |
| 3 | ERH_AUTO_NUM | numeric(20,0) | PK | Equipment Relocation History Number |
| 4 | ERH_EQP_ID | varchar(20) | PK FK→EQUIPMENT_MASTER | Equipment Id |
| 5 | ERH_TO_EQP_ID | varchar(20) | FK→EQUIPMENT_MASTER | Relocated to Equipment Id |
| 6 | ERH_FM_EQP_ID | varchar(20) | FK→EQUIPMENT_PARENT_MASTER | Relocated From Equipment Id |
| 7 | ERH_CMT1 | varchar(72) | Equipment Relocation Comments - Line 1 | |
| 8 | ERH_CMT2 | varchar(72) | Equipment Relocation Comments - Line 2 | |
| 9 | ERH_LOC_DSC | varchar(30) | Building/Floor/Room Location Description | |
| 10 | ERH_BLDG_ID | varchar(5) | FK→EQUIP_BUILDING_LOCATION_CODES | Building Id |
| 11 | ERH_FLR_ID | varchar(2) | FK→EQUIPMENT_FLOOR_LOCATION_CODES | Floor Id |
| 12 | ERH_RM_ID | varchar(3) | FK→EQUIPMENT_ROOM_LOCATION_CODES | Room Id |
| 13 | ERH_RELO_DTE | datetime | Equipment Relocation Date | |
| 14 | INS_UID | varchar(20) | User Id who Inserted Row | |
| 15 | INS_DTE | datetime | Date of Row Insertion | |
| 16 | INS_TME | varchar(4) | Time of Row Insertion | |
| 17 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 18 | FACTORY_CODE | varchar(2) | PK | Factory Code |
| 19 | ERH_MACHINE | varchar(8) | Equipment Relocation History of Machine | |
| 20 | ERH_DPT_ID | varchar(5) | ERH Department ID | |
| 21 | ERH_ACCT_ID | varchar(20) | ERH Charge Account ID | |
| 22 | ERH_MNT_AREA_ID | varchar(5) | ERH Maintanence Area ID | |
| 23 | ERH_SYS_ID | varchar(3) | ERH System ID | |
| 24 | COST_CENTER | varchar(3) | Cost Center Code |