EOEP_ARBACT_VW

(SQL View)
 Index Back

Arb Plan Action Type by Trans

Arb Plan Action Type by Trans

SELECT D.EOEP_APP_CD , %Substring(FIELDVALUE , 1 , 2) , X.EFFDT , X.EFF_STATUS , X.XLATLONGNAME , X.XLATSHORTNAME FROM PS_EOEP_APP_CD_DTL D , PSXLATITEM X WHERE D.EOEP_APP_CD_FIELD = 'ACTION_TYPE' AND X.FIELDNAME = 'EOEP_ARB_ACTN_TYPE' AND ( (D.EOEP_TRANS_VALUE = '1' AND X.FIELDVALUE IN ('1','2')) OR (D.EOEP_TRANS_VALUE = '2' AND X.FIELDVALUE = '3') OR (D.EOEP_TRANS_VALUE = '3' AND X.FIELDVALUE = '4') OR (D.EOEP_TRANS_VALUE = '4' AND X.FIELDVALUE IN ('5','6')) OR (D.EOEP_TRANS_VALUE = '10' AND X.FIELDVALUE = '8') OR (D.EOEP_TRANS_VALUE = '11' AND X.FIELDVALUE = '7') )

  • Related Language Record: EOEP_ARBACT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code
    2 EOEP_ARB_ACTN_TYPE Character(2) VARCHAR2(2) NOT NULL Price Action Type
    1=Discount
    2=Surcharge
    3=Price Override
    4=Giveaway / Product Add
    5=Total Order Discount
    6=Total Order Surcharge
    7=Product Add
    8=Free Period Promotion
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    6 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name