TR_ACT_BNK_VW1

(SQL View)
 Index Back

cash forecast sum tbl view

view on CSH_FCST_Sum on cash flow lines

SELECT DISTINCT (A.BANK_CD) ,D.DESCR ,D.CITY , D.COUNTRY , D.DESCR FROM PS_CSH_FCST_SUM A , PS_TR_CASH_POS_CFG C ,PS_BANK_CD_TBL D ,PS_BANK_BAL_DAILY E WHERE A.SETID = C.SETID AND A.SETID = D.SETID AND A.BANK_CD = D.BANK_CD AND A.WORKSHEET_ID = C.WORKSHEET_ID AND A.GROUP_BY_FIELD = 'BNK' AND A.SOURCE_SET = C.SOURCE_SET AND A.LINE_ITEM_TYPE ='1' AND A.POS_HIST_FLAG ='N' AND A.CALC_DT IN ( SELECT MAX(B.CALC_DT) FROM PS_CSH_FCST_SUM B WHERE B.SETID = A.SETID AND B.WORKSHEET_ID = A.WORKSHEET_ID AND B.SOURCE_SET = A.SOURCE_SET AND B.WRKSHEET_LINE_ITEM = A.WRKSHEET_LINE_ITEM AND B.VALUE_DT = A.VALUE_DT AND B.POSITION_CURRENCY = A.POSITION_CURRENCY AND B.GROUP_BY_FIELD = 'BNK' AND B.LINE_ITEM_TYPE ='1' AND B.POS_HIST_FLAG ='N' ) AND D.BNK_ID_NBR = E.BNK_ID_NBR

  • Related Language Record: TR_A_BNK_LG_VW1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 CITY Character(30) VARCHAR2(30) NOT NULL City
    4 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description