ODBC Driver for Pipedrive

Build 24.0.9062

SubscriptionPayments

Returns all payments of an installment or recurring subscription.

Select

The 本製品 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 本製品.

  • 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062