EM_SP_PYBKCU_VW(SQL View) |
Index Back |
|---|---|
Bank Pymnt Currency |
| SELECT a.pay_cycle ,b.currency_cd FROM ps_pycycl_bnk a , PS_BANK_ACCT_TBL b WHERE a.bank_setid = b.setid AND a.bank_cd = b.bank_cd AND a.bank_acct_key = b.bank_acct_key |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(6) | VARCHAR2(6) NOT NULL | Pay Cycle | |
| 2 | Character(3) | VARCHAR2(3) NOT NULL | Payment Currency |