TR_DASH_BSL_VW

(SQL View)
 Index Back

Bank Statement Header

Header record for bank statement and balances tables

SELECT DISTINCT B.BNK_STMT_TYPE ,%Substring(F.FIELDVALUE,1,1) ,CASE WHEN TR_DASH_DT_OPTN = '1' THEN E.ASOFDATE ELSE %CurrentDateIn END ,CASE WHEN B.ASOFDATE IS NULL AND TR_DASH_DT_OPTN = '2' THEN %CurrentDateIn WHEN B.ASOFDATE IS NULL AND TR_DASH_DT_OPTN = '1' THEN E.ASOFDATE ELSE B.ASOFDATE END ,A.BNK_ID_NBR ,A.BANK_CD ,C.BANK_ACCOUNT_NUM ,C.BANK_ACCT_KEY , CASE WHEN B.CYCLE_STATUS <> ' ' THEN B.CYCLE_STATUS WHEN B.CYCLE_STATUS IS NULL THEN 'Y' END , E.OPRID FROM PS_BANK_CD_TBL A INNER JOIN PS_BANK_ACCT_DEFN C ON A.SETID=C.SETID AND A.BANK_CD=C.BANK_CD LEFT OUTER JOIN PS_BANK_STMT_HDR B ON A.BNK_ID_NBR = B.BNK_ID_NBR AND C.BANK_ACCOUNT_NUM = B.BANK_ACCOUNT_NUM LEFT OUTER JOIN PS_TR_DASH_BSL_CFG E ON 1 =1 , PSXLATITEM F WHERE A.BANK_TYPE='E' AND A.BANKING_SW='Y' AND A.BANK_STATUS = 'A' AND C.ACCT_STATUS = 'A' AND F.FIELDNAME='BNK_STMT_TYPE'

  • 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_C Date(10) DATE As Of Date
    4 ASOFDATE 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).