DP_SPECS_IDDP_CONFIGVIEWPrompt Table: DP_VIEW4USER_VW
Default Value: N
Default Value: 1
B=BU Items Inventory
M=Master Item Table
Default Value: B
DP_REFRESH_HDR(SQL Table) |
Index Back |
|---|---|
Forecast Item Refresh HeaderForecast Item Refresh Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DP_SPECS_ID |
Character(20) | VARCHAR2(20) NOT NULL | DP_SPECS_ID |
| 2 | DP_CONFIGVIEW |
Character(20) | VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW
Prompt Table: DP_VIEW4USER_VW |
| 3 | DP_ROLLPERIODS | Signed Number(4,0) | DECIMAL(3) NOT NULL | DP_ROLLPERIODS |
| 4 | DP_REFRESH_PARENT | Character(1) | VARCHAR2(1) NOT NULL |
DP_REFRESH_PARENT
Default Value: N |
| 5 | DP_LEVEL_SELECT | Number(2,0) | SMALLINT NOT NULL |
DP_LEVEL_SELECT
Default Value: 1 |
| 6 | DP_CUSTOM_FLD_FROM | Character(1) | VARCHAR2(1) NOT NULL |
DP_CUSTOM_FLD_FROM
B=BU Items Inventory M=Master Item Table Default Value: B |
| 7 | DP_USERDATACODE | Character(20) | VARCHAR2(20) NOT NULL | DP_USERDATACODE |
| 8 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |