Examples of Subscription Impact on Revenue Management

When you activate a subscription in Subscription Management, the integration process automatically transfers data to these Revenue Management database tables:

Interface Table	Description
VRM_SOURCE_DOCUMENTS	Stores the basic subscription header information such as document date, document number, bill-to customer ID, bill-to site ID, subscription start date, subscription number, and so on.
VRM_SOURCE_DOC_LINES	Stores information about the subscription lines, such as the quantity, unit selling price, and line amount.
VRM_SOURCE_DOC_SUB_LINES	Stores the information about satisfaction events.

This example describes how subscription data is processed by the Revenue Management and inserted into:

• VRM_SOURCE_DOC_LINES

• VRM_SOURCE_DOC_SUB_LINES

This table summarizes subscription types and fees associated with the sample Blast Internet Connection subscription:

Subscription Fee	Blast Internet Basic	Blast Internet Premium
Activation Fee (one-time)	$80	$80
Internet Fee (recurring)	$50	$60
Consumption Fee (usage)	Free Allowance: 100 GB Usage fee after 100 GB: $1 for every 2 GB	Free Allowance: 100 GB Usage fee after 100 GB: $1 for every 2GB

• An extra usage fee is charged if your customer exceeds the data consumption limit of 100 GB per month. If internet data consumption exceeds this limit, the customer is charged with $1 for every 2 GB of extra usage.

• At any time, the customer can upgrade his subscription and opt for the premium package that costs $60 per month.

• The customer has purchased the Blast Internet Basic subscription for 12 months.

Scenario 1: Basic Subscription Activation

This scenario covers the impact of activating the Blast Internet Basic subscription on the Revenue Management database tables.

Impact on VRM_SOURCE_DOC_LINES:

This table displays the values inserted in the VRM_SOURCE_DOC_LINES database table:

Table Attributes	Doc Line 1	Doc Line 2
Source Line	Source Line 1	Source Line 2
Item	Blast Internet Basic	Blast Internet Basic
Extensible Attribute 1	Internet (Recurring)	Activation Fee(One-time)
Extensible Attribute 2	Monthly	One-time
UOM	Year	Year
Quantity	1	1
Unit Selling Price	50	80
Service Duration	12	1
Charge UOM	Month	ORA_PRICE_PERIOD_ONETIME
Line Amount	600	80
List Price	50	80
Version Number	1	1
Version Indicator	Null	Null
Plan Start Date	01-Jan-2020	NA
Plan End Date	31-Dec-2020	NA
Satisfaction Measurement Model	ORA_MEASURE_PERIOD_SATISFIED	ORA_MEASURE_QUANTITY_SATISFIED

Subscription activation results in the addition of two rows in this table:

• Doc Line 1 stores the values associated with the recurring monthly internet fee of $50. Since the unit selling price is $50, the line amount becomes $600 ($50 for 12 months).

• Doc Line 2 stores the values associated with the one-time activation fee of $80.

Impact on VRM_SOURCE_DOC_SUB_LINES:

The application populates the values in this table only when the customer completes the payment for a fee type applicable to his subscription. This table displays the values inserted in the VRM_SOURCE_DOC_SUB_LINES database table:

Table Attributes	Doc Sub Line 1
Source Line	2
Sub Line Type Code	ORA_SATIS_EVENT_SMM_QUANTITY
Satisfaction Measurement Date	1-Jan-2020
Satisfied Quantity	1

Since the customer pays the activation fee at the time of subscription activation, only the activation fee meets the satisfaction criteria.

After the monthly fee of $50 meets the satisfaction criteria, the application adds a new row at the end of every month.

Scenario 2: Subscription with Usage Fee

This scenario covers a scenario where an extra consumption fee is applicable because the customer exceeds his internet data limit of 100 GB per month by:

• 20 GB in January

• 30 GB in February

This table shows the values inserted in the VRM_SOURCE_DOC_LINES database table when the usage fee is applied to the subscription:

Table Attributes	Doc Line 3	Doc Line 4
Source Line	Source Line 3	Source Line 4
Item	Blast Internet Basic	Blast Internet Basic
Extensible Attribute 1	Internet (Recurring)	Internet (Recurring)
UOM	Year	Year
Quantity	120	130
Unit Selling Price	10/120	15/130
Service Duration	NA	NA
Charge UOM	NA	NA
Line Amount	10	15
List Price	10/120	15/130
Plan Start Date	01-Jan-2020	01-Feb-2020
Plan End Date	31-Jan-2020	28-Feb-2020
Satisfaction Measurement Model	ORA_MEASURE_PERIOD_SATISFIED	ORA_MEASURE_PERIOD_SATISFIED

Note: New rows in the VRM_SOURCE_DOC_LINES table aren't inserted at the time of subscription activation. To apply the usage fee on a subscription, a new accounting contract is created for every usage line . The customer is charged only when the usage fee becomes applicable.

The usage fee results in the addition of two rows:

• Doc Line 3 stores the values associated with the usage fee associated with January. The line amount is $10, since the customer has used 20 GB of extra data, and every 2 GB of data costs $1.

• Doc Line 4 stores the values associated with the usage fee associated with February. The line amount is $15, since the customer has used 30 GB of extra data.

Exceeding the usage limit doesn't impact the VRM_SOURCE_DOC_SUB_LINES values. The VRM_SOURCE_DOC_SUB_LINES table displays the same values as described in Scenario 1.

Scenario 3: Upgraded Subscription

This scenario shows an example of when a customer decides to upgrade his subscription to premium, which costs $60 per month, for six months, from 01-July-2020 to 31-Dec-2020.

This table displays the values inserted in the VRM_SOURCE_DOC_LINES database table when the customer upgrades the subscription:

Table Attributes	Doc Line 1	Doc Line 2	Doc Line 3	Doc Line 4
Source Line	Source Line 1	Source Line 2	Source Line 3	Source Line 1
Item	Blast Internet Basic	Blast Internet Basic	Blast Internet Premium	Blast Internet Basic
Extensible Attribute 1	Internet (Recurring)	Activation Fee (One-time)	Internet (Recurring)	Internet (Recurring)
Extensible Attribute 2	Monthly	One-time	Monthly	Monthly
UOM	Year	Year	Year	Year
Quantity	1	1	1	1
Unit Selling Price	50	80	60	50
Service Duration	12	1	6	6
Charge UOM	Month	ORA_PRICE_PERIOD_ONETIME	Month	Month
Line Amount	600	80	360	300
List Price	50	80	60	50
Version Number	1	1	1	2
Version Indicator	Null	Null	Null	Y
Plan Start Date	01-Jan-2020		01-Jul-2020	01-Jan-2020
Plan End Date	31-Dec-2020		31-Dec-2020	30-Jun-2020
Satisfaction Measurement Model	ORA_MEASURE_PERIOD_SATISFIED	ORA_MEASURE_QUANTITY_SATISFIED	ORA_MEASURE_PERIOD_SATISFIED	ORA_MEASURE_PERIOD_SATISFIED

When the customer upgrades his subscription, two new rows are inserted in this Revenue Management table:

• Doc Line 3 stores the values associated with the recurring premium monthly internet fee of $60. Since the unit selling price is $60, the line amount becomes $360 ($60 for 6 months).

• Doc Line 4 is created as the new version of Doc Line 1, which was created at the time of the subscription activation. Doc Line 4 stores the values associated with the monthly internet fee paid until 30 June 2020. Since the unit selling price is $50, the line amount becomes $300 ($50 for 6 months). Since Doc Line 4 is created as the replacement of Doc Line 1, the Version Number value is updated as 2 and the Version Indicator value is updated as Y.

Upgrading the subscription doesn't impact the VRM_SOURCE_DOC_SUB_LINES values. The VRM_SOURCE_DOC_SUB_LINES table displays the same values as described in Scenario 1.