1. Tables and Views for SCM
  2. CMR_ACCRUAL_CLR_DTLS_S_GT

CMR_ACCRUAL_CLR_DTLS_S_GT

This table is used to temporarily store a subset of data from CMR_AUTO_ACCRUAL_CLR_DTLS table to support internal processing within the Cost Processor.

Details

  • Schema: FUSION

  • Object owner: CMR

  • Object type: TABLE

  • Tablespace: DEFAULT

Columns

Name Datatype Length Precision Not-null Comments
CMR_PO_DISTRIBUTION_ID NUMBER 18 Yes Identifies an entity in receipt accounting purchase order distributions. This value will exist for match to purchase order as well as match to receipt cases.
ACCRUAL_CLEARED_DATE TIMESTAMP Yes Accrual cleared date on which date purchase order distribution passed accrual clearing rule.
ACCRUAL_TXN_DATE TIMESTAMP Latest transaction date on purchase order distribution or schedule.
ACTIVE_FLAG VARCHAR2 1 Indicates the active record for a given purchase order distribution.
ACCRUAL_PROCESS_STATUS VARCHAR2 5 This column indicates the purchase order distribution is processed or not by receipt accounting.
DELIVERY_PROCESS_STATUS VARCHAR2 5 This column indicates that the distribution is processed by delivery process engines.
PO_LINE_LOCATION_ID NUMBER 18 Purchase order shipment schedule identifier.
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.
EVENT_DATE TIMESTAMP Date when the event in the EVENT_TYPE happened.
PROCESSED_BY_CA_FLAG VARCHAR2 1 Indicates whether the distribution was picked up by the cost accounting processor.
INVENTORY_ITEM_ID NUMBER 18 Inventory Item Identifier and References {EGP_SYSTEM_ITEMS_B.inventory_item_id}.
ACCRUAL_STATUS VARCHAR2 25 This column indicates the latest status of the accrual transaction.
ROW_UPDATED_FLAG VARCHAR2 1 Indicates if this row has been updated during the process.
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 Columns
CMR_ACCRUAL_CLR_DTLS_S_GT_U1 Unique CMR_PO_DISTRIBUTION_ID, ACCRUAL_CLEARED_DATE