PROCESS_INSTANCEPrompt Table: DP_VIEW4USER_VW
B=BU Items Inventory
M=Master Item Table
DP_REFRESH_AET(SQL Table) |
Index Back |
|---|---|
Forecat Item Refresh AETForecast Item Refresh State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | DP_SPECS_ID | Character(20) | VARCHAR2(20) NOT NULL | DP_SPECS_ID |
| 5 | DP_CONFIGVIEW | Character(20) | VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW
Prompt Table: DP_VIEW4USER_VW |
| 6 | DP_ROLLPERIODS | Signed Number(4,0) | DECIMAL(3) NOT NULL | DP_ROLLPERIODS |
| 7 | DP_USERDATACODE | Character(20) | VARCHAR2(20) NOT NULL | DP_USERDATACODE |
| 8 | DP_REFRESH_PARENT | Character(1) | VARCHAR2(1) NOT NULL | DP_REFRESH_PARENT |
| 9 | DP_LEVEL_SELECT | Number(2,0) | SMALLINT NOT NULL | DP_LEVEL_SELECT |
| 10 | DP_CUSTOM_FLD_FROM | Character(1) | VARCHAR2(1) NOT NULL |
DP_CUSTOM_FLD_FROM
B=BU Items Inventory M=Master Item Table |
| 11 | DP_DYNAMIC_SQL | Character(254) | VARCHAR2(254) NOT NULL | DP_DYNAMIC_SQL |
| 12 | DP_KEYFLDNAMES | Character(254) | VARCHAR2(254) NOT NULL | DP_KEYFLDNAMES |