Summary

Standard dBase III+ format.

Field Number

Field Name

Format

Comment

1

Paylink

Char 6

Employee code: Mandatory

2

Code

Char 4

Allowance code: Mandatory

3

Qty

Numeric 9,2

Quantity: Always overrides this value with 1.

4

AlDate

Date

Date: Optional

5

CostCode

Char 12

Cost centre code: Optional

6

JobCode

Char 12

Job code: Optional

7

Alt_Rate

Char 1

Rate code: Optional

8

Tr_Rate

Numeric 10,4

Rate amount: Optional

9

Tr_Fact

Numeric 7,4

Factor: Optional

10

Tr_Total

Numeric 10,2

Total amount: Optional

11

Reason

Char 4

Reason code: Optional

12

Award

Char7

Award code: Optional

13

Calculate

Char 1

Recalculate: Optional - Should be "N" for "No recalculation". All other values mean Recalculate = True.

14

Reduce_Qty

Numeric 6,2

Optional - Stored in cargo as "Reduce Quantity"

Notes

• CostCode, JobCode, ReasonCode and Award are considered to be null values if empty.
• RateCode, RateAmount, Factor and Total are considered to be null values if empty, unless Recalculate = False; in which case, this format retains the zero (0) for numerics and blank for characters.