Subscriptions
Returns details of an installment or a recurring Subscription
Columns
| Name | Type | ReadOnly | References | 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. |