EM_BANK_MTHD_L2(SQL View) |
Index Back |
---|---|
Paymnt Methods/Banks- LanguageRelated Language View of EM_BANK_MTHD_V2. Payment Methods for Bank Accounts. Joins: BANK_CD_TBL BANK_ACCT_DEFN BANK_ACCT_MTHD |
SELECT C.SETID , C.BANK_CD , C.BANK_ACCT_KEY , 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.SETID = B.SETID AND A.BANK_CD = B.BANK_CD AND B.SETID = C.SETID AND B.BANK_CD = C.BANK_CD AND B.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(D1.EFFDT) FROM PSXLATITEM D1 WHERE D1.FIELDNAME = D.FIELDNAME AND D1.FIELDVALUE = D.FIELDVALUE AND D1.EFFDT <= %CurrentDateIn) 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 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
2 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
3 | 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 |
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 |