CSHTNDRFLWVWLNG

(SQL View)
 Index Back

Bus Dt Cashier Tender View


SELECT DISTINCT a.business_unit , a.cashier_office , b.tender_key ,c.language_cd , c.descr FROM ps_csh_off_receipt a , ps_csh_off_rcpt_t b , ps_TENDER_KEY_LNG c WHERE a.business_unit=b.business_unit AND a.cashier_office=b.cashier_office AND a.receipt_nbr=b.receipt_nbr AND b.business_unit = c.business_unit AND b.tender_key=c.tender_key AND c.effdt = ( SELECT MAX(cc.effdt) FROM ps_TENDER_KEY_LNG cc ,PS_TENDER_KEY_TBL Y WHERE c.business_unit = cc.business_unit AND c.tender_key = cc.tender_key AND cc.effdt <= %CurrentDateIn AND Y.eff_status = 'A' AND cc.BUSINESS_UNIT=Y.BUSINESS_UNIT AND cc.TENDER_KEY=Y.TENDER_KEY AND cc.EFFDT=Y.EFFDT)

  • Related Language Record for CSH_TNDR_FLW_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 TENDER_KEY Character(10) VARCHAR2(10) NOT NULL Tender Key
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description