CSHCSHTNDRVWLNG

(SQL View)
 Index Back

Bus Dt Cashier Tender View


SELECT a.business_unit , a.cashier_office , c.cashier , b.tender_key ,b.language_cd , b.descr FROM ps_csh_off_cashier a , ps_TENDER_KEY_LNG b , ps_tender_cshr_tbl c WHERE a.business_unit = b.business_unit AND a.cashier = c.cashier AND b.business_unit = c.business_unit AND b.tender_key = c.tender_key AND b.effdt = c.effdt AND b.effdt = ( SELECT MAX(bb.effdt) FROM ps_TENDER_KEY_LNG bb ,PS_TENDER_KEY_TBL Y WHERE b.business_unit = bb.business_unit AND b.tender_key = bb.tender_key AND bb.effdt <= %CurrentDateIn AND Y.eff_status = 'A' AND bb.BUSINESS_UNIT=Y.BUSINESS_UNIT AND bb.TENDER_KEY=Y.TENDER_KEY AND bb.EFFDT=Y.EFFDT)

  • Related Language Record for CSH_CSH_TNDR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 CASHIER_OFFICE Character(8) VARCHAR2(8) NOT NULL Cashier's Office
    3 CASHIER Character(30) VARCHAR2(30) NOT NULL Cashier
    4 TENDER_KEY Character(10) VARCHAR2(10) NOT NULL Tender Key
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description