Previous page

Next page

Export Type - PV. PayGlobal CSV date effective

Summary

This export file creates a CSV file. It does not contain column headings and the data is sourced from the Current Actuals Allowance table

Layout

 

 Field

Field Name

Format

Comment

1

EmployeeCode or ExportEmployeeCode (Alternate employee code)

Char 12

Mandatory

2

Allowance code

Char 12

Mandatory

3

Quantity

Double - rounds to 2 decimal places

Mandatory

4

Reduce Quantity

999.99

Optional - Stored in cargo field.

5

RateCode

Char 12

Optional

6

RateAmount

Double - rounds to 4 decimal places

Optional - If supplied, then PayGlobal forces the rate code to be the first override rate.

7

Factor

Double - rounds to 4 decimal places

Optional

8

TotalAmount

Double - rounds to 2 decimal places

Optional

9

Recalculate

Logical - Y/N

Optional

10

ReasonCode

Char 12

Optional

11

DateFrom

Date - yyyymmdd

Optional

12

DateTo

Date - yyyymmdd

Optional

13

AwardCode

Char 12

Optional

14

CostCentreCode

Char 12

Optional

15

JobCode

Char 12

Optional - Imported only if Edit Job codes = "Yes".

16

WAPCode

Char 12

Optional - Will be added only if Company Settings | Transactions tab | Edit WAP Codes = "Yes".

17

Text

Char 250

Optional

 

See also

Modify Company Settings

Rostering - Export to Payroll

T&A - Export to Payroll