FR_WS_GRID_VW

(SQL View)
 Index Back

Cash Flows Worksheet Lines

Cash Flows Worksheet Lines

SELECT C.OPRID , A.WORKSHEET_ID , A.LINE_NBR , C.FR_REPORT_ENTITY , A.FR_BALANCE_TYPE , B.CURRENCY_CD , COUNT(*) , SUM(B.BEGINNING_BAL) , SUM(B.ENDING_BAL) , SUM(B.TOTAL_NET_AMT) , SUM(B.OVERRIDE_AMOUNT) , SUM(B.FR_FX_ADJUSTMENT) FROM PS_FR_WORKSHT_LN A , PS_FR_WORKSHT_GRID B , PS_FR_WS_BU_SEL C WHERE B.WORKSHEET_ID = A.WORKSHEET_ID AND B.FR_ELEMENT_ID = A.FR_ELEMENT_ID AND C.WORKSHEET_ID = B.WORKSHEET_ID AND C.BUSINESS_UNIT = B.BUSINESS_UNIT GROUP BY C.OPRID, A.WORKSHEET_ID, A.LINE_NBR, C.FR_REPORT_ENTITY, A.FR_BALANCE_TYPE, B.CURRENCY_CD

  • Parent record: FR_WORKSHT_TBL

    • # 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 WORKSHEET_ID Character(20) VARCHAR2(20) NOT NULL Cash Flows Worksheet ID
    3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    4 FR_REPORT_ENTITY Character(20) VARCHAR2(20) NOT NULL Report Entity
    5 FR_BALANCE_TYPE Character(1) VARCHAR2(1) NOT NULL Balance Type
    1=Beginning Balance
    2=Ending Balance
    3=Balance Variance
    4=Foreign Exchange Adjustment
    6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    7 ROW_COUNT Number(8,0) INTEGER NOT NULL Number to Purge
    8 BEGINNING_BAL Signed Number(28,3) DECIMAL(26,3) NOT NULL The bank statement beginning balance for a given bank account.
    9 ENDING_BAL Signed Number(28,3) DECIMAL(26,3) NOT NULL The bank statement end of day account balance
    10 TOTAL_NET_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Net Amount
    11 OVERRIDE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Override amount
    12 FR_FX_ADJUSTMENT Signed Number(28,3) DECIMAL(26,3) NOT NULL Foreign Currency Exchange Adjustment Amount