PROCESS_INSTANCE1=Supply Forecast
2=Demand Forecast
3=Consolidated Scenario
RS_COPY_FR_AET(SQL Table) |
Index Back |
|---|---|
State record for RS_COPY_FRSTState record for RS_COPY_FRST Application Engine. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | PC_PROJ_REC_NAME | Character(20) | VARCHAR2(20) NOT NULL | Project Record (Table) |
| 4 | PC_TEMP_REC_NAME | Character(20) | VARCHAR2(20) NOT NULL | Temporary Record (Table) |
| 5 | FORECAST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
SCP-Forecast Types-Supply, Demand and Combined Scenario
1=Supply Forecast 2=Demand Forecast 3=Consolidated Scenario |
| 6 | LAST_FR_ID_SUP | Number(10,0) | DECIMAL(10) NOT NULL | Last Supply Forecast ID Used |
| 7 | LAST_FR_ID_DMD | Number(10,0) | DECIMAL(10) NOT NULL | Last Demand Forecast ID Used |
| 8 | FORECAST_ID_FRM | Character(15) | VARCHAR2(15) NOT NULL | SCP - Forecast Id |
| 9 | FORECAST_ID_TARGET | Character(15) | VARCHAR2(15) NOT NULL | New Forecast ID |
| 10 | SELECT_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Select Clause |
| 11 | SELECT_CLAUSE1 | Character(254) | VARCHAR2(254) NOT NULL | First Select Clause |
| 12 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 13 | PC_CPY_UNIQUEID | Character(15) | VARCHAR2(15) NOT NULL | Copy Unique ID |
| 14 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |