QP_CHANGE_PL_CHARGES
Table that stores changed price list charges
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
QP_CHANGE_PL_CHARGES_PK |
CHANGE_PL_CHARGE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
CHANGE_PL_CHARGE_ID | NUMBER | 18 | Yes | Indicates the primary key for price list charge changes | |
CHANGE_ID | NUMBER | 18 | Yes | Indicates the identifier of the changes associated to the existing row. | |
PARENT_TYPE_CODE | VARCHAR2 | 30 | Yes | The parent type to which the charge applies to | |
PARENT_ID | NUMBER | 18 | Yes | The parent id to which the charge applies to. | |
OPERATION_CODE | VARCHAR2 | 30 | Yes | The operation code to which the charge the charge applies to. | |
ORIGINAL_PRICE_LIST_CHARGE_ID | NUMBER | 18 | Indicates the identifier of the price list charge associated to the existing row. | ||
NEW_PRICE_LIST_CHARGE_ID | NUMBER | 18 | Unique for the new change price list charge. | ||
PRICE_LIST_ID | NUMBER | 18 | Yes | Id of the price list to which this charge belongs to. | |
CHARGE_LINE_NUMBER | NUMBER | 9 | Yes | Unique charge line number.THIS number is unique for a parent entity. | |
START_DATE | TIMESTAMP | Yes | The date starting from which this charge is valid. | ||
CHARGE_DEFINITION_ID | NUMBER | 18 | Yes | The charge defination for the associated price. | |
PARENT_ENTITY_TYPE_CODE | VARCHAR2 | 30 | Yes | The parent type to which the charge applies to. | |
PARENT_ENTITY_ID | NUMBER | 18 | Yes | The parent entity id to which the charge applies to. | |
CALCULATION_METHOD_CODE | VARCHAR2 | 30 | Yes | The price calculation method for the charge. | |
BASE_PRICE | NUMBER | Base price before applying adjustments to on the PLL (AP, CP, TP, FP) | |||
USAGE_UOM_CODE | VARCHAR2 | 3 | Uom code for the usage price of the product. | ||
PRICE_PERIODICITY_CODE | VARCHAR2 | 3 | Uom code for the price periodicity of the product. | ||
CAN_ADJUST_FLAG | VARCHAR2 | 30 | Flag that indicates if the price returned by this line can be adjusted manually. | ||
END_DATE | TIMESTAMP | The date starting to which this charge is valid. | |||
TIERED_PRICING_HEADER_ID | NUMBER | 18 | Foreign key to tiered pricing header entity. | ||
ATTRIBUTE_PRICING_MATRIX_ID | NUMBER | 18 | Foreign key to attribute pricing model header entity. | ||
TIER_CONTEXT_CODE | VARCHAR2 | 30 | If parent type is price list item,The value of this attribute will be set to Item.If parent type is covered item,The value of this attribute will be set to coverage. | ||
CALCULATION_TYPE_CODE | VARCHAR2 | 30 | Indicates how coverage will be priced or adjusted.The adjustment type for adjusting the coverage when adjusting coverage or the coverage calculation type when pricing coverage.Can be price override or percentage of covered product. | ||
COST_CALCULATION_AMOUNT | NUMBER | Indicates the adjustment amount for cost based rules for a change | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
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. | |
ORIG_OBJ_VER_NUM | NUMBER | 9 | Yes | To implement locking betwen Change and Live data tables. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
QP_CHANGE_PL_CHARGES | qp_changes_all_b | CHANGE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
QP_CHANGE_PL_CHARGES_FK | Non Unique | FUSION_TS_TX_IDX | CHANGE_ID |
QP_CHANGE_PL_CHARGES_PK | Unique | FUSION_TS_TX_IDX | CHANGE_PL_CHARGE_ID |