POMAGRMTLN FILE
REFERENCED BY
PO225 PO28.1 POI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PML-PROCURE-GROUP Alpha 4 PO28.1 POI1.1
Procure Group This field contains the identifier for a
group of companies that share a common
procurement effort. They buy items and
services together.
PML-MAS-AGRMT-REF Alpha 30 PO28.1 POI1.1
Mas Agrmt Ref
PML-LINE-NBR Numeric 6 PO28.1 POI1.1
Line Number This field contains the line number.
PML-VEN-ITEM Alpha 32 PO28.1 POI1.1
Vendor Item The vendor's item identifer.
PML-ITEM Alpha 32 PO28.1 POI1.1
Item Number This field contains the item
identifier.
PML-NDC-NBR Alpha 15 PO28.1 POI1.1
National Drug Code National Drug Code.
PML-MANUF-NBR Alpha 15 PO28.1 POI1.1
Manufacturer's Item This is the identifier that the
Number manufacturer has assigned to an item.
PML-DESCRIPTION Alpha 30 (Lower Case) PO28.1 POI1.1
Description This field displays the description.
PML-DESCRIPTION2 Alpha 30 (Lower Case) PO28.1 POI1.1
Second Description This field contains the second line of
the description.
PML-UOM Alpha 4 PO28.1 POI1.1
Unit of Measure This field contains the valid stock
unit of measure for this item.
PML-UOM-MULT Signed 13.7 PO28.1 POI1.1
Unit of Measure This field contains the multiplier for
Multiplier converting this unit of measure to the
stock unit of measure.
PML-BASE-COST Signed 13.5 PO28.1 POI1.1
Base Cost This unit cost is the standard cost or
saved average cost used to calculate a
cost variance. The average cost
variance comes into play if the stock on
hand quantity is allowed to go negative
and the company costing method is
average cost.
PML-COST-OPTION Alpha 1 PO28.1 POI1.1
Cost Option 1 = Cost Required
2 = No Charge
3 = Vendor Determined
POMAGRMTLN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PMLSET1 PROCURE-GROUP PO225 PO28.1
MAS-AGRMT-REF POI1.1
LINE-NBR
PMLSET2 PROCURE-GROUP KeyChange, Subset PO28.1 POI1.1
ITEM Where ITEM != Spaces
MAS-AGRMT-REF
LINE-NBR
PMLSET3 PROCURE-GROUP KeyChange, Subset PO28.1 POI1.1
VEN-ITEM Where VEN-ITEM != Spaces
MAS-AGRMT-REF
LINE-NBR
PMLSET4 PROCURE-GROUP KeyChange PO28.1 POI1.1
MAS-AGRMT-REF
VEN-ITEM
ITEM
LINE-NBR
PMLSET5 PROCURE-GROUP KeyChange PO28.1 POI1.1
MAS-AGRMT-REF
ITEM
LINE-NBR
POMAGRMTLN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemmast ITEMMAST Required
PCG-ITEM-GROUP -> ITE-ITEM-GROUP
PML-ITEM -> ITE-ITEM
Poitemven POITEMVEN Required
PML-PROCURE-GROUP -> PIV-PROCURE-GROUP
PMH-VENDOR -> PIV-VENDOR
PML-ITEM -> PIV-VEN-ITEM
Pomagrmthd POMAGRMTHD Required
PML-PROCURE-GROUP -> PMH-PROCURE-GROUP
PML-MAS-AGRMT-REF -> PMH-MAS-AGRMT-REF
Procuregrp PROCUREGRP Required
PML-PROCURE-GROUP -> PCG-PROCURE-GROUP
POMAGRMTLN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Povagrmtln POVAGRMTLN
PML-PROCURE-GROUP -> PVN-PROCURE-GROUP
PML-MAS-AGRMT-REF -> PVN-MAS-AGRMT-REF
PML-LINE-NBR -> PVN-MAS-LINE-NBR
PVN-VEN-AGRMT-REF
PVN-LINE-NBR
|
