B JD Edwards EnterpriseOne Homebuilder Management Tables

This appendix contains the following topics:

B.1 Tables Used With Homebuilder Management

This table lists the tables that JD Edwards EnterpriseOne Homebuilder Management uses to process purchasing, construction, sales, and financial transactions:

Table Name and Table Number Contents
Homebuilder Constants Lot Start Documents (F44H0011) Contains information about the Procurement Order Types used in the JD Edwards EnterpriseOne Homebuilder Management system.
Homebuilder Constants (F44H001) Contains the constants used in the JD Edwards EnterpriseOne Homebuilder Management system.
Homebuilder Activity Rules (F44H002) Contains setup information for construction and sales activity rules, including allowed statuses and history to be captured for each activity.
Extended Homebuilder Data Template (F44H0920) Contains the user-defined data keys that are associated with each data type.
Extended Homebuilder Data Headings (F44H0921) Contains the specific data elements and modified column titles for the selected extended data.
Extended Homebuilder Data (F44H0929) Contains the extended data for any of these seven data types: area, community, lot, option, phase, plan, and sales.
Community Phase Master (F44H101) Contains all of the master information for communities, including general description, number of lots, activity rule types, tax information, category codes, closing worksheet template, user dates, and other information.
Lot Master (F44H201) Contains all of the master information for lots, including address; general description; cost code and schedule template overrides; release and construction dates; permit information; house color schemes; additional date and amount fields; and other information.
Plan Master (F44H301) Contains all of the master information for plans, including general description; associated elevations; cost code and schedule templates; base prices; user-defined category codes and dates; and other information.
Option Master (F44H401) Contains all of the master information for options, including general description; assignment to area, community, phase, plan, and elevation; sales prices with effective dates; designation of option package or custom option, category code, date and amount fields; and other information.
Option Packages (F44H402) Contains information for linking options with appropriate quantities and effective dates when they are sold together as a package.
Item Master Homebuilder Extension (F44H4101) Contains the Homebuilder-specific information used in the Item Master.
Sales Master (F44H501) Contains all of the sales information for the lot, including lot configuration (plan, elevation, and swing), buyer address book number, sales and close dates, sales activity statuses, contingency information, cancellation information, loan information, sales prices, and other information.
Sales Master History (F44H501H) Contains the sales history information for a lot, such as changes to plan and elevation, sale cancellations, transfers, and closings. Records written to this file are controlled by the user-defined sales activity rules.
Option Selections (F44H511) Contains option selection information for each lot, such as selection quantity, unit price, and extended price.
Option Selection History (F44H511H) Contains all history information for option selections on a lot, including option reversals.
Closing Worksheet Accounting Instructions (F44H590) Contains the setup information for sales closings templates, including business unit source instructions; object, subsidiary, and subledger accounts; amounts, and ledger types.
Closing Worksheet Entries (F44H591) Contains the closing entry information for each closed lot, including all account numbers and corresponding amounts.
Closing Worksheet Data Mapping (F44H599) Contains the setup information that links a field used during lot close with a closing worksheet line number and description.
Bid Header (F44H601) Contains the commitment header information, including the bid number and description, document type and company, community number, supplier number, tax information, and other unique information assigned to the bid.
Takeoff Master File (F44H602) Contains all takeoff master information necessary to process takeoffs, including area, community, phase, plan, elevation, option, item number, item quantity, cost type, cost code, and other information.
Takeoff History File (F44H602H) Contains all information related to changes to takeoff records, including reason code and quantity changes.
Material Item Pricing (F44H603) Contains information related to the pricing of an item for a supplier, including the price amount, effective and expiration dates, lead times, and other information.
Supplier Assignment (F44H604) Contains information for assigning a specific supplier to the bid and takeoff commitments for a community, phase, lot, or option, using effective and expiration dates.
Bid Details (F44H611) Contains the detailed information for the bid, including the phase, cost code, cost type, plan, elevation, option number, quantities, amounts, effective and expiration dates, and other information.
Workfile Generation (F44H711) Contains all of the detailed information for each lot, following lot start generation, and prior to commitment generation (generating budgets and commitments), including job number, object, subsidiary, option, quantities, amounts, supplier number, and other information.
After Start Purchasing (F44H711P) Contains all of the detailed information from extra purchase order entry or an electronic purchase order upload. You can upload the information in this table to the Lot Start Workfile Generation table.