ICMANUF – Manufacturer

System
Inventory Control (IC)
Prefix
ICM
Primary key
ITEM-GROUP, MANUF-ID
Fields
12
Updated by
2 programs
Referenced by
1 program

ICMANUF is the Manufacturer table in Lawson Inventory Control (prefix ICM). It is indexed by ITEM-GROUP, MANUF-ID (ICMSET1). It is related 1:M to MFGSHPFAC. It is updated by IC153 and IC34.1 and referenced by PO00.1. The table has 12 fields, 1 index and 1 documented relation.

About ICMANUF

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.

Fields (12)

Column = COBOL field name without the ICM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ICM-MANUF-ID PK
MANUF_ID		Numeric 4A unique idenitifier for a manufacturerIC34.1
ICM-ITEM-GROUP PK
ITEM_GROUP		Alpha 5This field contains the identifier for a group of items that can be shared by one or more companies.IC34.1
ICM-NAME
NAME		Alpha 30 (Lower Case)Displays the company description.IC34.1
ICM-EDI-NBR
EDI_NBR		Alpha 15—IC34.1
ICM-RPT-FREQ
RPT_FREQ		Numeric 1Identifies the frequency or time boundry for reporting
  • 0 Daily
  • 1 Weekly
  • 2 Monthly
IC34.1
ICM-NXT-RPT-DT
NXT_RPT_DT		Numeric 8 (yyyymmdd)Contains the last date that will be reported.IC153, IC34.1
ICM-NON-INV-ITEM
NON_INV_ITEM		Numeric 1—
  • 0 Exclude
  • 1 Include
IC34.1
ICM-DETAIL-OPTION
DETAIL_OPTION		Numeric 1Provides the option to select the level of detail(or roll up) that will be reported.
  • 0 Net Daily
  • 1 Net Period
  • 2 Detail
IC34.1
ICM-SORT-SEQ
SORT_SEQ		Numeric 1Establishes the report detail sort sequence.
  • 0 By Date
  • 1 By Item
IC34.1
ICM-UOM-OPTION
UOM_OPTION		Numeric 1Determies which Unit of measure will be used fro reporting purposes.
  • 0 Issue Uom
  • 1 Buy Uom
IC34.1
ICM-DECIMAL-HNDL
DECIMAL_HNDL		Numeric 1Identifies option for handling decimal values that may be calculated for a quantity.
  • 0 Report Decimal
  • 1 Truuncate
IC34.1
ICM-CURRENCY-CD
CURRENCY_CD		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).IC34.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ICMSET1ITEM-GROUP, MANUF-IDPrimaryIC153, IC34.1, IC34.2, IC34.3, PO00.1

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
MfgshpfacMFGSHPFACICM-ITEM-GROUP → MFG-ITEM-GROUP, ICM-MANUF-ID → MFG-MANUF-ID, → MFG-ST-FACILITY

Programs

Updated by (2)

Referenced by (1)