DP_PUBSPEC_AET(SQL Table) |
Index Back |
|---|---|
Publishing AE Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 3 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 4 | AE_STEP | Character(8) | VARCHAR2(8) NOT NULL | Name |
| 5 | DP_CONFIGVIEW | Character(20) | VARCHAR2(20) NOT NULL | DP_CONFIGVIEW |
| 6 | DP_EXPORTSPEC | Character(20) | VARCHAR2(20) NOT NULL | DP_EXPORTSPEC Date Initials Reference # Description 12/21/09 MP NK-22 Translation Add new label to used in translation |
| 7 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 8 | DP_PUBLISHNAME | Character(20) | VARCHAR2(20) NOT NULL | Publish Name |
| 9 | DP_PUBLISH_DATE | Date(10) | DATE | DP_PUBLISH_DATE |
| 10 | DP_DESCRIPTION | Character(120) | VARCHAR2(120) NOT NULL | Description |
| 11 | DP_OFFSET_FROMPD | Character(4) | VARCHAR2(4) NOT NULL | DP_OFFSET_FROMPD |
| 12 | DP_OFFSET_TOPD | Character(4) | VARCHAR2(4) NOT NULL | DP_OFFSET_TOPD |
| 13 | DP_FROMPERIOD | Number(2,0) | SMALLINT NOT NULL | DP_FROMPERIOD |
| 14 | DP_FROMYEAR | Number(4,0) | SMALLINT NOT NULL | DP_FROMYEAR |
| 15 | DP_TOPERIOD | Number(2,0) | SMALLINT NOT NULL | DP_TOPERIOD |
| 16 | DP_TOYEAR | Number(4,0) | SMALLINT NOT NULL | DP_TOYEAR |
| 17 | DP_CONFIGLEVEL | Number(2,0) | SMALLINT NOT NULL | DP_CONFIGLEVEL |
| 18 | DP_FCCONVUNIT | Character(2) | VARCHAR2(2) NOT NULL |
DP_FCCONVUNIT
0=Base Uom (=1) 1=Weight 10=Standard Margin 11=Period Margin 2=Volume 3=Alternate (Using Conversion) 4=UOM Group 5=Standard Price 6=Standard Cost 7=Base Inventory Standard 8=Period Price 9=Period Cost |
| 19 | DP_UOMGROUP | Character(10) | VARCHAR2(10) NOT NULL | DP_UOMGROUP |
| 20 | DP_PUB_ALTUOM | Character(3) | VARCHAR2(3) NOT NULL | DP_PUB_ALTUOM |
| 21 | DP_PUB_DW | Character(1) | VARCHAR2(1) NOT NULL | DP_PUB_DW |
| 22 | DP_PUB_EXT | Character(1) | VARCHAR2(1) NOT NULL | DP_PUB_EXT |
| 23 | DP_PUB_SCM | Character(1) | VARCHAR2(1) NOT NULL | DP_PUB_SCM |
| 24 | DP_FCIP_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
DP_FCIP_OPTION
I=Item Forecast P=Product Forecast |
| 25 | DP_TIMEPERIODCODE | Character(10) | VARCHAR2(10) NOT NULL | DP_TIMEPERIODCODE |
| 26 | DP_PUB_FCST_FIELD | Character(24) | VARCHAR2(24) NOT NULL | DP_PUB_FCST_FIELD |
| 27 | DP_DATEFORMAT | Character(3) | VARCHAR2(3) NOT NULL |
DP_DATEFORMAT
DMY=DMY MDY=MDY YMD=YMD |
| 28 | DP_DATEDELIMITER | Character(1) | VARCHAR2(1) NOT NULL |
DP_DATEDELIMITER
-=- .=. /=/ N= |
| 29 | DP_STATISTICALATTR | Character(1) | VARCHAR2(1) NOT NULL | DP_STATISTICALATTR |
| 30 | DP_DAILYWEIGHTS | Character(1) | VARCHAR2(1) NOT NULL | DP_DAILYWEIGHTS |
| 31 | DP_DAILYFORECAST | Character(1) | VARCHAR2(1) NOT NULL | DP_DAILYFORECAST |
| 32 | DP_USERFIELD | Character(1) | VARCHAR2(1) NOT NULL | DP_USERFIELD |
| 33 | DP_OUTPUTFILENAME | Character(254) | VARCHAR2(254) NOT NULL | DP_OUTPUTFILENAME |
| 34 | DP_OUTPUT_FORMAT | Character(1) | VARCHAR2(1) NOT NULL |
DP_OUTPUT_FORMAT
0=Comma Delimited (quotes) 1=Semicolon Delimited (quotes) 2=Tab Delimited (quotes) |
| 35 | DP_HEADINGS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
DP_HEADINGS_TYPE
C=Field Caption F=Field Name |
| 36 | DP_ROWONELABELS | Character(1) | VARCHAR2(1) NOT NULL | DP_ROWONELABELS |
| 37 | DP_FILE_MODE | Character(1) | VARCHAR2(1) NOT NULL |
DP_FILE_MODE
A=Append File C=Create New File |
| 38 | DP_PUBFCST_PREVER | Character(1) | VARCHAR2(1) NOT NULL | Publish Previous Version |
| 39 | DP_PUBFCST_CURRVER | Character(1) | VARCHAR2(1) NOT NULL | Publish Current Version |
| 40 | DP_STARTDATETIME | DateTime(26) | TIMESTAMP | DP_STARTDATETIME |
| 41 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |