i
<br /> 47110 Interest Onlnvestments 6 (45,110.00) (41,958.00} (4,255.00) (121,$95.00}
<br /> 9 (51,127.00) (25,770.00) (117,878.00} YTD {$17,181.00)
<br /> 12 (49,$65.00} (100,252.00} last Qrt x2 ($8.510.00)
<br /> j 13 (21:878.00) (21,878.00} ($25,691.00)
<br /> 47110 Total 204,003.00 {142,475.00. 17,181.00 (518,461.00} (25,691) ~ ~ ~ s'
<br /> 47111 Int on Investments FMV Adj 2 {14,584.00) {14,584.00)
<br /> 13 14,584.00 ,
<br /> 47111 Total 14,584.00) 0.00
<br /> ` 47125 Interest on SDC Contracts 1 0.00 (1,455.46) (5.09} (1,792.42}
<br /> 2 (228.45} (79.70) (130.15} {642.?_4}
<br /> 3 (629.32) (1,598.55) (2,662.72}
<br /> 4 (366.58) (289.24) (761.26) (2,437.66}
<br /> I 5 (66.44 j (283.51 } {513.59) (966.18}
<br /> 6 (633.25} {666.37} (341.97) (2,483.93}
<br /> 7 {4.55) {1,754.68) {1,221.65) (3,066.32)
<br /> 8 (187.62) (168.$7) (410.94}
<br /> 9 (21.98) {45.37) {269.65}
<br /> 10 (948.99) {702.07) (1,977.88} YTD Actuals ($2,973.71 j
<br /> ~ 11 {96.37) (129.39) (41fi.15} .Scheduled ($1,766.53)
<br /> ~ ~ 12 {594.18) {1,591.38} (2,935.51} ($4,740.24}
<br /> 47125 Total 3,777.73 8,764.59 2,973.71 20,061.60 (4,740)
<br /> ~ 47126 Interest SDC Cont - Reimb C 1 0.00 0.00
<br /> 4 {29.57) (29.57)
<br /> 5 (20.05} (20.05}
<br /> 6 (102.15) {102.15)
<br /> 7 (179.31) (27.37) (206.68)
<br /> 8 (17.62) (17.62)
<br /> 10 (27.71) {27.71) YTDActuals ($179.14)
<br /> 11 (16.49) {16.49} Scheduled ($527.66)
<br /> 12 {10.98) (10.98) {$706.80)
<br /> 47126 Total (252.11 179.14 431.25 (707)
<br /> 49304 Intrafund Loan P 1 0.00 0.00 0.00
<br /> 12 (300,000.00} {600,0o6.ooj
<br /> j 13 285,000AO 285,OOOAO
<br />
<br /> ~i 49304 Total 300,000.00 285,000.00. 885,000.00
<br /> 49305 ' Intrafund Interest I 1 0.00 0.00 0:00
<br /> 12 (29,367.00) {64,856.00)
<br /> 'I, 13 (13,016.00 13,016,00
<br /> ~ 49305 Total 29,367.00 13,016.00 77,872.00
<br /> ~ 49900 Beginning Working Capital 1 0.00 0.00 ~ 0.00 0.00
<br /> j 6 0.00 0.00 0.00 0.00
<br /> ' 49900 Total 0.00 0.00 0.00 0.00
<br /> ` Grand Total 1,254,033.35 (1,946,862.08 436,281.90 5,835,696.62 (747,741)
<br /> I
<br /> SQL Statement
<br /> ' SELECT GL ACCOUNT.ACCOUNT, GL ACCOUNT.ACCOUNT DESC, GL MASTER.ACCT_PERIOD, GL MASTER.ACTUAL AMOUNT, GL MASTERFISCAL_YEAR
<br /> FROM OUERY_GL.dbo.GL ACCOUNT GL_ACCOUNT, OUERY_GL.dbo.GL_MASTER GL MASTER
<br /> ' WHERE GL ACCOUNT.ACCOUNT=GL_MASTERACCOUNT AND ((GL MASTERFISCAL_YEAR>=2003')
<br /> ~ AND (GL_MASTER.ACCT_PERIOD<=73)RND (GL_MASTERFUND_CODE=338')RND (GL_ACCOUNT.ACCOUNT Like'4Ye1)
<br /> Sum 44xxx (79,729} kt r
<br /> Sum 45xxx {636,874}
<br /> ~ Sum 47xxx {31,138)
<br /> (747,741}
<br /> i
<br /> j
<br /> 7
<br /> ~ ,
<br /> i
<br /> I
<br /> I
<br /> j
<br /> j
<br /> j
<br />
<br /> 1
<br />
<br />
|