DP_IMPORTSPECPrompt Table: DP_CAL2_VW
Prompt Table: DP_CALTIMECODES
Prompt Table: DP_WTPROFILES
Prompt Table: FINT_FLDMAP_HD
I=Item Forecast
P=Product Forecast
Y/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: N
FINT_IMPSPEC_HD(SQL Table) |
Index Back |
|---|---|
Interface Import HeaderForecast Interface Import Specification Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DP_IMPORTSPEC |
Character(20) | VARCHAR2(20) NOT NULL | Specification used for running imports |
| 2 | DP_CAPTION | Character(30) | VARCHAR2(30) NOT NULL | DP_CAPTION |
| 3 | DP_PUBLISHNAME | Character(20) | VARCHAR2(20) NOT NULL | Publish Name |
| 4 | DP_CALENDARID | Character(20) | VARCHAR2(20) NOT NULL |
DP_CALENDARID
Prompt Table: DP_CAL2_VW |
| 5 | DP_TIMEPERIODCODE | Character(10) | VARCHAR2(10) NOT NULL |
DP_TIMEPERIODCODE
Prompt Table: DP_CALTIMECODES |
| 6 | DP_WEIGHTPROFILE | Character(20) | VARCHAR2(20) NOT NULL |
DP_WEIGHTPROFILE
Prompt Table: DP_WTPROFILES |
| 7 | MAPID | Character(3) | VARCHAR2(3) NOT NULL |
Map ID
Prompt Table: FINT_FLDMAP_HD |
| 8 | DP_FCIP_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
DP_FCIP_OPTION
I=Item Forecast P=Product Forecast |
| 9 | DP_DAILYWEIGHTS | Character(1) | VARCHAR2(1) NOT NULL |
DP_DAILYWEIGHTS
Y/N Table Edit Default Value: Y |
| 10 | DP_DAILYFORECAST | Character(1) | VARCHAR2(1) NOT NULL |
DP_DAILYFORECAST
Y/N Table Edit Default Value: N |
| 11 | DP_FILEPATH | Character(254) | VARCHAR2(254) NOT NULL | DP_FILEPATH |