CMR_TRADE_OVERHEADS

This table stores overhead cost for all trade events to be processed by receipt accounting.

Details

• Schema: FUSION

• Object owner: CMR

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
CMR_TRADE_OVERHEADS_PK	TRADE_OVERHEAD_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TRADE_OVERHEAD_ID	NUMBER		18	Yes	Trade event overhead id and surrogate key column.
TRADE_EVENT_ID	NUMBER		18	Yes	Trade Events identifier. References to {CST_TRADE_EVENTS.TRADE_EVENT_ID}.
INV_TRANSACTION_ID	NUMBER		18		Inventory shipping transaction identifier. This is populated for inter Org and Transfer Order transactions.
EXPENSE_POOL_ID	NUMBER			Yes	Overhead absorption bucket. Value of -99 used for Cost propagation and other values are for overheads.
PROCESSED_BY_RA_FLAG	VARCHAR2	5			it indicates overheads are processed by receipt accounting. Values - Y and N
COST_DATE	TIMESTAMP				Costed date of trade event overheads
TRANSACTION_DATE	TIMESTAMP				trade event transaction date for accounting the transaction overheads and cost propagation transactions.
UNIT_COST	NUMBER				Overhead's or cost propagation's unit cost.
UOM_CODE	VARCHAR2	3			unit of measure code of costing transaction's code
CURRENCY_CODE	VARCHAR2	15			Currency code of overheads. It should be same as primary cost book's ledger currency and same as trade event business unit's ledger currency
UOM_CONVERSION_FACTOR	NUMBER				UOM conversion factor from primary UOM of item to overhead cost uom.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
CMR_TRADE_OVERHEADS_N1	Non Unique	Default	PROCESSED_BY_RA_FLAG, TRADE_EVENT_ID
CMR_TRADE_OVERHEADS_U1	Unique	Default	TRADE_OVERHEAD_ID