OSS_USAGE_CHARGES
Following table is used to capture usage changes.
Details
-
Schema: FUSION
-
Object owner: OSS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
OSS_USAGE_CHARGES_PK |
USAGE_CHARGE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| USAGE_CHARGE_ID | NUMBER | 18 | Yes | Unique identifier for usage charge. | |
| USAGE_CHARGE_PUID | VARCHAR2 | 120 | Alternate identifier for usage charge. | ||
| PARTITION_KEY | VARCHAR2 | 128 | Yes | Unique Identifier for the partition. | |
| BATCH_ID | NUMBER | 18 | Tracks the batch id for given usage charge. | ||
| EVENT_ID | NUMBER | 18 | Field used to capture, primary key of usage event. | ||
| SUBSCRIPTION_ID | NUMBER | 18 | Usage chages for source subscription. | ||
| SUBSCRIPTION_PRODUCT_ID | NUMBER | 18 | Usage charges for source subscription product. | ||
| CHARGE_ID | NUMBER | Field used to capture subscription product charge id. | |||
| BILL_LINE_ID | NUMBER | 18 | Unique identifier of bill line Id for usage changes. | ||
| SEQUENCE_NUMBER | NUMBER | 9 | source system price sequence number of usage charge. | ||
| CHARGE_DEFINITION_ID | NUMBER | 18 | Source system Usage chage source identifier. | ||
| CHARGE_DEFINITION | VARCHAR2 | 30 | Source system charge definition of usage charge. | ||
| CHARGE_NAME | VARCHAR2 | 120 | source system charge name of usage charge. | ||
| CHARGE_CURRENCY | VARCHAR2 | 15 | Source system charge currency of usage charge. | ||
| PARENT_ENTITY | VARCHAR2 | 30 | Source system parent entity of usage charge. | ||
| PARENT_ENTITY_ID | NUMBER | 18 | Source system parent entity id of usage charge. | ||
| PRICED_QUANTITY | NUMBER | Field used to capture, price quantity of usage charge. | |||
| PRICED_QUANTITY_UOM | VARCHAR2 | 3 | price quantity uom of usage charge. | ||
| UNIT_PRICE | NUMBER | This field tracks the unit price of usage charge. | |||
| EXTENDED_AMOUNT | NUMBER | calculated charge amount of usage charge. | |||
| BALANCE_PROFILE_ID | NUMBER | 18 | Field used to capture balance profile id. | ||
| BALANCE_REGISTER_ID | NUMBER | 18 | Field used to capture balance register. | ||
| BALANCE_REGISTER_PERIOD_ID | NUMBER | 18 | Field used to capture balance register period. | ||
| BALANCE_CODE_ID | NUMBER | 18 | Field used to capture balance code. | ||
| REPORTED_QUANTITY | NUMBER | Field used to capture reported quantity. | |||
| ROUNDED_QUANTITY | NUMBER | Field used to capture rounded quantity. | |||
| USAGE_QUANTITY | NUMBER | Field used to capture usage quantity. | |||
| ALLOWANCE_QUANTITY | NUMBER | Field used to capture allowance quantity. | |||
| USAGE_UOM | VARCHAR2 | 3 | Field used to capture usage usint of measure. | ||
| CHARGE_LINE_ID | NUMBER | 18 | Field used to capture balance charge line. | ||
| ALLOWANCE_AMOUNT | NUMBER | Field used to capture allowance amount. | |||
| BILLED_AMOUNT | NUMBER | Field used to capture billed amount. | |||
| AMOUNT_BALANCE_CODE_ID | NUMBER | 18 | Field used to capture amount balance code id. | ||
| BALANCE_ESTIMATE_ID | NUMBER | 18 | Field used to capture balance estimated id. | ||
| BALANCE_COMMITMENT_ID | NUMBER | 18 | Field used to capture balance commitment id. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| ADJUSTED_QUANTITY | NUMBER | It records the adjusted quantity for the given usage charge. | |||
| ADJUSTED_AMOUNT | NUMBER | It records the adjusted amount for the given usage charge. | |||
| RATING_MODEL | VARCHAR2 | 30 | This column indicates the rating model used for the given usage charge. | ||
| AMOUNT_BALANCE_ESTIMATE_ID | NUMBER | 18 | Captures the identifier of the estimate line of type amount. | ||
| AMOUNT_BALANCE_COMMITMENT_ID | NUMBER | 18 | Captures the identifier of the commitment line of type amount. | ||
| CAN_ADJUST_FLAG | VARCHAR2 | 1 | Flag to denote whether adjustment can be done or not. | ||
| CHARGE_APPLIES_TO | VARCHAR2 | 30 | Type to which charge is applied. | ||
| CHARGE_SUBTYPE | VARCHAR2 | 30 | Subtype corresponding to charges. | ||
| CHARGE_TYPE | VARCHAR2 | 30 | Type corresponding to charges. | ||
| REC_PRICE_PERIODICITY_CODE | VARCHAR2 | 30 | Price Periodicity for recurring charge return by pst. | ||
| PRICE_TYPE | VARCHAR2 | 30 | Type corresponding to the price. | ||
| ROLLUP_FLAG | VARCHAR2 | 1 | Flag to denote whether amount roll up needs to be done or not. | ||
| PRIMARY_FLAG | VARCHAR2 | 1 | Flag to denote if charge is primary charge or not. | ||
| CHARGE_PERIOD_CODE | VARCHAR2 | 30 | Field used to capture charge period code. | ||
| PERIODIC_BILLING_YN | VARCHAR2 | 1 | Enable Periodic Billing For OneTime Charges. | ||
| PERIODIC_RECOGNITION_YN | VARCHAR2 | 1 | Enable Periodic Recognition of One-Time Charges. | ||
| USER_REPORTED_UOM | VARCHAR2 | 3 | To specify the unit of measurement used by a user when reporting data, ensuring accurate interpretation and processing of the reported information. | ||
| USER_REPORTED_QUANTITY | NUMBER | To record the specific amount or count of an item, usage, or activity as reported by the user. | |||
| CONVERSION_RATE | NUMBER | To provide a multiplier for converting a quantity from one unit of measure to another. | |||
| CHARGE_DETERMINANT_ID | NUMBER | 18 | This field tracks the identifier of charge determinant for usage charge. | ||
| DETERMINANT_BALANCE_CODE_ID | NUMBER | 18 | Obsoleted : This field tracks the identifier of charge determinant balance code for usage charge. | ||
| VOL_AGGR_BALANCE_CODE_ID | NUMBER | 18 | This field tracks the identifier of balance code which is setup for aggregated summarized volume rating. | ||
| VOL_ELIGIBLE_BALANCE_CODE_ID | NUMBER | 18 | This field tracks the identifier of balance code which is eligible for volume rating. | ||
| RATING_CHARGE_LINE_ID | NUMBER | 18 | This field tracks the identifier of rating charge line associated with the usage charge. | ||
| RATE_TABLE_MATRIX_CRITERIA_ID | NUMBER | 18 | This field tracks the identifier of rate table matrix criteria associated with the usage charge. | ||
| PRICE_ADJ_MATRIX_CRITERIA_ID | NUMBER | 18 | This field tracks the identifier of price adjustment matrix criteria associated with the usage charge. | ||
| ADDTL_CHARGE_RULE_CRITERIA_ID | NUMBER | 18 | This field tracks the identifier of additional charge rule criteria associated with the usage charge. | ||
| QUANTITY_ATTRIBUTE_NAME | VARCHAR2 | 240 | This field tracks the name of quantity attribute associated with the usage charge. | ||
| QUANTITY_UOM_ATTRIBUTE_NAME | VARCHAR2 | 240 | This field tracks the name of quantity unit of measure attribute associated with the usage charge. | ||
| QUANTITY_COLUMN_NAME | VARCHAR2 | 240 | This field tracks the column name of quantity attribute associated with the usage charge. | ||
| QUANTITY_UOM_COLUMN_NAME | VARCHAR2 | 240 | This field tracks the column name of quantity unit of measure attribute associated with the usage charge. | ||
| REPORTED_QTY_ATTRIBUTE_NAME | VARCHAR2 | 240 | This field tracks the name of reported quantity attribute associated with the usage charge. | ||
| REPORTED_UOM_ATTRIBUTE_NAME | VARCHAR2 | 240 | This field tracks the name of reported quantity unit of measure attribute associated with the usage charge. | ||
| REPORTED_QTY_COLUMN_NAME | VARCHAR2 | 240 | This field tracks the column name of reported quantity attribute associated with the usage charge. | ||
| REPORTED_UOM_COLUMN_NAME | VARCHAR2 | 240 | This field tracks the column name of reported quantity unit of measure attribute associated with the usage charge. | ||
| QP_QUANTITY_ATTRIBUTE_NAME | VARCHAR2 | 240 | This field tracks the name of quantity attribute from pricing application associated with the usage charge. | ||
| QP_QUANTITY_UOM_ATTRIBUTE_NAME | VARCHAR2 | 240 | This field tracks the name of quantity unit of measure attribute from pricing application associated with the usage charge. | ||
| BALANCE_PROFILE_CHARGE_ID | NUMBER | 18 | This field tracks the identifier of balance profile charge associated with the usage charge. | ||
| EVENT_TYPE_CHARGE_ID | NUMBER | 18 | This field tracks the identifier of event type charge associated with the usage charge. | ||
| PRICE_LIST_CHARGE_ID | NUMBER | 18 | This field tracks the identifier of price list charge associated with the usage charge. | ||
| USAGE_CAPTURE_FLAG | VARCHAR2 | 1 | This field tracks the usage capture flag associated with the usage charge. | ||
| SUMMARIZED_RATING_FLAG | VARCHAR2 | 1 | This field tracks the summarized rating flag associated with the usage charge. | ||
| VOLUME_PRICING_FLAG | VARCHAR2 | 1 | This field tracks the volume pricing flag associated with the usage charge. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | This field tracks the currency code associated with the usage charge. | ||
| ENT_PLAN_CHARGE_RULE_ID | NUMBER | 18 | This field tracks the identifier of entitlement plan charge rule associated with the usage charge. | ||
| RATE_TABLE_CHARGE_RULE_ID | NUMBER | 18 | This field tracks the identifier of rate table charge rule associated with the usage charge. | ||
| PRICE_ADJ_CHARGE_RULE_ID | NUMBER | 18 | This field tracks the identifier of price adjustment charge rule associated with the usage charge. | ||
| ADDTL_CHARGE_RULE_ID | NUMBER | 18 | This field tracks the identifier of additional charge rule associated with the usage charge. | ||
| INSTANCE_CHARGE_DETERMINANT_ID | NUMBER | 18 | This field tracks the identifier of instance charge determinant associated with the usage charge. | ||
| BASE_PRICE_MATRIX_ID | NUMBER | 18 | This field tracks the identifier of base price matrix associated with the usage charge. | ||
| PRICE_ADJUSTMENT_MATRIX_ID | NUMBER | 18 | This field tracks the identifier of price adjustment matrix associated with the usage charge. | ||
| BALANCE_USAGE_CHARGE_ID | NUMBER | 18 | This field tracks the identifier of balance uage charge associated with the usage charge. | ||
| AMOUNT_BALANCE_USAGE_CHARGE_ID | NUMBER | 18 | This field tracks the identifier of amount balance usage charge associated with the usage charge. | ||
| USAGE_BILL_LINE_ID | NUMBER | 18 | This field tracks the identifier of usage bill line associated with the usage charge. | ||
| VOL_PRI_ELGBL_BALANCE_CODE_ID | NUMBER | 18 | This field tracks the identifier of volume pricing eligibility balance code associated with the usage charge. | ||
| VOL_PRI_AGGN_BALANCE_CODE_ID | NUMBER | 18 | This field tracks the identifier of volume pricing aggregation balance code associated with the usage charge. | ||
| ENT_PLAN_AGGN_CHARGE_RULE_ID | NUMBER | 18 | This field tracks the identifier of entitlement plan aggregation charge rule associated with the usage charge. | ||
| PARENT_USAGE_CHARGE_ID | NUMBER | 18 | This field tracks the identifier of parent usage charge associated with the usage charge. | ||
| QP_RATE_TABLE_RULE_ID | NUMBER | 18 | This field tracks the identifier of pricing rate table rule associated with the usage charge. | ||
| QP_ADJ_MATRIX_RULE_ID | NUMBER | 18 | This field tracks the identifier of pricing adjustment martix rule associated with the usage charge. | ||
| QP_RATE_TABLE_VALIDITY_FLAG | VARCHAR2 | 1 | This field tracks the pricing rate table validity flag associated with the usage charge. | ||
| QP_ADJ_MATRIX_VALIDITY_FLAG | VARCHAR2 | 1 | This field tracks the pricing adjustment matrix validity flag associated with the usage charge. | ||
| BALANCE_CODE_QP_RT_RULE_ID | NUMBER | 18 | This field tracks the identifier of balance code pricing rate table rule associated with the usage charge. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OSS_USAGE_CHARGES_N1 | Non Unique | Default | EVENT_ID |
| OSS_USAGE_CHARGES_N2 | Non Unique | Default | BILL_LINE_ID |
| OSS_USAGE_CHARGES_N3 | Non Unique | Default | BALANCE_REGISTER_ID, BALANCE_REGISTER_PERIOD_ID, BALANCE_CODE_ID |
| OSS_USAGE_CHARGES_N4 | Non Unique | Default | PARENT_ENTITY_ID, CHARGE_DEFINITION |
| OSS_USAGE_CHARGES_N5 | Non Unique | Default | SUBSCRIPTION_ID, REQUEST_ID |
| OSS_USAGE_CHARGES_N6 | Non Unique | Default | SUBSCRIPTION_PRODUCT_ID, REQUEST_ID |
| OSS_USAGE_CHARGES_N7 | Non Unique | Default | BALANCE_REGISTER_ID, REQUEST_ID |
| OSS_USAGE_CHARGES_N8 | Non Unique | Default | BALANCE_ESTIMATE_ID, AMOUNT_BALANCE_ESTIMATE_ID |
| OSS_USAGE_CHARGES_N9 | Non Unique | Default | BALANCE_COMMITMENT_ID, AMOUNT_BALANCE_COMMITMENT_ID |
| OSS_USAGE_CHARGES_PK | Unique | Default | USAGE_CHARGE_ID |
| OSS_USAGE_CHARGES_U1 | Unique | Default | USAGE_CHARGE_PUID |