subscription
Stores active subscriptions, including plan details, renewal dates, and associated accounts.
Columns
| Name | Type | References | Description |
| advancerenewalperiodnumber | Integer | The number of periods before renewal that notifications are sent. | |
| advancerenewalperiodunit | String | The unit of time used for advance renewal notifications (for example, days or months). | |
| autoname | Boolean | Specifies whether the record is automatically named based on system rules. | |
| autorenewal | Boolean | Specifies if the subscription automatically renews upon expiration. | |
| billingaccount | String | The billing account associated with the subscription. | |
| billingaccountstartdate | Date | The start date of the billing account's active period. | |
| billingschedule | String | The schedule governing billing frequency and amounts. | |
| billingsubscriptionstatus | String | The current status of the subscription's billing (for example, active or inactive). | |
| class | String | The classification or category assigned to the subscription for reporting purposes. | |
| currency | String | The currency used for transactions related to this subscription. | |
| customer | String | The customer associated with this subscription record. | |
| customform | String | The specific form template used for capturing this subscription record. | |
| defaultrenewalmethod | String | The standard method used for handling subscription renewals. | |
| defaultrenewalplan | String | The default plan applied when the subscription is renewed. | |
| defaultrenewalpricebook | String | The default price book used during subscription renewal. | |
| defaultrenewalterm | String | The standard duration of the renewal period. | |
| defaultrenewaltrantype | String | The type of transaction generated during renewal (for example, sales order or invoice). | |
| department | String | The department associated with the subscription for reporting or billing purposes. | |
| enddate | Date | The date when the subscription expires or ends. | |
| estimatedrevrecenddate | Date | The estimated date for the end of revenue recognition for this subscription. | |
| externalid | String | An external identifier used to link this record to other systems. | |
| frequency | String | The frequency of subscription billing (for example, monthly or annually). | |
| id | Integer | The unique identifier for this subscription record. | |
| idnumber | String | The unique identification number assigned to the subscription. | |
| initialterm | String | The initial term length for the subscription. | |
| initialtermduration | String | The duration of the initial term (for example, 12 months). | |
| initialtermtype | String | The type of initial term applied (for example, fixed or evergreen). | |
| initialtermunits | String | The units of time used for defining the initial term (for example, months or years). | |
| internalid | Integer | A unique internal identifier used within the system. | |
| lastbillcycledate | Date | The date when the last billing cycle was completed. | |
| lastbilldate | Date | The date when the last bill was generated. | |
| location | String | The location associated with the subscription. | |
| name | String | The name assigned to the subscription or plan. | |
| nextbillcycledate | Date | The scheduled date for the next billing cycle. | |
| nextrenewalstartdate | Date | The start date of the next scheduled renewal period. | |
| otherrecordnumber | String | A reference number linking to another related record. | |
| pricebook | String | The pricing structure or catalog used for this subscription. | |
| renewalnumber | Integer | The number of times this subscription has been renewed. | |
| salesorder | String | The sales order associated with this subscription. | |
| startdate | Date | The start date of the subscription's active period. | |
| subscriptionplan | String | The subscription plan applied to this record. | |
| subscriptionplanname | String | The name of the subscription plan associated with this record. | |
| subscriptionrevision | Integer | The revision number indicating updates or changes to the subscription. | |
| subsidiary | String | The subsidiary or business unit linked to this subscription. | |
| templatestored | Boolean | Specifies whether the subscription template is stored within the system. |