Employee Labor Rates
Import Specification: Employee Labor Rates
Table Name: LookupsEmployeeLaborRates
Table Type: Lookups
Current Import Version: 1.0
Data Specification
|
Field Name |
Requires Value? |
Max Length |
Related Table |
Precision |
|
|
EmployeeCode |
String |
Yes |
50 |
|
|
|
LaborClassCode |
String |
Yes |
50 |
|
|
|
LaborSubclassCode |
String |
No |
50 |
|
|
|
LaborRate |
Decimal |
Yes |
Min: 0 Max: 9999 |
|
|
|
LaborRate2 |
Decimal |
No |
Min: 0 Max: 9999 |
|
|
|
LaborRate3 |
Decimal |
No |
Min: 0 Max: 9999 |
|
|
|
LaborRate4 |
Decimal |
No |
Min: 0 Max: 9999 |
|
|
|
LaborRate5 |
Decimal |
No |
Min: 0 Max: 9999 |
|
|
|
LaborRate6 |
Decimal |
No |
Min: 0 Max: 9999 |
|
|
|
LaborRate7 |
Decimal |
No |
Min: 0 Max: 9999 |
|
|
|
LaborRate8 |
Decimal |
No |
Min: 0 Max: 9999 |
|
|
|
LaborRate9 |
Decimal |
No |
Min: 0 Max: 9999 |
|
|
|
LaborRate10 |
Decimal |
No |
Min: 0 Max: 9999 |
|
|
|
LaborRate11 |
Decimal |
No |
Min: 0 Max: 9999 |
|
|
|
LaborRate12 |
Decimal |
No |
Min: 0 Max: 9999 |
|
|
|
LaborRate13 |
Decimal |
No |
Min: 0 Max: 9999 |
|
|
|
LaborRate14 |
Decimal |
No |
Min: 0 Max: 9999 |
|
|
|
LaborRate15 |
Decimal |
No |
Min: 0 Max: 9999 |
|
|
|
LaborRate16 |
Decimal |
No |
Min: 0 Max: 9999 |
|
|
|
LaborRate17 |
Decimal |
No |
Min: 0 Max: 9999 |
|
|
|
LaborRate18 |
Decimal |
No |
Min: 0 Max: 9999 |
|
|
|
LaborRate19 |
Decimal |
No |
Min: 0 Max: 9999 |
|
|
|
LaborRate20 |
Decimal |
No |
Min: 0 Max: 9999 |
|
|
|
EffectiveDate |
Date |
Yes |
- |
|
|
Available Import Header Commands
* This is the default behavior for file import processing of this table.
Page ID:4439-7680-7621