POPREFDMFG – Preferred Manufacturer

POPREFDMFG is the Preferred Manufacturer table in Lawson Purchase Order (prefix PMF). It is indexed by COMPANY, ITEM, LOCATION, REQ-LOCATION (PMFSET1). It is related 1:1 to ICCOMPANY, ICLOCATION, ICMANFCODE, ITEMMAST, POCOMPANY, POCONTGRP, POCONTRACT and RQLOC and 1:M to POITEMVEN, POLINE, POVAGRMTLN and REQLINE. The table has 8 fields, 1 index and 12 documented relations.

About POPREFDMFG

This table contains the preferred manufacturer and contract for inventory items.

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

Field / column	Type	Description & values	Updated by
`PMF-COMPANY` PK COMPANY	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	—
`PMF-ITEM` PK ITEM	Alpha 32	This field contains the item identifier.	—
`PMF-LOCATION` PK LOCATION	Alpha 5	This field contains a valid stocking location within the company inventory.	—
`PMF-REQ-LOCATION` PK REQ_LOCATION	Alpha 5	The location requisitioning items. This location can be an inventory or noninventory location.	—
`PMF-CONTRACT-GROUP` CONTRACT_GROUP	Alpha 4	This field contains the identifier for a group of contracts that can be shared by one or more companies.	—
`PMF-CM-CONTRACT` CM_CONTRACT	Numeric 15	—	—
`PMF-MANUF-CODE` MANUF_CODE	Alpha 4	This field contains a user defined code that indicates the manufacturer of an item.	—
`PMF-MANUF-DIVISION` MANUF_DIVISION	Alpha 4	This is a user defined code that indicates which division of a manufacturer is tied to an item.	—

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

Index	Keys	Flags	Condition	Used in
`PMFSET1`	`COMPANY`, `ITEM`, `LOCATION`, `REQ-LOCATION`	Primary		POIH.1

Relation	Table	Rules	Condition	Field map
Iccompany	ICCOMPANY	Required		`PMF-COMPANY` → `ICC-COMPANY`
Iclocation	ICLOCATION	Required	When PMF-LOCATION != Spaces	`PMF-COMPANY` → `ICL-COMPANY`, `PMF-LOCATION` → `ICL-LOCATION`
Icmanfcode	ICMANFCODE	Required	When PMF-MANUF-CODE != Spaces	`ICC-ITEM-GROUP` → `IMC-ITEM-GROUP`, `PMF-MANUF-CODE` → `IMC-MANUF-CODE`, `PMF-MANUF-DIVISION` → `IMC-MANUF-DIVISION`
Itemmast	ITEMMAST	Required		`ICC-ITEM-GROUP` → `ITE-ITEM-GROUP`, `PMF-ITEM` → `ITE-ITEM`
Pocompany	POCOMPANY	Required		`PMF-COMPANY` → `PCY-COMPANY`
Pocontgrp	POCONTGRP	Required	When PMF-CM-CONTRACT != Zeroes	`PMF-CONTRACT-GROUP` → `CNG-CONTRACT-GROUP`
Pocontract	POCONTRACT	Required	When PMF-CM-CONTRACT != Zeroes	`PMF-CONTRACT-GROUP` → `CMH-CONTRACT-GROUP`, `PMF-CM-CONTRACT` → `CMH-CM-CONTRACT`
Rqloc	RQLOC	Required	When PMF-REQ-LOCATION != Spaces	`PMF-COMPANY` → `RQL-COMPANY`, `PMF-REQ-LOCATION` → `RQL-REQ-LOCATION`

Relation	Table	Condition	Field map
Poitemven	POITEMVEN		`PCY-PROCURE-GROUP` → `PIV-PROCURE-GROUP`, `PMF-ITEM` → `PIV-ITEM`, → `PIV-VENDOR`, → `PIV-VEN-ITEM`
Poline	POLINE	Valid When PMF-LOCATION != Spaces	`PMF-COMPANY` → `PLI-COMPANY`, `PMF-ITEM` → `PLI-ITEM`, `PMF-LOCATION` → `PLI-LOCATION`, → `PLI-EARLY-DL-DATE`, → `PLI-PO-NUMBER`, → `PLI-PO-RELEASE`, → `PLI-PO-CODE`, → `PLI-LINE-NBR`
Povagrmtln	POVAGRMTLN	Valid When PMF-CM-CONTRACT != Zeroes	`PCY-PROCURE-GROUP` → `PVN-PROCURE-GROUP`, `PMF-ITEM` → `PVN-ITEM`, `PMF-CONTRACT-GROUP` → `PVN-CONTRACT-GROUP`, `PMF-CM-CONTRACT` → `PVN-CM-CONTRACT`, → `PVN-VEN-ITEM`, → `PVN-VEN-AGRMT-REF`, → `PVN-LINE-NBR`
Reqline	REQLINE	Valid When PMF-REQ-LOCATION != Spaces	`PMF-COMPANY` → `RLN-COMPANY`, `PMF-REQ-LOCATION` → `RLN-REQ-LOCATION`, `PMF-ITEM` → `RLN-ITEM`, → `RLN-REQ-DEL-DATE`, → `RLN-REQ-NUMBER`, → `RLN-LINE-NBR`

No Lawson programs are documented as updating or referencing this table.