DP_PUBSPEC_HDR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DP_CONFIGVIEW	Character(20)	VARCHAR2(20) NOT NULL	DP_CONFIGVIEW Prompt Table: DP_VIEW1USER_VW
2	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
3	DP_CAPTION	Character(30)	VARCHAR2(30) NOT NULL	DP_CAPTION
4	DP_OFFSET_FROMPD	Character(4)	VARCHAR2(4) NOT NULL	DP_OFFSET_FROMPD
5	DP_OFFSET_TOPD	Character(4)	VARCHAR2(4) NOT NULL	DP_OFFSET_TOPD
6	DP_FROMPERIOD	Number(2,0)	SMALLINT NOT NULL	DP_FROMPERIOD
7	DP_FROMYEAR	Number(4,0)	SMALLINT NOT NULL	DP_FROMYEAR
8	DP_TOPERIOD	Number(2,0)	SMALLINT NOT NULL	DP_TOPERIOD
9	DP_TOYEAR	Number(4,0)	SMALLINT NOT NULL	DP_TOYEAR
10	DP_PUBLISHNAME	Character(20)	VARCHAR2(20) NOT NULL	Publish Name
11	DP_CONFIGLEVEL	Number(2,0)	SMALLINT NOT NULL	DP_CONFIGLEVEL Prompt Table: DP_LVL1_VW
12	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 Default Value: 0
13	DP_UOMGROUP	Character(10)	VARCHAR2(10) NOT NULL	DP_UOMGROUP Prompt Table: DP_OUTPUTUOM_VW
14	DP_PUB_ALTUOM	Character(3)	VARCHAR2(3) NOT NULL	DP_PUB_ALTUOM Prompt Table: UNITS_TBL
15	DP_PUB_DW	Character(1)	VARCHAR2(1) NOT NULL	DP_PUB_DW Y/N Table Edit Default Value: N
16	DP_PUB_EXT	Character(1)	VARCHAR2(1) NOT NULL	DP_PUB_EXT Y/N Table Edit Default Value: N
17	DP_PUB_SCM	Character(1)	VARCHAR2(1) NOT NULL	DP_PUB_SCM Y/N Table Edit Default Value: N
18	DP_FCIP_OPTION	Character(1)	VARCHAR2(1) NOT NULL	DP_FCIP_OPTION I=Item Forecast P=Product Forecast
19	DP_PUB_FCST_FIELD	Character(24)	VARCHAR2(24) NOT NULL	DP_PUB_FCST_FIELD Prompt Table: DP_VWFLDSE13_VW
20	DP_TIMEPERIODCODE	Character(10)	VARCHAR2(10) NOT NULL	DP_TIMEPERIODCODE Prompt Table: DP_CALTIME4_VW
21	DP_PUB_FCITEM	Character(1)	VARCHAR2(1) NOT NULL	DP_PUB_FCITEM Y/N Table Edit Default Value: N
22	DP_PUB_PDDATA	Character(1)	VARCHAR2(1) NOT NULL	DP_PUB_PDDATA Y/N Table Edit Default Value: N
23	DP_PUB_UDF	Character(1)	VARCHAR2(1) NOT NULL	DP_PUB_UDF Y/N Table Edit Default Value: N
24	DP_PUB_STATISTICS	Character(1)	VARCHAR2(1) NOT NULL	DP_PUB_STATISTICS Y/N Table Edit Default Value: N
25	DP_STATISTICALATTR	Character(1)	VARCHAR2(1) NOT NULL	DP_STATISTICALATTR Y/N Table Edit Default Value: N
26	DP_DAILYWEIGHTS	Character(1)	VARCHAR2(1) NOT NULL	DP_DAILYWEIGHTS Y/N Table Edit Default Value: N
27	DP_DAILYFORECAST	Character(1)	VARCHAR2(1) NOT NULL	DP_DAILYFORECAST Y/N Table Edit Default Value: N
28	DP_USERFIELD	Character(1)	VARCHAR2(1) NOT NULL	DP_USERFIELD Y/N Table Edit Default Value: N
29	DP_PUBFCST_PREVER	Character(1)	VARCHAR2(1) NOT NULL	Publish Previous Version Y/N Table Edit Default Value: N
30	DP_PUBFCST_CURRVER	Character(1)	VARCHAR2(1) NOT NULL	Publish Current Version Y/N Table Edit Default Value: N
31	DP_DATEFORMAT	Character(3)	VARCHAR2(3) NOT NULL	DP_DATEFORMAT DMY=DMY MDY=MDY YMD=YMD Default Value: MDY
32	DP_DATEDELIMITER	Character(1)	VARCHAR2(1) NOT NULL	DP_DATEDELIMITER -=- .=. /=/ N= Default Value: /
33	DP_FILE_MODE	Character(1)	VARCHAR2(1) NOT NULL	DP_FILE_MODE A=Append File C=Create New File Default Value: C
34	DP_OUTPUTFILENAME	Character(254)	VARCHAR2(254) NOT NULL	DP_OUTPUTFILENAME
35	DP_OUTPUT_FORMAT	Character(1)	VARCHAR2(1) NOT NULL	DP_OUTPUT_FORMAT 0=Comma Delimited (quotes) 1=Semicolon Delimited (quotes) 2=Tab Delimited (quotes) Default Value: 0
36	DP_ROWONELABELS	Character(1)	VARCHAR2(1) NOT NULL	DP_ROWONELABELS Y/N Table Edit Default Value: N
37	DP_HEADINGS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	DP_HEADINGS_TYPE C=Field Caption F=Field Name Default Value: C