DP_IPPUBSPC_HDR(SQL Table) |
Index Back |
---|---|
IP Publish Specs HeaderHamzeh Bouchi 05/28/2003 - Added new flags to handle individual SCM Publish tables. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | DP_POLICYSET | Character(10) | VARCHAR2(10) NOT NULL |
DP_POLICYSET
Prompt Table: DP_POLS2USER_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_PUBLISHNAME | Character(20) | VARCHAR2(20) NOT NULL | Publish Name |
5 | DP_IPOFFSET_FROMPD | Character(4) | VARCHAR2(4) NOT NULL | DP_OFFSET_FROMPD |
6 | DP_IPOFFSET_TOPD | Character(4) | VARCHAR2(4) NOT NULL | DP_OFFSET_FROMPD |
7 | DP_FROMPERIOD | Number(2,0) | SMALLINT NOT NULL | DP_FROMPERIOD |
8 | DP_FROMYEAR | Number(4,0) | SMALLINT NOT NULL | DP_FROMYEAR |
9 | DP_TOPERIOD | Number(2,0) | SMALLINT NOT NULL | DP_TOPERIOD |
10 | DP_TOYEAR | Number(4,0) | SMALLINT NOT NULL | DP_TOYEAR |
11 | DP_IPCONVUNIT | Character(4) | VARCHAR2(4) NOT NULL |
DP_IPCONVUNIT
0=PolicyUom (=1) 1=Weight 10=Inventory Standard 2=Volume 3=Alternate (Using Conversion) 4=Standard Price 5=Standard Cost 6=Period Cost 8=Standard Margin Default Value: 10 |
12 | DP_PUB_ALTUOM | Character(3) | VARCHAR2(3) NOT NULL |
DP_PUB_ALTUOM
Prompt Table: DP_UNITSTBL_VW |
13 | DP_PUB_DW | Character(1) | VARCHAR2(1) NOT NULL |
DP_PUB_DW
Y/N Table Edit Default Value: N |
14 | DP_PUB_SCM | Character(1) | VARCHAR2(1) NOT NULL |
DP_PUB_SCM
Default Value: N |
15 | DP_PUB_EXT | Character(1) | VARCHAR2(1) NOT NULL |
DP_PUB_EXT
Y/N Table Edit Default Value: N |
16 | DP_PUBIP_PREVER | Character(1) | VARCHAR2(1) NOT NULL | DP_PUBIP_PREVER |
17 | DP_PUBIP_CURRENT | Character(1) | VARCHAR2(1) NOT NULL | DP_PUBIP_CURRENT |
18 | DP_TIMEPERIODCODE | Character(10) | VARCHAR2(10) NOT NULL |
DP_TIMEPERIODCODE
Prompt Table: DP_CALTIME4_VW |
19 | DP_USERFIELD | Character(1) | VARCHAR2(1) NOT NULL | DP_USERFIELD |
20 | DP_DECIMALPLACES | Number(2,0) | SMALLINT NOT NULL |
DP_DECIMALPLACES
Default Value: 0 |
21 | DP_PUB_POLITEM | Character(1) | VARCHAR2(1) NOT NULL |
DP_PUB_POLITEM
Default Value: N |
22 | DP_PUB_UDF | Character(1) | VARCHAR2(1) NOT NULL |
DP_PUB_UDF
Default Value: N |
23 | DP_PUB_PDDATA | Character(1) | VARCHAR2(1) NOT NULL |
DP_PUB_PDDATA
Default Value: N |
24 | DP_PUB_BUIINV | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit Items
Default Value: N |
25 | DP_PUB_PLATTRIB | Character(1) | VARCHAR2(1) NOT NULL |
DP_PUB_PLATTRIB
Y/N Table Edit Default Value: N |
26 | DP_PUB_ORD_MOD | Character(1) | VARCHAR2(1) NOT NULL |
Publish Order Modifier flag
Default Value: N |
27 | DP_PUB_UTIL | Character(1) | VARCHAR2(1) NOT NULL |
DP_PUB_UTIL
Default Value: N |
28 | DP_PUB_STOCK_PD | Character(1) | VARCHAR2(1) NOT NULL |
Publish Stock Period In flag
Default Value: N |
29 | DP_DATEFORMAT | Character(3) | VARCHAR2(3) NOT NULL |
DP_DATEFORMAT
DMY=DMY MDY=MDY YMD=YMD Default Value: MDY |
30 | DP_UTILIZ_CD | Character(1) | VARCHAR2(1) NOT NULL | DP_UTILIZ_CD |
31 | DP_UTILIZ_GROUP | Character(1) | VARCHAR2(1) NOT NULL | DP_UTILIZ_GROUP |
32 | DP_ROWONELABELS | Character(1) | VARCHAR2(1) NOT NULL | DP_ROWONELABELS |
33 | DP_DATEDELIMITER | Character(1) | VARCHAR2(1) NOT NULL |
DP_DATEDELIMITER
-=- .=. /=/ N= Default Value: / |
34 | DP_FILE_MODE | Character(1) | VARCHAR2(1) NOT NULL |
DP_FILE_MODE
A=Append File C=Create New File Default Value: C |
35 | DP_HEADINGS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
DP_HEADINGS_TYPE
C=Field Caption F=Field Name Default Value: C |
36 | 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 |
37 | DP_OUTPUTFILENAME | Character(254) | VARCHAR2(254) NOT NULL | DP_OUTPUTFILENAME |