Export Data Structure - Field Descriptions

Data exported from Acubiz is broadly divided into two categories:

1. Accounting to ERP (Accounting System)
2. Payroll-related data

1. Accounting to ERP

Export Types and Structure

To ensure a consistent integration, all export formats use the same basic data structure. The number and order of columns are identical across export types, but the specific field content varies. An export contains the following four types of transactions:

1. Accruals
2. Expenses
3. Invoices
4. Cash Advances

Each journal entry basically consists of two lines: one debit line (D+) and one credit line (C-).

Field Overview (31 Columns)

The symbol ● indicates that the field is filled for the given export type/entry. Parentheses (●) indicate optional or conditional filling.

* When there are multiple attached files, filenames are separated by an asterisk (*).

Base64-encoded image files are transferred exclusively via the XML format and here replace the usual filename specification from the CSV export.

Handling Base64-encoded Files (XML)

When exporting in XML format, receipt images are embedded directly in the document structure as Base64 data under field #30:

<files>
  <file filetype="JPG" filename="[Filename].jpg">[Base64-encoded data]</file>
</files>

See also: Sample files in both CSV and XML formats in the associated documentation archive.