Creating/Defining Your Data Model › Defining Your Data Model › Example of Redirecting Qualifier Fields

Example of Redirecting Qualifier Fields

A Product price could be defined as follows:

FIL Product price      REF     Owned by                FIL     Product                 REF

FIL Product price    REF     Qualified by    FLD     Effective date  DT#

FIL Product price    REF     Has                     FLD     Product price   PRC

When referring to the Product price in relations that describe other files, you may redirect the source of the Effective date as follows:

FIL  Order detail   CPT     Refers to       4 FIL   Product price     REF

                 Order date           RDR  Effective date    DT#