AJE83912 4th Qrt SDC Contract Interest

New Search

336ARS Payments 05/15/13 DC:INT:5/15/2013 ($68.68)($20.55)($89.23) ARS Payments 05/16/13 DC:INT:5/16/2013 ($13.79)($4.12)($17.91) ARS Payments 05/20/13 DC:INT:5/20/2013 ($7.67)($2.80)($10.47) ARS Payments 05/21/13 DC:INT:5/21/2013 ($105.01)($31.37)($136.38) ARS Payments 05/29/13 DC:INT:5/29/2013 ($1,937.55)($578.75)($2,516.30) ARS Payments 05/31/13 DC:INT:5/31/2013 ($190.81)($57.00)($247.81) ARS Payments 06/07/13 DC:INT:6/7/2013 ($138.87)($138.87) ARS Payments 06/10/13 DC:INT:6/10/2013 ($115.66)($34.56)($150.22) ARS Payments 06/11/13 DC:INT:6/11/2013 ($21.08)($6.32)($27.40) ARS Payments 06/12/13 DC:INT:6/12/2013 ($3.80)($1.13)($4.93) ARS Payments 06/13/13 DC:INT:6/13/2013 ($11.78)($3.52)($15.30) ARS Payments 06/17/13 DC:INT:6/17/2013 ($54.52)($16.28)($70.80) ARS Payments 06/20/13 DC:INT:6/20/2013 ($58.71)($18.15)($76.86) ARS Payments 06/24/13 DC:INT:6/24/2013 ($9.07)($2.71)($11.78) ARS Payments 06/25/13 DC:INT:6/25/2013 ($3.24)($0.97)($4.21) ARS Payments 06/26/13 DC:INT:6/26/2013 ($33.76)($10.08)($43.84) ARS Payments 06/27/13 DC:INT:6/27/2013 ($24.46)($7.32)($31.78) ARS Payments 06/28/13 DC:INT:6/28/2013 ($59.84)($17.88)($77.72) 336 Total($5,641.46)($1,645.45)($7,286.91) Grand Total($9,177.13)($5,137.83)($14,314.96) SQL Stmt SELECT GL_MASTER.FUND_CODE, GL_MASTER.ACCOUNT, GL_MASTER.ACCT_PERIOD, GL_DETAIL.JE_DESC, GL_DETAIL.JE_AMOUNT FROM QUERY_GL.dbo.GL_DETAIL GL_DETAIL, QUERY_GL.dbo.GL_MASTER GL_MASTER 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 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 AND GL_DETAIL.PROGRAM_CODE = GL_MASTER.PROGRAM_CODE AND GL_DETAIL.PROJECT_ID = GL_MASTER.PROJECT_ID AND ((GL_MASTER.FISCAL_YEAR='2013') AND (GL_MASTER.FUND_CODE Like '33%') AND (GL_MASTER.ACCT_PERIOD In (10,11,12)) AND (GL_MASTER.ACCOUNT In ('47125','47126')))