TR_BANK_ID_VW2

(SQL View)
 Index Back

Bank Statement Header

Header record for bank statement and balances tables

SELECT A.BANK_CD ,A.BNK_ID_NBR ,%Substring(B.FIELDVALUE,1,1) FROM PS_BANK_CD_TBL A , PSXLATITEM B WHERE A.BANK_TYPE='E' AND A.BANKING_SW='Y' AND A.BANK_STATUS = 'A' AND B.FIELDNAME='BNK_STMT_TYPE'

  • Parent record: BANK_ACCT_DEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    2 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
    3 BNK_STMT_TYPE Character(1) VARCHAR2(1) NOT NULL Bank statement type
    1=Current Day
    2=Previous Day
    3=Statement Analysis