POPREFDMFG – Preferred Manufacturer

System
Purchase Order (PO)
Prefix
PMF
Primary key
COMPANY, ITEM, LOCATION, REQ-LOCATION
Fields
8
Updated by
0 programs
Referenced by
0 programs

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.

Fields (8)

Column = COBOL field name without the PMF- 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 / columnTypeDescription & valuesUpdated by
#PMF-COMPANY PK
COMPANY		Numeric 4Identifies 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 32This field contains the item identifier.—
#PMF-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.—
#PMF-REQ-LOCATION PK
REQ_LOCATION		Alpha 5The location requisitioning items. This location can be an inventory or noninventory location.—
#PMF-CONTRACT-GROUP
CONTRACT_GROUP		Alpha 4This 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 4This field contains a user defined code that indicates the manufacturer of an item.—
#PMF-MANUF-DIVISION
MANUF_DIVISION		Alpha 4This is a user defined code that indicates which division of a manufacturer is tied to an item.—

Indexes (1)

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.

IndexKeysFlagsConditionUsed in
PMFSET1
  1. COMPANY
  2. ITEM
  3. LOCATION
  4. REQ-LOCATION
PrimaryPOIH.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ICCOMPANYICLOCATIONICMANFCODEITEMMASTPOCOMPANYPOCONTGRPPOCONTRACTRQLOCPOITEMVENPOLINEPOVAGRMTLNREQLINEPOPREFDMFG

One to one (8) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYRequired
PMF-COMPANY→ICC-COMPANY
IclocationICLOCATIONRequiredWhen PMF-LOCATION != Spaces
PMF-COMPANY→ICL-COMPANY
PMF-LOCATION→ICL-LOCATION
IcmanfcodeICMANFCODERequiredWhen PMF-MANUF-CODE != Spaces
ICC-ITEM-GROUP→IMC-ITEM-GROUP
PMF-MANUF-CODE→IMC-MANUF-CODE
PMF-MANUF-DIVISION→IMC-MANUF-DIVISION
ItemmastITEMMASTRequired
ICC-ITEM-GROUP→ITE-ITEM-GROUP
PMF-ITEM→ITE-ITEM
PocompanyPOCOMPANYRequired
PMF-COMPANY→PCY-COMPANY
PocontgrpPOCONTGRPRequiredWhen PMF-CM-CONTRACT != Zeroes
PMF-CONTRACT-GROUP→CNG-CONTRACT-GROUP
PocontractPOCONTRACTRequiredWhen PMF-CM-CONTRACT != Zeroes
PMF-CONTRACT-GROUP→CMH-CONTRACT-GROUP
PMF-CM-CONTRACT→CMH-CM-CONTRACT
RqlocRQLOCRequiredWhen PMF-REQ-LOCATION != Spaces
PMF-COMPANY→RQL-COMPANY
PMF-REQ-LOCATION→RQL-REQ-LOCATION

One to many (4) — child tables

RelationTableRulesConditionField map
PoitemvenPOITEMVEN
PCY-PROCURE-GROUP→PIV-PROCURE-GROUP
PMF-ITEM→PIV-ITEM
—→PIV-VENDOR
—→PIV-VEN-ITEM
PolinePOLINEValid 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
PovagrmtlnPOVAGRMTLNValid 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
ReqlineREQLINEValid 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

Programs

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