Quickbooks: Expenses Sales Enhanced

Description

• Table that unions all expense records from int_quickbooks__expenses_union and all sales records from the int_quickbooks__sales_union while also adding customer, vendor, and department level detail to the expense and sales records.

Supported Data Sources

• QuickBooks

Columns

Type	Name	Description
STRING	transaction_source	Set to 'expense' if the transaction type is an expense and 'sale' if the transaction type is a sale.
STRING	transaction_id	Unique identifier of the transaction for either the expense or sale.
STRING	source_relation	The source of the record if the unioning functionality is being used. If not this field will be null.
INTEGER	transaction_line_id	Unique identifier of either the expense or sale line item.
STRING	doc_number	The QuickBooks document number reference.
STRING	transaction_type	Specifies the expense or sale transaction type (ie. invoice, sales_receipt, deposit, journal entry, etc.).
DATE	transaction_date	The date that the transaction occurred.
STRING	item_id	Unique identifier of the item included in a sale transaction.
DECIMAL	item_quantity	Quantity of items included in the sale transaction.
DECIMAL	item_unit_price	Unit price of the item included in the sale transaction.
STRING	account_id	The identifier of the account associated with either the expense or sale.
STRING	account_name	Name of the account associated with either the expense or sale.
STRING	account_sub_type	Sub type of the account associated with either the expense or sale.
STRING	class_id	Reference to the class associated with either the expense or sale.
STRING	department_id	Reference to the department associated with either the expense or sale.
STRING	department_name	Name of the department associated with either the expense or sale.
STRING	customer_id	Reference to the customer associated with either the expense or sale.
STRING	customer_name	Name of the customer associated with either the expense or sale.
STRING	customer_website	The website url of the customer.
STRING	vendor_id	Reference to the vendor associated with either the expense or sale.
STRING	vendor_name	Name of the vendor associated with either the expense or sale.
STRING	billable_status	Status indicating whether the expense or sale is billable.
STRING	description	Description given to either the expense or sale transaction.
DECIMAL	amount	Monetary amount of either the expense or sale line item.
DECIMAL	total_amount	Total monetary amount of either the expense or sale.