## Appendix: Tables Used in JD Edwards EnterpriseOne Advanced Real Estate Forecasting

This appendix provides a list of the tables that are used in JD Edwards EnterpriseOne Advanced Real Estate Forecasting.

### Tables Used in JD Edwards EnterpriseOne Advanced Real Estate Forecasting

This table lists the tables used by JD Edwards EnterpriseOne Advanced Real Estate Forecasting in alphanumeric order:

Table Number | Table Name | Description
F15L001W | Work File for R15L001 | Stores records by tenant when you generate the AREF Lease Revenue by Type report (R15L001). The table is subsequently cleared after each generation of the report.
F15L100 | AREF Building Constants | Stores default rules for assumptions, expense participation, sales overage, rent and nonrent bill codes, and growth patterns. The building constants also include management fee information needed for budget calculations as well as the initial purchase price and cap rate, discount rate, and selling cost percentages.
F15L1001 | AREF Building Constants Model | Stores the same information as the F15L100 table, but also includes the model ID and description.
F15L101 | AREF Unit Master | Stores unit and lease information that is manually added or downloaded from JD Edwards EnterpriseOne Real Estate Management. This information includes square footage, unit type, unit description, tenant, lease number, and lease begin and end dates.
F15L102 | AREF Unit Assumptions Master Header | Stores information for budget calculations including market rates, growth patterns, downtime, free rent number of months, and assumption terms.
F15L103 | AREF Sales Overage Rule Header | Stores the sales overage rule information, such as the sales overage rule, growth pattern, an option to calculate and use a natural breakpoint, and the computation method.
F15L104 | AREF E.P. Rules Header | Stores expense participation information for budget calculations including E.P. rule, rule type, and recovery type.
F15L105 | AREF Growth Pattern File | Stores a total of 15 yearly amounts of growth rates to be used in the budget calculations.
F15L106 | AREF Recurring Bill Code Rules Header | Stores the recurring bill code rule information such as the building and revision numbers, the name of the rule, and report codes.
F15L107 | AREF Recycle Assumption Rules | Stores recycle rules information.
F15L109 | AREF Budget Results | Stores the calculated budget results including revision number, object account, subledger and subledger type, account ID, and net posting amounts 1 through 12.
F15L109W | AREF Grown Amounts Work File | Stores growth values for the business unit, assumption ID, assumption type and revision number that is used to grow amounts for the budget calculations.
F15L110 | AREF Account Status | Stores amounts by period for accounts that are retrieved from the Account Balances table (F0902) and/or Budget Results table (F15L109).
F15L111 | AREF Account Status Detail | Stores amounts by periods for amounts that are overridden by the user.
F15L112 | AREF Unit Assumptions Master Detail | Stores information for detailed budget calculations of commission, tenant improvements, and other assumptions including assumption type, calculation method, posting bill code or object account, and retrieval bill codes.
F15L113 | AREF Sales Overage Detail | Stores the breakpoint sales amount and breakpoint sales percent for forecasting sales overage amounts.
F15L114 | AREF E.P. Rules Detail | Stores E.P. class, E.P. code, computation method, expense stop per square foot, amount per square foot, growth pattern, denominator, and exclusion rules for expense participation budget calculations.
F15L116 | AREF Recurring Bill Code Rules Detail | Stores the same information that is in the AREF Recurring Bill Code Rules Header table, but also includes the bill codes that make up the recurring bill code rule, as well as the value for the rent flag, and growth pattern, if applicable.
F15L120 | AREF Account Association | Stores information to define account setup for association codes, including building, revision number, account ID, object account, and subsidiary.
F15L141 | AREF Gross Lease Occupied Area | Stores occupancy information including building, revision number, unit, GLOA, GLA, and area type that the system uses for expense participation if you specify to use a share factor denominator or tenant exclusion rule.
F15L301 | AREF Projected Sales | Stores information from the F1542 table from JD Edwards EnterpriseOne Real Estate Management, including lease number, unit, revision number, and estimated sales amounts for periods 1 through 12.
F15L302 | AREF Prior Gross Billings | Stores the sales overage billing amounts that the system calculates for each period.
F15L38 | EP Billing Register | Stores the calculated amounts for expense participation.