Skip to content

Table schemas

The normalized tables have the same columns for every iteration of the auditfile. Columns a version does not have are null. See Interoperability for how to export them.

Logical types map to Arrow types as follows: string → utf8, int64 → int64, date → date32, bool → bool, decimal(p,s) → decimal128(p,s). CSV and JSONL write decimals as exact strings and dates as ISO 8601.

Table Rows Columns
header one row: file header and detected version 11
company one row 5
addresses company and customer/supplier addresses 12
accounts ledger accounts (with RGS reference) 13
relations customers/suppliers 15
vat_codes VAT codes 5
periods periods 6
journals journals 8
transactions journal entries (with line counts and debit/credit totals) 13
lines transaction lines with their transaction context 36
line_vat VAT details of transaction lines (line_seq → lines.seq) 8
opening_balance opening-balance lines (from the element or period-0/opening transactions) 11

One row: file header and detected version.

Column Logical type Arrow type
format_version string utf8
family string utf8
fiscal_year string utf8
start_date date date32
end_date date date32
currency string utf8
created date date32
software_name string utf8
software_version string utf8
rgs_version string utf8
declared_version string utf8

company

One row.

Column Logical type Arrow type
name string utf8
identifier string utf8
commerce_number string utf8
tax_registration_country string utf8
tax_registration_id string utf8

addresses

Company and customer/supplier addresses.

Column Logical type Arrow type
owner_type string utf8
owner_id string utf8
seq int64 int64
kind string utf8
street string utf8
number string utf8
number_extension string utf8
property string utf8
city string utf8
postal_code string utf8
region string utf8
country string utf8

accounts

Ledger accounts (with RGS reference).

Column Logical type Arrow type
seq int64 int64
file int64 int64
id string utf8
description string utf8
account_type string utf8
account_kind string utf8
lead_code string utf8
lead_description string utf8
rgs_raw string utf8
rgs_code string utf8
rgs_extension string utf8
rgs_source string utf8
rgs_placeholder bool bool

relations

Customers/suppliers.

Column Logical type Arrow type
seq int64 int64
file int64 int64
id string utf8
name string utf8
relation_type string utf8
relation_kind string utf8
contact string utf8
tax_registration_country string utf8
tax_registration_id string utf8
commerce_number string utf8
email string utf8
telephone string utf8
website string utf8
opening_balance decimal(20,2) decimal128(20,2)
closing_balance decimal(20,2) decimal128(20,2)

vat_codes

VAT codes.

Column Logical type Arrow type
seq int64 int64
id string utf8
description string utf8
payable_account_id string utf8
receivable_account_id string utf8

periods

Periods.

Column Logical type Arrow type
seq int64 int64
key string utf8
number int64 int64
start_date date date32
end_date date date32
description string utf8

journals

Journals.

Column Logical type Arrow type
seq int64 int64
file int64 int64
id string utf8
description string utf8
journal_type string utf8
journal_kind string utf8
offset_account_id string utf8
bank_account string utf8

transactions

Journal entries (with line counts and debit/credit totals).

Column Logical type Arrow type
seq int64 int64
file int64 int64
journal_id string utf8
number string utf8
description string utf8
period_key string utf8
period_number int64 int64
date date date32
source string utf8
user string utf8
line_count int64 int64
total_debit decimal(20,2) decimal128(20,2)
total_credit decimal(20,2) decimal128(20,2)

lines

Transaction lines with their transaction context.

Column Logical type Arrow type
seq int64 int64
transaction_seq int64 int64
file int64 int64
journal_id string utf8
transaction_number string utf8
period_key string utf8
transaction_date date date32
number string utf8
account_id string utf8
amount decimal(20,2) decimal128(20,2)
side string utf8
signed_amount decimal(20,2) decimal128(20,2)
debit decimal(20,2) decimal128(20,2)
credit decimal(20,2) decimal128(20,2)
description string utf8
document_ref string utf8
effective_date date date32
settlement_date date date32
relation_id string utf8
invoice_ref string utf8
order_ref string utf8
receiving_doc_ref string utf8
shipping_doc_ref string utf8
cost_center string utf8
cost_unit string utf8
product string utf8
project string utf8
work_cost_arrangement string utf8
bank_account string utf8
offset_bank_account string utf8
quantity decimal(24,6) decimal128(24,6)
foreign_currency string utf8
foreign_amount decimal(20,2) decimal128(20,2)
foreign_signed_amount decimal(20,2) decimal128(20,2)
exchange_rate decimal(24,6) decimal128(24,6)
vat_count int64 int64

line_vat

VAT details of transaction lines (line_seq → lines.seq).

Column Logical type Arrow type
line_seq int64 int64
transaction_seq int64 int64
index int64 int64
code string utf8
percentage decimal(8,3) decimal128(8,3)
amount decimal(20,2) decimal128(20,2)
side string utf8
signed_amount decimal(20,2) decimal128(20,2)

opening_balance

Opening-balance lines (from the element or period-0/opening transactions).

Column Logical type Arrow type
seq int64 int64
source string utf8
number string utf8
account_id string utf8
amount decimal(20,2) decimal128(20,2)
side string utf8
signed_amount decimal(20,2) decimal128(20,2)
debit decimal(20,2) decimal128(20,2)
credit decimal(20,2) decimal128(20,2)
transaction_seq int64 int64
journal_id string utf8