EOEP_ACTVAL_VW

(SQL View)
 Index Back

Formula Adj Type Values

Formula Adjustment Type Valid Values

SELECT %Substring(A.FIELDVALUE , 1 , 2) , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'EOEP_ACTION_TYPE' AND A.FIELDVALUE NOT IN ('8','99') AND %EffdtCheck(PSXLATITEM B, A, %CURRENTDATEIN) AND A.EFF_STATUS = 'A'

  • Related Language Record: EOEP_ACTVAL_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOEP_ACTION_TYPE Character(2) VARCHAR2(2) NOT NULL Action Type
    1=Discount/Surcharge
    10=Free Period Promotion
    11=Product Add
    12=Price Base
    13=Rollup Only Rule
    14=Min/Max Margin
    15=Recurring Discount/Surcharge
    2=Price Override
    3=Giveaway / Product Add
    4=Total Order Discount/Surcharge
    5=Min/Max Target Price
    6=Min/Max Target Discount
    7=Min/Max Target Surcharge
    8=Related Busines Objects
    9=Price List Only Condition
    99=Standard Discount
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description