New Search
Expenditure Detail for all years >=1999 by project number <br /> 61512009 Printed Date <br /> Sum ofAMOUNT <br /> FUND 1 DESC ACCOUNT ACCOUNT DESC Total <br /> 535 -Stormwater Utility -Operation 51100 Regular Wages 5,829.42 <br /> 56002 FICA 352.70 <br /> 56003 Workers' Compensation 2.66 <br /> 56007 Medicare 82.43 <br /> 56100 PERS EE 349.74 <br /> 56101 PERS ER 800.37 <br /> 56104 PERS Pension Bond UAL 320.60 <br /> 57001 Long Term Disability 13.91 <br /> 57003 Life Insurance 14.84 <br /> 57004 Health Benefit Charges 998.02 <br /> 535 -Stormwater Utility -Operation Total 8,764.69 <br /> 631 -ENG -Professional Services 51100 Regular Wages 5,829.42 <br /> 56002 FICA 352.71 <br /> 56003 Workers' Compensation 2.65 <br /> 56007 Medicare 82.40 <br /> 56100 PERS EE 349.75 <br /> 56101 PERS ER 800.38 <br /> 56104 PERS Pension Bond UAL 320.61 <br /> 57001 Long Term Disability 13.90 <br /> 57003 Life Insurance 14.83 <br /> 57004 Health Benefit Charges 998.05 <br /> 61891 Engineer & Design Fees-PSF 20,230.35 <br /> 631 -ENG -Professional Services Total 28,995.05 <br /> Grand Total 37,759.74 <br /> SELECT GL_PROJECT.PROJECT_ID AS'PROJECT ID', GL_PROJECT.PROJECT_DESC AS'PROJ DESC, GL_ACCOUNT.ACCOUNT, <br /> GL_ACCOUNT.ACCOUNT_DESC AS'ACCOUNT DESC, GL_DETAIL.CLASS_FLD AS'GRANT', GL_DETAIL.DEPTID, <br /> GL_DETAIL.FUND_CODE+'- '+gl_fund.fund_desc AS'FUND /DESC', GL_DETAIL.JOURNAL_DATE AS'JRNL DT', <br /> GL_DETAIL.JE_AMOUNT AS 'AMOUNT', GL_DETAIL.JE_DESC AS 'DESCRIPTION', GL_DETAIL.JOURNAL_ID AS 'JRNL ID', <br /> GL_DETAIL.POSTED_DATE AS'POSTED DT', GL_DETAIL.JE_DOC_REF AS'JRNL REFERENCE' <br /> FROM QUERY_GL.dbo.GL_A000UNT GL_ACCOUNT, QUERY_GL.dbo.GL_DETAIL GL_DETAIL, QUERY_GL.dbo.GL_PROJECT GL_PROJECT <br /> QUERY_GL.dbo.GL_FUND GL_FUND, <br /> WHERE GL PROJECT.PROJECT ID = GL DETAIL.PROJECT ID AND GL DETAIL.A000UNT = GL ACCOUNT.ACCOUNT <br /> <br /> AND GL_FUND.FUND_CODE = GL_DETAIL.FUND_CODE AND ((GL_PROJECT.PROJECT_ID='647025') AND (GL_DETAIL.JE_AMOUNT<>0) <br /> <br /> AND (GL_DETAIL.ACCT_PERIOD<14) AND (GL_DETAIL.FISCAL_YEAR>='1999')) <br /> <br />