EM_SP_PYBKCD_VW(SQL View) |
Index Back |
---|---|
Bank Pymnt Selection Criteria |
SELECT a.pay_cycle , a.bank_setid , a.bank_cd , b.descrshort FROM ps_pycycl_bnk a , PS_BANK_CD_TBL b WHERE a.bank_setid = b.setid AND a.bank_cd = b.bank_cd |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PAY_CYCLE | Character(6) | VARCHAR2(6) NOT NULL | Pay Cycle |
2 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: BANK_SETID_VW |
3 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_CD_VW9 |
4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |