PA_LABOR_CLASSES
PA Labor Classes
tableFINPA
PA_LABOR_CLASSES — PA Labor Classes. FIN table in the standard Ross ERP 8.0 schema: 30 columns, used by 2 programs. Columns, data types, keys, foreign keys and relationships.
Open PA_LABOR_CLASSES in the interactive Data Dictionary →Part of PA 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 | PA_LABOR_CLASS | varchar(4) | PK | Labor Class Code |
| 4 | DESCRIPTION | varchar(30) | Description | |
| 5 | COST_CENTER | varchar(3) | Cost Center Code | |
| 6 | LABOR_PREMIUM_RATE_1 | numeric(5,2) | Labor Premium Rate | |
| 7 | LABOR_PREMIUM_RATE_2 | numeric(5,2) | Labor Premium Rate | |
| 8 | LABOR_PREMIUM_RATE_3 | numeric(5,2) | Labor Premium Rate | |
| 9 | OH_ALLOCATION_FLAG | varchar(1) | Overhead Allocation Flag | |
| 10 | OH_ALLOCATION_BASIS | varchar(1) | Basis of OH Calculation | |
| 11 | OH_ALLOCATION_COST | numeric(20,4) | Overhead Allocation Cost | |
| 12 | LABOR_RATE | numeric(20,4) | Labor Rate | |
| 13 | GL_PA_LABOR_ACCOUNT | varchar(50) | ||
| 14 | GL_PA_LABOR_CODE | varchar(6) | ||
| 15 | GL_PA_LAB_OH_ACCOUNT | varchar(50) | ||
| 16 | GL_PA_LAB_OH_CODE | varchar(6) | ||
| 17 | GL_LABOR_PREM_REC_ACCOUNT | varchar(50) | ||
| 18 | GL_LABOR_PREM_REC_CODE | varchar(6) | ||
| 19 | GL_LABOR_STD_REC_ACCOUNT | varchar(50) | ||
| 20 | GL_LABOR_STD_REC_CODE | varchar(6) | ||
| 21 | GL_LAB_OH_REC_ACCOUNT | varchar(50) | Labour Overhead Recovery Account | |
| 22 | GL_LAB_OH_REC_CODE | varchar(6) | Labor Overhead Recovery Code | |
| 23 | GL_LABOR_PREM_OFFSET_ACCT | varchar(50) | ||
| 24 | GL_LABOR_PREM_OFFSET_CODE | varchar(6) | ||
| 25 | GL_LABOR_STD_OFFSET_ACCT | varchar(50) | ||
| 26 | GL_LABOR_STD_OFFSET_CODE | varchar(6) | ||
| 27 | GL_LAB_OH_OFFSET_ACCT | varchar(50) | ||
| 28 | GL_LAB_OH_OFFSET_CODE | varchar(6) | ||
| 29 | SYSTEM_DATE | datetime | System Date Transaction Made | |
| 30 | SYS_EMPLOYEE_TYPE | smallint | Employee Type |