CMR_AUTO_ACCRUAL_CLR_DTLS
This table stores the auto accrual clearing transactions for the purchase order distribution.
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 | 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. | |
| BUSINESS_UNIT_ID | NUMBER | 18 | Yes | Profit center business unit identifier of purchase order deliver transactions. | |
| ACCRUAL_CLR_GROUP_ID | NUMBER | 18 | Accrual clearing group identifier used while performing accrual clearing event. | ||
| ACCRUAL_CLR_RULE_NAME | VARCHAR2 | 25 | This column indicates accrual clearing rule name for auto accrual clearing events. | ||
| ACCRUAL_STATUS | VARCHAR2 | 25 | This column indicates the latest status of the accrual transaction. | ||
| 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 receipt accounting. | ||
| DELIVERY_PROCESS_STATUS | VARCHAR2 | 5 | This column indicates that the distribution is processed by delivery process engines, | ||
| CMR_ACCRUAL_AMT | NUMBER | Indicates the total receipt accrual amount for the purchase order distribution in receipt accounting. | |||
| AP_ACCRUAL_AMT | NUMBER | Indicates the total invoice accrual amount for the purchase order distribution in receipt accounting. | |||
| ACCRUAL_CLR_AMT | NUMBER | Indicates the sum of total receipt accrual amount and total invoice accrual amount for the purchase order distribution. | |||
| 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 |