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.