OEDIAGDTL FILE
UPDATED BY
OE55.1 OE55.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ODL-ITEM-GROUP Alpha 5 OE55.1 OE55.2
Element: 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
Element: Diagram Id
ODL-SEQ-NBR Numeric 4 OE55.1 OE55.2
Element: Sequence NumbeAn automatically assigned sequence
number.
ODL-ITEM Alpha 32 OE55.1 OE55.2
Element: Item Number This field contains the item
identifier.
ODL-COORD-ONE Numeric 4 OE55.1
Element: Coord One
ODL-COORD-TWO Numeric 4 OE55.1
Element: Coord Two
ODL-COORD-THREE Numeric 4 OE55.1
Element: Coord Three
ODL-COORD-FOUR Numeric 4 OE55.1
Element: 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
|
