GP_BNK_FILE_VW

(SQL View)
 Index Back

Search Record Bank File Entry

Record used as Search for Update Display Mode Bank File Entry Component

SELECT DISTINCT A.SRC_BANK_ID , B.BNK_FILE_ID , A.BANK_CD , A.ACCOUNT_EC_ID , A.CURRENCY_CD , A.DESCR , B.ASOFDATE , B.OPRID FROM PS_SRC_BANK A , PS_GP_BNK_FILE_HDR B WHERE A.BANK_CD = B.BANK_CD AND A.ACCOUNT_EC_ID = B.ACCOUNT_EC_ID AND A.EFF_STATUS = 'A'

  • Parent record: GP_BNK_FILE_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID

    Prompt Table: GP_BNK_SRC_VW

    2 BNK_FILE_ID Number(10,0) DECIMAL(10) NOT NULL Auto generated number when Bank File is loaded

    Prompt Table: GP_BNK_FL_ID_VW

    3 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID

    Prompt Table: GP_BNK_CD_VW

    4 ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account Number used in banking.

    Prompt Table: GP_BNK_EC_ID_VW

    5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: GP_BNK_CUR_VW.CURRENCY_CD

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 ASOFDATE Date(10) DATE As of Date
    8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).