Quickbooks: General Ledger

Description

• Table that unions all records from each model within the double_entry_transactions directory. The table end result is a comprehensive general ledger with an offsetting debit and credit entry for each transaction.

Supported Data Sources

• QuickBooks

Columns

Type	Name	Description
STRING	unique_id	Unique identifier of the general ledger line, dependent on transaction_id, transaction_index, account_id, transaction_type, transaction_source, and source_relation.
STRING	transaction_id	Unique identifier of the transaction. Each transaction will have an offsetting debit and credit record.
STRING	source_relation	The source of the record if the unioning functionality is being used. If not this field will be null.
INTEGER	transaction_index	Unique identifier of the individual debit and credit records of the transaction.
DATE	transaction_date	The date that the transaction occurred.
STRING	customer_id	Reference to the customer associated with the transaction.
STRING	vendor_id	Reference to the vendor associated with the transaction.
DECIMAL	amount	Monetary amount of the transaction line.
STRING	account_id	The identifier of the account associated with the transaction line.
STRING	class_id	Reference to the class associated with the transaction line.
STRING	department_id	Reference to the department with the transaction line.
STRING	account_number	User defined number of the account.
STRING	account_name	Name of the account associated with the transaction line.
BOOLEAN	is_sub_account	Boolean indicating whether the account is a sub account (true) or a parent account (false).
STRING	parent_account_number	The parent account number. If the account is the parent account then the account number is recorded.
STRING	parent_account_name	The parent account name. If the account is the parent account then the account name is recorded.
STRING	account_type	The type of account associated with the transaction line.
STRING	account_sub_type	Sub type of the account associated with the transaction line.
STRING	financial_statement_helper	Either 'balance sheet' or 'income statement' and is used to determine that financial statement the account impacts.
DECIMAL	account_current_balance	Total current balance of the account associated with the transaction line.
STRING	account_class	Class of the account associated with the transaction line. Will be one of 'Expense', 'Revenue', 'Asset', 'Liability', and 'Equity'.
STRING	transaction_type	Identifier of whether the transaction is a debit or credit entry.
STRING	transaction_source	Field signifying the source of transaction (eg. Bill, Invoice, Deposit, Journal Entry, etc.).
STRING	account_transaction_type	Identifier of whether the account is increased by either a debit or credit entry.
DECIMAL	adjusted_amount	The amount that impacts the account. If the transaction_type = account_transaction_type then the impact will increase, otherwise it will decrease the account.
DECIMAL	running_balance	The running balance of the account by each individual day.