CMR_RCV_EVENT

Details

Schema: FUSION
Object owner: CMR
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
CMR_RCV_EVENT_COSTS_PK	EVENT_COST_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
EVENT_COST_ID	NUMBER		18	Yes	Surrogate key identifying accounting event Cost Identifier.
ACCOUNTING_EVENT_ID	NUMBER		18	Yes	Accounting Event Identifier and maps to {CMR_RCV_EVENTS.ACCOUNTING_EVENT_ID}
EVENT_COST_SOURCE	VARCHAR2	30			Stores event cost sources like Transfer Price, Purchase Order, Landed Costs, Payables, Transaction Taxes.
EVENT_COST_SOURCE_TYPE	VARCHAR2	50			Stores the event source types based on the event cost source values.
CMR_PO_DISTRIBUTION_ID	NUMBER		18		Purchase Order Distribution Identifier used as foreign key to CMR_PURCHASE_ORDER_DTLS
TRADE_EVENT_COST_ID	NUMBER		18		Trade Event Cost Identifier used as foreign key to CST_TRADE_EVENTS.
TRADE_EVENT_TAX_ID	NUMBER		18		Trade Event Tax Identifier used as foreign key to CST_TRADE_EVENT_TAXES.
TRADE_OVERHEAD_ID	NUMBER				Trade overhead identifier and maps to {CMR_TRADE_OVERHEADS.TRADE_OVERHEAD_ID}
TRADE_EVENT_AVG_COST_ID	NUMBER		18		Trade Event Average Cost Identifier used as foreign key to CMR_TRADE_EVENT_AVG_COST.
RCV_CHARGE_ACTUAL_ID	NUMBER		18		Rcv Charge Actual Identifier used as foreign key to CML_RCV_CHARGE_ACTUALS
RCV_CHARGE_ESTIMATE_ID	NUMBER		18		RCV charge estimate identifier used as foreign key to CML_RCV_CHARGE_ESTIMATES
RCV_CHARGE_ALLOC_ID	NUMBER		18		Reference value of fiscal document freight charges and maps to {CMF_RCV_CHARGE_ALLOCS}
CHARGE_ID	NUMBER		18		Charge Identifier of Landed Cost Charge.
CMR_AP_INVOICE_DIST_ID	NUMBER		18		CMR AP Invoice Distribution Identifier used as foreign key to CMR_AP_INVOICE_DTLS
ACCRUAL_CLR_ID	NUMBER		18		Accrual Clear Identifier used as foreign key to CMR_ACCRUAL_CLR_AMTS.
TRANSACTION_TAX_ID	NUMBER		18		Foreign key reference to CMR_TRANSACTION_TAXES
EVENT_UNIT_COST	NUMBER				Accounting transaction's Unit Cost.
EVENT_PRIOR_UNIT_COST	NUMBER				Stores prior unit cost of the same cost source document.
INCLUSIVE_TAX	NUMBER				Stores Inclusive tax unit amount of the cost source document and applicable for inclusive tax enabled documents
CURRENCY_CODE	VARCHAR2	15			Accounting transaction's entered currency code.
CURRENCY_CONVERSION_TYPE	VARCHAR2	40			Stores entered currency conversion type.
CURRENCY_CONVERSION_RATE	NUMBER				Stores entered currency conversion rate.
CURRENCY_CONVERSION_DATE	DATE				Stores entered currency conversion date
PROCUREMENT_BU_FLAG	VARCHAR2	1			Y/N Flag to indicate if it is a procurement business or not.
SELF_ASSESSED_FLAG	VARCHAR2	1			Flag to indicate if the tax is Self assessed
DESTINATION_TYPE_CODE	VARCHAR2	25			Identifies type of destination for the material: Inventory, Expense
CROSS_BU_FLAG	VARCHAR2	1			Y/N Flag to indicate if it is a Global/Non-Global Purchase Order.
SERVICE_LINE_TYPE_PO_FLAG	VARCHAR2	1			Y/N Flag to indicate if it is a service line type PO or not.
INTERCOMPANY_INVOICING_FLAG	VARCHAR2	1			InterCompany invoice flag. Y means accounting event is intercompany enabled. NULL or N means not enabled.
TAX_LIABILITY_FLAG	VARCHAR2	1			Tax liability accounting line type on transaction tax line. Y means Tax Liability accounting line type. NULL or N means ACCRUAL
INCLUSIVE_FLAG	VARCHAR2	1			Inclusive Tax line indicator used while transferring taxes to Projects. Y indicates inclusive tax and NULL or N indicates exclusive tax
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CMR_RCV_EVENT_COSTS	cmr_rcv_events	ACCOUNTING_EVENT_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CMR_RCV_EVENT_COSTS_N1	Non Unique	Default	ACCOUNTING_EVENT_ID, EVENT_COST_SOURCE, EVENT_COST_SOURCE_TYPE
CMR_RCV_EVENT_COSTS_N2	Non Unique	Default	CMR_PO_DISTRIBUTION_ID, TRADE_EVENT_COST_ID, TRADE_OVERHEAD_ID, TRADE_EVENT_AVG_COST_ID, CMR_AP_INVOICE_DIST_ID, TRANSACTION_TAX_ID, ACCRUAL_CLR_ID
CMR_RCV_EVENT_COSTS_N3	Non Unique	Default	TRADE_EVENT_TAX_ID
CMR_RCV_EVENT_COSTS_U1	Unique	Default	EVENT_COST_ID