VED_PVX_VNL1_VW

(SQL View)
 Index Back

Vchr Edit PVX VndrLoc Fld Vw1

R-DFLORI-7P4RN - make sure that the correct bank_setid is used . . . , D.SETID <=== , C.BANK_CD , C.BANK_ACCT_KEY , C.PYMNT_METHOD , C.PYMNT_HANDLING_CD FROM PS_VENDOR_LOC A , PS_VENDOR_PAY B , PS_VENDOR_PAY C , PS_SET_CNTRL_GROUP D <==== WHERE D.rec_group_id = 'FS_39' <=== AND B.setid = D.setcntrlvalue <=== . . .

SELECT A.SETID , A.VENDOR_ID , A.VNDR_LOC , A.REMIT_SETID , A.REMIT_VENDOR , A.REMIT_LOC , A.REMIT_ADDR_SEQ_NUM , C.PYMNT_SEPARATE , B.CURRENCY_PYMNT , B.CUR_RT_TYPE_PYMNT , B.EFT_PYMNT_FMT_CD , D.SETID , C.BANK_CD , C.BANK_ACCT_KEY , C.PYMNT_METHOD , C.PYMNT_HANDLING_CD , C.PYMNT_GROUP_CD , E.BANK_ACCT_SEQ_NBR , C.EFT_LAYOUT_CD FROM PS_VENDOR_LOC A , PS_VENDOR_PAY B , PS_VENDOR_PAY C , PS_SET_CNTRL_GROUP D , PS_VENDOR_LOC E WHERE D.rec_group_id = 'FS_39' AND B.SETID = D.SETCNTRLVALUE AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(I.EFFDT) FROM PS_VENDOR_LOC I WHERE I.SETID = A.SETID AND I.VENDOR_ID = A.VENDOR_ID AND I.VNDR_LOC = A.VNDR_LOC AND I.EFFDT <= %CurrentDateIn) AND B.SETID = A.SETID AND B.VENDOR_ID = A.VENDOR_ID AND B.VNDR_LOC = A.VNDR_LOC AND B.EFFDT = A.EFFDT AND B.SEQ_NUM = ( SELECT MAX(KK.SEQ_NUM) FROM PS_VENDOR_PAY KK WHERE KK.SETID = B.SETID AND KK.VENDOR_ID = B.VENDOR_ID AND KK.VNDR_LOC = B.VNDR_LOC AND KK.EFFDT = B.EFFDT) AND C.SETID = A.REMIT_SETID AND C.VENDOR_ID = A.REMIT_VENDOR AND C.VNDR_LOC = A.REMIT_LOC AND C.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(J.EFFDT) FROM PS_VENDOR_PAY J WHERE J.SETID = C.SETID AND J.VENDOR_ID = C.VENDOR_ID AND J.VNDR_LOC = C.VNDR_LOC AND J.EFFDT <= %CurrentDateIn) AND C.SEQ_NUM = ( SELECT MAX(JJ.SEQ_NUM) FROM PS_VENDOR_PAY JJ WHERE JJ.SETID = C.SETID AND JJ.VENDOR_ID = C.VENDOR_ID AND JJ.VNDR_LOC = C.VNDR_LOC AND JJ.EFFDT = C.EFFDT) AND E.SETID = A.REMIT_SETID AND E.VENDOR_ID = A.REMIT_VENDOR AND E.VNDR_LOC = A.REMIT_LOC AND E.EFF_STATUS = 'A' AND E.EFFDT = ( SELECT MAX(K.EFFDT) FROM PS_VENDOR_LOC K WHERE K.SETID = E.SETID AND K.VENDOR_ID = E.VENDOR_ID AND K.VNDR_LOC = E.VNDR_LOC AND K.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 VCHR_VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Voucher supplier loc
4 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
5 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
6 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
7 REMIT_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Remitting Location
8 PYMNT_SEPARATE Character(1) VARCHAR2(1) NOT NULL Separate Payment
9 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
10 CUR_RT_TYPE_PAID Character(5) VARCHAR2(5) NOT NULL Payment Rate Type
11 EFT_PYMNT_FMT_CD Character(3) VARCHAR2(3) NOT NULL Payment Format
00=Standard SWIFT transfer
10=Urgent SWIFT
15=Euro-Transfer
21=Check, w/ receipt confirmation
22=Check, Urgent
23=Check, urgent w/ receipt
40=Postal Order
CTX=Corp Trade Exchange
PBC=Check, standard
PPD=Prearranged Pay & Deposit
WRT=Wire Transfer
12 REMIT_BANK_SETID Character(5) VARCHAR2(5) NOT NULL Remit Bank Setid
13 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
14 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
15 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
16 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling
17 PYMNT_GROUP_CD Character(2) VARCHAR2(2) NOT NULL Pay Group Code
18 BANK_ACCT_SEQ_NBR Number(3,0) SMALLINT NOT NULL Bank Account Sequence Number
19 EFT_LAYOUT_CD Character(10) VARCHAR2(10) NOT NULL EFT Layout Code