Import Specification:  Employee Labor Rates

Table Name: LookupsEmployeeLaborRates 

Table Type:  Lookups

Current Import Version: 1.0


Data Specification

Field Name

Data Type

Requires Value?

Max Length

Related Table

EmployeeCode

String

Yes

50

Employees

LaborClassCode

String

Yes

50

Labor Classes

LaborSubclassCode

String

Yes

50

Labor Subclasses

LaborRate

Decimal

Yes

Min: 0

Max: 9999


LaborRate2

Decimal

Yes

Min: 0

Max: 9999


LaborRate3

Decimal

Yes

Min: 0

Max: 9999


LaborRate4

Decimal

Yes

Min: 0

Max: 9999


LaborRate5

Decimal

Yes

Min: 0

Max: 9999


LaborRate6

Decimal

Yes

Min: 0

Max: 9999


LaborRate7

Decimal

Yes

Min: 0

Max: 9999


LaborRate8

Decimal

Yes

Min: 0

Max: 9999


LaborRate9

Decimal

Yes

Min: 0

Max: 9999


LaborRate10

Decimal

Yes

Min: 0

Max: 9999


LaborRate11

Decimal

Yes

Min: 0

Max: 9999


LaborRate12

Decimal

Yes

Min: 0

Max: 9999


LaborRate13

Decimal

Yes

Min: 0

Max: 9999


LaborRate14

Decimal

Yes

Min: 0

Max: 9999


LaborRate15

Decimal

Yes

Min: 0

Max: 9999


LaborRate16

Decimal

Yes

Min: 0

Max: 9999


LaborRate17

Decimal

Yes

Min: 0

Max: 9999


LaborRate18

Decimal

Yes

Min: 0

Max: 9999


LaborRate19

Decimal

Yes

Min: 0

Max: 9999


LaborRate20

Decimal

Yes

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