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 |