Data Relationships
The Data Relationships tool is a collection of programs that you can use to manage the consistency and quality of data that is entered in certain master tables. Using this tool to set up data relationships enables you to place tighter controls over your data and helps increase efficiency during data entry. You use the tool to define relationships between columns (data items) in these tables:
Business Unit Master (F0006)
Contract Master (F5201)
After you define data relationships for the columns, you define the default destination values that you want to appear for a single basis value when you enter a new business unit, job, or contract. The system automatically applies the data relationships rules during data entry in the following programs:
Business Unit Master (P0006)
Job Cost Master (P51006)
Contract Master (P5201)
Create/Edit Advanced Contracts (P52G01M)
This program is used by customers who conduct business with the government.
If a job, business unit, or contract exists, you must update the existing records in the F0006 or F5201 table with the data relationships rules by doing one of the following:
Running the Update Data Relationships program (R00422).
Manually updating the records in the data entry program.
You update the F0006 and F5201 tables after you initially define your data relationships rules. Thereafter, you update the tables whenever you revise existing data relationship rules or define new ones. If you have just a few records to update, you can manually update the records in the data entry program instead of running the R00422 program.
See Updating F0006 and F5201 Records with Data Relationships Rules.