QP_CLCHARGES_DATE_OVERLAP_GT
This table is a global temporary table which is used by the Cost Lists Import FBDI process and will contain the cost list charges rows copied from both the base table (qp_cost_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 |
---|---|---|---|---|---|
COST_LIST_CHARGE_ID | NUMBER | 18 | Unique ID for the cost list charge copied from the qp_cost_list_charges for overlap check. | ||
COST_LIST_CHARGE_INT_ID | NUMBER | A system generated unique ID for a charge copied from the qp_cost_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 cost list charge. e.g. Cost list item id. | |
CHARGE_DEFINITION_ID | NUMBER | 18 | Yes | A value that uniquely identifies the charge definition for a cost 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 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_CLCHG_DATE_OVERLAP_GT_N1 | Non Unique | PARENT_ENTITY_ID, CHARGE_DEFINITION_ID, PRICE_PERIODICITY_CODE, USAGE_UOM_CODE |