TR_WR_PM_E_V_L(SQL View) |
Index Back |
|---|---|
Ext Bank Acct View for InquiryView over External Bank Accounts |
| SELECT A.SETID ,A.BNK_ID_NBR ,B.BANK_ACCOUNT_NUM ,C.PYMNT_METHOD ,E.LANGUAGE_CD ,E.XLATLONGNAME FROM PS_BANK_CD_TBL A ,PS_BANK_ACCT_DEFN B ,PS_BANK_ACCT_MTHD C ,PSXLATITEM D ,PSXLATITEMLANG E WHERE A.BANK_TYPE='E' AND B.SETID=A.SETID AND B.BANK_CD=A.BANK_CD AND C.SETID=B.SETID AND C.BANK_CD=B.BANK_CD AND C.BANK_CD_CPTY=B.BANK_CD_CPTY AND C.BANK_ACCT_KEY=B.BANK_ACCT_KEY AND C.PYMNT_METHOD IN ('ACH','DD','EFT','WIR') AND A.BANK_TYPE='E' AND D.FIELDNAME='PYMNT_METHOD' AND D.FIELDVALUE=C.PYMNT_METHOD AND D.EFF_STATUS='A' AND D.EFFDT=( SELECT MAX(EFFDT) FROM PSXLATITEM F WHERE F.FIELDNAME=D.FIELDNAME AND F.FIELDVALUE=D.FIELDVALUE AND F.EFFDT<=%CurrentDateIn) AND B.ACCT_STATUS='A' AND D.FIELDNAME = E.FIELDNAME AND D.FIELDVALUE = E.FIELDVALUE AND D.EFFDT = E.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | BNK_ID_NBR |
Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 3 | BANK_ACCOUNT_NUM |
Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |