OEDIAGDTL FILE

UPDATED BY

OE55.1    OE55.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ODL-ITEM-GROUP       Alpha 5                                     OE55.1  OE55.2
Item Group           This field contains the identifier for
                     a group of items that can be shared by
                     one or more companies.

ODL-DIAGRAM-ID       Alpha 15                                    OE55.1  OE55.2
Diagram Id

ODL-SEQ-NBR          Numeric 4                                   OE55.1  OE55.2
Sequence Number      An automatically assigned sequence
                     number.

ODL-ITEM             Alpha 32                                    OE55.1  OE55.2
Item Number          This field contains the item
                     identifier.

ODL-COORD-ONE        Numeric 4                                   OE55.1
Coord One

ODL-COORD-TWO        Numeric 4                                   OE55.1
Coord Two

ODL-COORD-THREE      Numeric 4                                   OE55.1
Coord Three

ODL-COORD-FOUR       Numeric 4                                   OE55.1
Coord Four

                         OEDIAGDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ODLSET1   ITEM-GROUP                                             OE55.1  OE55.2
          DIAGRAM-ID
          SEQ-NBR

ODLSET2   ITEM                                                   OE55.2
          ITEM-GROUP
          DIAGRAM-ID
          SEQ-NBR

                         OEDIAGDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemmast       ITEMMAST     Required

                            ODL-ITEM-GROUP    -> ITE-ITEM-GROUP
                            ODL-ITEM          -> ITE-ITEM

Oediaghdr      OEDIAGHDR    Required

                            ODL-ITEM-GROUP    -> ODH-ITEM-GROUP
                            ODL-DIAGRAM-ID    -> ODH-DIAGRAM-ID