ICFGBYPROD FILE

                        Finished Goods Byproduct

The Finished Goods Byproduct file contains information for byproducts that
are a result of the process that creates the finished goods.

REFERENCED BY

IC262     WOEX.1    IC12.1

UPDATED BY

IC62.1    IC62.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ICP-COMPANY          Numeric 4                                   IC62.1  IC62.2
Company              The company number represents an
                     established company and is entered on
                     all function codes.

ICP-LOCATION         Alpha 5                                     IC62.1  IC62.2
Location Code        This field contains a valid stock
                     location within the company inventory.
                     It is also the production facility where
                     finished goods are produced.

ICP-FG-ITEM          Alpha 32                                    IC62.1  IC62.2
Fg Item              This field contains the finished good
                     item number.

ICP-SEQ              Numeric 3                                   IC62.2
Sequence Number      This field contains the record sequence
                     number.

ICP-ITEM             Alpha 32                                    IC62.2
Item Number          This field contains the item identifier.

ICP-QUANTITY         Signed 13.4                                 IC62.2
Quantity             This field contains the requested
                     quantity.

                         ICFGBYPROD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ICPSET1   COMPANY                                                IC262   IC62.1
          LOCATION                                               IC62.2  WOEX.1
          FG-ITEM
          SEQ

ICPSET2   COMPANY       KeyChange                                IC12.1
          LOCATION
          ITEM
          FG-ITEM
          SEQ

                         ICFGBYPROD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required

                            ICP-COMPANY       -> ICC-COMPANY

Itemmast       ITEMMAST     Required

                            ICC-ITEM-GROUP    -> ITE-ITEM-GROUP
                            ICP-ITEM          -> ITE-ITEM