SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
BANK_CDBNK_CD_CUST_VW(SQL View) |
Index Back |
|---|---|
Customer Banks/CounterpartiesPrompting view that shows only those Customer bank codes that have accounts defined. Used on records where bank code/account are entered in combination. |
| SELECT DISTINCT A.setid , A.bank_cd , A.descr , A.descrshort , A.descr_ac FROM PS_BANK_CD_TBL A , ps_bank_acct_defn B WHERE A.setid = B.setid AND A.bank_cd = B.bank_cd AND A.bank_type = 'E' AND B.bank_acct_qual = 'U' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | DESCR_AC | Character(30) | VARCHAR2(30) NOT NULL | Alternate Description |