CMR_ACCR_RECONC

Details

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

Primary Key

Name	Columns
CMR_ACCR_RECONC_DTLS_PK	CMR_ACCR_RECONC_DTL_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CMR_ACCR_RECONC_DTL_ID	NUMBER		18	Yes	Accrual reconciliation detail identifier and surrogate key column.
CMR_ACCR_RECONC_HEADER_ID	NUMBER		18	Yes	Accrual reconciliation header identifier. Foreign key column to CMR_ACCR_RECONC_HEADERS.
EVENT_TRANSACTION_DATE	TIMESTAMP			Yes	Event transaction date on which date this event is accounted and posted to SLA.
EVENT_ACCOUNTED_AMT	NUMBER			Yes	Source event transaction accounted amount in functional currency.
EVENT_TYPE_CODE	VARCHAR2	25			Single column FK: Identifies the SLA event type as defined in CMR_RCV_EVENT_TYPES.
TRANSACTION_TYPE_CODE	VARCHAR2	40			Receipt accounting transaction type code.
EVENT_ENTERED_AMT	NUMBER				Source event transaction entered amount in user specified currency. This will be different if the user transacts other than functional currency.
EVENT_QTY	NUMBER				Source event transaction accounted quantity.
EVENT_UOM_CODE	VARCHAR2	25			Event unit of measure for the quantity.
CURRENCY_CODE	VARCHAR2	15			Identifies currency of the event.
CURRENCY_CONVERSION_TYPE	VARCHAR2	30			Conversion type that should be used for currency conversion.
CURRENCY_CONVERSION_RATE	NUMBER				Optional user specified currency conversion rate.
CURRENCY_CONVERSION_DATE	TIMESTAMP				The date to be used to determine the exchange rates for currency conversion.
CMR_RCV_TRANSACTION_ID	NUMBER		18		Single Column FK: Identifies the receiving transaction.
INVOICE_DISTRIBUTION_ID	NUMBER		18		Invoice distribution identifier - populated only if invoice transaction from account payables.
ACCRUAL_CLR_ID	NUMBER		18		Accrual clearing identifier - populated only if transaction is auto/manual accrual clearing event from CMR.
TRADE_EVENT_ID	NUMBER		18		Trade event identifier on purchase order with multiple nodes and FK column to (CMR_TRANSACTIONS} table.
ACCOUNTING_EVENT_ID	NUMBER		18		Accounting event identifier of purchase order transactions and FK column to table {CMR_RCV_EVENTS}.
EVENT_COST_ID	NUMBER		18		Event cost identifier of purchase order receipts and FK column to table {CMR_RCV_EVENT_COSTS}.
CMR_SUB_LEDGER_ID	NUMBER		18		Distribution identifier of purchase order transactions and FK column to table {CMR_RCV_DISTIRBUTIONS}.
EVENT_DISTRIBUTION_TYPE	VARCHAR2	50			Stores the distribution type of the event of purchase order transactions.
EVENT_TRANSACTION_NUMBER	VARCHAR2	50			Stores event transaction number of purchase order transactions like receipt or purchase order number or invoice number.
SLA_AE_HEADER_ID	NUMBER		18		SLA header identifier - foreign key relationship with XLA_AE_HEADERS.
SLA_AE_LINE_NUM	NUMBER		18		SLA line number - foreign key relationship with XLA_AE_LINES.
SLA_EVENT_ID	NUMBER		18		SLA event identifier purchase order transactions and FK column to {XLA_EVENTS}.
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.
LEDGER_CURRENCY_CODE	VARCHAR2	20			Functional currency code and it is ledger currency code of profit center business unit.
LE_TIMEZONE_TRANSACTION_DATE	TIMESTAMP				Event transaction date as per the time zone code of the Legal entity.
LE_TIMEZONE_CODE	VARCHAR2	50			Indicates legal entity time zone for transaction.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CMR_ACCR_RECONC_DTLS	cmr_accr_reconc_headers	CMR_ACCR_RECONC_HEADER_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CMR_ACCR_RECONC_DTLS_N1	Non Unique	FUSION_TS_TX_DATA	EVENT_TRANSACTION_DATE, EVENT_TYPE_CODE, TRANSACTION_TYPE_CODE, INVOICE_DISTRIBUTION_ID
CMR_ACCR_RECONC_DTLS_N2	Non Unique	Default	CMR_ACCR_RECONC_HEADER_ID
CMR_ACCR_RECONC_DTLS_PK	Unique	FUSION_TS_TX_DATA	CMR_ACCR_RECONC_DTL_ID