CSH_REG_TNDR_VW

(SQL View)
Index Back

Register Tender View


SELECT a.business_unit , a.cashier_office , a.business_date , a.cashier , c.sf_register , b.tender_key , b.descr FROM PS_CSH_BD_CSH_TBL a , ps_csh_csh_tndr_vw b , ps_csh_bd_reg_open c WHERE a.business_unit = b.business_unit AND a.cashier_office = b.cashier_office AND a.cashier = b.cashier AND b.business_unit = c.business_unit AND b.cashier_office = c.cashier_office AND a.business_date = c.business_date AND a.sf_register = c.sf_register AND b.tender_key = c.tender_key

  • Related Language Record: CSHREGTNDRVWLNG
  • # 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 CASHIER Character(30) VARCHAR2(30) NOT NULL Cashier
    5 SF_REGISTER Character(5) VARCHAR2(5) NOT NULL Cash Register
    6 TENDER_KEY Character(10) VARCHAR2(10) NOT NULL Tender Key
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description