PayoutDetailsCData BizTalk Adapter for PayPal 2019 - Build 19.0.7354
Retrieve details about Payouts.
Table Specific Information
The only filter supported by the PayPal API is PayoutBatchId, which is required. The adapter processes other filters client side within the adapter.
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.
For example, the following query is processed server side and retrieves details for a specific Payout.
SELECT * FROM PayoutDetails WHERE PayoutBatchId = 'HSY55UPD25KF2'
|PayoutBatchId [KEY]||String||The ID of the payout for which to show details.|
|BatchStatus||String||The PayPal-generated payout status. If the payout passes preliminary checks, the status is PENDING.|
|TimeCreated||Datetime||The date and time when processing for the payout began|
|TimeCompleted||Datetime||The date and time when processing for the payout completed.|
|SenderBatchId||String||The sender-specified ID number. Tracks the payout in an accounting system.|
|SenderEmailSubject||String||The subject line for the email that PayPal sends when payment for a payout item completes. The subject line is the same for all recipients.|
|Amount||Decimal||The total amount,requested for the payouts.|
|Currency||String||The currency of the total amount|
|FeeAmount||Decimal||The amount of the total estimate for the applicable payouts fees. Initially, the fee is 0. The fee is populated after the payout moves to the PROCESSING state.|
|FeeCurrency||String||The currency for the applicable payouts fees.|