SELECT PropertyFK, PeriodYear, PeriodQuarter, [1] AS [Cash], [2] AS [Accounts Receivable Tenants], [3] AS [Accounts Receivable Other],
[4] AS [Prepaid Expenses], [5] AS [Tenant Security Deposits], [6] AS [Other Current Assets], [7] AS [Replacement Reserves],
[8] AS [Tax and Escrow Insurance], [9] AS [Operating Reserve], [10] AS [Other Reserve], [11] AS [Land], [12] AS [Buildings],
[13] AS [Equipment and Furniture], [14] AS [Accumulated Depreciation], [15] AS [AR Syndication Proceeds], [16] AS [Amortized Expenses],
[17] AS [Other Assets], [18] AS [Accounts Payable], [19] AS [Accrued Expense], [20] AS [Accrued Interest], [21] AS [Accrued Property Tax],
[22] AS [Tenant Security Deposit Liability], [23] AS [Current Notes Payable], [24] AS [Other Current Liabilities], [25] AS [Hard Long Term Debt],
[26] AS [Deferred Soft Debt], [27] AS [Deferred Soft Interest], [28] AS [Debt Added], [29] AS [GP Loans], [30] AS [Development Fee Payable],
[31] AS [Accrued LP Fees Payable], [32] AS [Accrued GP Fees Payable], [33] AS [Other Long Term Liabilities], [34] AS [Limited Partners Capital],
[35] AS [General Partners Capital], [36] AS [Other Capital Account]
FROM (SELECT dbo.AccountBalance.PropertyFK, dbo.AccountBalance.PeriodYear, dbo.AccountBalance.PeriodQuarter, dbo.AccountBalance.AccountFK,
dbo.AccountBalance.Amount
FROM dbo.AccountBalance INNER JOIN
dbo.LUAccount ON dbo.AccountBalance.AccountFK = dbo.LUAccount.AccountID INNER JOIN
dbo.LUAccountCategory ON dbo.LUAccount.AccountCategoryFK = dbo.LUAccountCategory.AccountCategoryID INNER JOIN
dbo.LUAccountType ON dbo.LUAccountCategory.AccountTypeFK = dbo.LUAccountType.AccountTypeID
WHERE (dbo.LUAccountType.StatementTypeFK = 1)) A PIVOT (SUM(Amount) FOR AccountFK IN ([1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12], [13],
[14], [15], [16], [17], [18], [19], [20], [21], [22], [23], [24], [25], [26], [27], [28], [29], [30], [31], [32], [33], [34], [35], [36])) B