BNK_ACCMTHD_VW2(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 = '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 |  SALE_BANK_SETID |
Character(5) | VARCHAR2(5) NOT NULL | The subject tableset ID associated with the treasury bank code for a buy/sellback transaction. |
| 2 | SALE_BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL | The subject settlement bank code for a buy/sellback transaction. |
| 3 | SALE_BANK_ACCT_KEY |
Character(4) | VARCHAR2(4) NOT NULL | The subject bank account for a buy/sellback transaction. |
| 4 | SALE_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 DD=Direct Debit DFT=Draft - Supplier Initiated 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 |