RMA_MERCHCSHLVW

(SQL View)
 Index Back

RMA Merch Type View

RMA Merch Type View

SELECT P.BUSINESS_UNIT , P.RMA_ID , P.RMA_LINE_NBR , P.SOLD_TO_CUST_ID , P.PRODUCT_ID , P.PPRC_PROMO_CD , P.MERCH_TYPE , M.LANGUAGE_CD , M.DESCR FROM PS_RMA_PRMCDCSH_VW P , PS_TD_MRCH_TYPL_VW M WHERE P.SETID_PROMO = M.SETID AND P.MERCH_TYPE = M.MERCH_TYPE UNION SELECT P.BUSINESS_UNIT , P.RMA_ID , P.RMA_LINE_NBR , P.SOLD_TO_CUST_ID , P.PRODUCT_ID , P.PPRC_PROMO_CD , P.MERCH_TYPE , M.LANGUAGE_CD , M.XLATLONGNAME FROM PS_RMA_PRMCDCSH_VW P , PSXLATITEMLANG M WHERE M.FIELDNAME = 'EOEP_ADJUST_TYPE' AND M.FIELDVALUE = P.MERCH_TYPE

  • Related Language Record for RMA_MERCHCSH_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
    3 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number
    4 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

    Prompt Table: %EDITTABLE5

    5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    6 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code

    Prompt Table: PPRC_PROMO_TBL
    Set Control Field: BUSINESS_UNIT

    7 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type
    8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description