EOEP_ACTVAL_LVW

(SQL View)
Index Back

Formula Adj Type Value

Formula Adjustment Type Valid Values

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

  • Related Language Record for EOEP_ACTVAL_VW
  • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description