EQUIPMENT_DRAWING_XREF
EQUIPMENT-TO-DRAWING CROSS-REFERENCES.
tableMANEQUIPMENT
EQUIPMENT_DRAWING_XREF — EQUIPMENT-TO-DRAWING CROSS-REFERENCES.. MAN table in the standard Ross ERP 8.0 schema: 12 columns, used by 6 programs. Columns, data types, keys, foreign keys and relationships.
Open EQUIPMENT_DRAWING_XREF 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 | EDX_OWN_ID | varchar(12) | Company/Factory Id | |
| 3 | EDX_EQP_ID | varchar(20) | PK FK→EQUIPMENT_MASTER | Equipment Id |
| 4 | EDX_IMG_ID | varchar(20) | Drawing Image Id | |
| 5 | EDX_DWG_ID | varchar(20) | PK | Equipment Drawing Id |
| 6 | EDX_DWG_TYP | varchar(1) | Drawing Type | |
| 7 | EDX_DWG_DSC | varchar(50) | Drawing Description | |
| 8 | INS_UID | varchar(20) | User Id who Inserted Row | |
| 9 | INS_DTE | datetime | Date of Row Insertion | |
| 10 | INS_TME | varchar(4) | Time of Row Insertion | |
| 11 | COMPANY_CODE | varchar(10) | Company Code | |
| 12 | FACTORY_CODE | varchar(2) | Factory Code |