JD Edwards EnterpriseOne Quality Management Tables

The JD Edwards EnterpriseOne Quality Management system uses these tables:

Table Name	Description
F3701 table	Contains test definitions, which consist of the Test ID, description, type of test, minimum and maximum values, target values, and effectivity dates. This table also contains information that indicates whether to print the test on the certificate of analysis and whether to print generic text.
F3702 table	Contains the description of the specification and effectivity dates.
F37021 table	Contains information about the different tests that are grouped within the specification.
F3703 table	Contains records of failed tests.
F3711 table	Contains the test results for an item and lot number in inventory or on a work order, purchase order, or sales order.
F3711Z1 table	Contains test results uploaded from a Laboratory Information Management (LIM) system.
F37900 table	Contains test results that print on the certificate of analysis or Product Test report (R37901).
F40318 table	Identifies which tests or specifications are required for an item, item group, customer, or customer group.
F40318R table	Contains historical information about the number of times that a preference has been used on sales orders.