A Database Overview
This appendix contains these topics:
-
Section A.5, "Real Estate Management - Sales Overage and Sales Analysis,"
-
Section A.7, "Real Estate Management - Expense Participation,"
This appendix is a list of the primary, secondary, and supporting files that the Property Management system uses. The chapter also includes flowcharts that show the relationship between the principal physical files within the system. The charts flow left to right and top to bottom. Control files are on the left side of the chart, master files are toward the center, and transaction files are on the right.
Note:
To keep from being cluttered, the flowchart does not contain the less important control files and workfiles and the files for features that are not commonly used. For a list of minor G/L files, see the JD Edwards World General Accounting I Guide.A.1 Primary Files
| File | Description |
|---|---|
| F0006 | Building (Business Unit) Master |
| F0101 | Address Book Master |
| F0311 | A/R Account Ledger |
| F0411 | A/P Account Ledger |
| F0901 | Account Master |
| F0902 | Account Balances |
| F0911 | G/L Account Ledger |
| F1501 | Tenant/Lease Master |
| F1511 | Tenant/Lease Billings Detail |
| F4801 | Work Order Master |
| F4802 | Work Order Instructions |
A.2 Secondary Files
A.2.1 Facility Information
| File | Description |
|---|---|
| F1506 | Floor Master |
| F1507 | Unit Master |
| F15071 | Unit Status/Activity |
A.2.2 Billings
| File | Description |
|---|---|
| F15011 | Billings Generation Control Master |
| F1502 | Recurring Billings Master |
| F1512 | Billing Code Extension |
| F1513 | FASB 13 Lease Control |
| F1516 | Extended Invoice Text |
| F1520 | Lease Financial Summary |
| F1521 | Business Unit Financial Summary |
A.2.3 Sales Overage
| File | Description |
|---|---|
| F15013 | Sales Overage Master |
| F15014 | Product Scales Master (Sales Overage Detail) |
| F15015 | Minimum Rent/Recoveries Master |
| F1540 | Sales Reporting Control |
| F1541 | Tenant Sales History |
A.2.4 Sales Analysis
| File | Description |
|---|---|
| F1543 | Sales Analysis Reporting |
| F1544 | Sales Analysis (Summary) Control |
| F1545 | Square Footage History |
| F1546 | Square Footage Comparison Log |
A.2.5 Expense Participation
| File | Description |
|---|---|
| F15012 | Tenant Class Master |
| F1502W | Estimated Expense Participation Recurring Billings |
| F15100 | Expense Class Amounts |
| F15110 | Accounts by Expense Participation |
| F1530 | Expense Participation Class Master |
| F1531 | Expense Participation Class Adjustment |
| F1532 | Expense Participation Audit |
| F1533 | Tenant Class Account Exclusion |
| F1538 | Expense Participation Billing Register (Calculation Details) |
A.2.6 Escalation
| File | Description |
|---|---|
| F15016 | Tenant Escalation Master |
| F1548 | Escalation Billing Register (Calculation Details) |
| F1550 | Escalation Index Master |
A.3 Supporting Files
| File | Description |
|---|---|
| F0005 | User Defined Codes |
| F0008 | Fiscal Date Patterns |
| F0009 | General Constants |
| F0010 | Company Constants |
| F0011 | Batch Control Records |
| F0012 | Automatic Accounting Instructions Master |
| F0014 | Payment Terms |
| F0018 | Sales/Use/V.A.T. Tax |
| F0019 | Generic Message/Rate Types |
| F00191 | Generic Message/Rates |
| F00192 | General Message Detail |
| F0111 | Address Book - Who's Who |
| F0116 | Address Book by Date |
| F0301 | Customer Master |
| F0315 | A/R Credit/Cash Management |
| F0401 | Supplier Master |
| F15018 | DBA Master |
| F1503 | Log Standards Master |
| F1504 | Log Standards Extension Master |
| F1509 | Collection Activity Rules |
| F1510 | Property Management Constants |
| F1511H | Billings Detail History (for late fees and sales overage) |
| F1515 | Tenant Receivable Cash Management |
| F1526 | Collection Transaction Log |
| F1527 | Collection Transaction Log-Additional Text |
| F1590 | PRO-JECT Initial Generation |
| F1595 | PRO-JECT Final Generation |
| F4008 | Tax Area Master |
A.4 Real Estate Management - Base
A.5 Real Estate Management - Sales Overage and Sales Analysis
Figure A-2 Sales Overage and Sales Analysis
Description of "Figure A-2 Sales Overage and Sales Analysis"
