MSPBots WIKI : QuickBooks Online Public Datasets
Here are the published or Alpha version QuickBooks Online datasets that you can use to create the widgets and dashboards
In total, there are 49 publish/alpha Datasets
| Name | Description | Created Date | Last updated | Fields |
|---|---|---|---|---|
| quickbooksonline_bills_balance of outstanding bills | return to subtotal of outstanding bills | Dec 28, 2020 | Jul 18, 2023 | ["id", "amount", "description", "account_ref_name", "billable_status", "balance", "due_date", "create_time", "last_updated_time", "total_amt", "vendor", "private_note", "bill_number", "doc_number", "transaction_date", "aging_range"] |
| quickbooksonline_bills_bills details | return to all bills details regardless paid or not | Dec 28, 2020 | Jun 18, 2021 | ["Vendor", "Debit Account", "Balance", "Due Date", "Last Update", "Bill Number", "Bill Date", "Total Amt", "Days Till Due"] |
| quickbooksonline_bills_accounts payable aging | output unpaid bill balance for each vendor segregated by different time lapse | Dec 28, 2020 | Jul 18, 2023 | ["vendor", "1-30", "31-60", "61-90", "91_and_over", "total"] |
| quickbooksonline_invoices_invoices details | return to all invoice details whether paid or not | Dec 28, 2020 | Jun 18, 2021 | ["customer", "invoice_id", "balance", "due_date", "aging", "total_amt", "invoice_date"] |
| quickbooksonline_profitandlossstandard | return to accounts related to income statement with balance for a given period | Dec 28, 2020 | Jun 18, 2021 | ["id", "tenant_code", "time_period", "col_data_1", "col_data_2", "row_group", "row_type", "times", "options", "currency", "date_macro", "end_period", "report_name", "report_basis", "start_period", "summarize_columns_by"] |
| QBO GL Accounts | output: balance sheet related accounts and account balance for given point in time | Dec 28, 2020 | Aug 02, 2022 | ["time_period", "account_type", "account_name", "sub_account_name", "amount", "beginning_balance", "ending_balance", "category"] |
| quickbooksonline_invoices_accounts receivable aging | returns to each customers unpaid balances segregated by different time lapse | Dec 28, 2020 | Dec 23, 2022 | ["Customer", "1-30 Days Past Due", "31-60 Days Past Due", "61-90 Days Past Due", "91 And Over", "Total"] |
| Top 25 Outstanding Balances Due by Customer | unpaid balance by client | Jun 09, 2021 | Jun 18, 2021 | ["customer_ref_name", "sum"] |
| Net Profit and Margin PCT - Last 3 month | review net profit and profit margin for last 3 months | Jun 11, 2021 | Jun 18, 2021 | ["time_period", "net_income", "margin_pct"] |
| QBO Profit and Loss Data | For QBO Profit and Loss Data. Jira ticket request: https://jira.mspbots.ai/browse/POSL-1754 | Oct 12, 2021 | Feb 21, 2023 | ["date", "time_period", "account_number", "account", "account_type", "amount", "sales_mapping", "ebitda_mapping", "service_mapping", "picanomics_mapping", "sales_revenue_mapping", "ga_mapping"] |
| QuickBooks Online Invoices | A dataset for invoices from QuickBooks Online with due dates in the last 730 days | Nov 23, 2021 | Dec 10, 2022 | ["terms", "terms_type", "id", "invoice_id", "total_amount", "due_date", "day_due_status", "status", "is_paid", "invoice_number", "memo", "deposit", "balance", "customer", "total_tax", "invoice_date", "invoice_created", "last_update", "aging"] |
| GL Accounts | dataset | Nov 24, 2021 | Dec 10, 2022 | ["fully_qualified_name", "sub_account", "classification", "account_sub_type", "current_balance_with_sub_accounts", "account_type", "current_balance", "active", "account_created", "last_updata", "id", "name"] |
| QBO Invoice | Information on invoices from your Quickbooks setup. Invoices dated within the last 730 days | Nov 26, 2021 | Dec 10, 2022 | ["terms", "terms_type", "id", "invoice", "total_amount", "due_date", "days_due_status", "status", "is_paid", "invoice_number", "memo", "deposit", "balance", "customer", "total_tax", "invoice_date", "invoice_created", "last_update", "aging"] |
| QuickBooks Online - Profit and Loss Data | Profit and Loss details from the current and previous calendar years. | Nov 30, 2021 | May 09, 2023 | ["id", "account_type", "memodescription", "category", "amount", "transaction_number", "account", "date", "date_formatted", "report_period", "transaction_type", "transaction_reference", "company_string", "company_parent", "company_job", "group", "account_number", "category_string"] |
| Quickbooks Online Profit And Loss Detail By Accrual - API | ODS Dataset which generated from Quickbooks Online Profit And Loss Detail By Accrual | Jan 06, 2022 | Jan 18, 2022 | ["id", "tenant_code", "time_period", "start_period", "end_period", "group_name", "group_id", "tx_date", "txn_type", "doc_num", "name", "dept_name", "class_name", "memo", "split_acc", "subt_nat_amount", "rbal_nat_amount"] |
| QuickBooks Online Journalentry - API | ODS Dataset which generated from QuickBooks Online Journalentry | Jan 06, 2022 | Sep 06, 2022 | ["id", "tenant_code", "sync_time", "other_id", "description", "line_id", "detail_type", "last_updated", "created", "transaction_no", "transaction_note", "transaction_date", "account_fully_qualified_name", "account_fully_qualified_value", "posting_type", "amount", "sparse", "adjustment", "department_ref_name", "department_ref_value", "account_name", "sub_account", "account_type", "classification"] |
| QuickBooks Online Credit Memo - API | ODS Dataset which generated from QuickBooks Online Credit Memo | Jan 06, 2022 | Jan 18, 2022 | ["id", "tenant_code", "other_id", "line_id", "line_amount", "line_num", "line_detail_type", "line_salesitemlinedetail_name", "line_salesitemlinedetail_value", "line_salesitemlinedetail_taxcoderef_value", "domain", "sparse", "txn_date", "billaddr_id", "billaddr_city", "billaddr_line1", "billaddr_line2", "billaddr_line3", "billaddr_line4", "billaddr_postalcode", "billaddr_countrysubdivisioncode", "create_time", "last_updated_time", "shipaddr_id", "shipaddr_city", "shipaddr_line1", "shipaddr_line2", "shipaddr_line3", "shipaddr_line4", "shipaddr_postalcode", "shipaddr_countrysubdivisioncode", "total_amt", "billemail_address", "doc_number", "sync_token", "currency_ref_name", "currency_ref_value", "custom_field", "customer_ref_name", "customer_ref_value", "email_status", "print_status", "delivery_time", "delivery_type", "exchange_rate", "home_total_amt", "total_tax", "remaining_credit", "apply_tax_after_discount", "sync_time"] |
| QuickBooks Online Taxagency - API | ODS Dataset which generated from QuickBooks Online Taxagency | Jan 06, 2022 | Jan 18, 2022 | ["id", "tenant_code", "other_id", "sync_time", "do_main", "sparse", "meta_data_create_time", "meta_data_last_updated_time", "sync_token", "display_name", "tax_tracked_on_sales", "tax_tracked_on_purchases"] |
| QuickBooks Online Estimate - API | ODS Dataset which generated from QuickBooks Online Estimate | Jan 06, 2022 | Jan 18, 2022 | ["id", "tenant_code", "other_id", "sync_time", "line", "do_main", "sparse", "txn_date", "bill_addr_id", "bill_addr_line1", "bill_addr_line2", "bill_addr_line3", "bill_addr_line4", "bill_addr_line5", "meta_data_create_time", "meta_data_last_updated_time", "ship_addr_id", "ship_addr_line1", "ship_addr_line2", "ship_addr_line3", "ship_addr_line4", "ship_date", "total_amt", "doc_number", "sync_token", "txn_status", "currency_ref_name", "currency_ref_value", "custom_field", "customer_ref_name", "customer_ref_value", "email_status", "print_status", "private_note", "tracking_num", "customer_memo_value", "exchange_rate", "home_total_amt", "txn_tax_detail_tax_line", "txn_tax_detail_total_tax", "txn_tax_code_ref_value", "expiration_date", "apply_tax_after_discount"] |
| QuickBooks Online Payment - API | ODS Dataset which generated from QuickBooks Online Payment | Jan 06, 2022 | Jan 18, 2022 | ["id", "tenant_code", "other_id", "sync_time", "domain", "sparse", "txn_date", "create_time", "last_updated_time", "total_amt", "sync_token", "currency_ref_name", "currency_ref_value", "customer_ref_name", "customer_ref_value", "unapplied_amt", "process_payment", "deposit_to_account_ref"] |
| QuickBooks Online Balance Sheet - API | ODS Dataset which generated from QuickBooks Online Balance Sheet | Jan 06, 2022 | Jan 18, 2022 | ["id", "tenant_code", "header", "time_period", "parent", "group_name", "type", "summary_name", "summary_value", "start_period", "end_period"] |
| QuickBooks Online Vendor - API | ODS Dataset which generated from QuickBooks Online Vendor | Jan 06, 2022 | Jan 18, 2022 | ["id", "tenant_code", "other_id", "display_name", "print_on_check_name", "sparse", "create_time", "last_updated_time", "balance", "sync_token", "currency_ref_name", "currency_ref_value", "sync_time"] |
| QuickBooks Online General Ledger - API | ODS Dataset which generated from QuickBooks Online General Ledger | Jan 06, 2022 | Jan 18, 2022 | ["id", "tenant_code", "time_period", "name", "type", "account_id", "account_name", "sub_account_id", "sub_account_name", "amount", "balance", "beginning_balance", "time", "currency", "report_name", "report_basis", "end_period", "start_period", "no_report_data", "sync_time", "key"] |
| QuickBoots Online Account - API | ODS Dataset which generated from QuickBoots Online Account | Jan 06, 2022 | Jan 18, 2022 | ["id", "tenant_code", "other_id", "sync_time", "account_id", "account_name", "active", "account_domain", "sparse", "acct_num", "meta_data_create_time", "meta_data_last_updated_time", "parent_ref_value", "sync_token", "sub_account", "account_type", "currency_ref_name", "currency_ref_value", "account_sub_type", "classification", "current_balance", "fully_qualified_name", "current_balance_with_sub_accounts"] |
| QuickBooks Online Employee - API | ODS Dataset which generated from QuickBooks Online Employee | Jan 06, 2022 | Jan 18, 2022 | ["id", "tenant_code", "other_id", "sync_time", "ssn", "active", "gender", "mobile_free_form_number", "employee_domain", "sparse", "meta_data_create_time", "meta_data_last_updated_time", "birth_date", "given_name", "hired_date", "sync_token", "family_name", "middle_name", "display_name", "primary_addr_id", "primary_addr_city", "primary_addr_line1", "primary_addr_postal_code", "primary_addr_country_sub_division_code", "billable_time", "primary_email_addr_address", "print_on_check_name"] |
| QuickBooks Online Bill - API | ODS Dataset which generated from QuickBooks Online Bill | Jan 06, 2022 | Jan 18, 2022 | ["id", "tenant_code", "other_id", "sync_time", "bill_sequeence", "amount", "line_num", "detail_type", "description", "account_ref_name", "account_ref_value", "tax_code_ref", "billable_status", "domain", "sparse", "balance", "due_date", "create_time", "last_updated_time", "total_amt", "linked_txn", "sync_token", "vendor_ref_name", "vendor_ref_value", "currency_ref_name", "currency_ref_value", "private_note", "ap_account_ref_name", "ap_accoun_ref_value", "bill_number"] |
| QuickBooks Online Preferences - API | ODS Dataset which generated from QuickBooks Online Preferences | Jan 06, 2022 | Jan 18, 2022 | ["id", "tenant_code", "other_id", "sync_time", "do_main", "sparse", "meta_data_create_time", "meta_data_last_updated_time", "tax_prefs_using_sales_tax", "tax_group_code_ref_value", "sync_token", "other_prefs_name_value", "report_prefs_report_basis", "report_prefs_calc_aging_report_from_txn_date", "home_currency_value", "currency_prefs_multi_currency_enabled", "sales_forms_prefs_custom_field", "sales_forms_prefs_allow_deposit", "sales_forms_prefs_default_terms_value", "sales_forms_prefs_allow_discount", "sales_forms_prefs_allow_shipping", "sales_forms_prefs_allow_estimates", "sales_forms_prefs_allow_service_date", "sales_forms_prefs_custom_txn_numbers", "sales_forms_prefs_using_price_levels", "sales_forms_prefs_ipn_support_enabled", "sales_forms_prefs_e_transaction_attach_p_d_f", "sales_forms_prefs_default_discount_account", "sales_forms_prefs_default_shipping_account", "sales_forms_prefs_e_transaction_enabled_status", "sales_forms_prefs_e_transaction_payment_enabled", "time_tracking_prefs_use_services", "time_tracking_prefs_bill_customers", "time_tracking_prefs_show_bill_rate_to_all", "time_tracking_prefs_mark_time_entries_billable", "invoice_message_message", "invoice_message_subject", "estimate_message_message", "estimate_message_subject", "statement_message_message", "statement_message_subject", "sales_receipt_message_message", "sales_receipt_message_subject", "accounting_info_prefs_track_departments", "accounting_info_prefs_class_tracking_per_txn", "accounting_info_prefs_customer_terminology", "accounting_info_prefs_class_tracking_per_txn_line", "product_and_services_prefs_for_sales", "product_and_services_prefs_for_purchase", "product_and_services_prefs_quantity_on_hand", "product_and_services_prefs_quantity_with_price_and_rate", "default_terms_name", "vendor_and_purchases_prefs_default_terms_value", "vendor_and_purchases_prefs_default_markup", "vendor_and_purchases_prefs_p_o_custom_field", "vendor_and_purchases_prefs_tracking_by_customer", "default_markup_account_value", "vendor_and_purchases_prefs_billable_expense_tracking"] |
| QuickBooks Online Customer - API | ODS Dataset which generated from QuickBooks Online Customer | Jan 06, 2022 | Jan 18, 2022 | ["id", "tenant_code", "other_id", "sync_time", "email_address", "company_domain", "sparse", "country", "meta_data_create_time", "meta_data_last_updated_time", "legal_addr_id", "legal_addr_city", "legal_addr_line1", "legal_addr_country", "legal_addr_postal_code", "legal_addr_country_sub_division_code", "legal_name", "name_value", "sync_token", "employer_id", "company_addr_id", "company_addr_city", "company_addr_line1", "company_addr_country", "company_addr_postal_code", "company_addr_country_sub_division_code", "company_name", "primary_phone_free_form_number", "company_start_date", "supported_languages", "fiscal_year_start_month", "customer_communication_addr_id", "customer_communication_addr_city", "customer_communication_addr_line1", "customer_communication_addr_country", "customer_communication_addr_postal_code", "customer_communication_addr_country_sub_division_code"] |
| QuickBooks Online Profit And Loss - API | ODS Dataset which generated from QuickBooks Online Profit And Loss | Jan 06, 2022 | Jan 18, 2022 | ["id", "tenant_code", "header", "time_period", "parent", "group_name", "type", "summary_name", "summary_value", "start_period", "end_period"] |
| QuickBooks Online Invoice - API | ODS Dataset which generated from QuickBooks Online Invoice | Jan 06, 2022 | Jan 18, 2022 | ["id", "tenant_code", "invoice_id", "doc_number", "balance", "total_amt", "customer_ref_name", "due_date", "txn_date", "print_status", "email_status", "total_tax", "create_time", "last_updated_time", "sync_time", "sales_term_ref_name", "sales_term_ref_value", "customer_memo_value", "deposit"] |
| QuickBooks Online Company Info - API | ODS Dataset which generated from QuickBooks Online Company Info | Jan 06, 2022 | Jan 18, 2022 | ["id", "tenant_code", "other_id", "sync_time", "email_address", "company_domain", "sparse", "country", "meta_data_create_time", "meta_data_last_updated_time", "legal_addr_id", "legal_addr_city", "legal_addr_line1", "legal_addr_country", "legal_addr_postal_code", "legal_addr_country_sub_division_code", "legal_name", "name_value", "sync_token", "employer_id", "company_addr_id", "company_addr_city", "company_addr_line1", "company_addr_country", "company_addr_postal_code", "company_addr_country_sub_division_code", "company_name", "primary_phone_free_form_number", "company_start_date", "supported_languages", "fiscal_year_start_month", "customer_communication_addr_id", "customer_communication_addr_city", "customer_communication_addr_line1", "customer_communication_addr_country", "customer_communication_addr_postal_code", "customer_communication_addr_country_sub_division_code"] |
| QuickBooks Online Deposit - API | ODS Dataset which generated from QuickBooks Online Deposit | Jan 06, 2022 | Jan 18, 2022 | ["tenant_code", "other_id", "amount", "linked_txn", "description", "deposit_line_detail", "domain", "sparse", "txn_date", "create_time", "last_updated_time", "total_amt", "sync_token", "currency_ref_name", "currency_ref_value", "private_note", "exchange_rate", "deposit_to_account_ref_name", "deposit_to_account_ref_value"] |
| QuickBooks Online Cash Flow - API | ODS Dataset which generated from QuickBooks Online Cash Flow | Jan 06, 2022 | Jun 27, 2023 | ["id", "tenant_code", "header", "time_period", "parent", "group_name", "type", "summary_name", "summary_value"] |
| Quickbooks Online Bills | Information on bills within Quickbooks | Feb 22, 2022 | Oct 26, 2023 | ["id", "bill_id", "terms", "term_type", "bill_number", "vendor", "bill_date", "total_amount", "ap_account", "due_date", "aging", "balance", "is_paid", "status", "days_due_status", "create_time", "bill_created", "last_update"] |
| QuickBooks Online Profit and Loss Data - Mapped | A dataset from the profit and loss data of Quickbooks Online integrated with the accounting mappings | Feb 25, 2022 | Feb 21, 2023 | ["date", "time_period", "year", "account_number", "account", "account_type", "amount", "bering_mckinley_account_category", "bering_mckinley_account_group", "sli_account_subcategory", "sli_account_category", "sli_account_group", "n_able_account_category"] |
| QuickBooks Online Journal Entries Last 365 Days | Quickbooks Online all Journal Entries entered into Quickbooks with the transaction date in the last 365 days. | Mar 07, 2022 | Dec 10, 2022 | ["id", "description", "line_id", "detail_type", "je_line_id", "last_updated", "created", "transaction_no", "transaction_note", "account_fully_qualified_name", "posting_type", "amount", "transaction_date", "sparse", "adjustment", "account_type", "account_clasification", "account_sub_type", "account_name", "other_id", "account_id"] |
| QuickBooks Online Customer Balance Detail - API | ODS Dataset which generated from QuickBooks Online Customer Balance Detail | Apr 11, 2022 | Feb 21, 2023 | ["id", "tenant_code", "customer", "time", "report_name", "header", "type", "datemacro", "currency", "summary_value", "summary_num", "section_num", "columns"] |
| QuickBooks Online Invoice Line Item Detail | Information on invoices from your Quickbooks setup. Invoices dated within the last 730 days | Nov 04, 2022 | Feb 21, 2023 | ["invoice_id", "invoice_number", "line_item_description", "line_item_number", "line_item_amount", "line_item_class", "line_item_taxable_flag", "line_item_product_or_service_name", "line_item_rate", "line_item_quantity", "line_item_service_date", "line_item_percent_of_total", "invoice_total_amount", "invoice_due_date", "invoice_date", "invoice_status", "invoice_is_paid", "invoice_memo", "invoice_balance", "customer", "invoice_created", "invoice_last_update"] |
| Quickbooks Online Profit And Loss Detail By Cash - API | ODS Dataset which generated from Quickbooks Online Profit And Loss Detail By Cash | Dec 11, 2022 | Dec 11, 2022 | ["id", "tenant_code", "time_period", "start_period", "end_period", "group_name", "group_id", "tx_date", "txn_type", "doc_num", "name", "dept_name", "class_name", "memo", "split_acc", "subt_nat_amount", "rbal_nat_amount"] |
| N-able Q Benchmark Top 3 Financial Data | Top 3 data for N-able Benchmark for Q50-52 | Jan 04, 2023 | Feb 08, 2023 | ["quarter", "customer", "q_benchmark", "value"] |
| QuickBooks Online PurchaseOrder - API | ODS Dataset which generated from QuickBooks Online PurchaseOrder | Jan 11, 2023 | Feb 21, 2023 | ["id", "tenant_code", "other_id", "sync_time", "purchase_order_id", "vendor_addr_id", "vendor_addr_line1", "vendor_addr_city", "vendor_addr_country_sub_division_code", "vendor_addr_postal_code", "ship_addr_id", "ship_addr_line1", "ship_addr_line2", "ship_addr_line3", "po_status", "purchase_order_domain", "doc_number", "sparse", "sync_token", "meta_data_create_time", "meta_data_last_updated_time", "custom_field", "docnumber", "txn_date", "currency_ref_value", "currency_ref_name", "linked_txn", "vendor_ref_value", "vendor_ref_name", "ap_account_ref_value", "ap_account_ref_name", "total_amt"] |
| QuickBooks Online Purchase - API | ODS Dataset which generated from QuickBooks Online Purchase | Jan 11, 2023 | Feb 21, 2023 | ["id", "tenant_code", "other_id", "sync_time", "purchase_id", "account_ref_value", "account_ref_name", "payment_type", "entity_ref_value", "entity_ref_name", "entity_ref_type", "credit", "total_amt", "purchase_ex", "purchase_domain", "sparse", "sync_token", "meta_data_create_time", "meta_data_last_updated_time", "txn_date", "currency_ref_value", "currency_ref_name", "private_note"] |
| QuickBooks Online Recurring Transaction Sales Receipt - API | ODS Dataset which generated from QuickBooks Online Recurring Transaction Sales Receipt | Apr 03, 2023 | Apr 04, 2023 | ["id", "tenant_code", "sync_time", "other_id", "domain", "sparse", "balance", "bill_addr_id", "bill_addr_city", "bill_addr_line1", "bill_addr_country", "bill_addr_postal_code", "bill_addr_country_sub_division_code", "class_ref_name", "class_ref_value", "meta_data_create_time", "meta_data_last_updated_time", "ship_addr_id", "ship_addr_line1", "ship_addr_line2", "ship_addr_line3", "ship_addr_line4", "ship_addr_line5", "total_amt", "bill_email_address", "sync_token", "currency_ref_name", "currency_ref_value", "custom_field", "customer_ref_name", "customer_ref_value", "email_status", "print_status", "customer_memo_value", "delivery_info_delivery_type", "recur_data_ref_value", "txn_tax_detail_total_tax", "department_ref_name", "department_ref_value", "recurring_info_name", "recurring_info_active", "recurring_info_recur_type", "recurring_info_schedule_info_next_date", "recurring_info_schedule_info_start_date", "recurring_info_schedule_info_day_of_month", "recurring_info_schedule_info_num_interval", "recurring_info_schedule_info_interval_type", "recurring_info_schedule_info_previous_date", "payment_method_ref_name", "payment_method_ref_value", "credit_card_payment_credit_charge_response_avs_zip", "credit_card_payment_credit_charge_response_status", "credit_card_payment_credit_charge_response_avs_street", "credit_card_payment_credit_charge_response_card_security_code_m", "deposit_to_account_ref_name", "deposit_to_account_ref_value", "apply_tax_after_discount"] |
| QuickBooks Online Recurring Transaction Line - API | ODS Dataset which generated from QuickBooks Online Recurring Transaction Line | Apr 03, 2023 | Apr 04, 2023 | ["id", "tenant_code", "sync_time", "parent_type", "parent_id", "other_id", "line_num", "description", "amount", "detail_type", "detail_node"] |
| QuickBooks Online Recurring Transaction Bill - API | ODS Dataset which generated from QuickBooks Online Recurring Transaction Bill | Apr 03, 2023 | Apr 04, 2023 | ["id", "tenant_code", "sync_time", "other_id", "sales_term_ref_value", "balance", "domain", "sparse", "sync_token", "meta_data_create_time", "meta_data_last_updated_time", "currency_ref_value", "currency_ref_name", "recur_data_ref_value", "recurring_info_name", "recurring_info_recur_type", "recurring_info_active", "recurring_info_schedule_info_interval_type", "recurring_info_schedule_info_num_interval", "recurring_info_schedule_info_day_of_month", "recurring_info_schedule_info_days_before", "recurring_info_schedule_info_start_date", "recurring_info_schedule_info_next_date", "recurring_info_schedule_info_previous_date", "vendor_ref_value", "vendor_ref_name", "ap_account_ref_value", "ap_account_ref_name", "total_amt"] |
| QuickBooks Online Recurring Transaction Invoice - API | ODS Dataset which generated from QuickBooks Online Recurring Transaction Invoice | Apr 03, 2023 | Apr 04, 2023 | ["id", "tenant_code", "sync_time", "other_id", "domain", "sparse", "balance", "due_date", "bill_addr_id", "bill_addr_line1", "bill_addr_line2", "bill_addr_line3", "bill_addr_line4", "meta_data_create_time", "meta_data_last_updated_time", "ship_addr_id", "ship_addr_city", "ship_addr_line1", "ship_addr_line2", "ship_addr_postal_code", "ship_addr_country_sub_division_code", "ship_date", "total_amt", "linked_txn", "sync_token", "currency_ref_name", "currency_ref_value", "custom_field", "customer_ref_name", "customer_ref_value", "email_status", "print_status", "private_note", "recur_data_ref_value", "txn_tax_detail_tax_line", "txn_tax_detail_total_tax", "txn_tax_detail_txn_tax_code_ref_value", "recurring_info_name", "recurring_info_active", "recurring_info_recur_type", "recurring_info_schedule_info_next_date", "allow_ipn_payment", "allow_online_payment", "allow_online_ach_payment", "apply_tax_after_discount", "allow_online_credit_card_payment"] |
| QuickBooks Online Recurring Transaction Journal Entry - API | ODS Dataset which generated from QuickBooks Online Recurring Transaction Journal Entry | Apr 03, 2023 | Apr 04, 2023 | ["id", "tenant_code", "sync_time", "other_id", "domain", "sparse", "meta_data_create_time", "meta_data_last_updated_time", "sync_token", "adjustment", "currency_ref_name", "currency_ref_value", "recur_data_ref_value", "recurring_info_name", "recurring_info_active", "recurring_info_recur_type", "recurring_info_schedule_info_next_date", "recurring_info_schedule_info_day_of_week", "recurring_info_schedule_info_start_date", "recurring_info_schedule_info_num_interval", "recurring_info_schedule_info_interval_type", "recurring_info_schedule_info_previous_date"] |
| QuickBooks Online Recurring Transaction Purchase - API | ODS Dataset which generated from QuickBooks Online Recurring Transaction Purchase | Apr 03, 2023 | Apr 04, 2023 | ["id", "tenant_code", "sync_time", "other_id", "account_ref_value", "account_ref_name", "payment_type", "entity_ref_value", "entity_ref_name", "entity_ref_type", "total_amt", "print_status", "purchase_ex_any", "domain", "sparse", "sync_token", "meta_data_create_time", "meta_data_last_updated_time", "currency_ref_value", "currency_ref_name", "recur_data_ref_value", "recurring_info_name", "recurring_info_recur_type", "recurring_info_active", "recurring_info_schedule_info_interval_type", "recurring_info_schedule_info_num_interval", "recurring_info_schedule_info_day_of_month", "recurring_info_schedule_info_start_date", "recurring_info_schedule_info_next_date", "recurring_info_schedule_info_previous_date"] |
| QuickBooks Online Balance Sheet | Get QuickBooks Online Balance Sheet data | Jun 16, 2023 | Jun 20, 2023 | ["date", "time_period", "month", "year", "quarter", "account", "period_bal_beg", "month_bal_beg", "month_bal_end", "number_of_days"] |