SSIS Components for QuickBooks Online

Build 20.0.7587

CustomerBalanceDetail

The QuickBooks report CustomerBalanceDetail.

Columns

Name Type References Description
Label String A column for Label.
ReportDate String A column for Date. If used as a filter it will retrieve the records up to the specified date.
TransactionType String A column for TransactionType containing String data.
Num String A column for Num containing String data.
DueDate String A column for Due_Date containing Date data.
Amount Decimal A column for Amount containing Money data.
OpenBalance Decimal A column for OpenBalance containing Money data.
Balance Decimal A column for Balance containing Money data.
RowType String A column for Type of the row.
RowGroup String A column for Group of the row.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
AgingMethod String The date upon which aging is determined.

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

ARPaid String The accounts receivable paid status.

使用できる値は次のとおりです。All, Paid, Unpaid

デフォルト値はUnpaidです。

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.
Department String Filters report contents to include information for specified departments if so configured in the company file. This is a comma separated list (spaces omitted after/before separating comma) of one or more Department IDs.
ShipVia String Filter by the shipping method as specified in Invoice's ShipMethodRef. This is the name of the shipping method.
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.

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