SUB_BANK_CD_VW

(SQL View)
Index Back

Cash Sweep Sub Account

Prompting view that shows only those bank codes that have been defined as External Banks.

SELECT SETID , BANK_CD , DESCR , BNK_ID_NBR FROM PS_BANK_CD_TBL WHERE BANKING_SW = 'Y' AND BANK_TYPE = 'E' AND BANK_STATUS = 'A'

  • Related Language Record: SUB_BANK_CD_LG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SUB_BANK_SETID Character(5) VARCHAR2(5) NOT NULL The tableset ID for a sub bank account on the Cash Sweep Structure Definition.

    Prompt Table: SP_SETID_NONVW

    2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

    Prompt Table: BANK_CD_EXT_VW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.