Defining the formatted XREF criteria

The selected ORDERPO layout is displayed in formatted mode. As described earlier, the ORDERPO layout defines all records with ORDER-TYPE equal to "PO".

Related topics

Define-XREF

Formatted-XREF-Definition

Formatted XREF Definition - ORDERPO - ORDER-LINE-DATA-PO

 File-AID --- Formatted XREF Definition -------------- LAYOUTS HAVE BEEN LOADED
 COMMAND ===>                                                  SCROLL ===> CSR
 CRITERIA NUMBER:  1 OF  1  ORDER-LINE-DATA-PO              LAYOUT LENGTH:   184
 ---- FIELD NUMBER/NAME ------ COLUMNS- RO ----+----1----+----2----+----3----+-
 ******************************* TOP OF DATA ********************************
 1 RECORD-LENGTH                   0
 2 ORDER-NO                        2
 3 ORDER-LINE-KEY SYNC             8
   4 LINE-NUMBER                   8
 5 ORDER-TYPE                     10
 6 LINE-STATUS                    12
 7 PART-NO                        19
 8 DESCRIPTION                    25
 9 UNIT-OF-MEASURE                55
 10 PURCHASE-ORDER-INFO SYNC      57
   11 PO-CODE                     57
   12 PO-NUMBER                   61
   13 PO-COMPANY                  73
   14 PO-VENDOR-NUMBER           103
   15 PO-VENDOR-CODE             108
 16 FILLER                       113
 17 ORDER-QUANTITIES SYNC        143
   18 QTY-ORDERED                143
   19 QTY-BACKORDERED            146

Showing Field Offsets with the SHOW OFFSET Command

Before you specify the condition, notice that all standard File-AID formatted mode commands are available including the SHOW and DISPLAY commands. You now use the SHOW OFFSET command to set the display to show the offset of each field so that you can see the location of the ORDER-TYPE field.

Display Offset Information - SHOW OFFSET

image2021-6-21_19-15-5.png

Steps:

  1. If COLUMNS already appears in the center portion of the screen, you may skip these steps.
  2. Type SHOW OFFSET in the COMMAND field.
  3. Press Enter. File-AID redisplays the Formatted XREF Definition screen showing the offsets of each field, as illustrated in Formatted XREF Definition. Specifying the Selection Condition.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*