JDBC Driver for QuickBooks Online

Build 22.0.8675

CustomerSalesReport

The QuickBooks report CustomerSales.

Columns

Name Type References Description
CustomerName String A column for CustomerName containing Customer data.
RowType String A column for RowType containing RowType data.
RowGroup String A column for RowGroup containing RowGroup data.
RowId Integer A column for RowId containing RowId data.

Pseudo-Columns

Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
DateMacro String A predefined date range. Use this if you want the report to cover a standard report date range. Otherwise, use the StartDate and EndDate to cover an explicit range.

The allowed values are Today, Yesterday, This Week, This Week-to-date, Last Week, Last Week-to-date, Next Week, Next 4 Weeks, This Month, This Month-to-date, Last Month, Last Month-to-date, Next Month, This Fiscal Quarter, This Fiscal Year, This Fiscal Year-to-date, Last Fiscal Year, Last Fiscal Year-to-date, Next Fiscal Year.

StartDate String The startdate of the report. StartDate must be less than EndDate.

The default value is 2018-02-27.

EndDate String The enddate of the report. EndDate must be greater than StartDate.

The default value is 2018-04-27.

AccountingMethod String The accounting method used in the report.

The allowed values are Cash, Accrual.

SummarizeColumnsBy String The criteria by which to group the report results.

The allowed values are Total, Month, Week, Days, Quarter, Year, Customers, Vendors, Classes, Departments, Employees, ProductsAndServices.

Indentation String Add spaces at the start of values to visually identify totals and group values.
Customer String Filters report contents to include information for specified customers. This is a comma separated list (spaces omitted after/before separating comma) of one or more Customer IDs.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8675