ODBC Driver for QuickBooks Online

Build 23.0.8839

CreateTransactionListWithSplitsReport

Generates an Account list report schema file.

Input

Name Type Description
ReportName String The name of the report.

デフォルト値はTransactionListWithSplitsReportです。

ReportDescription String A description for the report. If one is not specified, a description based on the ReportType will be selected.
StartDate String The startdate of the report. StartDate must be less than EndDate.
EndDate String The enddate of the report. EndDate must be greater than StartDate.
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.
SourceAccountType String Account type from which transactions are included in the report.
SortBy String The column type used in sorting report rows. Specify one of the Columns from the Columns input.
SortOrder String The sort ordering.

使用できる値は次のとおりです。ascend, descend

DocNum String Filters report contents to include information for specified transaction number, as found in the docnum parameter of the transaction object.
PaymentMethod String Filter report contents based on payment method.
Transactiontype String Filters report based on transaction type.
WriteToFile String Whether to write to an output file or not. Defaults to true, must be set to false to write to FileStream or FileData.

Result Set Columns

Name Type Description
Result String Success or Failure.
SchemaFile String The generated schema file.
Columns String The number of columns found.
FileData String The BASE64 downloaded file content. Only returned if WriteToFile set to false and FileStream is not set.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839