PYCYCL_NBAL_VW

(SQL View)
 Index Back

Negative Bal Summary Vw


select a.pay_cycle, a.pay_cycle_seq_num, a.remit_setid, a.remit_vendor, b.name1, a.currency_pymnt, sum(a.paid_amt), count(distinct a.voucher_id) from PS_PYCYCL_DATA a, ps_vendor b where a.pay_cycle <> ' ' and a.pay_cycle_seq_num > 0 and a.pymnt_separate in ('C','N') and a.pymnt_selct_status='D' and b.setid=a.remit_setid and b.vendor_id=a.remit_vendor group by a.pay_cycle, a.pay_cycle_seq_num, a.remit_setid, a.remit_vendor, b.name1, a.currency_pymnt

  • Related Language Record: PYCYCL_NBALVWLG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle

    Prompt Table: SP_PYCYCL_NONVW

    2 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number
    3 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
    4 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    6 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
    7 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
    8 NUM_OF_VOUCHERS Number(8,0) INTEGER NOT NULL Sched Pymnts