MACHINES
Machines
tableMANMACHINES
MACHINES — Machines. MAN table in the standard Ross ERP 8.0 schema: 39 columns, used by 75 programs. Columns, data types, keys, foreign keys and relationships.
Open MACHINES 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 | varchar(2) | PK FK→FACTORIES | Factory Code |
| 4 | MACHINE_CODE | varchar(8) | PK | Machine Code |
| 5 | DESCRIPTION | varchar(60) | Description | |
| 6 | DETAIL_DESCRIPTION | text | Detailed Description | |
| 7 | TIME_RATE_FLAG | varchar(1) | Time Rate Flag | |
| 8 | FACTORY_LOCATION | varchar(6) | FK→FACTORY_LOCATIONS | Factory Location |
| 9 | COST_TIME_UNIT | varchar(1) | FK→TIME_UNITS | Cost Time Unit |
| 10 | WORK_CENTER | varchar(6) | FK→WORK_CENTERS | Work Center |
| 11 | COST_CENTER | varchar(3) | Cost Center Code | |
| 12 | COST_CATEGORY | varchar(2) | FK→COST_CATEGORIES | Cost Category |
| 13 | TIME_UNIT | varchar(1) | FK→TIME_UNITS | Time Unit |
| 14 | MACHINE_CAPACITY_TIME | numeric(20,3) | Machine Capacity (Time Units) | |
| 15 | MACHINE_CAPACITY_RATE | int | Machine Capacity (Units/Time Unit) | |
| 16 | MACHINE_CAPACITY_VOLUME | numeric(10,2) | Machine Capacity Volume | |
| 17 | VOLUME_CAPACITY_UNIT | varchar(4) | Volume Capacity Unit | |
| 18 | MACHINE_RECOVERY_FLAG | varchar(1) | Machine Recovery Flag | |
| 19 | MACHINE_RECOVERY_COST | numeric(20,4) | Machine Recovery Cost | |
| 20 | OH_COST_CATEGORY | varchar(2) | FK→COST_CATEGORIES | Overhead Cost Category |
| 21 | OH_ALLOCATION_FLAG | varchar(1) | Overhead Allocation Flag | |
| 22 | OH_ALLOCATION_REQD | varchar(1) | Overhead Allocation Required | |
| 23 | OH_ALLOCATION_BASIS | varchar(1) | Basis of OH Calculation | |
| 24 | OH_ALLOCATION_COST | numeric(20,4) | Overhead Allocation Cost | |
| 25 | OH_ALLOCATION_PERCENT | numeric(5,2) | Overhead Allocation Percentage | |
| 26 | GL_MACHINE_OH_REC_CODE | varchar(6) | Machine Overhead Recovery Code | |
| 27 | GL_MACHINE_OH_REC_ACCOUNT | varchar(50) | Machine Overhead Recovery Account | |
| 28 | JOB_MIXING_ALLOWED | varchar(1) | Mixing of jobs allowed on a machine. | |
| 29 | NUM_IDENTICAL_MACHINES | smallint | Number of Identical Machines | |
| 30 | RESOURCE_GROUP_CODE | varchar(6) | FK→RESOURCE_GROUPS | Resource Group |
| 31 | GL_MACHINE_COST_REC_ACCOUNT | varchar(50) | Machine Cost Recovery Account | |
| 32 | GL_MACHINE_COST_REC_CODE | varchar(6) | Machine Cost Recovery Code | |
| 33 | GL_MACHINE_OH_OFFSET_ACCT | varchar(50) | ||
| 34 | GL_MACHINE_OH_OFFSET_CODE | varchar(6) | ||
| 35 | GL_MACHINE_COST_OFFSET_ACCT | varchar(50) | ||
| 36 | GL_MACHINE_COST_OFFSET_CODE | varchar(6) | ||
| 37 | RCS_CONVERSION_STATUS | varchar(1) | Ren/CS Data Conversion Status | |
| 38 | RF_MACHINE_IN_USE | varchar(1) | Indicates whether the machine is Ross Factory enabled | |
| 39 | GEM_MODIFY_DATE | datetime | System timestamp of the most recent modification to the row, maintained by GEMBASE. |