# DW_NS_subscriptionChangeOrder_F

This fact contains information about the change orders associated with the subscription. Change Orders are used to perform changes to the subscriptions or its components over their life cycle starting from Activation till its Termination or Renewal.

## Details

Module:

## Key Columns

id

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
id | NUMBER | 38 | 0 | True | Transaction Identifier. |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Composite key that consists of all PK values of the transaction. This consists combination of columns that defines the granularity of the table and identifies a row uniquely. |  |
action | VARCHAR2 | 64 |  |  | Indicates the type of change order action it performs i.e Activation, Modify Pricing, Terminate, Suspend, Reactivate, Renew. | DW_NS_SUBSCRIPTIONCHANGEORDERACTION_D | key
billingaccount | NUMBER | 38 | 0 |  | Billing account identifier where the entity receives their bills. | DW_NS_billingAccount_D | id
customer | NUMBER | 38 | 0 |  | Customer identifier. | DW_NS_customer_D | id
datecreated | TIMESTAMP |  |  |  | Created date of this record. |  |
effectivedate | TIMESTAMP |  |  |  | The date on which the change order takes effect. |  |
idnumber | VARCHAR2 | 128 |  |  | This is an automatically generated number identifying this subscription. |  |
lastmodifieddate | TIMESTAMP |  |  |  | Last Modification Date. |  |
memo | VARCHAR2 | 999 |  |  | Textual description provided by transaction creators. |  |
modificationtype | VARCHAR2 | 64 |  |  | It determines how this change order impacts recurring revenue analytics of a subscription. | DW_NS_SUBSCRIPTIONCHANGEORDERMODIFICATIONTYPE_D | key
renewalenddate | TIMESTAMP |  |  |  | End date of the renewed subscription. |  |
renewalmethod | VARCHAR2 | 64 |  |  | Specified Method determines how a subscription is renewed when it reaches the end of its term - Extend Existing subscription or create a new subscription. | DW_NS_SUBSCRIPTIONRENEWALMETHOD_D | key
renewalplan | NUMBER | 38 | 0 |  | Subscription Plan identifier of the renewed subscription. | DW_NS_subscriptionPlan_D | id
renewalpricebook | NUMBER | 38 | 0 |  | Price Book identifier associated with the renewed subscription. | DW_NS_priceBook_D | id
renewalstartdate | TIMESTAMP |  |  |  | Start date of the renewed subscription. |  |
renewalterm | NUMBER | 38 | 0 |  | Term associated with the Renewed subscription | DW_NS_subscriptionTerm_D | id
renewaltrantype | VARCHAR2 | 16 |  |  | It determines the Transaction Type to create for the Renewal | DW_NS_STATUS_D | key
requestoffcycleinvoice | VARCHAR2 | 16 |  |  | Flag to set the default for off-cycle invoice for advance charges. |  |
requestor | NUMBER | 38 | 0 |  | The identifier of the person entering the change order. | DW_NS_employee_D | id
subscription | NUMBER | 38 | 0 |  | Identifier of the associated subscription. | DW_NS_SUBSCRIPTIONS_F | id
subscriptionchangeorderstatus | VARCHAR2 | 64 |  |  | Status of the change order. | DW_NS_subscriptionChangeOrderStatus_D | key
subscriptionplan | NUMBER | 38 | 0 |  | The subscription plan associated with a subscription. | DW_NS_subscriptionPlan_D | id
subsidiary | NUMBER | 38 | 0 |  | Subsidiary identifier associated with this transaction. | DW_NS_subsidiary_D | id
terminateatstartofday | VARCHAR2 | 16 |  |  | Flag which determines whether a termination change order begins at the start of the day or at end of the day. |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.