Invoice Item

Table name (referenced in Insights SQL queries): marts_mdc__invoice_item

Invoice item represents charges (invoice line items) that are taken as a source of data for the new invoice detail page and invoice docs (PDF and CSV exports).

Columns

Column	Type	Description
account_id	number	Unique identifier of account to which the charge is billed
account_name	varchar	Name of account to which the charge is billed
invoice_id	number	Unique identifier of the invoice to which the line item belongs.
invoice_number	varchar	Number of invoice in which the charge is billed
billing_period_start	date	Start of billing period within which the charge is billed
billing_period_end	date	End of billing period within which the charge is billed
conversion_rate	number	Conversion rate fixed for the billing period for the pair of original and converted currency
warehouse_name	varchar	Name of the warehouse where the receiving occurred.
category	varchar	Human-readable description of the Account Billing View Data category.
subcategory	varchar	Human-readable subcateogry description of the Account Billing View Data category. In comparison to the legacy invoice docs this allows further breakdown categorization of the line items.
date	date	Date when the charge incurred.
description	varchar	The main description of charge that appears in the invoice breakdown (CSV export).
quantity	number	Quantity of units that are charged to the customer. To be multiplied with unit price.
original_unit_price	number	Original unit price used to calculate the total amount. It is in original currency, before conversion to the invoice currency. To be multiplied with quantity,
original_total_price	number	Original total price calculated from quantity and original unit price. This is the total amount in original currency before conversion to the invoice currency.
original_currency	varchar	Original currency of the charge
converted_unit_price	number	Unit price converted from the original unit price to the invoice currency
converted_total_price	number	Total price converted from the original total price to the invoice currency . The exchange rates are fixed for each billing period based on public exchange rates a few days before its start.
converted_currency	varchar	Invoice billing currency
transaction	varchar	Type of transaction the charge is being billed for, e.g. Order, Receiving, Return
reference	varchar	Identifier of the transaction known to the customer
reference_2	varchar	Additional identifier of the transaction known to the customer, e.g. order PO number
tracking_number	varchar	Tracking number of the related shipment, if available for given transaction
store	varchar	Name of store, if available for given transaction
trading_partner	varchar	Name of trading partner, if available for given transaction