TR_DASH_BSL_VW2

(SQL View)
 Index Back

Bank Statement Header

Header record for bank statement and balances tables

SELECT A.BNK_STMT_TYPE ,A.ASOFDATE ,A.BNK_ID_NBR ,A.BANK_CD ,A.BANK_ACCOUNT_NUM ,A.TR_DASH_CYCLE_ST ,A.OPRID FROM PS_TR_DASH_BSL_VW1 A WHERE EXISTS ( SELECT 'X' FROM PS_BANK_STMT_HDR B WHERE A.BNK_STMT_TYPE = B.BNK_STMT_TYPE AND A.BNK_ID_NBR = B.BNK_ID_NBR AND A.BANK_ACCOUNT_NUM = B.BANK_ACCOUNT_NUM) AND A.TR_DASH_CYCLE_ST <> 'Y' AND A.BNK_STMT_TYPE = A.BNK_STMT_TYPE_2

  • 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 ASOFDATE Date(10) DATE As of Date
    3 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
    4 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    5 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
    6 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
    7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).