JDBC Driver for QuickBooks Online

Build 20.0.7587

CreateAPAgingDetailReport

Generates an A/P Aging Detail report schema file.

Input

Name Type Description
ReportName String The name of the report.

デフォルト値はAPAgingDetailReportです。

ReportDescription String A description for the report. If one is not specified, a description based on the ReportType will be selected.
AccountingMethod String The accounting method used in the report.

使用できる値は次のとおりです。Cash, Accrual

AgingPeriod String The number of days in the aging period.
Columns String Column types to be shown in the report. A comma separated list of one or more of the following: create_by, create_date, doc_num, due_date, last_mod_by, last_mod_date, memo, past_due, term_name, tx_date, txn_type, vend_bill_addr, vend_comp_name, vend_name, vend_pri_cont, vend_pri_email, vend_pri_tel. Additional columns with location tracking enabled: dept_name. In addition to the above, the following values are supported based on the multicurrency setting for the company. Multicurrency disabled: subt_net_open_bal, subt_neg_amount. Multicurrency enabled: currency, exch_rate, neg_foreign_open_bal, subt_neg_home_open_bal, neg_foreign_amount, subt_neg_home_amount. Default=tx_date,txn_type,doc_num,vend_name,dept_name,due_date,past_due,subt_neg_amount,subt_net_open_bal
NumPeriods String The number of periods to be shown in the report.
PastDue String Filters report contents based on minimum days past due.
ReportDate String Start date to use for the report.
ShipVia String Filter by the shipping method as specified in Invoice's ShipMethodRef. This is the name of the shipping method.
StartDueDate String The startdate of which the recievables are due. StartDueDate must be less than EndDueDate.
EndDueDate String The enddate of which the recievables are due. EndDueDate must be greater than StartDueDate.
Term String Filters report contents to include information for specified term or terms supplied. This is a comma separated list (spaces omitted after/before separating comma) of one or more Term IDs.
Vendor String Filters report contents to include information for specified vendors. This is a comma separated list (spaces omitted after/before separating comma) of one or more Vendor IDs.
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 20.0.7587