GFVC_VCHRPO_VW4

(SQL View)
Index Back

Federal Sched Pymnt Cancel VW4


SELECT DISTINCT A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , B.PYMNT_ID_REF , A.PYMNT_ID , A.PYMNT_METHOD , A.BUSINESS_UNIT , A.VOUCHER_ID , A.PYMNT_CNT , B.SCHEDULE_ID , C.PO_ID , D.VENDOR_ID FROM PS_PYMNT_VCHR_XREF A , PS_PAYMENT_TBL B , PS_VOUCHER C , PS_VENDOR D WHERE A.PYMNT_ID <> ' ' AND 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 AND C.VENDOR_SETID = D.SETID AND C.VENDOR_ID = D.VENDOR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
3 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
4 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference
5 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
6 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
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
9 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
10 SCHEDULE_ID Character(10) VARCHAR2(10) NOT NULL Schedule ID
11 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
12 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier