EMPLIDACCOUNT_IDGP_CB_BANK_VW(SQL View) |
Index Back |
|---|---|
GP Chatbot Bank viewGP Chatbot Bank view |
| SELECT a.emplid ,a.account_id ,c1.descr ,b.bank_nm ,X.XLATLONGNAME ,A.ACCOUNT_EC_ID ,A.ACCOUNT_NAME ,A.CURRENCY_CD ,c.ACCOUNT_EC_ID FROM ps_pye_bankacct a , ps_BANK_EC_TBL b ,psxlatitem x ,PS_COUNTRY_TBL c1 ,ps_gp_cb_acmsk_tbl c WHERE a.bank_cd=b.bank_cd AND X. fieldname='ACCOUNT_TYPE_PYE' AND X.FIELDVALUE=ACCOUNT_TYPE_PYE AND c1.country=a.country_cd AND c.emplid=a.emplid AND c.account_id = a.account_id and a.eff_status='A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | ACCOUNT_ID |
Number(3,0) | SMALLINT NOT NULL | Account ID |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | BANK_NM | Character(40) | VARCHAR2(40) NOT NULL | Bank Name |
| 5 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 6 | ACCOUNT_EC_ID | Character(35) | VARCHAR2(35) NOT NULL | Account Number used in banking. |
| 7 | ACCOUNT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Account Name |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |