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	cmr 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 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 id - populated only if invoice transaction from account payables
ACCRUAL_CLR_ID	NUMBER		18		accrual clearing id - 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 a 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 id - 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.

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