Previous Topic: Define the Files

Next Topic: Create an EXCEXTFUN to Retrieve the Order Header and Order Details

Define the Order Details Array

We assume the following array definition for the process.

Note: The Element number field should be of type NBR.

Follow these steps:

  1. Create an array named Order Details over the *Arrays file.
  2. Take option Z to open the EDIT ARRAY DETAILS screen.
  3. Define the Order details array with the retrieval index structure of the order detail file and additionally an Element number field (Type NBR), as follows:

    Define Order Details1

  4. Press F7 to access the EDIT ARRAY KEY ENTRIES panel and define Element number as the key to the array.

    Define Order Details2