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 Business database, and loads the processed data back into the CloudSuite Business 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).
Related topics