Subscriptions
Returns details of an installment or a recurring Subscription
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Integer | True |
ID of the Subscription. |
| AddTime | Datetime | True |
AddTime. |
| CadenceType | String | False |
Interval between payments. 使用できる値は次のとおりです。weekly, monthly, quarterly, yearly |
| Currency | String | False |
The currency of the Installment Subscription. Accepts a 3-character currency code. |
| CycleAmount | Double | False |
Amount of each payment. |
| CyclesCount | Integer | False |
Shows how many payments the Subscription has. |
| DealId | Integer | False |
ID of the Deal this Installment Subscription is associated with. |
| Description | String | False |
Description of the Recurring Subscription. |
| EndDate | String | False |
EndDate. |
| FinalStatus | String | True |
FinalStatus. |
| Infinite | Boolean | False |
This indicates that the Recurring Subscription will last until it's manually canceled or deleted. |
| IsActive | Boolean | True |
IsActive. |
| LifetimeValue | Double | True |
LifetimeValue. |
| StartDate | String | False |
Start date of the Recurring Subscription. Format: YYYY-MM-DD |
| UpdateTime | Datetime | False |
UpdateTime. |
| UserId | Integer | True |
UserId. |
| SubscriptionType | String | True |
SubscriptionType. 使用できる値は次のとおりです。recurring, installment デフォルト値はrecurringです。 |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Payments | String |
Array of payments. |
| EffectiveDate | Date |
Array of payments. |
| UpdateDealValue | Boolean |
Indicates that the Deal value must be set to Recurring Subscription's MRR value. |