We assume the following basic file definitions for the process:
Note: The field types are not critical to this scenario, so you can define field type as you see fit.
Order Header Files
If your screen shows the Order Header File as:
Order header Known by Order Number Order header Has Customer Name Order header Has Order Date
Then the Order Header Records look like this example:
|
Order Number |
Customer Name |
Order Date |
|---|---|---|
|
10001 |
John Doe |
123111 |
|
10002 |
Jane Doe |
022811 |
Order Detail File
If your screen shows the Order Detail File as:
Order detail Owned by FIL Order Header Order detail Known By FLD Line Number Order detail Refers to FIL Product Order detail Has FLD Quantity
Then the Order Detail Records look like this example:
|
Order Number |
Line Number |
Product Code |
|
|---|---|---|---|
|
10001 |
1 |
BH |
101 |
|
10001 |
3 |
IP5 |
103 |
|
10002 |
1 |
BH |
201 |
|
10002 |
3 |
LH |
203 |
Note: Product code refers to the product file. For example, LH refers to Little Hammer and BH refers to Big Hammer.
Product File
FIL Product Known by FLD Product code FIL Product Has FLD Product description FIL Product Has FLD Product price date FIL Product Has FLD Product price
|
Product code |
Product description |
Product Date |
Product Price |
|---|---|---|---|
|
BH |
Big Hammer |
20010101 |
23.45 |
|
LH |
Little Hammer |
20101010 |
18.97 |
|
IP5 |
Ice Pick |
20020202 |
299.00 |
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |