Acubiz provides a specific file with information about device registrations
Exporting Unit Transactions to the External System
| Note: The format description below is based on a basic setup and may vary depending on the specific payroll system to which data is to be delivered. As a starting point, the basic information for a payroll system is described below. |
A file with unit transactions can be extracted from Acubiz independently of both the cost and payroll files. The format for units basically contains the following information
| # | Column name | Data | Description |
|---|---|---|---|
| 1 | RecordNo | String | Consecutive number |
| 2 | ExportDate | Dato | Date of export |
| 3 | UnitID | String | The ID of the unit category |
| 4 | TravelID | String | Acubiz transactions ID |
| 5 | Unittype | String | the type of the unit |
| 6 | Units | Numeric | Number of units registered |
| 7 | UnitRate | Numeric | Rate per unit |
| 8 | UnitTotalAmount | Numeric | Total amount for the entire registration |
| 9 | Username | String | Name of the user who made the registration |
| 10 | UserInitials | String | Initials of the user who made the registration |
| 11 | TransactionDate | Date | Transaction creation date |
Example of device file with all records included.
RecordNo;ExportDate;UnitID;TravelID;UnitType;Units;UnitRate;UnitTotalAmount;Username;UserInit;TransactionDate 1;04-07-2025;1234;1000276,00;Stk;1,50;500,00;750,00;Peter Sørensen;PSO;20-06-2025 2;07-07-2025;1234;1000209,00;Stk;2,50;500,00;1250,00;Jane Jespersen;JAJ;25-06-2025
Column format display
Data values are provided as follows:
- Amount: Decimal point is comma "," Ex. 199,45
- Date: (dd-mm-yyyy) Ex. 01-01-2025
There are options for different date and amount setups.
Comments
0 comments
Please sign in to leave a comment.