Importing CSV Files from Grampian To this Application
This topic describes the process of importing CSV files from the
Grampian database tables to CloudSuite Business.
Importing Data
The external payroll interface (EPI) supports importing specific information from the Grampian database tables to CloudSuite Business in CSV (comma-separated values) format.
The following table maps the Grampian export file columns to the CloudSuite Business PR Distribution Journal table field names. The output file must be in CSV format.
File Layout
Grampian Field Number | Grampian Field Name | Format | Required | ERP Field (Schema) |
---|---|---|---|---|
1 | Payroll Number | 99 | Optional | Not used |
2 | Cost Centre | nvarchar(15) | Required | Characters 1-4 -> journal_mst.acct_unit1. If populated, characters 5-8 -> journal_mst.acct_unit3. If populated, characters 9-12 -> journal_mst.acct_unit4. |
3 | Account Code | nvarchar(15) | Required | Characters 1-12 -> journal_mst.acct |
4 | National Code description | nvarchar(20) | Optional | Not used |
5 | Description | nvarchar(20) | Optional | journal_mst.ref |
6 | Period End Date | 99/99/9999 (ddmmyyyy) | journal_mst.trans_date | |
7 | Debit Value | -999999.99 | If populated -> journal_mst.dom_amount | |
8 | Credit Value | -999999.99 | If populated -> journal_mst.dom_amount |
Related topics