Lists transactions for a subscription.
Table Specific Information
This view returns a list of transactions with details for a specific subscription.
The following filters are supported by the PayPal API:
SELECT * FROM SubscriptionTransactions WHERE SubscriptionId='1234' SELECT * FROM SubscriptionTransactions WHERE SubscriptionId='1234' and StartTime='2018-01-21T07:50:20.940Z' and EndTime='2018-08-21T07:50:20.940Z'
NOTE: 1. SubscriptionId, StartTime and EndTime are the required parameters for this view and if StartTIme and EndTime are not specified in the query the default values will be assigned from the code. 2. We can get get the SubscriptionId by creating the subscription using CreateSubscription Stored procedure.
The provider processes other filters client side within the provider. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.
|SubscriptionId||String||The ID of the subscription.|
|AmountWithBreakdown_FeeAmountCurrencyCode||String||The fee details for the transaction.|
|AmountWithBreakdown_FeeAmountValue||String||The fee details for the transaction.|
|AmountWithBreakdown_GrossAmountCurrencyCode||String||The three-character ISO-4217 currency code that identifies the currency.|
|AmountWithBreakdown_GrossAmountValue||String||The value of the currency.|
|AmountWithBreakdown_NetAmountCurrencyCode||String||The currency code of the net amount that the payee receives for this transaction in their PayPal account.|
|AmountWithBreakdown_NetAmountValue||String||The net amount that the payee receives for this transaction in their PayPal account.|
|PayerEmail||String||The email ID of the customer.|
|PayerNameGivenName||String||When the party is a person, the party's given, or first, name.|
|PayerNameSurname||String||When the party is a person, the party's surname or family name. Also known as the last name.|
|Status||String||The initial state of the plan.|
|Time||Datetime||The date and time when the transaction was processed.|
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.
|StartTime||Datetime||The start time of the range of transactions to list.|
|EndTime||Datetime||The end time of the range of transactions to list.|