OSS_USAGE_CHARGES_INT
This table oss_usage_charges_int is used to import usage charges attributes.
Details
-
Schema: FUSION
-
Object owner: OSS
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
OSS_USAGE_CHARGES_INT_PK |
BATCH_ID, INTERFACE_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BATCH_ID | NUMBER | 18 | Yes | Import Batch Id, every batch of data being imported should be assigned a batch id. | |
| EVENT_NUMBER | VARCHAR2 | 120 | Event number to capture PUID of usage event. | ||
| INTERFACE_ROW_ID | NUMBER | 18 | Yes | Unique identifier for a record within a batch, source system should populate this. | |
| IMPORT_STATUS_CODE | VARCHAR2 | 30 | Status of row in the interface table, source system should leave this as null. | ||
| FILE_RECORD_NUM | NUMBER | 18 | Used by import utility to relate the record in interface table to the file row. | ||
| ACTION_CODE | VARCHAR2 | 30 | Code specifying the action for the import for e.g., INSERT, UPDATE or NULL. | ||
| INTERNAL_ACTION_CODE | VARCHAR2 | 30 | Used internally by the bulk import ODI program. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| FILE_NAME_SYSTASK_ID | NUMBER | 18 | Save the individual sys task id for each input csv file. | ||
| ERROR_MESSAGE | VARCHAR2 | 2000 | This column would be populated when there is any error. | ||
| USAGE_CHARGE_ID | NUMBER | 18 | Unique identifier for usage charge. | ||
| USAGE_CHARGE_PUID | VARCHAR2 | 120 | Alternate identifier for usage charge. | ||
| USAGE_EVENT_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. | ||
| 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 | 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. | ||
| 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 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | 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. | ||
| BATCH_TAG | VARCHAR2 | 30 | User defined value which determines whether the record is in inconsistent state and has to be rectified. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OSS_USAGE_CHARGES_INT_N1 | Non Unique | Default | BATCH_ID, IMPORT_STATUS_CODE, INTERNAL_ACTION_CODE, INTERFACE_ROW_ID |
| OSS_USAGE_CHARGES_INT_N2 | Non Unique | Default | BATCH_ID, USAGE_CHARGE_ID |
| OSS_USAGE_CHARGES_INT_U1 | Unique | Default | BATCH_ID, INTERFACE_ROW_ID |