CSHOFFREPLVWLNG

(SQL View)
 Index Back

Replenish Cash Tender View


SELECT DISTINCT A.BUSINESS_UNIT ,A.CASHIER_OFFICE ,A.BUSINESS_DATE ,A.CASHIER ,A.TENDER_KEY ,B.EFFDT ,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 C , PS_CSH_BD_REG_OPEN D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND Y.TENDER_CATEGORY = 'CS' AND A.TENDER_KEY = B.TENDER_KEY AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.CASHIER_OFFICE = C.CASHIER_OFFICE AND A.BUSINESS_DATE = C.BUSINESS_DATE AND A.CASHIER = C.CASHIER AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.CASHIER_OFFICE = D.CASHIER_OFFICE AND A.BUSINESS_DATE = D.BUSINESS_DATE AND C.SF_REGISTER = D.SF_REGISTER AND A.TENDER_KEY = D.TENDER_KEY AND b.effdt = ( SELECT MAX (e.effdt) FROM PS_TENDER_KEY_TBL e WHERE b.business_unit = e.business_unit AND b.tender_key = e.tender_key AND e.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_OFF_REPL_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 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description