New Search
336ARS Payments 02/20/13 DC:INT:2/20/2013 ($65.68)($20.02)($85.70) <br />ARS Payments 02/22/13 DC:INT:2/22/2013 ($8.33)($2.49)($10.82) <br />ARS Payments 02/25/13 DC:INT:2/25/2013 ($10.91)($5.52)($16.43) <br />ARS Payments 02/28/13 DC:INT:2/28/2013 ($132.61)($39.62)($172.23) <br />ARS Payments 03/01/13 DC:INT:3/1/2013 ($48.79)($14.57)($63.36) <br />ARS Payments 03/04/13 DC:INT:3/4/2013 ($70.10)($20.94)($91.04) <br />ARS Payments 03/06/13 DC:INT:3/6/2013 ($142.42)($42.54)($184.96) <br />336 Total($2,358.80)($510.47)($2,869.27) <br />Grand Total($4,482.64)($2,445.84)($6,928.48) <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='2013') <br />AND (GL_MASTER.FUND_CODE Like '33%') AND (GL_MASTER.ACCT_PERIOD In (7,8,9)) AND (GL_MASTER.ACCOUNT In ('47125','47126'))) <br />