CSH_BD_TNDR_VW

(SQL View)
 Index Back

Bus Dt Cashier Tender View


select 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 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 c.eff_status = 'A')

  • Related Language Record: CSHBDTNDRVWLNG

  • 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