EOEP_ARBDEC_LVW

(SQL View)
 Index Back

Arb decision by trans

Arb decision by trans

SELECT D.EOEP_APP_CD , %Substring(FIELDVALUE , 1 , 2) , X.EFFDT , X.LANGUAGE_CD , X.XLATLONGNAME , X.XLATSHORTNAME FROM PS_EOEP_APP_CD_DTL D , PSXLATITEMLANG X WHERE D.EOEP_APP_CD_FIELD = 'ACTION_TYPE' AND X.FIELDNAME = 'EOEP_ARB_DECISION' AND ( (X.FIELDVALUE IN ('2','3','5','6') AND D.EOEP_TRANS_VALUE IN ('1','4')) OR (X.FIELDVALUE IN ('7','8') AND D.EOEP_TRANS_VALUE = '2') OR (X.FIELDVALUE IN ('11','12','13','14') AND D.EOEP_TRANS_VALUE = '12') OR (X.FIELDVALUE IN ('9','10') AND D.EOEP_TRANS_VALUE IN ('1','2','4')) OR (X.FIELDVALUE IN ('1' ,'4')))

  • Related Language Record for EOEP_ARBDEC_VW

    • # 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_DECISION Character(2) VARCHAR2(2) NOT NULL Pricing arbitration decision
    1=Rule Name in Ascending Order
    10=Lowest Price First
    11=Use Highest Base
    12=Use Lowest Base
    13=Use Cost as Base
    14=Use List Price as Base
    15=Use Alternate Cost as Base
    2=Highest Discount First
    3=Highest Surcharge First
    4=Rule Name in Descending Order
    5=Lowest Discount First
    6=Lowest Surcharge First
    7=Highest Price Override First
    8=Lowest Price Override First
    9=Highest Price First
    3 EFFDT Date(10) DATE Effective Date
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    6 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name