CData BizTalk Adapter for QuickBooks Online 2019 - Online Help
Questions / Feedback?


CData BizTalk Adapter for QuickBooks Online 2019 - Build 19.0.7354

Generates a Journal report schema file.


Name Type Description
ReportName String The name of the report.
ReportDescription String A description for the report. If one is not specified, a description based on the ReportType will be selected.
Columns String Column types to be shown in the report. A comma separated list of one or more of the following:acct_num_with_extn,account_name,credit_amt,create_by,create_date,debt_amt,doc_num,due_date,is_ar_paid,is_ap_paid,item_name,journal_code_name,last_mod_by,last_mod_date,memo,name,neg_open_bal,paid_date,pmt_mthd,quantity,rate,tx_date,txn_num,txn_type.
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.

JournalCode String One or more comma separated journal codes. For example AN, BQ1, VT, and so on. Default is to include data for all journal codes.
SortBy String The column type used in sorting report rows. Specify one of the Columns from the Columns input.
SortOrder String The sort ordering.

The allowed values are ascend, descend.

StartDate String The startdate of the report. StartDate must be less than EndDate. If not specified value of DateMacro is used.
EndDate String The enddate of the report. EndDate must be greater than StartDate.
Locale String Specify the Locale of the QBOnline Company you are running this report for. If a French company, specify the locale as FR.
Indentation String Add spaces at the start of values to visually identify totals and group values.

Result Set Columns

Name Type Description
Result String Success or Failure.
SchemaFile String The generated schema file.
Columns String The number of columns found.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0