PYMNT_VCHR_XVW

(SQL View)
Index Back

Voucher Scheduled Payment


SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.PYMNT_ID , A.REMIT_SETID , A.REMIT_VENDOR , A.VNDR_LOC , A.REMIT_ADDR_SEQ_NUM , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , B.VENDOR_SETID , B.VENDOR_ID , B.VNDR_LOC , B.ADDRESS_SEQ_NUM FROM PS_PYMNT_VCHR_XREF A , PS_VOUCHER B WHERE A.PYMNT_ID <> ' ' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID

# 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_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
4 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
5 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
6 REMIT_LOC Character(10) VARCHAR2(10) NOT NULL Remit to Location
7 REMIT_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Remitting Location
8 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
9 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
10 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
11 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
12 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
13 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
14 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number