CMF_PROCESS_RUN_DTLS
This table stores summarizes information about back ground processes requests in fiscal document capture
Details
-
Schema: FUSION
-
Object owner: CMF
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CMF_PROCESS_RUN_DTLS_PK |
PROCESS_RUN_DETAIL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROCESS_RUN_DETAIL_ID | NUMBER | 18 | Yes | Process run detail row identifier. | |
| PROCESS_NAME | VARCHAR2 | 250 | Yes | Name of the CMF process being detailed. | |
| TOTAL_SUCCESS | NUMBER | 18 | Number of records processed for this request. | ||
| TOTAL_ERROR | NUMBER | 18 | Number of records errored for this request. | ||
| TOTAL_IGNORED | NUMBER | 18 | Number of records ignored for this request. | ||
| 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. | ||
| P_LEGAL_ENTITY_ID | NUMBER | 18 | Request parameter: Legal entity identifier. | ||
| P_BUSINESS_UNIT_ID | NUMBER | 18 | Request parameter: Business unit identifier. | ||
| P_INV_ORG_ID | NUMBER | 18 | Request parameter: Inventory organization identifier. | ||
| P_ISSUER_TAXPAYER_ID | NUMBER | 18 | Request parameter: Issuer taxpayer identifier. | ||
| P_ISSUE_DATE_FROM | DATE | Request parameter: ISSUE DATE FROM | |||
| P_ISSUE_DATE_TO | DATE | Request parameter: Issue Date To | |||
| P_DOCUMENT_HEADER_ID | NUMBER | 18 | Request parameter: Fiscal document header identifier. | ||
| P_DOCUMENT_NUMBER | NUMBER | Request parameter: Fiscal document number. | |||
| P_RECEIVER_TAXPAYER_ID | NUMBER | 18 | Request parameter: Indicates taxpayer identifier of the receiver of the fiscal document. | ||
| P_FD_TO_VALIDATE | VARCHAR2 | 30 | Request parameter: Indicates whether all, new or old Fiscal Documents to select for Validation. | ||
| P_ASSOC_ID | NUMBER | 18 | Request parameter: Indicates the fiscal documents to select for validation by fiscal flow. | ||
| P_DOC_STATUS | VARCHAR2 | 30 | Request parameter: Indicates fiscal document to select for validation by fiscal document status. | ||
| P_DOCUMENT_TYPE | VARCHAR2 | 30 | Request parameter: Indicates the fiscal document type by which fiscal documents are to be selected for validation. | ||
| P_SRC_DOC_TYPE | VARCHAR2 | 30 | Request parameter: Indicates the source document type by which fiscal documents are to be selected for validation. | ||
| P_COMMIT_LIMIT | NUMBER | 10 | Request parameter: Identifies the Commit Limit for the processing of fiscal documents. It is the unit of work to perform before committing the work to the database. | ||
| P_CUTOFF_DATE | TIMESTAMP | Request parameter: Cut-off date. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMF_PROCESS_RUN_DTLS_N1 | Non Unique | FUSION_TS_TX_IDX | REQUEST_ID, JOB_DEFINITION_NAME |
| CMF_PROCESS_RUN_DTLS_U1 | Unique | FUSION_TS_TX_IDX | PROCESS_RUN_DETAIL_ID |