CMR_TRADE_EVENT_COST_SOURCES

This table will have trade receipt accrual events that lead to the average cost of Trade Receipt Accrual.

Details

• Schema: FUSION

• Object owner: CMR

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
CMR_TRADE_EVENT_COST_SRC_PK	TRADE_EVENT_COST_SOURCE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TRADE_EVENT_COST_SOURCE_ID	NUMBER		18	Yes	Trade Event Cost Source Identifier
EFFECTIVE_DATE	TIMESTAMP				Average Cost re-calculative date.
TRADE_EVENT_ID	NUMBER		18		Trade Event Identifier of complex flows like global procurement and inter organization flows. This column maps to {CST_TRADE_EVENTS.TRADE_EVENT_ID}
PO_LINE_LOCATION_ID	NUMBER		18		Purchase Order Line Location Identifier.
BUSINESS_UNIT_ID	NUMBER		18		Profit center business Unit Identifier of the trade organization.
INTER_ORG_SHIPMENT_INV_TXN_ID	NUMBER		18		Inter Org transfer shipping transaction identifier. Used for inter Org transfer.
DOO_FULFILLMENT_ID	NUMBER		18		Sales Order fulfillment line identifier. Used in drop shipment case.
EVENT_UNIT_COST	NUMBER				store trade event unit cost used in average calculations
TRADE_EVENT_QTY	NUMBER				stores trade event quantity in source document unit of measure
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.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
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_EVENT_COST_SRC_N1	Non Unique	Default	EFFECTIVE_DATE, BUSINESS_UNIT_ID, PO_LINE_LOCATION_ID, INTER_ORG_SHIPMENT_INV_TXN_ID, DOO_FULFILLMENT_ID, TRADE_EVENT_ID
CMR_TRADE_EVENT_COST_SRC_U1	Unique	Default	TRADE_EVENT_COST_SOURCE_ID