PYMNT_XREF_VW

(SQL View)
 Index Back

AP Payment Voucher Information


select b.remit_setid, b.remit_vendor, b.bank_setid, a.bank_cd, a.bank_acct_key, b.pymnt_id_ref, a.pymnt_id, a.business_unit, a.voucher_id, a.pymnt_cnt, a.currency_pymnt, a.paid_amt, a.pymnt_gross_amt, a.dscnt_pay_amt, a.paid_amt_gross, a.paid_amt_dscnt, c.txn_currency_cd, c.invoice_id, c.invoice_dt, c.vendor_id from ps_pymnt_vchr_xref a, ps_payment_tbl b, PS_VOUCHER c where a.bank_setid = b.bank_setid and a.bank_cd= b.bank_cd and a.bank_acct_key = b.bank_acct_key and a.pymnt_id = b.pymnt_id and a.business_unit = c.business_unit and a.voucher_id = c.voucher_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
2 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
3 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
4 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

Prompt Table: BANK_CD_TBL

5 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
6 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference
7 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
10 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
11 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
12 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
13 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount
14 DSCNT_PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Discount Amount
15 PAID_AMT_GROSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Paid Amount
16 PAID_AMT_DSCNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount on Paid Amount
17 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
18 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
19 INVOICE_DT Date(10) DATE Invoice Date
20 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier