SubscriptionPayments
Returns all payments of an installment or recurring subscription.
Select
The add-in will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.
- SubscriptionId supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM SubscriptionPayments WHERE SubscriptionId = 2
Columns
| Name | Type | Description |
| Id [KEY] | Integer | ID of the Subscription Payments. |
| SubscriptionId | Integer | ID of the Subscription. |
| DealId | Integer | Deal Id. |
| IsActive | Boolean | Is Active. |
| Amount | Integer | Amount. |
| Currency | String | Currency. |
| ChangeAmount | Integer | Change amount. |
| DueAt | Date | Due at. |
| RevenueMovementType | String | Revenue movement type. |
| PaymentType | String | Payment type. |
| Description | String | Description. |
| AddTime | String | Add time. |
| UpdateTime | String | Update time. |