EX_SES_BASE_LVW

(SQL View)
 Index Back

Expense Base Lang View

Expense Base Language View for PTSF

SELECT A.SHEET_ID , A.LINE_NBR , ( SELECT B.LANGUAGE_CD FROM %Table(EX_MERCH2_LVW) B WHERE D.SETID = B.SETID AND A.MERCHANT_CD = B.MERCHANT_CD ) , A.MERCHANT , A.MERCHANT_CD , D.SETID , ( SELECT B.DESCR FROM %Table(EX_MERCH2_LVW) B WHERE D.SETID = B.SETID AND A.MERCHANT_CD = B.MERCHANT_CD ) , CASE WHEN A.MERCHANT_CD <> ' ' THEN ( SELECT B.DESCR FROM %Table(EX_MERCH2_LVW) B WHERE D.SETID = B.SETID AND A.MERCHANT_CD = B.MERCHANT_CD ) ELSE A.MERCHANT END FROM %Table(EX_SHEET_LINE) A , %Table(EX_SHEET_HDR) C , %Table(SET_CNTRL_GROUP) D WHERE A.SHEET_ID = C.SHEET_ID AND C.BUSINESS_UNIT_GL = D.SETCNTRLVALUE AND D.REC_GROUP_ID = 'EX_02'

  • Related Language Record for EX_SES_BASE_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 MERCHANT Character(40) VARCHAR2(40) NOT NULL Merchant
    5 MERCHANT_CD Character(10) VARCHAR2(10) NOT NULL Preferred Merchant
    6 SETID2 Character(5) VARCHAR2(5) NOT NULL 2nd SetId
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 DESCR40 Character(40) VARCHAR2(40) NOT NULL Description