CMR_ACCRUAL_CLR_AMT

Details

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

Primary Key

Name	Columns
CMR_ACCRUAL_CLR_AMT_DTLS_PK	ACCRUAL_CLR_DTL_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ACCRUAL_CLR_DTL_ID	NUMBER		18	Yes	accrual clearing detail identifier and surrogate key column.
ACCRUAL_CLR_ID	NUMBER		18	Yes	Single column FK: Identifies the accrual clearing event.
CMR_RCV_TRANSACTION_ID	NUMBER		18		Single Column FK: Identifies the receiving transaction.
INVOICE_DISTRIBUTION_ID	NUMBER		18		Single Column FK: Identifies the Invoice document distribution details
CMR_ACCRUAL_CLR_ID	NUMBER		18		This identifies the accrual clearing id of the event.
ACCOUNTING_EVENT_ID	NUMBER		18		Accounting event identifier and this is FK column {CMR_RCV_EVENTS}
EVENT_DISTRIBUTION_TYPE	VARCHAR2	50			Store the event distribution type - ACCRUAL or NRTAX
CMR_AP_INVOICE_DIST_ID	NUMBER		18		Receipt accounting invoice distribution identifier
EVENT_TRANSACTION_NUMBER	VARCHAR2	50			Stores event transaction number - It is receipt number or Purchase Order number.
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
TRANSACTION_DATE	TIMESTAMP			Yes	event transaction date on which date the transaction is created
TXN_ACCOUNTED_AMT	NUMBER			Yes	event transaction accounted amount in functional currency
TXN_ENTERED_AMT	NUMBER				event transaction entered amount in user entered currency
TRANSACTION_QTY	NUMBER				event transaction accounted quantity
TRANSACTION_UOM_CODE	VARCHAR2	3			transaction 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
ACCRUAL_CLR_MODE	VARCHAR2	30			accrual clearing mode - MANUAL CLEARING or AUTO CLEARING
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
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_ACCRUAL_CLR_AMT_DTLS	cmr_accrual_clr_amts	ACCRUAL_CLR_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CMR_ACCRUAL_CLR_AMT_DTLS_N1	Non Unique	Default	ACCRUAL_CLR_ID
CMR_ACCRUAL_CLR_AMT_DTLS_PK	Unique	FUSION_TS_TX_DATA	ACCRUAL_CLR_DTL_ID