This document describes the fields, columns, and data structure for importing payout references into Acubiz.
1. Process Description
To update transactions in Acubiz with a payout reference after the payout has been made, an external system must provide a return file to Acubiz.
Important: The unique Acubiz Transaction ID (TravelID) must remain intact throughout the entire flow (Acubiz - Payout System - Acubiz), as this ID serves as the primary matching key during the update.
2. Data Structure and Field Definitions
The files must contain the following three mandatory fields:
| Field Name | Description | Format / Type | Example |
| Payout Reference ID | A unique reference value for the payout (usually the bank's payout or transaction ID). | Alphanumeric | 9000500024 |
| Payout Date | The date when the payout was completed in the bank/system. | DD-MM-YYYY | 20-03-2026 |
| Acubiz Transaction ID | The original ID (TravelID) from Acubiz, which is included in the export file to accounting. | Numeric | 1000185 |
3. File Format and Example
File Type: Semicolon-separated CSV file (
.csvor.txt).Encoding: UTF-8
Separator: Semicolon (
;)Headers: The file can be provided without a header line (Clean data).
Data Example (Visual)
| Reference ID | Date | Acubiz ID |
| 9000500024 | 20-03-2026 | 1000185 |
| 9000500025 | 19-03-2026 | 1000187 |
Raw File Structure (Format)
Plaintext
9000500024;20-03-2026;1000185
9000500025;19-03-2026;1000187
Comments
0 comments
Please sign in to leave a comment.