Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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     IC12.1    IC330

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 desired
                     quantity.

                         ICFGBYPROD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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