Previous page

Next page

Importing to Payroll - CSVDBF Format

Payroll | Payroll Import Types | Details tab | Import Type field

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

Alt_Rate

Char 1

Rate code: Optional

6

CostCode

Char 12

Cost centre code: Optional

Notes
  • Alt_Rate and CostCode are considered to be null values if empty.
  • Quantity and Factor for this format are always hardcoded to be 1.
  • If the allowance is not a leave-type allowance (V, S, L or O), then the Rateamount is hardcoded as the Quantity in the import file, and PayGlobal uses the first override rate code that it locates.