CSH_OFF_RCL_NVW

(SQL View)
 Index Back

Cashier Office Receipts


select a.business_unit ,a.cashier_office ,a.receipt_nbr ,sum(b.amount_sf) from ps_csh_off_receipt a, ps_csh_off_rcpt_l b, PS_TARGET_KEY_TBL c where a.business_unit = b.business_unit and a.cashier_office = b.cashier_office and a.receipt_nbr = b.receipt_nbr and b.business_unit = c.business_unit and b.target_key = c.target_key and c.effdt = (select max(c1.effdt) from PS_TARGET_KEY_TBL c1 where c.business_unit = c1.business_unit and c.target_key = c1.target_key and c1.effdt <= %currentdatein) and c.eff_status = 'A' and (b.tax_row = 'Y' or (b.tax_row <> 'Y' and c.post_target <> 'Y')) group by a.business_unit, a.cashier_office, a.receipt_nbr

  • Parent record: CSH_OFF_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

    Prompt Table: SP_BU_SF_NONVW

    2 CASHIER_OFFICE Character(8) VARCHAR2(8) NOT NULL Cashier's Office

    Default Value: OPR_DEF_TBL_CS.CASHIER_OFFICE

    Prompt Table: SP_CSHOFF_NONVW

    3 RECEIPT_NBR Number(12,0) DECIMAL(12) NOT NULL Receipt Number

    Default Value: 999999999999

    4 TOTAL_AMOUNT_SF Signed Number(17,2) DECIMAL(15,2) NOT NULL Total Amount