Tableau Connector for QuickBooks Online

Build 22.0.8678

CreateARAgingDetailReport

Generates an A/R Aging Detail report schema file.

Input

Name Type Accepts Output Streams Description
ReportName String False The name of the report.

デフォルト値はARAgingDetailReportです。

ReportDescription String False A description for the report. If one is not specified, a description based on the ReportType will be selected.
AgingMethod String False The date upon which aging is determined.

使用できる値は次のとおりです。Report_Date, Current

AgingPeriod String False The number of days in the aging period.
Columns String False Column types to be shown in the report. A comma separated list of one or more of the following: bill_addr, create_date, create_by, cust_bill_email, cust_comp_name, cust_msg, cust_phone_other, cust_tel, cust_name, deliv_addr, doc_num, due_date, last_mod_by, last_mod_date, memo, past_due, sale_sent_state, ship_addr, term_name, tx_date, txn_type. Additional columns with custom fields enabled: sales_cust1, sales_cust2, sales_cust3. 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: supt_open_bal, subt_amount. Multicurrency enabled: currency, exch_rate, foreign_open_bal, subt_home_open_bal, foreign_amount, subt_home_amount. Default=tx_date,txn_type,doc_num,cust_name,dept_name,due_date,subt_open_bal,subt_amount
Customer String False 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.
NumPeriods String False The number of periods to be shown in the report.
PastDue String False Filters report contents based on minimum days past due.
ReportDate String False Start date to use for the report.
ShipVia String False Filter by the shipping method as specified in Invoice's ShipMethodRef. This is the name of the shipping method.
StartDueDate String False The startdate of which receivables are due. StartDueDate must be less than EndDate.
EndDueDate String False The enddate of which receivables are due. EndDueDate must be greater than StartDate.
Term String False 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.
Indentation String False Add spaces at the start of values to visually identify totals and group values.
FileStream String True An instance of an output stream where file data is written to. Only used if WriteToFile set to false
WriteToFile String False 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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8678