Accounting

elorus

elorus_detailed_expenses

name	type	description	values
table_x_id	INT	A surrogate key to uniquely identify specific row.
account_x_id	INT	The universal ID of the account_id.
id	STRING
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
total	NUMERIC
source_service	STRING	The name of the service that data were extracted from.
representation	STRING
net	NUMERIC
modified	DATE
item_net	NUMERIC
expense_category	STRING
exchange_rate	NUMERIC
description	STRING
date	DATE	The date (yyyy-MM-dd).
currency_code	STRING
created	DATE
company	STRING
calculator_mode	STRING
amount	NUMERIC

elorus_expenses

name	type	description	values
table_x_id	INT	A surrogate key to uniquely identify specific row.
account_x_id	INT	The universal ID of the account_id.
id	STRING
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
total	NUMERIC
source_service	STRING	The name of the service that data were extracted from.
representation	STRING
net	NUMERIC
modified	DATE
exchange_rate	NUMERIC
date	DATE	The date (yyyy-MM-dd).
currency_code	STRING
created	DATE
company	STRING
calculator_mode	STRING

elorus_invoices

name	type	description	values
id	STRING
total	NUMERIC
status	STRING
shipping_address	STRING
sequence	STRING
representation	STRING
permalink	STRING
payable	NUMERIC
paid	NUMERIC
organization	STRING
number	STRING
net	NUMERIC
mydata_submission_status	STRING
mydata_document_type	STRING
modified	DATE
initial	NUMERIC
exchange_rate	STRING
due_date	STRING
draft	STRING
documenttype	STRING
date	STRING	The date (yyyy-MM-dd).
currency_code	STRING
created	DATE
client_vat_number	STRING
client_tax_office	STRING
client_profession	STRING
client_phone_number	STRING
client_email	STRING
client_display_name	STRING
client_contact_person	STRING
client	STRING
calculator_mode	STRING
billing_address_zip	STRING
billing_address_state	STRING
billing_address_country	STRING
billing_address_city	STRING
billing_address_branch_code	STRING
billing_address_address_line	STRING