Where Order detail refers to Product, Product may be defined as follows:
FIL Product REF Known by FLD Product code CDE
FIL Product REF Has FLD Product name TXT
The Product could then be referenced elsewhere, for instance by an Order detail file:
FIL Order detail REF Owned by FIL Order CPT
FIL Order detail REF Known by FLD Order line no NBR
FIL Order detail REF Has FLD Order quantity QTY
FIL Order detail REF Refers to FIL Product REF
This results in the Product code being added to the Order detail file as a foreign key field:
|
|
Product file |
|
Order detail file |
|
K |
Product code Product name |
K K |
Order code Order line no Order quantity Product code |
|
Copyright © 2014 CA.
All rights reserved.
|
|