CMF_PROCESS_REQUESTS

Stores the Online run to the CMF processes.

Details

  • Schema: FUSION

  • Object owner: CMF

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CMF_PROCESS_REQUESTS_PK

RUN_ID, DOCUMENT_HEADER_ID

Columns

Name Datatype Length Precision Not-null Comments Status
RUN_ID NUMBER 18 Yes Stores the Unique key which identifies the row. Active
DOCUMENT_HEADER_ID NUMBER 18 Yes Stores the foreign key which identifies the FD Header row. Active
PROCESS_NAME VARCHAR2 100 Pocess which is running under the current record. Active
TIMEOUT NUMBER 9 Timeout definition for the currently execution. Active
STATUS VARCHAR2 30 Keeps the data which represents the Status of the request. Active
IMPORTING_STATUS VARCHAR2 30 Importing Status in which are the eligible interfaced records. Active
ACCESS_KEY_NUMBER_FROM VARCHAR2 64 Lower limit to the access key number parameter. Active
ACCESS_KEY_NUMBER_TO VARCHAR2 64 Upper limit to the access key number parameter. Active
FISCAL_DOCUMENT_TYPE VARCHAR2 30 Stores the type of the FISCAL Document. Active
SOURCE_DOCUMENT_TYPE VARCHAR2 30 Stores the type of the Source Document. Active
BLOCKING_RUN_ID NUMBER 18 Run identifier of the blocking execution. Active
BLOCKING_REQUEST_ID NUMBER 18 Request identifier of the blocking execution. Active
TIMEOUT_RUN_ID NUMBER 18 Stores the Run Id of the TIMEOUT execution. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active

Indexes

Index Uniqueness Tablespace Columns Status
CMF_PROCESS_REQUESTS_U1 Unique Default RUN_ID, DOCUMENT_HEADER_ID Active