CSHIDTNDRVWLNG

(SQL View)
 Index Back

Interim Deposit Tender View


SELECT DISTINCT a.business_unit ,a.cashier_office ,a.business_date ,a.cashier ,a.tender_key ,b.language_cd ,b.descr FROM ps_csh_bd_csh_open a , ps_TENDER_KEY_LNG b ,PS_TENDER_KEY_TBL Y , ps_csh_bd_csh_tbl d , ps_csh_bd_reg_open e WHERE a.business_unit = d.business_unit AND a.cashier_office = d.cashier_office AND a.business_date = d.business_date AND a.cashier = d.cashier AND d.business_unit = e.business_unit AND d.cashier_office = e.cashier_office AND d.business_date = e.business_date AND d.sf_register = e.sf_register AND a.tender_key = e.tender_key AND a.business_unit = b.business_unit AND a.tender_key = b.tender_key AND b.effdt = ( SELECT MAX (c.effdt) FROM PS_TENDER_KEY_TBL c WHERE b.business_unit = c.business_unit AND b.tender_key = c.tender_key AND c.effdt <= %CurrentDateIn) AND Y.eff_status = 'A' AND b.BUSINESS_UNIT=Y.BUSINESS_UNIT AND b.TENDER_KEY=y.TENDER_KEY AND b.EFFDT=Y.EFFDT

  • Related Language Record for CSH_ID_TNDR_VW

  • Parent record: CSH_BD_CSH_TBL

    • # 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 BUSINESS_DATE Date(10) DATE NOT NULL Business Date
    4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    5 TENDER_KEY Character(10) VARCHAR2(10) NOT NULL Tender Key
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description