ICMANFCODE – Manufacturers Code
- System
- Inventory Control (IC)
- Prefix
IMC- Primary key
ITEM-GROUP,MANUF-CODE,MANUF-DIVISION- Fields
- 7
- Updated by
- 14 programs
- Referenced by
- 62 programs
ICMANFCODE is the Manufacturers Code table in Lawson Inventory Control (prefix IMC). It is indexed by ITEM-GROUP, MANUF-CODE, MANUF-DIVISION (IMCSET1); alternate indexes: IMCSET2. It is related 1:1 to GLNLOCDTL, GLNLOC and ITEMGROUP. It is updated by AP510, IC14.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 and 6 more and referenced by CX05.1, CX05.2, CX805, DR100, IC10.2, IC11.1, IC11.7, IC12.1 and 54 more. The table has 7 fields, 2 indexes and 4 documented relations.
About ICMANFCODE
The Manufacturer's Code file is a user-defined list of codes that identify the manufacturers of items.
Fields (7)
Column = COBOL field name without the IMC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#IMC-ITEM-GROUP PKITEM_GROUP | Alpha 5 | This field contains the identifier for a group of items that can be shared by one or more companies. | IC14.1, IC811, IC812, PO813 |
#IMC-MANUF-CODE PKMANUF_CODE | Alpha 4 | This field contains a user defined code that indicates the manufacturer of an item. | IC14.1, IC811, IC812, PO813 |
#IMC-MANUF-DIVISION PKMANUF_DIVISION | Alpha 4 | This is a user defined code that indicates which division of a manufacturer is tied to an item. | IC14.1, IC811, IC812, PO813 |
#IMC-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | IC14.1 |
#IMC-LIC-CODE SET2LIC_CODE | Alpha 4 | The Labeler Identification Code (LIC) is assigned to any organization in the healthcare industry. The LIC is used with bar code technology to identify the company that put the label on the product. | IC14.1, PO813 |
#IMC-USED-FLAGUSED_FLAG | Alpha 1 | Indicates if the record has been accessed by some source after creation. | — |
#IMC-GLN-NBRGLN_NBR | Alpha 13 | — | AP510, IC14.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +3 more |
Indexes (2)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
IMCSET1 |
| Primary | AP510, CX05.1, CX05.2, CX805, DR100, IC10.2, IC11.1, IC11.7 +22 more (list truncated in source) | |
IMCSET2 |
| Subset | Where (LIC-CODE != Spaces) | PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2, PO36.2, PO536 |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Gln Mfr Code | GLNLOCDTL | Not Required | Valid When IMC-GLN-NBR != Spaces |
| |||||||||||||||
| Gln Mfr Div | GLNLOCDTL | Not Required | Valid When IMC-GLN-NBR != Spaces |
| |||||||||||||||
| Glnloc | GLNLOC | Not Required | Valid When IMC-GLN-NBR != Spaces |
| |||||||||||||||
| Itemgroup | ITEMGROUP | Required |
|
Programs
Updated by (14)
- AP510 Vendor Conversion
- IC14.1 Manufacturer Code
- IC64.1 Global Location Nbr Assignment GL/IC Company
- IC64.2 Global Location Nbr Assignment IC Location
- IC64.3 Global Location Number Assignment RQ Location
- IC64.4 Global Location Number Assignment Manuf Code
- IC64.5 Global Location Number Assignment Manuf Div
- IC64.6 Global Location Number Assignment Vendor
- IC64.7 Global Location Number Assignment Vendor Location
- IC64.8 Global Location Number Assignment IC Bin
- IC64.9 Global Location Number Assignment Buyer
- IC811 Item Master Load
- IC812 Item Location Load
- PO813 Item Vendor Load
Referenced by (62)
- CX05.1 Preference Template
- CX05.2 Preference Template Diagnostics
- CX805 Template Card Conversion
- DR100 Distribution Requirements Report
- IC10.2 Item Master and Location
- IC11.1 Item Master
- IC11.7 Global Trade Item Number
- IC12.1 Item Location
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC218 GTIN Listing
- IC258 Global Location Number Listing
- IC330 Item Mass Change
- IC331 Par Cart Mass Changes
- IC34.1 Manufacturer Relationship Management
- IC46.1 Inventory Status
- IC511 Item Master-Item Location Extr
- IC512 Item Audit Extract
- IC522 HL7 Item Master - Atwork
- IC524 CSV Item Master
- IC525 HL7 Item Master Interface
- IC526 HL7 Item Master - McKesson
- IC527 HL7 Item Master - DeRoyal
- IC58.1 Global Location Numbers
- IC58.2 Global Location Numbers Inquiry
- IC58.3 Global Location Numbers Inquiry Details
- IC81.1 Cart, Par Location
- IC81.2 Cart, Par Location Item Detail
- IC83.1 Par Location Counts
- ICI9.1 Item GTIN Invoke Object
- MA278 Cost Variance Analysis
- PD21.1 P-Card Charge Detail
- PO04.1 Buyer
- PO100 Purchase Order Interface from Lawson Applications
- PO13.1 Vendor Item
- PO13.3 Vendor Items
- PO150 Bid Load to Contract or Catalog
- PO213 Vendor Item Listing
- PO23.5 Worksheet Filter
- PO25.1 Vendor Agreements
- PO25.6 Vendor Agreement Line
- PO25.7 Service Agreement Line
- PO26.4 Vendor Agreement Line Price Breaks
- PO26.5 Vendor Agreement Line Price Breaks
- PO28.2 Vendor Agreement Line Detail List
- PO30.1 PO Receiving
- PO36.2 Vendor Agreement Import Manual Input
- PO525 Vendor Agreement Header, Line
- PO536 Vendor Price Agreement Load
- PO550 Bid Creation
- POA2.3 Define Product Dimension
- POI7.1 POI7 Print Object
- POIJ.1 Invoke for POPLIUPD
- RQ10.1 Requisition
- RQ10.3 Select and Copy
- RQ10.4 Requisition Line Entry Detail
- RQ10.5 Substitutes
- RQ11.1 Kit Accessories
- RQ260 Requisitioned Items Report
- RQ35.1 Requisition Returns
- RQ500 Requisition Interface
- RQIF.1 RQRLNUPD Invoke Object