CSH_OFF_REC_VW

(SQL View)
 Index Back

Cashier Office Receipts View


SELECT a.business_unit ,b.sf_deposit_id ,a.emplid ,a.ext_org_id ,a.cashier_office ,a.current_bus_dt ,a.sf_register ,a.cashier ,a.trans_dt ,a.trans_time ,a.receipt_nbr ,' ' ,a.ssf_appr_status ,' ' ,SUM(b.amount_sf) FROM PS_CSH_OFF_RECEIPT a , ps_csh_off_rcpt_t b WHERE a.business_unit = b.business_unit AND a.cashier_office = b.cashier_office AND a.receipt_nbr = b.receipt_nbr GROUP BY a.business_unit ,b.sf_deposit_id ,a.cashier_office ,a.current_bus_dt ,a.emplid ,a.ext_org_id ,a.sf_register ,a.cashier ,a.trans_dt ,a.trans_time ,a.receipt_nbr ,a.ssf_appr_status

  • 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
    2 SF_DEPOSIT_ID Character(10) VARCHAR2(10) NOT NULL Deposit ID
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    5 CASHIER_OFFICE Character(8) VARCHAR2(8) NOT NULL Cashier's Office
    6 BUSINESS_DATE Date(10) DATE Business Date
    7 SF_REGISTER Character(5) VARCHAR2(5) NOT NULL Cash Register
    8 CASHIER Character(30) VARCHAR2(30) NOT NULL Cashier
    9 TRANS_DT Date(10) DATE Transaction Date
    10 TRANS_TIME Time(15) TIMESTAMP Transaction Time
    11 RECEIPT_NBR Number(12,0) DECIMAL(12) NOT NULL Receipt Number
    12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    13 SSF_APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag .
    A=Approved
    C=Cancelled
    D=Denied
    G=Group Post
    N=Not Posted
    P=Pending
    T=Posted
    U=Unprocessed
    V=Voided
    X=Delayed Post
    Z=Processed
    14 SF_REVERSAL_IND Character(1) VARCHAR2(1) NOT NULL Reversal Indicator
    15 AMOUNT_TOTAL Signed Number(18,2) DECIMAL(16,2) NOT NULL Amount Total