This appendix lists the tables that JD Edwards EnterpriseOne Homebuilder Management uses to process purchasing, construction, sales, and financial transactions.
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 |
|
Contains information about the Procurement Order Types used in the JD Edwards EnterpriseOne Homebuilder Management system. |
|
|
Contains the constants used in the JD Edwards EnterpriseOne Homebuilder Management system. |
|
|
Contains setup information for construction and sales activity rules, including allowed statuses and history to be captured for each activity. |
|
|
Contains the user-defined data keys that are associated with each data type. |
|
|
Contains the specific data elements and modified column titles for the selected extended data. |
|
|
Contains the extended data for any of these seven data types: area, community, lot, option, phase, plan, and sales. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
Contains information for linking options with appropriate quantities and effective dates when they are sold together as a package. |
|
|
Contains the Homebuilder-specific information used in the Item Master. |
|
|
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. |
|
|
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. |
|
|
Contains option selection information for each lot, such as selection quantity, unit price, and extended price. |
|
|
Contains all history information for option selections on a lot, including option reversals. |
|
|
Contains the setup information for sales closings templates, including business unit source instructions; object, subsidiary, and subledger accounts; amounts, and ledger types. |
|
|
Contains the closing entry information for each closed lot, including all account numbers and corresponding amounts. |
|
|
Contains the setup information that links a field used during lot close with a closing worksheet line number and description. |
|
|
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. |
|
|
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. |
|
|
Contains all information related to changes to takeoff records, including reason code and quantity changes. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |