BNK_ACCMTHD_VW3(SQL View) |
Index Back |
|---|---|
Pay Methods by Bank |
| SELECT A.SETID , A.BANK_CD , A.BANK_ACCT_KEY , C.PYMNT_METHOD , D.XLATLONGNAME FROM PS_BANK_ACCT_DEFN A , PS_BANK_ACCT_MTHD C , PSXLATITEM D WHERE A.BANK_ACCT_QUAL = 'C' AND A.SETID = C.SETID AND A.BANK_CD = C.BANK_CD AND A.BANK_CD_CPTY = C.BANK_CD_CPTY AND A.BANK_ACCT_KEY = C.BANK_ACCT_KEY AND D.FIELDNAME = 'REC_PYMNT_METHOD' AND D.FIELDVALUE = C.PYMNT_METHOD AND D.EFF_STATUS = 'A' AND D.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE D.FIELDVALUE = B.FIELDVALUE AND D.FIELDNAME = B.FIELDNAME AND B.EFF_STATUS = 'A' AND B.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  REC_BANK_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID for a bank on the receiving side of a settlement transaction.
Prompt Table: SP_SETID_NONVW |
| 2 | REC_BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL |
The bank for the receiving side of a settlement transaction.
Prompt Table: BANK_TR_REC_VW |
| 3 | REC_BANK_ACCT_KEY |
Character(4) | VARCHAR2(4) NOT NULL |
The bank account for the receiving side of a settlement transaction.
Prompt Table: BANK_TR_ACTR_VW |
| 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |