PYMNT_EMAIL_VW(SQL View) |
Index Back |
|---|---|
Payments joined by email flgList all payments that its EFT/ACH advice will be send by Email Advice or FG remittance Advice |
| SELECT DISTINCT P.PAY_CYCLE , P.PAY_CYCLE_SEQ_NUM , P.BANK_SETID , P.BANK_CD , P.BANK_ACCT_KEY , P.PYMNT_ID , P.PYMNT_METHOD , P.STL_THROUGH FROM PS_PAYMENT_TBL P , PS_PYCYCL_WRK_OPT O , PS_PMT_SRC_DEFN D , PS_VND_PAYEMAIL_VW V WHERE P.REMIT_SETID = V.SETID AND P.REMIT_VENDOR = V.VENDOR_ID AND P.VNDR_LOC = V.VNDR_LOC AND P.PYMNT_METHOD = V.PYMNT_METHOD AND ((P.STL_THROUGH = '02' AND O.PAY_CYCLE = P.PAY_CYCLE AND O.EMAIL_ADVICE = 'Y' AND V.EMAIL_ADVICE = 'Y') OR ( P.STL_THROUGH = '01' AND D.PMT_SOURCE = 'AP' AND D.REMIT_ADVISE_OPT = 'Y' AND V.REMIT_ADVISE_OPT = 'Y')) AND P.PYMNT_STATUS NOT IN ('R', 'X') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PAY_CYCLE |
Character(6) | VARCHAR2(6) NOT NULL | Pay Cycle |
| 2 | PAY_CYCLE_SEQ_NUM |
Number(6,0) | INTEGER NOT NULL | Pay Cycle Sequence Number |
| 3 | BANK_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Default Value: OPR_BANK_VW_AP.BANK_SETID |
| 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 |
Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 7 | 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 |
| 8 | STL_THROUGH | Character(2) | VARCHAR2(2) NOT NULL |
Settle through
01=Financial Gateway 02=Pay Cycle |