CMR_RCV_DISTRIBUTIONS

Details

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

Primary Key

Name	Columns
CMR_RCV_DISTRIBUTIONS_PK	CMR_SUB_LEDGER_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
CMR_SUB_LEDGER_ID	NUMBER		18	Yes	Surrogate identifying the distribution line.	Active
ACCOUNTING_EVENT_ID	NUMBER		18	Yes	receiving accounting event identifier and references to {CMR_RCV_EVENTS.ACCOUNTING_EVENT_ID}	Active
ACCOUNTING_LINE_TYPE	VARCHAR2	40			Accounting line type of accounted transaction distribution line.	Active
EVENT_COST_ID	NUMBER		18		Event Cost Identifier and references to {CMR_RCV_EVENT_COSTSS.EVENT_COST_ID}
LINE_NUMBER	NUMBER		9		Accounted transaction's distribution line number.	Active
EVENT_ID	NUMBER		18		Sla event Id - generated during the event generation by SLA. References to {XLA_EVENTS.EVENT_ID}	Active
ACCOUNTED_QTY	NUMBER				Accounted qty in source document unit of measure.	Active
LEDGER_AMOUNT	NUMBER				Accounted value in Ledger currency	Active
ENTERED_CURRENCY_AMOUNT	NUMBER				Entered value in transaction currency.	Active
ENTERED_CURRENCY_CODE	VARCHAR2	15			Transaction entered currency code. Note this might not always same as transaction enter currency code.	Active
LEDGER_CURRENCY_CODE	VARCHAR2	15		Yes	functional currency code and it is ledger currency code of profit center business unit.	Active
CODE_COMBINATION_ID	NUMBER		18		Account Id - populated based on accounts from CMR_PURCHASE_ORDER_DTLS table	Active
PJC_TXN_STATUS_CODE	VARCHAR2	1			Indicates the status of project eligible transactions. Possible Values are A - successfully interfaced to projects, P-interfaced to projects and waiting for projects' cost processing, R- rejected, F- failed to interface. Z- Not Applicable.	Active
BALANCE_TYPE	VARCHAR2	1			Indicates Balance type. E means Encumbrance entry
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.	Active
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.	Active
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.	Active
EA_ENTERED_CURRENCY_CODE	VARCHAR2	15			Identifies the currency code for encumbrance enabled orders.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CMR_RCV_DISTRIBUTIONS	cmr_rcv_events	ACCOUNTING_EVENT_ID
cmr_prj_intf_errors	cmr_rcv_distributions	CMR_SUB_LEDGER_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
CMR_RCV_DISTRIBUTIONS_N1	Non Unique	Default	ACCOUNTING_LINE_TYPE, ACCOUNTING_EVENT_ID, EVENT_COST_ID, EVENT_ID
CMR_RCV_DISTRIBUTIONS_N2	Non Unique	Default	EVENT_ID
CMR_RCV_DISTRIBUTIONS_N3	Non Unique	Default	ACCOUNTING_EVENT_ID
CMR_RCV_DISTRIBUTIONS_N4	Non Unique	Default	PJC_TXN_STATUS_CODE
CMR_RCV_DISTRIBUTIONS_PK	Unique	FUSION_TS_TX_DATA	CMR_SUB_LEDGER_ID	Active