MSC_ST_ERP_INTG_PARAMS_INT
This table stores the input values provided use in ERP Integration Fflow to load data into planning.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Comments |
|---|---|---|---|
| SR_INSTANCE_CODE | VARCHAR2 | 30 | Unique code assigned to each application instance. |
| COLLECTION_MODE | VARCHAR2 | 1 | This identifies the mode of data update. It could be Incremental or Complete. Valid values are 1, 2. 1 means Target and 2 means Netchange. |
| ORG_GROUP | VARCHAR2 | 30 | Name of the organization group. This enables Organization group specific collection for transactional business objects. |
| REFRESH_NUMBER | NUMBER | Refresh identifier populated by the collection program. | |
| INSTANCE_MODE_SOURCE | VARCHAR2 | 1 | This column indicates whether user provided the instance/mode in params files or not. 1 means Params file is part of zip 2 means params file is not part of zip and code derived the instance and mode |
| INPUT_CSV_FILES | CLOB | This column stores the list of csv files user provided in the zip file. | |
| ALLOWED_INPUT_CSV_FILES | CLOB | This column stores the list of csv files selected based on the instance code from the input csv files list. | |
| DERIVED_SR_INSTANCE_CODE | VARCHAR2 | 30 | This column stores the final instance code selected and passed to collection jobset. |
| DERIVED_COLLECTION_MODE | VARCHAR2 | 1 | This column stores the final collection mode selected and passed to collection jobset. |
| DERIVED_BO_LIST | VARCHAR2 | 1000 | This column stores the BO LIST passed to collection jobset. |
| ESS_FLATFILE_LOAD_REQ_ID | NUMBER | This is the ess request of csv upload job submitted by erp flow. | |
| ESS_COLL_JOB_SET_REQ_ID | NUMBER | This column stores the Ess number of collection jobset. | |
| STATUS | VARCHAR2 | 1000 | This column indicates the status of the flow. Success or Error (reason if error). |
| LOAD_REQUEST_ID | NUMBER | This columns stores the Request ID of Job that loaded the data. | |
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. |
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
| RETAIN_FCST_BY_DESIGNATOR | NUMBER | This column indicates whether target collection of demand forecasts will retain other designator data or not. | |
| MULTIPLE_CSV_UPLOADS_FLAG | VARCHAR2 | 10 | This column indicates whether current collection run is to Load data into Staging tables or Load and Submit Collection Job Set. Valid values are UPLOAD, SUBMIT. |