1. Engineer to Order Implementation Guide
  2. Engineer to Order Tables

Engineer to Order Tables

Because JD Edwards EnterpriseOne Engineer to Order integrates with many JD Edwards EnterpriseOne systems, you use the tables in these other systems when you create and work with engineer to order (ETO) projects. For example, you use the Work Order Master table (F4801) to store project header and task information. In addition, you also store project information in tables that are specific to JD Edwards EnterpriseOne Engineer to Order:

Table

Description

Project Attributes (F31P01)

This table stores information that is entered for the project header, such as status information and the processing settings for a project.

Project Quote Header (F31P10)

This table stores the header information for the quote that is related to the project, such as the version and the number of the customer for whom the quote is created.

Project Quote Detail (F31P11)

This table stores the detail lines from the work breakdown structure that you chose to include in the quote, with the margin percent value and quote amount for each line.

Task Dependencies (F31P12)

This table stores the task dependencies that you establish between the tasks on the work breakdown structure, including the lag time between tasks.

Cost Classification Table (F31P21)

This table stores the cost type and account mappings that are required to correctly roll up cost information for a project.

Scheduling Error Report (F31PUI01)

This table is a work file that stores the scheduled dates created and deleted when the Project Workbench program (P31P001) is used to schedule.

List of Records Locked (F31PUI02)

This table is a work file that stores record reservation details created and deleted when the Project Workbench program (P31P001) is viewed in the Edit Tasks or Edit and Lock All Tasks mode.

Project Commitment Detail Table (F410211)

This table stores project-specific inventory commitments. These records are deleted when the commitment is relieved.

Related Order Cross Reference Table (F4080)

This table stores order information that the system uses to link the project descriptive task to the related orders. This table contains the descriptive task-order number and order type, and detail information from the related orders, such as document type, extended costs, and order status.

Work Order ETO Tag File (F4801T1)

This is a tag table to table F4801 that is used only for ETO. For every record in table F4801 that is associated with a project (PRJM not blank), the system creates a corresponding record in the F4801T1 table.