Xero: Invoice Line Items

Description

• Each record represents an invoice line item, enriched with account, contact and invoice information.

Supported Data Sources

• Xero

Columns

Type	Name	Description
DATETIME	_fivetran_synced	The timestamp that Fivetran last synced the record.
INTEGER	account_code	Customer defined alpha numeric account code e.g 200 or SALES
STRING	line_item_description	The description of the line item
INTEGER	discount_entered_as_percent	The discount rate for the line item as a percentage.
INTEGER	discount_rate	Percentage discount being applied to a line item.
STRING	invoice_id	The Xero identifier for the invoice the line items belongs to.
INTEGER	item_code	User defined item code.
DECIMAL	line_amount	The line amount reflects the discounted price if a DiscountRate has been used.
STRING	line_item_id	Xero identifier for the line item.
DECIMAL	quantity	The quantity of the line item.
DECIMAL	tax_amount	The tax amount is auto calculated as a percentage of the line amount based on the tax rate.
STRING	tax_type	Used as an override if the default Tax Code for the selected AccountCode is not correct.
DECIMAL	unit_amount	The unit amount of each line item.
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.
DATE	invoice_date	The date the invoice was issued.
STRING	updated_date	The date the invoice was last modified.
INTEGER	planned_payment_date	The planned payment date of the invoice, when set.
DATE	due_date	The date the invoice is/was due.
INTEGER	expected_payment_date	The expected payment date of the invoice, when set.
DATE	fully_paid_on_date	The date the invoice was fully paid. Only returned on fully paid invoices
STRING	currency_code	The currency that invoice has been raised in
DECIMAL	currency_rate	The currency rate for a multicurrency invoice
STRING	invoice_number	Alpha numeric code identifying invoice
BOOLEAN	is_sent_to_contact	Boolean to indicate whether the invoice in the Xero app displays as "sent"
STRING	invoice_status	The status of the invoice
STRING	type	The type of the invoice.
INTEGER	url	URL link to a source document
STRING	invoice_reference	Additional reference number. For accounts receivable only.
STRING	account_id	The Xero identifier for the related account.
STRING	account_name	The name of the account.
STRING	account_type	The type of account, e.g. CURRENT, EQUITY, SALES
STRING	account_class	The class of account, e.g. ASSET, EQUITY, EXPENSE, LIABILITY, REVENUE
STRING	contact_name	The name of the associated contact.