SubscriptionPayments
Returns all payments of an installment or recurring subscription.
Select
The connector 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 connector.
- 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. |