AJE 91722 FY15 Qrtrly SDC Int Bump Calc

New Search

336ARS Payments 02/09/15 DC:INT:2/9/2015 ($66.90)($19.98)($86.88) ARS Payments 02/10/15 DC:INT:2/10/2015 ($105.55)($31.52)($137.07) ARS Payments 02/13/15 DC:INT:2/13/2015 ($19.07)($5.70)($24.77) ARS Payments 02/17/15 DC:INT:2/17/2015 ($35.42)($10.58)($46.00) ARS Payments 02/19/15 DC:INT:2/19/2015 ($67.41)($20.14)($87.55) ARS Payments 02/20/15 DC:INT:2/20/2015 ($2.23)($2.26)($4.49) ARS Payments 02/23/15 DC:INT:2/23/2015 ($9.43)($2.82)($12.25) ARS Payments 02/24/15 DC:INT:2/24/2015 ($48.26)($14.41)($62.67) ARS Payments 02/26/15 DC:INT:2/26/2015 ($22.28)($6.65)($28.93) ARS Payments 03/04/15 DC:INT:3/4/2015 ($384.31)($114.80)($499.11) ARS Payments 03/06/15 DC:INT:3/6/2015 ($12.16)($3.63)($15.79) ARS Payments 03/13/15 DC:INT:3/13/2015 ($34.29)($10.27)($44.56) ARS Payments 03/17/15 DC:INT:3/17/2015 ($4.07)($1.21)($5.28) ARS Payments 03/20/15 DC:INT:3/20/2015 ($1.75)($2.01)($3.76) ARS Payments 03/26/15 DC:INT:3/26/2015 ($741.97)($221.62)($963.59) ARS Payments 03/27/15 DC:INT:3/27/2015 ($65.04)($19.42)($84.46) ARS Payments 03/31/15 DC:INT:3/31/2015 ($22.04)($6.58)($28.62) 336 Total($4,863.62)($1,341.67)($6,205.29) Grand Total($7,026.00)($3,683.65)($10,709.65) 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='2015') AND (GL_MASTER.FUND_CODE Like '33%') AND (GL_MASTER.ACCT_PERIOD In (4,5,6)) AND (GL_MASTER.ACCOUNT In ('47125','47126')))