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