New Search
336ARS Payments 11/12/13 DC:INT:11/12/2013 ($194.44)($58.08)($252.52) <br />ARS Payments 11/15/13 DC:INT:11/15/2013 ($10.90)($3.26)($14.16) <br />ARS Payments 11/18/13 DC:INT:11/18/2013 ($47.79)($14.31)($62.10) <br />ARS Payments 11/20/13 DC:INT:11/20/2013 ($6.54)($2.77)($9.31) <br />ARS Payments 11/21/13 DC:INT:11/21/2013 ($84.04)($84.04) <br />ARS Adjustments 11/08/13 DC2012005239020:OFF:11/8/2013 ($67.92)($67.92) <br />ARS Payments 11/22/13 DC:INT:11/22/2013 ($14.42)($4.31)($18.73) <br />ARS Payments 11/25/13 DC:INT:11/25/2013 ($8.77)($2.62)($11.39) <br />ARS Payments 11/26/13 DC:INT:11/26/2013 ($1,815.80)($542.38)($2,358.18) <br />ARS Payments 12/02/13 DC:INT:12/2/2013 ($150.97)($45.09)($196.06) <br />ARS Payments 12/03/13 DC:INT:12/3/2013 ($9.85)($2.94)($12.79) <br />ARS Payments 12/04/13 DC:INT:12/4/2013 ($24.54)($7.33)($31.87) <br />ARS Payments 12/10/13 DC:INT:12/10/2013 ($68.50)($20.46)($88.96) <br />ARS Payments 12/12/13 DC:INT:12/12/2013 ($62.08)($18.54)($80.62) <br />ARS Payments 12/16/13 DC:INT:12/16/2013 ($53.01)($15.83)($68.84) <br />ARS Payments 12/20/13 DC:INT:12/20/2013 ($48.30)($15.30)($63.60) <br />ARS Payments 12/23/13 DC:INT:12/23/2013 ($490.34)($2.07)($492.41) <br />ARS Payments 12/24/13 DC:INT:12/24/2013 ($10.88)($3.27)($14.15) <br />ARS Payments 12/27/13 DC:INT:12/27/2013 ($2.74)($0.82)($3.56) <br />336 Total($5,338.44)($1,427.70)($6,766.14) <br />Grand Total($10,281.85)($6,894.01)($17,175.86) <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='2014') <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 />