| 
 | 
                            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
IC12.1    IC330
FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY
ICP-COMPANY            Numeric 4
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.
ICP-LOCATION           Alpha 5
Element: Location      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
Element: Item          This field contains the finished good
                       item number.
ICP-SEQ                Numeric 3
Element: Seq           This field contains the record sequence
                       number.
ICP-ITEM               Alpha 32
Element: Item          This field contains the item
                       identifier.
ICP-QUANTITY           Signed 13.4
Element: Quantity      This field contains the desired
                       quantity.
                         ICFGBYPROD FILE INDEX
NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN
ICPSET1   COMPANY
          LOCATION
          FG-ITEM
          SEQ
ICPSET2   COMPANY       KeyChange                                IC12.1  IC330
          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
 |