POPREFDMFG

Preferred Manufacturer

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

REFERENCED BY
POIH.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PMF-COMPANY
Element: 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
Element: Item
Alpha 32
This field contains the item identifier.
PMF-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
PMF-REQ-LOCATION
Element: Req Location
Alpha 5
The location requisitioning items. This location can be an inventory or noninventory location.
PMF-CONTRACT-GROUP
Element: Enterprise Grp
Alpha 4
This field contains the identifier for a group of contracts that can be shared by one or more companies.
PMF-CM-CONTRACT
Element: Cm Contract
Numeric 15
PMF-MANUF-CODE
Element: Manuf Code
Alpha 4
This field contains a user defined code that indicates the manufacturer of an item.
PMF-MANUF-DIVISION
Element: Manuf Division
Alpha 4
This is a user defined code that indicates which division of a manufacturer is tied to an item.


POPREFDMFG FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PMFSET1 COMPANY
ITEM
LOCATION
REQ-LOCATION
POIH.1


POPREFDMFG FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


POPREFDMFG FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 11:24:38 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.