Understanding Supported Data Relationship Columns
You can use the Register Relationship Columns program (P00424) to review a list of the columns in the F0006 and F5201 tables that are supported for data relationships. For each column (data item), the system displays the column type, which identifies whether the column can be used for both basis and destination values or for basis values only.
The program logic in the data relationship programs is dependent on the column type. The column type for AN8O (Owner Address) in the F0006 and F5201 tables is hard-coded to be basis only. The value in the AN8O column can be dependent on columns that are not supported by data relationships. If you set up a data relationship with AN8O as a destination column, the system would override the original value in AN8O, which could cause severe data integrity issues. For that reason, the AN8O should be designated as a basis column only.
If you try to change the column type for AN8O to basis and destination, the system issues a hard error message and you are prevented from changing the column type.
The system does not prevent you from changing basis and destination column types to basis only; however, you should do this during setup to prevent data integrity issues and not after you begin using the data relationships functionality. If you change a column type to basis only for any data item other than AN8O and then change the column type back to basis and destination, the system does not issue an error message. To prevent users from changing column types from basis only back to basis and destination, you should add logic in the P00424 program or place security on column types.
Although the software allows you to add new columns to a table, that work should be performed by a software developer or a field consultant because program logic must also be added to accommodate the new columns. JD Edwards EnterpriseOne does not support changes made to column types after the initial setup or the addition of columns to a table.
The data relationships functionality can also be used by customers who conduct business with the government. The F0006 and F5201 tables support additional columns for government contracting functionality.