EM_PYMTOUTST_VW

(SQL View)
Index Back

MP - Outstanding Payments

Outstanding Payments for Pymnt inq by voucher

SELECT DISTINCT a.business_unit , a.voucher_id , a.pymnt_cnt , A.SCHEDULED_PAY_DT , a.pymnt_gross_amt , A.txn_currency_cd , a.bank_setid , a.bank_cd , a.bank_acct_key , A.PYMNT_METHOD , A.DSCNT_PAY_AMT , A.DUE_DT , A.PYMNT_HOLD FROM ps_pymnt_vchr_xref a , PS_VOUCHER c WHERE a.business_unit=c.business_unit AND a.voucher_id=c.voucher_id AND a.pymnt_hold_wthd='N' AND a.pymnt_selct_status='N' AND ( a.NET_SELCT_STATUS IN ('N', ' ') OR a.NET_TXN_STATUS IN ('B', 'N') ) AND c.entry_status = 'P' AND c.appr_status = 'A' AND c.process_man_close = 'N' AND c.match_status_vchr IN ('M', 'N', 'O') AND c.BUDGET_HDR_STATUS = 'V' AND c.BUDGET_MISC_STATUS = 'V'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
4 SCHEDULED_PAY_DT Date(10) DATE Scheduled to Pay
5 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount
6 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
7 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
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 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer

Prompt Table: PYMNT_MTHD_VW2

11 DSCNT_PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Discount Amount
12 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
13 PYMNT_HOLD Character(1) VARCHAR2(1) NOT NULL Hold Payment
N=No
Y=Yes