Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICFGBYPROD


                            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