All the subscription information
the values for the overloaded fields for the subscription_details supplied out-of-the-box.
When subscription_type = 0 " text_5 = the unit cost text for display " enum_1 = pointer to another subscription_details record for looking up other subscription info, such as user specified quantity, etc. " numeric_1 = user defined quantity " numeric_2 = unit cost used for calculations
When subscription_type = 1 " text_1 = application id " text_2 = application name " text_3 = service config id " text_5 = the unit cost text for display " enum_1 = metric ID " enum_2 = offset used in making queries to the SM result tables. " numeric_2 = unit cost used for calculations
When subscription_type = 2 " text_1 = contract ID " text_2 = sla package name " text_5 = the unit cost text for display " numeric_2 = unit cost used for calculations
When subscription_type = 3 " enum_1 = the adjustment ID that the subscription was created for " numeric_1 = quantity used when invoicing adjustment depending on the what the adjustment is applied to (ie: rate's quantity, rate's unit cost, rate's cost, etc)
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | The unique id for each subscription record |
| account_no | varchar(50) | not null | The account number associated to the billing_account. |
| account_label | nvarchar(128) | not null | Tthe billing account label |
| parent_domain | varchar(50) | not 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. |
| offering_id | integer | not null | The unique id for each offering. |
| rate_plan_id | integer | not null | The unique id for each rate plan |
| item_id | integer | not null | The unique id for each rate item |
| status | integer | not null | 0=deleted, 1=pending, 2=active, 3=inactive, 4=cancelled. subsciptions to application rate items usually are first set to pending first until they are assigned to a resource. most subscriptions will be in the active state which means they will be invoiced. Inactive subscriptions are subscriptions that need to be invoiced before being cancelled. |
| subscription_type | integer | not null | 0=subscription to general rate item such as a Rate rateitem, Numeric rateitem, Adjustment rateitem, etc. 1=subscription to an Application rate item, 2=subscription to an Agreement rate item, 3=a periodic adjustment |
| instance_name | varchar(64) | with null | Name that can be associated to a particular subscription instance. |
| subscribed_date | date | not null | The date the subscription was made |
| unsubscribed_date | date | with null | The date the subscription was unsubscribed |
| charge_date | date | not null | The date that the subscription should begin getting charged. |
| last_charge_date | date | with null | The last date the subscription was charged up to. When first subscribing, this date is the same as the charge_date, and is then incremented every bill run this subscription is invoiced. |
| code | nvarchar(50) | with null | The codes of the rate items, rate plans or offerings will be persisted here during subscription |
| charge | integer | with null | 0=don't invoice this subscription, 1=invoice this subscription |
| installments | integer | with null | Number installments this subscription was invoice for to date |
| tiered_item_id | integer | with null | Charged tiered item ID |
| tiered_last_date | date | with null | Last charge date for tiered item pointed to by tiered_item_id |
| text_1 | nvarchar(50) | with null | If subscription_type=1 then application id, if subscription_type=2 then contract ID, otherwise empty |
| text_2 | nvarchar(50) | with null | If subscription_type=1 then application name, if subscription_type=2 then sla package name, otherwise empty |
| text_3 | nvarchar(50) | with null | If subscription_type=1 then service config ID, otherwise empty |
| text_4 | nvarchar(50) | with null | Currently not used |
| text_5 | nvarchar(50) | with null | See table comment |
| text_6 | nvarchar(50) | with null | |
| text_7 | nvarchar(50) | with null | |
| enum_1 | integer | with null | See table comment |
| enum_2 | integer | with null | See table comment |
| enum_3 | integer | with null | Currently not used |
| enum_4 | integer | with null | |
| enum_5 | integer | with null | |
| numeric_1 | float | with null | See table comment |
| numeric_2 | float | with null | See table comment |
| request_id | integer | with null | |
| parent_id | integer | with null | |
| request_type | integer | with null | |
| domain | varchar(50) | not null | Domain to which this item belongs. |
| group_id | integer | not null |
Product Name: Unicenter Service Management
Table Type: Table