New Search
336 <br />ARS Payments 12/15/14 DC:INT:12/15/2014 ($5.80)($1.73)($7.53) <br />ARS Payments 12/18/14 DC:INT:12/18/2014 ($18.45)($5.51)($23.96) <br />ARS Payments 12/19/14 DC:INT:12/19/2014 ($46.33)($13.84)($60.17) <br />ARS Payments 12/22/14 DC:INT:12/22/2014 ($3.03)($2.43)($5.46) <br />ARS Payments 12/23/14 DC:INT:12/23/2014 ($14.87)($4.44)($19.31) <br />ARS Payments 12/24/14 DC:INT:12/24/2014 ($2.52)($0.75)($3.27) <br />ARS Payments 12/26/14 DC:INT:12/26/2014 ($33.65)($10.06)($43.71) <br />336 Total($1,432.16)($432.01)($1,864.17) <br />Grand Total($3,955.40)($3,318.21)($7,273.61) <br />SQL Stmt <br />SELECT GL_MASTER.FUND_CODE, GL_MASTER.ACCOUNT, GL_MASTER.ACCT_PERIOD, GL_DETAIL.JE_DESC, GL_DETAIL.JE_AMOUNT <br />FROM QUERY_GL.dbo.GL_DETAIL GL_DETAIL, QUERY_GL.dbo.GL_MASTER GL_MASTER <br />WHERE GL_DETAIL.ACCOUNT = GL_MASTER.ACCOUNT AND GL_DETAIL.ACCT_PERIOD = GL_MASTER.ACCT_PERIOD AND GL_DETAIL.CLASS_FLD = GL_MASTER.CLASS_FLD <br />AND GL_DETAIL.DEPTID = GL_MASTER.DEPTID AND GL_DETAIL.FISCAL_YEAR = GL_MASTER.FISCAL_YEAR AND GL_DETAIL.FUND_CODE = GL_MASTER.FUND_CODE <br />AND GL_DETAIL.PROGRAM_CODE = GL_MASTER.PROGRAM_CODE AND GL_DETAIL.PROJECT_ID = GL_MASTER.PROJECT_ID AND ((GL_MASTER.FISCAL_YEAR='2015') <br />AND (GL_MASTER.FUND_CODE Like '33%') AND (GL_MASTER.ACCT_PERIOD In (4,5,6)) AND (GL_MASTER.ACCOUNT In ('47125','47126'))) <br />