VND_PAYEMAIL_VW(SQL View) |
Index Back |
|---|---|
Supplier Pay Notification viewList suppliers with payment notification option selected. |
| SELECT V.SETID , V.VENDOR_ID , V.VNDR_LOC , M.PYMNT_METHOD , V.EMAIL_ADVICE , V.REMIT_ADVISE_OPT , V.EMAILID FROM PS_VENDOR_PAY V ,PS_EMAIL_PAY_MTHD M WHERE M.SETID = V.SETID AND M.VENDOR_ID= V.VENDOR_ID AND M.VNDR_LOC = V.VNDR_LOC AND M.EFFDT = V.EFFDT AND M.SEQ_NUM = V.SEQ_NUM AND (V.EMAIL_ADVICE = 'Y' OR V.REMIT_ADVISE_OPT = 'Y') AND V.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_VENDOR_PAY C WHERE C.SETID = V.SETID AND C.VENDOR_ID = V.VENDOR_ID AND C.VNDR_LOC = V.VNDR_LOC AND C.SEQ_NUM = V.SEQ_NUM AND C.EFF_STATUS = 'A' AND C.effdt <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 4 | 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 |
| 5 | EMAIL_ADVICE | Character(1) | VARCHAR2(1) NOT NULL |
Email Payment Advice
N=No Y=Yes Default Value: N |
| 6 | REMIT_ADVISE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Flag to be used for sending remittance advise through FG
Default Value: N |
| 7 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |