EM_PYCY_STAT_VW

(SQL View)
 Index Back

EBPP-PayCycl Mgr Currt PayCycl

EBPP-Added 2000/10/04-Last Mod 2000/10/19 by Matthias Davet View used on the level 1 of the EM_PYCYCL_STAT page.

SELECT b.pay_cycle , b.pay_cycle_seq_num , sec.oprid , a.pay_from_dt , a.pay_thru_dt , a.pymnt_dt , b.pay_run_dt , a.descr , b.dscnt_alrt_flg , b.neg_bal_flg , b.cnv_err_flg , b.bad_curr_flg , c.remit_setid , c.remit_vendor , c.currency_pymnt , SUM(c.paid_amt) , COUNT(*) FROM ps_pycycl a , ps_pycycl_stat b , PS_PYCYCL_DATA c , ps_sec_pycycl_opr sec WHERE sec.pay_cycle = a.pay_cycle AND a.pay_cycle = b.pay_cycle AND c.pymnt_selct_status <> 'D' AND b.pay_cycle_seq_num=( SELECT MAX(ss1.pay_cycle_seq_num) FROM ps_pycycl_stat ss1 WHERE ss1.pay_cycle=b.pay_cycle ) AND b.pay_run_ap_status IN ('R','1') AND c.pay_cycle = b.pay_cycle AND c.pay_cycle_seq_num = b.pay_cycle_seq_num AND NOT EXISTS ( SELECT 'X' FROM psprcsrqst r WHERE r.runcntlid=a.pay_cycle AND runstatus IN ('5','6','7') ) GROUP BY b.pay_cycle , b.pay_cycle_seq_num , sec.oprid , a.pay_from_dt , a.pay_thru_dt , a.pymnt_dt , b.pay_run_dt , a.descr , b.dscnt_alrt_flg , b.neg_bal_flg , b.cnv_err_flg , b.bad_curr_flg , c.remit_setid , c.remit_vendor , c.currency_pymnt

  • Parent record: PYCYCL

    • # 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    4 PAY_FROM_DT Date(10) DATE Pay From Date
    5 PAY_THRU_DT Date(10) DATE Pay Through Date
    6 PYMNT_DT Date(10) DATE Payment Date
    7 PAY_RUN_DT Date(10) DATE Payment Run Date
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 DSCNT_ALRT_FLG Character(1) VARCHAR2(1) NOT NULL Discount Alert
    N=No discounts lost
    Y=Discounts will be lost
    10 NEG_BAL_FLG Character(1) VARCHAR2(1) NOT NULL Negative Balances
    N=No negative balances
    Y=Negative supplier balance(s)
    11 CNV_ERR_FLG Character(1) VARCHAR2(1) NOT NULL Conversion Error
    N=No conversion errors
    Y=Currency conversion error
    12 BAD_CURR_FLG Character(1) VARCHAR2(1) NOT NULL Wrong Currency
    N=Payment currencies OK
    Y=Wrong payment currency
    13 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
    14 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    15 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
    16 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
    17 NUM_OF_VOUCHERS Number(8,0) INTEGER NOT NULL Sched Pymnts