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 is the AREF Recurring Bill Code Rules Header table, but also includes the bill codes that comprise the recurring bill code rule, 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.