Importing to Payroll - PayGlobal DBF Format

Importing to Payroll - PayGlobal DBF Format

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

Summary

Standard dBase III+ format.

Field Number	Field Name	Format	Comment
1	Employee	Char 12	Mandatory
2	Allowance	Char 12	Mandatory
3	Date	Date	Optional
4	Quantity	Numeric 11,2	Mandatory
5	CostCentre	Char 12	Optional
6	RateCode	Char 12	Optional
7	RateAmount	Numeric 11,4	Optional
8	Factor	Numeric 7,4	Optional
9	Total	Numeric 11,2	Optional
10	Recalculate	Boolean	Optional
11	Reason	Char 12	Optional
12	Award	Char 12	Optional

Notes

CostCode, 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.