DP_IPPUBSPC_HDR

(SQL Table)
Index Back

IP Publish Specs Header

Hamzeh Bouchi 05/28/2003 - Added new flags to handle individual SCM Publish tables.

  • Parent Record Of DP_IPPUBSPC_LNS
  • # 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