Acubiz provides a dedicated file containing information about unit registrations.
Export of Unit Transactions to External System
Note: The following format description is based on a standard configuration. The format can be customized to the specific receiving system (e.g., payroll system). The table below contains the standard fields for payroll integration.
The unit file can be exported independently of both cost and payroll files. The standard format includes the following fields:
| # | Column Name | Datatype | Description |
| 1 | RecordNo | String | Sequential row number |
| 2 | ExportDate | Date | Export date |
| 3 | UnitID | String | Unique ID for the unit category |
| 4 | TravelID | String | Acubiz transaction ID |
| 5 | Unittype | String | Unit type (e.g., pcs) |
| 6 | Units | Numeric | Number of registered units |
| 7 | UnitRate | Numeric | Unit price/rate |
| 8 | UnitTotalAmount | Numeric | Total amount for the registration |
| 9 | Username | String | Name of the user who created the registration |
| 10 | UserInitials | String | User initials |
| 11 | TransactionDate | Date | Transaction creation date |
Formatting and Data Standards
Amounts: Format with comma (
,) as the decimal separator (e.g.,199,45).Dates: Standard format is
dd-mm-yyyy(e.g.,01-01-2025).Customization: Alternative formats for dates and amounts can be configured as needed.
Example Export File (CSV)
Example of a unit file in semicolon-separated format (.csv):
| Record No | Export Date | Unit ID | Travel ID | Unit Type | Units | Unit Rate | Unit Total Amount | Username | User Init | Transaction Date |
| 1 | 04-07-2025 | 1234 | 1000276 | Stk | 1,50 | 500,00 | 750,00 | Peter Sørensen | PSO | 20-06-2025 |
| 2 | 07-07-2025 | 1234 | 1000209 | Stk | 2,50 | 500,00 | 1250,00 | Jane Jespersen | JAJ | 25-06-2025 |
Code snippet
RecordNo;ExportDate;UnitID;TravelID;UnitType;Units;UnitRate;UnitTotalAmount;Username;UserInit;TransactionDate
1;04-07-2025;1234;1000276;Stk;1,50;500,00;750,00;Peter Sørensen;PSO;20-06-2025
2;07-07-2025;1234;1000209;Stk;2,50;500,00;1250,00;Jane Jespersen;JAJ;25-06-2025
Comments
0 comments
Please sign in to leave a comment.