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 |