TR_DASH_BSL_VW3

(SQL View)
 Index Back

Bank Statement Header

Header record for bank statement and balances tables

SELECT DISTINCT A.OPRID , A.BNK_STMT_TYPE_2 , A.ASOFDATE , A.BNK_ID_NBR , A.BANK_CD , A.BANK_ACCOUNT_NUM , A.BANK_ACCT_KEY , A.TR_DASH_CYCLE_ST FROM PS_TR_DASH_BSL_VW1 A WHERE A.TR_DASH_CYCLE_ST = 'Y' AND A.BNK_STMT_TYPE_2 = A.BNK_STMT_TYPE AND NOT EXISTS ( SELECT 'X' FROM PS_TR_DASH_BSL_VW2 B WHERE A.BNK_ID_NBR = B.BNK_ID_NBR AND A.BANK_ACCOUNT_NUM = B.BANK_ACCOUNT_NUM AND A.OPRID = B.OPRID)

  • Parent record: BANK_ACCT_DEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BNK_STMT_TYPE Character(1) VARCHAR2(1) NOT NULL Bank statement type
    1=Current Day
    2=Previous Day
    3=Statement Analysis
    3 ASOFDATE Date(10) DATE As of Date
    4 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
    5 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    6 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
    7 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
    8 TR_DASH_CYCLE_ST Character(1) VARCHAR2(1) NOT NULL Payment cycle status only for treasury dashboard
    C=Complete
    E=Load Failed
    F=Fatal Error
    I=EDI Loaded
    L=Loading
    N=Ready
    P=Selected
    R=Ready
    X=Reconciling
    Y=Not Loaded