Line 1
Unit
The building + unit number. For instance, 01-A101.
Name
The primary occupant name. For instance, Sally
Smith.
Table
The lease table, which tracks current balances
in order to optimize reporting speed.
Security
The amount of security deposit (Sec 1) on hand.
Other Deposit
The amount of other security deposit on hand (Sec
2) on hand.
Beginning Balance
The resident's beginning balance. Beginning Balance
is a field in the lease table that maintains what the balance was at the
beginning of the current period.
Billed
The total amount billed to the resident this month.
Paid
The total amount collected from the resident this
month.
Future
This field shows the amount of any future net
change. Typically this amount is 0, which indicates that a transaction
has a date of record in a future accounting period.
Ending Balance
Ending balance is equivalent to the resident's
current balance.
Line 2
Table
The open item table.
Security
N/A; security on hand is not tracked in the Open
Items table.
Other Deposit
N/A; other deposit on hand in not tracked in the
Open Items table.
Beginning Balance
N/A; the monthly beginning balance is not tracked
in the Open Items table.
Billed
N/A; billed this month is not tracked in the Open
Items table.
Paid
N/A; paid this month is not tracked in the Open
Items table.
Future
N/A; future detail is not tracked in the Open
Items table.
Ending Balance
The sum of open item balance due.
Line 3
Table
The transaction table, listed by name or number.
Security
The sum of transaction detail amounts where the
transaction income code type is Security.
Other Deposit
The sum of transaction detail amounts where the
transaction income code type is Other.
Beginning Balance
The sum of transaction detail amounts where the
transaction income code Receivable flag is set to Y, and the transaction
GL period is prior to the current accounting period. Note, the transaction
types 3 (payment), 4 (forfeit) and 8 (write-off) decrease this amount.
Billed
The sum of transaction detail amounts where the
transaction income code Receivable flag is set to Y, the transaction GL
period is the current accounting period, and the transaction type is 1
(recurring charge), 2 (adjustment), 5 (refund) , or 9 (one-time charge).
Paid
The sum of transaction detail amounts where the
transaction income code Receivable flag is set to Y, the transaction GL
period is the current accounting period, and the transaction type is 3
(payment), 4 (forfeit) or 8 (write-off).
Future
The sum of transaction detail amounts where the
transaction income code Receivable flag is set to Y, and the transaction
GL period is after the current accounting period.
Ending Balance
This number is calculated as Beginning Balance
+ Billed + Paid + Future.
Report Details