DOO_RMCS_INTG_CHARGE_COMP_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: doo_rmcs_intg_charge_comp_gt

Columns

Name	Datatype	Length	Comments
ORDER_CHARGE_ID	NUMBER		Foreign key to DOO_RMCS_INTG_CHARGE_GT table.
PRICE_ELEMENT_USAGE_CODE	VARCHAR2	30	Indicate how the charge component will be used. Values will come from a QP lookup. OOTB, the values will include "List Price" and "Invoice Price".
HEADER_CURRENCY_UNIT_PRICE	NUMBER		Indicates the price or adjustment per unit in the header currency for the line UOM.
HEADER_CURR_DURATION_EXT_AMT	NUMBER		Identifies extended amount over the given duration in the header currency.

Indexes

Index	Uniqueness	Columns
doo_rmcs_charge_comp_gt_N1	Non Unique	ORDER_CHARGE_ID, PRICE_ELEMENT_USAGE_CODE