CMR_PO_SCHED_ACCRUAL_CLR_DTLS

This table stores the manual and auto accrual clearing statuses at the PO Schedule Level. Accrual clearing is performed at the PO schedule level for Global Procurement purchase orders.

Details

• Schema: FUSION

• Object owner: CMR

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
CMR_POS_ACCRUAL_CLR_DTLS_PK	CMR_PO_LINE_LOCATION_ID, ACCRUAL_CLEARED_DATE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CMR_PO_LINE_LOCATION_ID	NUMBER		18	Yes	Internal Purchase Order Schedule Identifier.
BUSINESS_UNIT_ID	NUMBER		18	Yes	Profit center business Unit Identifier of purchase order schedule
ACCRUAL_CLR_GROUP_ID	NUMBER		18		Accrual Clearing Group identifier. This value is tie back for clearing and adjustment event.
ACCRUAL_CLEARING_STATUS	VARCHAR2	25			Denotes Accrual clearing status - Valid values are CLEARED, REVERSED.
ACCRUAL_CLR_RULE_NAME	VARCHAR2	25			Accrual clearing rule name - name of the rule defined in accrual clearing rules UI.
ACTIVE_FLAG	VARCHAR2	1		Yes	Active Flag Indicator of auto accrual cleared purchase order schedule.
ACCRUAL_CLEARED_DATE	TIMESTAMP			Yes	Accrual cleared date is the date PO passed the accrual clearing rule.
ACCRUAL_PROCESSED_FLAG	VARCHAR2	1		Yes	Indicator flag if PO distribution was processed by Receipt Accounting Distribution processor - Y means processed, N means not processed.
DELIVERY_PROCESSED_FLAG	VARCHAR2	1		Yes	Indicator flag if PO distribution was processed by delivery engines - 1. Receipt Accounting distribution processor for expense deliver 2. Cost processor for inventory deliver.
ACCRUAL_CLEARING_AMOUNT	NUMBER				Accrual Clearing amount of purchase order schedule.
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.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
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_POS_ACCRUAL_CLR_DTLS_U1	Unique	FUSION_TS_TX_DATA	CMR_PO_LINE_LOCATION_ID, ACCRUAL_CLEARED_DATE
CMR_PO_ACCRUAL_CLR_DTLS_N1	Non Unique	Default	ACCRUAL_CLR_GROUP_ID, CMR_PO_LINE_LOCATION_ID, BUSINESS_UNIT_ID