CMR_RCV_DISTRIBUTIONS_GT

This table stores all the distribution entries for Receipt accounting sub ledger temporarily, later moved to persistent table.

Details

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.	Active
ACCOUNTING_LINE_TYPE	VARCHAR2	40			Accounting line type of accounted transaction distribution line.	Active
EVENT_COST_ID	NUMBER		18		Event Cost Identifier.
LINE_NUMBER	NUMBER		9		Accounted transaction's distribution line number.	Active
EVENT_ID	NUMBER		18		Event identifier in SLA.	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 identifier.	Active
PJC_TXN_STATUS_CODE	VARCHAR2	1			It indicates the project eligible transactions.	Active
BALANCE_TYPE	VARCHAR2	1			Indicates Balance type.
EA_ENTERED_CURRENCY_CODE	VARCHAR2	15			Identifies the Currency Code for Encumbrance enabled Orders.

Index	Uniqueness	Columns
CMR_RCV_DISTRIBUTIONS_GT_N1	Non Unique	ACCOUNTING_EVENT_ID