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 |
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.