Quickbooks: Ap Ar Enhanced

Description

• Table that unions all accounts payable records from int_quickbooks__bill_join and all accounts receivable records from int_quickbooks__invoice_join while also adding customer, vendor, address, and department level detail to the accounts payable and receivable records. Further, date and amountcalculations are included to show if the payable/receivable has been fully paid and/or paid on time.

Supported Data Sources

• QuickBooks

Columns

Type	Name	Description
STRING	transaction_type	Set to 'bill' of the transaction is a bill and 'invoice' if the transaction is an invoice.
STRING	transaction_id	Unique identifier of the transaction for the bill or invoice.
STRING	source_relation	The source of the record if the unioning functionality is being used. If not this field will be null.
STRING	doc_number	The QuickBooks document number reference.
STRING	estimate_id	Unique identifier of the estimate associated with the invoice.
STRING	department_name	Name of the department associated with either the invoice or bill.
STRING	transaction_with	Set to 'vendor' if the transaction type is a bill and 'customer' if the transaction type is an invoice.
STRING	customer_vendor_name	Full name of the vendor (if a bill) or the customer (if an invoice).
DECIMAL	customer_vendor_balance	Total current account balance of the vendor (if a bill) or the customer (if an invoice).
STRING	customer_vendor_address_city	City of the vendor (if a bill) or the customer (if an invoice).
STRING	customer_vendor_address_country	Country of the vendor (if a bill) or the customer (if an invoice).
STRING	customer_vendor_address_line	Address line of the vendor (if a bill) or the customer (if an invoice).
STRING	customer_vendor_website	The website url of the customer or vendor.
STRING	delivery_type	How the invoice was delivered to the customer.
STRING	estimate_status	The status of the invoice estimate (if applicable).
DECIMAL	total_amount	The total monetary amount of the invoice or bill.
DECIMAL	estimate_amount	The total amount estimated of the bill or invoice (if applicable).
DECIMAL	current_balance	The bill or invoice defined remaining balance of the bill or invoice.
DECIMAL	total_current_payment	Sum of all total payments made towards the bill or invoice.
DATE	due_date	The due date for the bill or invoice.
BOOLEAN	is_overdue	Boolean indicating whether the bill or invoice full payment is overdue.
INTEGER	days_overdue	The recent payment minus the due date to show the total days the total payment is overdue.
DATE	initial_payment_date	The first date a payment was provided for the bill or invoice
DATE	recent_payment_date	The last date a payment was provided for the bill or invoice.