CMR_AUTO_ACCRUAL_CLR

Details

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

Primary Key

Name	Columns
CMR_AUTO_ACCRUAL_CLR_DTLS_PK	CMR_PO_DISTRIBUTION_ID, ACCRUAL_CLEARED_DATE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CMR_PO_DISTRIBUTION_ID	NUMBER		18	Yes	Single column FK: Identifies entity in Receipt accounting PO Distributions. This value will exist for match to PO as well as match to Receipt cases.
BUSINESS_UNIT_ID	NUMBER		18	Yes	Business Unit Id of the Inventory Organization.
ACCRUAL_CLR_GROUP_ID	NUMBER		18		Accrual Clearing Group identifier. This value is tie back for clearing and adjustment event.
ACCRUAL_CLR_RULE_NAME	VARCHAR2	25			Accrual clearing rule name - name of the rule defined in accrual clearing rules UI
ACCRUAL_STATUS	VARCHAR2	25			Denotes Accrual clearing status - CLEARED, REVERSE, NOT CLEARED (default) CLEARED means picked by respective background processor, NOT CLEARED means clearing rule is not satisfied, REVERSED - New transaction has come
ACCRUAL_CLEARED_DATE	TIMESTAMP			Yes	Accrual cleared date on which date po passed accrual clearing rule
ACTIVE_FLAG	VARCHAR2	1			Indicates the active record for a given POD
ACCRUAL_PROCESS_STATUS	VARCHAR2	5			Indicates flag if PO distribution is processed by Receipt Accounting Distribution processor - Y means processed, N means not processed
DELIVERY_PROCESS_STATUS	VARCHAR2	5			Indicates flag if PO distribution is processed by delivery engines - 1. Receipt Accounting distribution processor for expense deliver 2. Cost processor for inventory deliver
CMR_ACCRUAL_AMT	NUMBER				It is sum of accrual amount for all invoices on this po distribution posted by receipt accounting.
AP_ACCRUAL_AMT	NUMBER				It is sum of accrual amount for all invoices on this po distribution posted by accounts payables.
ACCRUAL_CLR_AMT	NUMBER				It is sum of accrual amount for all invoice and receipt transactions on this po distribution. it is sum of cmr_accrual_amt and ap_accrual_amt
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_AUTO_ACCRUAL_CLR_DTLS_N1	Non Unique	FUSION_TS_TX_DATA	ACCRUAL_STATUS, ACCRUAL_CLR_GROUP_ID, CMR_PO_DISTRIBUTION_ID, ACCRUAL_PROCESS_STATUS, DELIVERY_PROCESS_STATUS
CMR_AUTO_ACCRUAL_CLR_DTLS_PK	Unique	FUSION_TS_TX_DATA	CMR_PO_DISTRIBUTION_ID, ACCRUAL_CLEARED_DATE