EOEP_ACTVAL_LVW(SQL View) |
Index Back |
---|---|
Formula Adj Type ValueFormula 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) |
# | 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 |