CSE_ASSET_CHARGES_GT

This is an inprocess data staging table for asset changes in the process of integrating order management fulfillments to Installed Base.

Details

• Schema: FUSION

• Object owner: CSE

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Comments
GTT_DOC_ID	NUMBER		18	The primary key of the entity. To locate the unique inprocess row.
GTT_GROUP_ID	NUMBER		18	The processing group identifier. At the session level, there could be multiple groups.
GTT_TXN_ID	NUMBER		18	The foreign key to the asset transaction that is being processed.
ASSET_CHARGE_ID	NUMBER		18	The charge identifier. The foreign key to the asset charges entity.
ASSET_ID	NUMBER		18	The asset identifier. Foreigk key to the asset entity.
CHARGE_DEFINITION_CODE	VARCHAR2	30		The unique charge definition code
PRICE_ELEMENT_CODE	VARCHAR2	30		The elemental breakdown of the charge. The type code that denotes that breakdown.
PRICE_ELEMENT_USAGE_CODE	VARCHAR2	30		The usage of the price element where is charge is recorded.
PRICED_QUANTITY_UOM_CODE	VARCHAR2	3		The unit of measure at which the order line quantity is priced. The priced quantity would be the asset quantity.
UNIT_PRICE	NUMBER			The unit price of the item on the order line.
CURRENCY_CODE	VARCHAR2	15		The currency code with which the order line was priced.
PRIMARY_FLAG	VARCHAR2	1		Flag indicating which of the price element is to be treated as the primary charge.
PRICE_PERIODICITY_CODE	VARCHAR2	30		The price periodicity code when there is recurring billing involved.
CHARGES_ROLLUP_FLAG	VARCHAR2	1		Rollup flag for the charges entity.
CHARGE_COMPONENTS_ROLLUP_FLAG	VARCHAR2	1		The rollup flag at the charge comonents level.
TAX_INCLUDED_FLAG	VARCHAR2	1		Flag that indicates whether tax is included in the charge or not.
ACTIVE_START_DATE	TIMESTAMP			The date when the asset charge became active.
ACTIVE_END_DATE	TIMESTAMP			The date when the asset charge was terminated.