BANK_CD_VW12_LG(SQL View) |
Index Back |
---|---|
Bank codes with accountsPrompting view that shows only those bank codes that have accounts defined. Used on records where bank code/account are entered in combination. |
SELECT DISTINCT a.setid , a.bank_cd , C.LANGUAGE_CD , C.descr , C.descrshort FROM PS_BANK_ACCT_DEFN a , ps_bank_cd_LNG C WHERE a.setid = C.setid AND a.bank_cd = C.bank_cd AND a.bank_acct_qual = 'C' AND a.ap = 'Y' |
# | 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.
Prompt Table: SP_SETID_NONVW |
2 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_CD_TBL |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |