Persists all the subscription management criterias such as billing in advance, date differentials, and suspensions
the values for the overloaded fields for the subscription_mgmt types supplied out-of-the-box.
When type = 0 " enum_1 = differential type. 0=no difference, 1=fixed, 2=absolute, 3=offset, 4=user " enum_2 = day differential " enum_3 = month differential " enum_4 = year differential " enum_5 = day differential value " enum_6 = month differential value " enum_7 = year differential value " date_1 = fixed date of the date differential
When type = 1 " enum_1 = bill advance type. 0=no billing in advance, 1=specify billing in advance " enum_2 = the number periods to bill in advance
When type = 4 " enum_1 = the offering id " enum_2 = rate plan id " enum_3 = rate item id " enum_4 = 1 means the suspension is fully applied and will no longer be applied to new charges. 0 means keep applying " date_1 = the start date of the suspension " date_2 = the end date of the suspension " date_3 = the applied date of the suspension. That is, up to what date has the suspension already been applied.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Unique id for each subscription management record |
| parent_domain | varchar(50) | with null | This is the parent tenant ID, the value of this field is always either a Supert Tenant, Service Provider, or empty in the case when domain is the value of the Service Provider. |
| type | integer | not null | 0=date differential, 1=billing in advance, 4=suspension |
| scope | integer | not null | 0=global, 2=account label |
| label | nvarchar(128) | with null | Account label when specific accounts are specified. |
| subscription_type | integer | not null | 0=existing, 1=future, 2=both, 3=na |
| subscription_item | integer | not null | 0=offering, 1=rate plan, 2=rate item. This specifies at what level the subscription mgmt should take effect |
| subscription_item_id | integer | not null | The offerings.offering_id, rate_plans.rate_plan_id, or the rate_definition.item_id of an object depending on if subscription_item is 0,1, or 2 respecively. |
| status | integer | not null | 0=deleted, 1=active, 2=inactive |
| status_date | date | not null | The date the status changed |
| enum_1 | integer | with null | See table comment |
| enum_2 | integer | with null | See table comment |
| enum_3 | integer | with null | See table comment |
| enum_4 | integer | with null | See table comment |
| enum_5 | integer | with null | See table comment |
| enum_6 | integer | with null | See table comment |
| enum_7 | integer | with null | See table comment |
| date_1 | date | with null | See table comment |
| date_2 | date | with null | See table comment |
| date_3 | date | with null | See table comment |
| domain | varchar(50) | with null | Domain to which the this item belongs. |
Product Name: Unicenter Service Management
Table Type: Table