DOO_RMCS_INTG_CHARGE_GT

This table contains intermediate data to be processed for the interfacing data to revenue management. Data for this table is sourced from doo_order_charges. This is a temporary table which is used internally by Oracle.

Details

• Schema: FUSION

• Object owner: DOO

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Comments
ORDER_CHARGE_ID	NUMBER		Unique Identifier of DOO_RMCS_INTG_CHARGE_GT table.
CHARGE_DEFINITION_CODE	VARCHAR2	30	A charge definition is a combination of Price Type, Charge Type, Charge Sub Type. Combination of these three attributes is represented as a single code.
PARENT_ENTITY_ID	NUMBER		Id of the parent entity of the charge.
CHARGE_APPLIES_TO	VARCHAR2	30	Indicates whether a charge is applied to Product, Shipping or Return.
ROLLUP_FLAG	VARCHAR2	1	Marks a charge as a rollup/aggregate charge.
PRIMARY_FLAG	VARCHAR2	1	Indicates whether this charge is the primary charge.
PRICE_TYPE_CODE	VARCHAR2	30	Price type of a given charge. One-time, Recurring, Usage, Recurring usage.
PRICE_PERIODICITY_CODE	VARCHAR2	30	Indicates periodicity for both recurring and recurring usage price types. Viz Month, Year, Quarter.

Indexes

Index	Uniqueness	Columns
doo_rmcs_intg_charge_gt_N1	Non Unique	PARENT_ENTITY_ID
doo_rmcs_intg_charge_gt_U1	Unique	ORDER_CHARGE_ID