About Data Exported from this Application to the Generic Payroll Interface
The Export Payroll Information to EPI form summarizes payroll transactions in a table named prlog. Data in the table is then written to a comma-separated values file (.csv). This "external payroll file" is stored in the logical folder specified on the External Payroll Interface Parameters form in the Export Logical Folder field. You can open the file as a spreadsheet to view the data.
The external payroll file is subsequently imported into another payroll application. The other payroll application processes the data, connects to the CloudSuite Industrial database, and loads the processed data back into the CloudSuite Industrial general ledger.
External Payroll File Format
Description | Field Name | Type | Format |
---|---|---|---|
Employee number | emp-num | Integer | >>>>>> |
Transaction date | trans-date | Date | 99/99/99 |
Department | Dept | Character | x(6) |
Shift | Shift | Character | x(3) |
Pay type * | pay-type | Character | x(10) |
Hours | Hrs | Decimal | zzzz9.99 |
Pay rate | pay-rate | Integer | zz9.9999 |
* Pay-type codes: R (regular), O (overtime), V (vacation), H (holiday), S (sick), D (double time).