BANK_CD0=General/All-Purpose Bank
1=Commercial Bank
2=Savings Bank
3=Community Bank
5=Postal Bank
GPDE_BANK_EC_VW(SQL View) |
Index Back |
|---|---|
Bank Table ECBank Table EC |
| SELECT BANK_CD , BANK_TYPE , BANK_NM FROM PS_BANK_EC_TBL WHERE COUNTRY_CD = 'DEU' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BANK_CD |
Character(11) | VARCHAR2(11) NOT NULL | Bank ID |
| 2 | BANK_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
This is to distinguish different types of banks or financial institutions
0=General/All-Purpose Bank 1=Commercial Bank 2=Savings Bank 3=Community Bank 5=Postal Bank |
| 3 | BANK_NM | Character(40) | VARCHAR2(40) NOT NULL | Bank Name |