LABOUR_CLASSES
Labor Classes
tableMANLABOUR
LABOUR_CLASSES — Labor Classes. MAN table in the standard Ross ERP 8.0 schema: 38 columns, used by 71 programs. Columns, data types, keys, foreign keys and relationships.
Open LABOUR_CLASSES 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 | LABOUR_CLASS | varchar(4) | PK | Labor Class Code |
| 5 | DESCRIPTION | varchar(60) | Description | |
| 6 | COST_CENTER | varchar(3) | Cost Center Code | |
| 7 | COST_CATEGORY | varchar(2) | FK→COST_CATEGORIES | Cost Category |
| 8 | OH_COST_CATEGORY | varchar(2) | FK→COST_CATEGORIES | Overhead Cost Category |
| 9 | LABOUR_PREMIUM_RATE_1 | numeric(10,4) | Premium Rate Ratio | |
| 10 | LABOUR_PREMIUM_RATE_2 | numeric(10,4) | Premium Rate Ratio | |
| 11 | LABOUR_PREMIUM_RATE_3 | numeric(10,4) | Premium Rate Ratio | |
| 12 | OH_ALLOCATION_REQD | varchar(1) | Overhead Allocation Required | |
| 13 | OH_ALLOCATION_FLAG | varchar(1) | Overhead Allocation Flag | |
| 14 | OH_ALLOCATION_BASIS | varchar(1) | Basis of OH Calculation | |
| 15 | OH_ALLOCATION_COST | numeric(20,4) | Overhead Allocation Cost | |
| 16 | OH_ALLOCATION_PERCENT | numeric(5,2) | Overhead Allocation Percentage | |
| 17 | WORK_CENTER | varchar(6) | FK→WORK_CENTERS | Work Center |
| 18 | LABOUR_RATE | numeric(20,4) | Labor Rate | |
| 19 | TIME_UNIT | varchar(1) | Time Unit | |
| 20 | TIME_RATE_FLAG | varchar(1) | Time Rate Flag | |
| 21 | RESOURCE_GROUP_CODE | varchar(6) | FK→RESOURCE_GROUPS | Resource Group |
| 22 | GL_LABOUR_PREM_REC_ACCOUNT | varchar(50) | Labor Premium Recovery Account | |
| 23 | GL_LABOUR_PREM_REC_CODE | varchar(6) | Labor Premium Recovery Code | |
| 24 | GL_LABOUR_STD_REC_ACCOUNT | varchar(50) | Labor Standard Recovery Account | |
| 25 | GL_LABOUR_STD_REC_CODE | varchar(6) | Labor Standard Recovery Code | |
| 26 | GL_LAB_OH_REC_ACCOUNT | varchar(50) | Labour Overhead Recovery Account | |
| 27 | GL_LAB_OH_REC_CODE | varchar(6) | Labor Overhead Recovery Code | |
| 28 | JOB_MIXING_ALLOWED | varchar(1) | Mixing of jobs allowed on a machine. | |
| 29 | LABOUR_UNITS_AVAILABLE | numeric(10,3) | Available Labor Units | |
| 30 | GL_LABOUR_PREM_OFFSET_ACCT | varchar(50) | ||
| 31 | GL_LABOUR_PREM_OFFSET_CODE | varchar(6) | ||
| 32 | GL_LABOUR_STD_OFFSET_ACCT | varchar(50) | ||
| 33 | GL_LABOUR_STD_OFFSET_CODE | varchar(6) | ||
| 34 | GL_LAB_OH_OFFSET_ACCT | varchar(50) | ||
| 35 | GL_LAB_OH_OFFSET_CODE | varchar(6) | ||
| 36 | RCS_CONVERSION_STATUS | varchar(1) | Ren/CS Data Conversion Status | |
| 37 | LABOR_IN_SCM | varchar(1) | ||
| 38 | GEM_MODIFY_DATE | datetime | System timestamp of the most recent modification to the row, maintained by GEMBASE. |