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

IC262     WOEX.1    IC12.1    IC330

UPDATED BY

IC62.1    IC62.2    IC62.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ICP-COMPANY            Numeric 4                                 IC62.1  IC62.2
Element: Company       Identifies the AP company if the          IC62.4
                       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                                   IC62.1  IC62.2
Element: Location Code This field contains a valid stock         IC62.4
                       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
Element: Item Number   This field contains the finished good     IC62.4
                       item number.

ICP-SEQ                Numeric 3                                 IC62.2
Element: Sequence NumbeThis field contains the record sequence
                       number.

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

ICP-QUANTITY           Signed 13.4                               IC62.2
Element: Quantity      This field contains the desired
                       quantity.

                         ICFGBYPROD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ICPSET1   COMPANY                                                IC262   IC62.1
          LOCATION                                               IC62.2  IC62.4
          FG-ITEM                                                WOEX.1
          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