CMR_EXPENSE_CLR_AMTS

This table stores expense values corresponding to manual or auto accrual clearing events.

Details

• Schema: FUSION

• Object owner: CMR

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
CMR_EXPENSE_CLR_AMTS_PK	CMR_EXPENSE_CLR_AMTS_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CMR_EXPENSE_CLR_AMTS_ID	NUMBER		18	Yes	Unique identifier for the expense amounts calculated and stored during an accrual clearing.
EXP_PO_DIST_COST_ID	NUMBER		18		Reference to the expense distribution costs table whose clearing amounts are stored here.
CMR_PO_DISTRIBUTION_ID	NUMBER		18		Reference to the po distribution whose clearing amounts are stored here.
AP_INVOICE_DISTRIBUTION_TYPE	VARCHAR2	25			Invoice distribution type of this expense line.
INCLUSIVE_FLAG	VARCHAR2	1			Indicates whether the tax is inclusive or not.
INVOICE_AMT	NUMBER				Amount invoiced for this purchase order distribution.
INVOICE_AMT_ENTERED_CURR	NUMBER				Amount invoiced for this purchase order distribution in purchase order currency.
NET_EXP_ADJ_AMT_ROUNDED	NUMBER				Net expense adjustment amount rounded to functional currency precision.
NET_EXP_ADJ_AMT_ROUNDED_EC	NUMBER				Net expense adjustment amount in entered currency rounded to entered currency precision.
ACCRUAL_CLR_GROUP_ID	NUMBER		18		Identifier for a manual or auto accrual clearing event which is used during accrual reversal to identify the parent clearing event.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
CMR_EXPENSE_CLR_AMTS_N1	Non Unique	Default	EXP_PO_DIST_COST_ID
CMR_EXPENSE_CLR_AMTS_N2	Non Unique	Default	CMR_PO_DISTRIBUTION_ID
CMR_EXPENSE_CLR_AMTS_U1	Unique	Default	CMR_EXPENSE_CLR_AMTS_ID