AP_PYMNTNOTE_VW(SQL View) |
Index Back |
|---|---|
EBPP Payment File Creation VwView of file payments that have been made. Used to create email notification via a component interface. RSR MarketPay |
| SELECT DISTINCT a.pay_cycle , a.pay_cycle_seq_num , b.business_unit , b.voucher_id , d.invoice_id , b.pymnt_cnt , b.pymnt_selct_status , c.bank_cd , c.bank_acct_key , b.remit_setid , b.remit_vendor , c.pymnt_id_ref , c.pymnt_dt , E.NAME1 FROM ps_pycycl_stat a , ps_pymnt_vchr_xref b , ps_payment_tbl c , PS_VOUCHER d , PS_VENDOR E WHERE a.pay_cycle=b.pay_cycle AND a.pay_cycle_seq_num=b.pay_cycle_seq_num AND a.pay_cycle=c.pay_cycle AND a.pay_cycle_seq_num=c.pay_cycle_seq_num AND b.business_unit=d.business_unit AND b.voucher_id=d.voucher_id AND a.pay_run_ap_status IN ('C','X') AND b.pymnt_selct_status<>'X' AND C.REMIT_VENDOR=B.REMIT_VENDOR AND C.REMIT_SETID=B.REMIT_SETID AND C.REMIT_VENDOR=E.VENDOR_ID AND C.REMIT_SETID=E.SETID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PAY_CYCLE |
Character(6) | VARCHAR2(6) NOT NULL | Pay Cycle |
| 2 | PAY_CYCLE_SEQ_NUM |
Number(6,0) | INTEGER NOT NULL | Pay Cycle Sequence Number |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 5 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 6 | PYMNT_CNT |
Number(5,0) | INTEGER NOT NULL | Payments |
| 7 | PYMNT_SELCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Selection Status
C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid |
| 8 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 9 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 10 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Remit SetID |
| 11 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 12 | PYMNT_ID_REF | Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |
| 13 | PYMNT_DT | Date(10) | DATE | Payment Date |
| 14 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |