CustomerBalanceDetailCData BizTalk Adapter for QuickBooks Online 2019 - Build 19.0.7354
The QuickBooks report CustomerBalanceDetail.
|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.|
Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
|AgingMethod||String||The date upon which aging is determined.
The allowed values are Report_Date, Current.
|ARPaid||String||The accounts receivable paid status.
The allowed values are All, Paid, Unpaid.
The default value is 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.|