Defining Column Relationships for a Column Set

Access the Revise Column Relationships form.

You can navigate between the programs for column relationships and value relationships by selecting Value Relationships from the Form menu or Revise Values from the Row menu on the Revise Column Relationships form.

Table

Enter F0006 or F52001 in this field, depending on whether you want to define column set relationships for the Business Unit Master or the Contract Master table.

Column Set Description

Enter a description to further define the column set.

Effective As Of

Enter the date that the column set will be effective.

Sequence Number

Enter a unique number that identifies the sequence of the columns. The sequence determines the order in which the column pairs in the column set are read for default values when you run the Update Data Relationships program (R00422).

Note: If you leave the Sequence Number field blank, the system increments the last active sequence number by 10. For example, if the last active sequence number is 20, the system enters 30 as the default value.Using the example, if you add the sequence number 25 (to insert between 20 and 30), the system increments that number (25) by 10 if you leave the next Sequence Number field blank. So the default sequence number would be 35, which might not be the desired result if, for example, sequence number 40 already exists. For this reason, you should be careful when mixing the system default values with manual numbering.

Basis Column

Enter the data item of the column that is the basis of the data relationship.

You can define one basis column with multiple different destination columns. For example, you could enter multiple column pairs with RP01 in the Basis Column field and different destination columns (RP02, RP03, and RP04) in the Destination Column fields.

After you define a basis column for a column pair, you cannot define the same basis column as a destination column with a higher sequence number. Using the previous example, if sequence number 10 = RP01 (basis) —> RP02 (destination), you cannot enter sequence number 20 = RP03 (basis) —> RP01 (destination).

Destination Column

Enter the data item of the column that is populated when the basis column and value are entered for the data relationship.

Enforce Rule

Select this check box to enforce the data relationship rules for the destination column. If selected, the destination column is disabled in the entry program and the system prevents you from revising the corresponding destination value. If a destination value already exists, the system overwrites the value in the F0006 or F5201 table.

If not selected, the destination column is input capable and the system does not overwrite the existing value.

See Understanding the Enforce Rule and Blanks Allowed Check Boxes.

Blanks Allowed

Select this check box if blank can be a valid value for the destination column in the Value Relationships program (P00422). You can select this check box only for strings and characters, and not for math numeric values. If you select this check box, the Enforce Rule check box must also be selected for the column pair.

See Understanding the Enforce Rule and Blanks Allowed Check Boxes.