OKC_MANUAL_PRICE_ADJUSTMENTS
This table stores price adjustments for charges
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
OKC_MANUAL_PRICE_ADJUSTME_PK |
ID, MAJOR_VERSION |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ID | NUMBER | 18 | Yes | ID | |
| MANUAL_ADJ_PUID | VARCHAR2 | 2000 | Public Unique Identifier for the Manual Adjustments table | ||
| MAJOR_VERSION | NUMBER | 18 | Yes | Identifies the contract major version | |
| VERSION_TYPE | VARCHAR2 | 1 | Yes | VERSION_TYPE can have 3 values: C, A & H. Updates are allowed only if the Version_Type is ''C' | |
| SEQUENCE_NUMBER | NUMBER | 9 | 'SEQUENCE IN WHICH THIS ADJUSTMENT IS APPLIED IN RELATION TO OTHER MANUAL PRICE ADJUSTMENTS | ||
| 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. | |
| ADJUSTMENT_VALUE | NUMBER | UNITIZED VALUE USED IN CALCULATING THE MANUAL/NEGOTIATED DISCOUNT FOR CHARGE OR TOTAL. CAN BE A MONETARY UNIT OR A PERCENT VALUE | |||
| ADJUSTMENT_CURRENCY_CODE | VARCHAR2 | 30 | CURRENCY OF MANUAL PRICE ADJUSTMENTS SUCH AS PRICE OVERRIDES AND AMOUNT BASED ADJUSTMENTS | ||
| REASON_CODE | VARCHAR2 | 30 | CODE WHICH EXPLAINS RATIONALE FOR A MANUAL DISCOUNT | ||
| USAGE_UOM_CODE | VARCHAR2 | 30 | USAGE UOM CODE OF THE CHARGE ON WHICH MANUAL ADJUSTMENT IS APPLIED | ||
| 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. | ||
| VALID_FROM | TIMESTAMP | MANUAL ADJUSTMENT''S EFFECTIVE START DATE | |||
| VALID_UNTIL | TIMESTAMP | MANUAL ADJUSTMENT''S EFFECTIVE END DATE | |||
| DNZ_CHR_ID | NUMBER | 18 | Contract Id | ||
| PRICE_PERIODICITY_CODE | VARCHAR2 | 30 | PRICE PERIODICITY CODE OF THE CHARGE TO WHICH THE MANUAL PRICE ADJUSTMENT IS APPLIED | ||
| CHARGE_PARENT_ENTITY_CODE | VARCHAR2 | 30 | 'ENTITY CODE TO WHICH ADJUSTMENT IS APPLIED | ||
| CHARGE_PARENT_ENTITY_ID | NUMBER | 18 | ENTITY ID TO WHICH ADJUSTMENT IS APPLIED | ||
| CHARGE_ROLLUP_FLAG | VARCHAR2 | 1 | CHARGE ROLLUP ON FLAG OF THE CHARGE TO WHICH THE MANUAL PRICE ADJUSTMENT IS APPLIED | ||
| ADJUSTMENT_TYPE_CODE | VARCHAR2 | 30 | METHOD USED FOR CALCULATING A MANUAL/NEGOTIATED DISCOUNT FOR PRODUCT CHARGE | ||
| BASIS_ELEMENT_CODE | VARCHAR2 | 30 | PRICING BASIS FOR CALCULATION OF ADJUSTMENT | ||
| CHARGE_DEFINITION_CODE | VARCHAR2 | 30 | 'DEFINITION CODE OF CHARGE TO WHICH MANUAL PRICE ADJUSTMENT IS APPLIED | ||
| CHARGE_DEFINITION_ID | VARCHAR2 | 30 | ID OF THE CHARGE TO WHICH MANUAL PRICE ADJUSTMENT IS APPLIED | ||
| MANUAL_PRICING_ERROR | VARCHAR2 | 2000 | Indicates the pricing error message to be returned to indicate the details of the validation. | ||
| CHARGE_ID | NUMBER | 18 | ID OF THE CHARGE TO WHICH MANUAL PRICE ADJUSTMENT IS APPLIED | ||
| PERIOD_FROM | NUMBER | Billing period start for manual adjustments on billing | |||
| PERIOD_UNTIL | NUMBER | Billing period end for manual adjustments on billing | |||
| CLE_ID | NUMBER | 18 | ID OF THE LINE TO WHICH MANUAL PRICE ADJUSTMENT IS APPLIED | ||
| EXTERNAL_KEY1 | VARCHAR2 | 120 | EXTERNAL_KEY1 | ||
| EXTERNAL_KEY2 | VARCHAR2 | 120 | EXTERNAL_KEY2 |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OKC_MANUAL_PRICE_ADJ_U1 | Unique | Default | ID, MAJOR_VERSION |
| OKC_MANUAL_PRICE_ADJ_U2 | Unique | Default | EXTERNAL_KEY1, EXTERNAL_KEY2 |