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 |