Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICMANUF


                              ICMANUF FILE

The manufacturer table is used to identify entites requesting the product
transfer and resale report.  In addition this table is used to establish
reporting options.

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      A unique idenitifier for a manufacturer

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      Identifies the frequency or time boundry
                       for reporting
                       0 = Daily
                       1 = Weekly
                       2 = Monthly

ICM-NXT-RPT-DT         Numeric 8  (yyyymmdd)                     IC153   IC34.1
Element: Nxt Rpt Dt    Contains the last date that will be
                       reported.

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 Provides the option to select the level
                       of detail(or roll up) that will be
                       reported.
                       0 = Net Daily
                       1 = Net Period
                       2 = Detail

ICM-SORT-SEQ           Numeric 1                                 IC34.1
Element: Sort Seq      Establishes the report detail sort
                       sequence.
                       0 = By Date
                       1 = By Item

ICM-UOM-OPTION         Numeric 1                                 IC34.1
Element: Uom Option    Determies which Unit of measure will be
                       used fro reporting purposes.
                       0 = Issue Uom
                       1 = Buy Uom

ICM-DECIMAL-HNDL       Numeric 1                                 IC34.1
Element: Decimal Hndl  Identifies option for handling decimal
                       values that may be calculated for a
                       quantity.
                       0 = Report Decimal
                       1 = Truuncate

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