OSS_BALANCE_ADJUSTMENTS
Balance Adjustments table stores the Adjustments of Balances for Subscription Product.
Details
-
Schema: FUSION
-
Object owner: OSS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
OSS_BALANCE_ADJUSTMENTS_PK |
BALANCE_ADJUSTMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BALANCE_ADJUSTMENT_ID | NUMBER | 18 | Yes | Unique Identifier of Balance Adjustment | |
| BALANCE_ADJUSTMENT_NUMBER | VARCHAR2 | 120 | Yes | Alternate identifier of Balance Adjustment | |
| ENTITLEMENT_TYPE | VARCHAR2 | 120 | Type of Entitlement that is getting Adjusted. It can be Allowance, Estimate, Commitment. | ||
| ENTITLEMENT_ID | NUMBER | 18 | Foreign Key Identifier of Entitlement Record | ||
| SUBSCRIPTION_PRODUCT_ID | NUMBER | 18 | Foreign Key Identifier to Subscription Product. | ||
| BALANCE_REGISTER_ID | NUMBER | 18 | Foreign Key Identifier to Balance Register. | ||
| BALANCE_REGISTER_PERIOD_ID | NUMBER | 18 | Foreign Key Identifier to Balance Register Period. | ||
| CHARGE_LINE_ID | NUMBER | 18 | Foreign Key Identifier to Charge Line. | ||
| BALANCE_CODE_ID | NUMBER | 18 | Foreign Key Identifier to Balance Code Id. | ||
| BALANCE_CODE_TYPE | VARCHAR2 | 30 | Type of Balance Code. It can be Amount or Quantity. | ||
| CURRENCY_CODE | VARCHAR2 | 30 | Field used to capture currency code. | ||
| BAL_ADJ_PARTIAL_PERIOD_OPT | VARCHAR2 | 30 | The method that determines how the adjustment needs to be given for partial period. | ||
| ADJUSTMENT_NAME | VARCHAR2 | 30 | User-defined name or label to identify and categorize the specific adjustment record. | ||
| ADJUSTMENT_DESCRIPTION | VARCHAR2 | 120 | Detailed description of the adjustment reason or context for audit and reporting. | ||
| ADJUSTMENT_REASON_CODE | VARCHAR2 | 30 | Reason code for Adjustment. Extensible Lookup values. | ||
| ADJUSTMENT_TYPE | VARCHAR2 | 30 | Specifies the nature of adjustment, such as markup, markdown, or manual correction. | ||
| ADJUSTMENT_VALUE | NUMBER | Value of the adjustment. Can be percentage value or absolute value based on ADJUSTMENT_TYPE. | |||
| ADJUSTED_QUANTITY | NUMBER | Entitlement quantity changed as part of the adjustment process. | |||
| TERMINATED_QUANTITY | NUMBER | Adjusted quantity that got terminated as part of subscription product termination. | |||
| NET_ADJUSTED_QUANTITY | NUMBER | Final Adjusted Quantity for the current period. | |||
| ADJUSTED_AMOUNT | NUMBER | Entitlement amount changed as part of the adjustment process. | |||
| TERMINATED_AMOUNT | NUMBER | Adjusted amount that got terminated as part of subscription product termination. | |||
| NET_ADJUSTED_AMOUNT | NUMBER | Final Adjusted Amount for the current period. | |||
| SEQUENCE_NUMBER | NUMBER | Sequence Number of the adjustment record created. | |||
| 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_BALANCE_ADJUSTMENTS_N1 | Non Unique | Default | ENTITLEMENT_ID, ENTITLEMENT_TYPE, SEQUENCE_NUMBER |
| OSS_BALANCE_ADJUSTMENTS_PK | Unique | Default | BALANCE_ADJUSTMENT_ID |
| OSS_BALANCE_ADJUSTMENTS_U1 | Unique | Default | BALANCE_ADJUSTMENT_NUMBER |