QP_PLCHARGES_DATE_OVERLAP_GT
This table is a global temporary table which is used by the Price Lists Import FBDI process and will contain the price list charges rows copied from both the base table (qp_price_list_charges) and the interface table. This will help quickly compare all the charges for an item and identify if there are any overlapping rows. The data in this table will be deleted on commit.
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PRICE_LIST_CHARGE_ID | NUMBER | 18 | Unique ID for the price list charge copied from the qp_price_list_charges for overlap check. | ||
| PRICE_LIST_CHARGE_INT_ID | NUMBER | A system generated unique ID for a charge copied from the qp_price_list_charges_int table. It is used to identify whether the record is from the interface or base table. Only the rows copied from Interface table will have this attribute value populated. | |||
| PARENT_ENTITY_ID | NUMBER | 18 | Yes | Unique ID of parent source for a price list charge. e.g. Price list item id. | |
| CHARGE_DEFINITION_ID | NUMBER | 18 | Yes | A value that uniquely identifies the charge definition for a price list charge. | |
| PRICE_PERIODICITY_CODE | VARCHAR2 | 3 | Periodicity unit of measure code for a recurring or recurring usage charge. | ||
| USAGE_UOM_CODE | VARCHAR2 | 3 | Usage unit of measure code for a usage charge. | ||
| START_DATE | TIMESTAMP | Yes | Start date of the effective period of a charge. | ||
| END_DATE | TIMESTAMP | End date of the effective period of a charge. | |||
| STATUS | VARCHAR2 | 30 | Status of each charge record. It can be either ERROR or PARTIAL_ERROR | ||
| CHILD_BATCH_NAME | VARCHAR2 | 50 | Yes | Name of the child pricing batch to be processed. This will be the unique identifier for all the rows loaded in that child batch. | |
| OPERATION_CODE | VARCHAR2 | 30 | Indicates the operation on the records to be imported. It can be CREATE, UPDATE or END-INSERT. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| QP_PLCHG_DATE_OVERLAP_GT_N1 | Non Unique | PARENT_ENTITY_ID, CHARGE_DEFINITION_ID, PRICE_PERIODICITY_CODE, USAGE_UOM_CODE |