EX_MBL_LN_D2_VW

(SQL View)
 Index Back

SELECT HDR.SHEET_ID , LINE.LINE_NBR , C.DESCR FROM PS_EX_SHEET_HDR HDR INNER JOIN PS_EX_SHEET_LINE LINE ON LINE.SHEET_ID = HDR.SHEET_ID LEFT OUTER JOIN PS_EX_MERCHANT_VW C ON C.EXPENSE_TYPE = LINE.EXPENSE_TYPE AND C.MERCHANT_CD = LINE.MERCHANT_CD AND C.SETID = HDR.SETID

  • Related Language Record: EX_MBL_LN_D2_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
    2 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    3 MBL_MERCHANT_DESCR Character(30) VARCHAR2(30) NOT NULL Merchant Description