Vouchers eligible for having a payment applied to it. This view is used in a scroll select in RowInit P-code of pymnt_appl_srch

PYMNT_APPL_VW

(SQL View)
 Index Back

select a.business_unit, a.voucher_id, a.pymnt_cnt, a.remit_setid, a.remit_vendor, a.pymnt_id, a.paid_amt, a.pymnt_gross_amt, a.dscnt_pay_amt, a.due_dt, a.dscnt_due_dt, a.scheduled_pay_dt, b.vendor_setid, b.vendor_id, a.pymnt_hold, a.pymnt_hold_wthd, a.pay_cycle_seq_num, a.pymnt_selct_status, a.pymnt_method, c.cur_rt_type_pymnt, a.paid_amt_gross, a.paid_amt_dscnt, c.paid_amt_bse, c.paid_amt_gross_bse, c.paid_amt_dscnt_bse, a.currency_pymnt, c.pymnt_rate_mult, c.pymnt_rate_div, c.rate_mult, c.rate_div, b.txn_currency_cd, b.rt_type, b.base_currency, b.invoice_id, b.invoice_dt, c.gross_amt_bse, c.dscnt_amt_bse, a.paid_amt_bnk_bse, a.base_currency_bnk, a.cur_rt_type_bnk, a.bnk_rate_mult, a.bnk_rate_div from ps_pymnt_vchr_xref a, PS_VOUCHER b, ps_pymnt_vchr_book c where a.business_unit = b.business_unit and a.voucher_id = b.voucher_id and a.business_unit = c.business_unit and a.voucher_id = c.voucher_id and a.pymnt_cnt = c.pymnt_cnt and b.appr_status = 'A' and b.process_man_close = 'N' and b.entry_status = 'P'

# 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 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
5 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
6 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
7 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
8 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount
9 DSCNT_PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Discount Amount
10 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.
11 DSCNT_DUE_DT Date(10) DATE Discount Due Date
12 SCHEDULED_PAY_DT Date(10) DATE Scheduled to Pay
13 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
14 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
15 PYMNT_HOLD Character(1) VARCHAR2(1) NOT NULL Hold Payment
N=No
Y=Yes

Y/N Table Edit

16 PYMNT_HOLD_WTHD Character(1) VARCHAR2(1) NOT NULL On Withholding Hold
N=No
Y=Yes

Y/N Table Edit

17 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number
18 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
19 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
20 CUR_RT_TYPE_PYMNT Character(5) VARCHAR2(5) NOT NULL Payment Currency Rate Type
21 PAID_AMT_GROSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Paid Amount
22 PAID_AMT_DSCNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount on Paid Amount
23 PAID_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Paid Amount
24 PAID_AMT_GROSS_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Gross Payment Amount
25 PAID_AMT_DSCNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Discount Paid Amount
26 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
27 PYMNT_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange rate is stored
28 PYMNT_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange rate is store
29 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
30 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
31 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
32 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
33 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
34 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
35 INVOICE_DT Date(10) DATE Invoice Date
36 GROSS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Gross Amount
37 DSCNT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Discount Amount
38 PAID_AMT_BNK_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount - Base Bank Unit
39 BASE_CURRENCY_BNK Character(3) VARCHAR2(3) NOT NULL The base currency of the subject bank general ledger business unit.
40 CUR_RT_TYPE_BNK Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
41 BNK_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange spot rate is stored either as
42 BNK_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange spot rate is store