TR_DASH_BSL_VW1

(SQL View)
 Index Back

Bank Statement Header

Header record for bank statement and balances tables

SELECT BNK_STMT_TYPE ,BNK_STMT_TYPE_2 ,ASOFDATE_C ,ASOFDATE ,BNK_ID_NBR ,BANK_CD ,BANK_ACCOUNT_NUM ,BANK_ACCT_KEY ,CASE WHEN BNK_STMT_TYPE <> BNK_STMT_TYPE_2 THEN 'Y' WHEN BNK_STMT_TYPE = BNK_STMT_TYPE_2 AND ASOFDATE_C <> ASOFDATE THEN 'Y' ELSE TR_DASH_CYCLE_ST END ,OPRID FROM PS_TR_DASH_BSL_VW

  • Parent record: BANK_ACCT_DEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BNK_STMT_TYPE Character(1) VARCHAR2(1) NOT NULL Bank statement type
    1=Current Day
    2=Previous Day
    3=Statement Analysis
    2 BNK_STMT_TYPE_2 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 ASOFDATE_C Date(10) DATE As Of Date
    5 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
    6 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    7 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
    8 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
    9 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
    10 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).