DP_EIFLDSELU_VW

(SQL View)
 Index Back

Fields to select for UPD Impor

Fields to select for UPD Impor: SELECT DP_CONFIGVIEW ,DP_FIELDID ,DP_CAPTION ,DP_DATATYPE ,DP_KEYFIELD , 'LAST' , 'N' FROM PS_DP_VIEWFLD_SELS WHERE DP_AVAILON_EIUPD = 'Y' AND ((DP_FIELDID NOT LIKE 'DP_UD%' AND DP_FIELDID NOT IN ('DP_ITEMCODE', 'DP_LOCATION')) OR DP_KEYFIELD = 'Y')

SELECT DP_CONFIGVIEW ,DP_FIELDID ,DP_CAPTION ,DP_DATATYPE ,DP_KEYFIELD , 'LAST' , 'N' FROM PS_DP_VIEWFLD_SELS WHERE DP_AVAILON_EIUPD = 'Y' AND ((DP_FIELDID NOT LIKE 'DP_UD%' AND DP_FIELDID NOT IN ('DP_ITEMCODE', 'DP_LOCATION')) OR DP_KEYFIELD = 'Y')

  • Related Language Record: DP_EIFLDSLU_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
    2 DP_FIELDID Character(24) VARCHAR2(24) NOT NULL DP_FIELDID
    3 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION
    4 DP_DATATYPE Character(1) VARCHAR2(1) NOT NULL DP_DATATYPE
    0=Character
    1=Long Character
    2=Number
    3=Signed Number
    4=Date
    5 DP_KEYFIELD Character(1) VARCHAR2(1) NOT NULL DP_KEYFIELD

    Y/N Table Edit

    Default Value: N

    6 DP_UPDATEMETHOD Character(4) VARCHAR2(4) NOT NULL DP_UPDATEMETHOD
    ACC=Accumulate
    AVG=Average Exclude Current
    AVGA=Average Include Current
    LAST=Replace with Last
    WAVA=Weighted Average Include
    WAVG=Weighted Average Exclude
    7 DP_UPDATED Character(1) VARCHAR2(1) NOT NULL DP_UPDATED

    Y/N Table Edit

    Default Value: N