CSH_DP_TNDR_VW

(SQL View)
 Index Back

Department Receipt Tender View


SELECT DISTINCT A.BUSINESS_UNIT ,A.CASHIER_OFFICE ,A.BUSINESS_DATE ,A.CASHIER ,A.TENDER_KEY ,B.DESCR ,B.TENDER_CATEGORY FROM PS_CSH_BD_CSH_OPEN A , PS_TENDER_KEY_TBL B , PS_TENDER_CSHR_TBL D , PS_CSH_BD_REG_OPEN E , PS_CSH_BD_CSH_TBL F WHERE 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 B.EFF_STATUS = 'A' AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.TENDER_KEY = D.TENDER_KEY AND A.CASHIER = D.CASHIER AND D.EFFDT = B.EFFDT AND A.BUSINESS_UNIT = F.BUSINESS_UNIT AND A.CASHIER_OFFICE = F.CASHIER_OFFICE AND A.BUSINESS_DATE = F.BUSINESS_DATE AND A.CASHIER = F.CASHIER AND A.BUSINESS_UNIT = E.BUSINESS_UNIT AND A.CASHIER_OFFICE = E.CASHIER_OFFICE AND A.BUSINESS_DATE = E.BUSINESS_DATE AND F.SF_REGISTER = E.SF_REGISTER AND A.TENDER_KEY = E.TENDER_KEY AND B.TENDER_CATEGORY IN ('CC','CK','CS','DB','WIR','TP') AND D.IN_ALLOWED ='Y'

  • Related Language Record: CSHDPTNDRVWLNG

  • 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 TENDER_CATEGORY Character(3) VARCHAR2(3) NOT NULL Tender Category
    CC=Credit Card
    CCI=Credit Card In
    CCO=Credit Card Out
    CK=Check
    CKI=Check In
    CKO=Check Out
    CS=Cash
    CSI=Cash In
    CSO=Cash Out
    DB=Debit Card
    DBI=Debit Card In
    DBO=Debit Card Out
    DD=Direct Deposit
    DDI=Direct Debit
    DDO=Direct Deposit
    EC=Electronic Check
    TP=Third Party Check
    TPI=Third Party Check In
    WIR=Wire Transfer