A Tables Used in Enhanced Real Estate Management

This appendix contains the following topics:

A.1 JD Edwards EnterpriseOne Enhanced Real Estate Management Tables

JD Edwards EnterpriseOne Enhanced Real Estate Management stores information in these tables:

Table Description
Business Unit Tag

F74U006T

Contains additional property information, including billing tax codes/rates, expense tax codes/rates with effective tax dates and contact details.
Bill Pattern Mapping

F74U0208

Contains additional billing pattern information.
Global Generation Currency Work table

F74U210W

Contains the lease currency code that is used in expense participation.
Tenant EP Class Tag

F74U012T

Contains expense participation setup information, including the tenant participation period, occupancy period, gross-up factor, share factor, lease end dates, bill pattern and payment method.
Lease Master Tag

F74U01BT

Contains additional lease information, including bank codes, interest adjustment percentages, currency codes, and exchange rates.
Recurring Billing Tag

F74U02BT

Contains billing information for the lease, including the billing pattern, payment method and annual rent amount.
Property Unit Tag

F74U071T

Contains additional unit information, including billing tax codes/rates, expense tax codes/rates, effective tax dates, and contact details.
Property Company Constants

F74U0201

Contains company rules for lease, accounting and tax processing.
Bank Base Rates

F74U0202

Contains annual bank base rates with effective dates.
Lease Master Alternative UOM Tag

F74U03BT

Contains alternative unit of measure conversion for lease rentable and usable areas.
Billing Pattern-Periodic

F74U203A

Contains periodic billing pattern information for recurring billings and expense participation.
Billing Pattern -Weekly

F74U203B

Contains weekly billing pattern information for recurring billings.
Payment Profile Status History

F74U207A

Contains payment profile status history.
Periodic Accounting Profile Status History

F74U207B

Contains periodic accounting profile status history
Weekly Accounting Profile Status History

F74U207C

Contains weekly accounting profile status history.
Interest Tag

F74U25BT

Contains fee and interest information, including charges, bank rates, interest rates, and calculation patterns.
Payment Profile

F74U0205

Contains payment profile of recurring and manual billings.
Status Code

F74U0209

Contains status codes for the payment and accounting profiles.
Accounting Billing Profile

F74U0212

Contains periodic accounting profile of recurring billings.
Accounting Profile - Weekly

F74U0213

Contains weekly accounting profile of recurring billings.