Understanding Data Relationships Rules and Updating F0006 and F5201 Records

See also: Setting Up Data Relationships.

After initially setting up your data relationships, you must update the existing records in the F0006 or F5201 table. You can update the records using one of these methods:

• Run the Update Data Relationships program (R00422). This program automatically updates records based on processing options and data selection.

• Manually update the records in the data entry program for Business Unit Master (P0006), Job Cost Master (P51006), Contract Master (P5201), or Create/Edit Advanced Contracts (P52G01M). Using one of these programs, you manually enter the basis values and the system provides the default destination values. You might choose this method if you have just a few records to update.

  The P52G01M program is used by customers who conduct business with the government using the government contracting functionality.

  See "Entering Advanced Contract Master Records" in the JD Edwards EnterpriseOne Applications Advanced Contract Billing Implementation Guide.

After the initial setup, you will continue to update the records in the F0006 or F5201 table when you change the data relationship rules for existing business units, jobs, or contracts. The changes might include revising existing rules or defining new ones. For example, if you change the Enforce Rule value for a column set or if you add column pairs with new destination columns and effective dates, you must update the existing data in the F0006 or F5201 table.

You do not need to update the F0006 or F5201 table when you create new business units, jobs, or contracts; the system automatically applies the data relationships rules to the new records during data entry.