BNK_SID_EVNT_VW

(SQL View)
Index Back

Bank Statement ID Event Log


SELECT A.BNK_ID_NBR ,A.BANK_ACCOUNT_NUM , A.STATEMENT_ID FROM PS_BANK_STMT_HDR A , PS_BANK_CD_TBL B , PS_BANK_ACCT_DEFN C WHERE A.BNK_ID_NBR = B.BNK_ID_NBR AND A.BANK_ACCOUNT_NUM = C.BANK_ACCOUNT_NUM AND B.SETID = C.SETID AND B.BANK_CD = C.BANK_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
2 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
3 STATEMENT_ID Number(10,0) DECIMAL(10) NOT NULL Statement ID for bank statements, key on Bank Statement Header