Xero: General Ledger

Description

• Each record represents a journal line item. This ledger is used to create the balance sheet and profit and loss.

Supported Data Sources

• Xero

Columns

Type	Name	Description
STRING	journal_id	Xero identifier for the journal entry
STRING	created_date_utc	The created date of the journal entry
DATE	journal_date	The date the journal was posted
INTEGER	journal_number	Xero generated journal number
STRING	reference	The associated reference to the journal, if present.
STRING	source_id	The identifier for the source transaction. This can be used to join to other Xero tables.
STRING	source_type	The journal source type. This can be used to know which table to join to for additional information.
STRING	source_relation	The source where this data was pulled from. If you are making use of the union_schemas variable, this will be the source schema. If you are making use of the union_databases variable, this will be the source database. If you are not unioining together multiple sources, this will be an empty string.
STRING	journal_line_id	Xero identifier for the journal line.
INTEGER	account_code	Customer defined alpha numeric account code e.g 200 or SALES
STRING	account_id	The Xero identifier for the related account.
STRING	account_name	The name of the related account.
STRING	account_type	The type of the related account.
INTEGER	description	The description from the source transaction line item.
DECIMAL	gross_amount	Gross amount of journal line (NetAmount + TaxAmount).
DECIMAL	net_amount	Net amount of journal line. This will be a positive value for a debit and negative for a credit
DECIMAL	tax_amount	Total tax on a journal line
STRING	tax_name	The name of the tax rate.
STRING	tax_type	The type of the tax rate.
STRING	account_class	The class of account, e.g. ASSET, EQUITY, EXPENSE, LIABILITY, REVENUE
STRING	invoice_id	Source ID where it can be joined to the invoice table.
STRING	bank_transaction_id	Source ID where it can be joined to the bank transaction table.
STRING	bank_transfer_id	Source ID where it can be joined to the bank transfer table.
STRING	manual_journal_id	Source ID where it can be joined to the manual journal table.
STRING	payment_id	Source ID where it can be joined to the payment table.
STRING	credit_note_id	Source ID where it can be joined to the credit note table.
STRING	contact_id	ID of the associated contact, where relevant.
STRING	contact_name	Name of the associated contact, where relevant.