Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICMANUF


                              ICMANUF FILE

REFERENCED BY

PO00.1

UPDATED BY

IC153     IC34.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ICM-MANUF-ID           Numeric 4                                 IC34.1
Element: Manuf Id

ICM-ITEM-GROUP         Alpha 5                                   IC34.1
Element: Item Group    This field contains the identifier for
                       a group of items that can be shared by
                       one or more companies.

ICM-NAME               Alpha 30  (Lower Case)                    IC34.1
Element: Name          Displays the company description.

ICM-EDI-NBR            Alpha 15                                  IC34.1
Element: EDI Number

ICM-RPT-FREQ           Numeric 1                                 IC34.1
Element: Rpt Freq      0 = Daily
                       1 = Weekly
                       2 = Monthly

ICM-NXT-RPT-DT         Numeric 8  (yyyymmdd)                     IC153   IC34.1
Element: Nxt Rpt Dt

ICM-NON-INV-ITEM       Numeric 1                                 IC34.1
Element: Non Inv Item  0 = Exclude
                       1 = Include

ICM-DETAIL-OPTION      Numeric 1                                 IC34.1
Element: Detail Option 0 = Net Daily
                       1 = Net Period
                       2 = Detail

ICM-SORT-SEQ           Numeric 1                                 IC34.1
Element: Sort Seq      0 = By Date
                       1 = By Item

ICM-UOM-OPTION         Numeric 1                                 IC34.1
Element: Uom Option    0 = Issue UOM
                       1 = Buy UOM

ICM-DECIMAL-HNDL       Numeric 1                                 IC34.1
Element: Decimal Hndl  0 = Report Decimal
                       1 = Truncate

ICM-CURRENCY-CD        Alpha 5                                   IC34.1
Element: Currency Code

                         ICMANUF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ICMSET1   ITEM-GROUP                                             IC153   IC34.1
          MANUF-ID                                               IC34.2  IC34.3
                                                                 PO00.1

                         ICMANUF FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mfgshpfac      MFGSHPFAC

                            ICM-ITEM-GROUP    -> MFG-ITEM-GROUP
                            ICM-MANUF-ID      -> MFG-MANUF-ID
                                                 MFG-ST-FACILITY