 |
Lawson Insight Technical Documentation |
|
POMAGRMTLN FILE
REFERENCED BY
PO150 PO225 PO23.6 PO27.2 PO27.4 PO28.1
POI1.1 PO13.1
UPDATED BY
PO25.1 PO300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PML-PROCURE-GROUP Alpha 4 PO150 PO23.6
Procure Group This field contains the identifier for a PO25.1 PO25.7
group of companies that share a common PO25.8 PO27.2
procurement effort. They buy items and PO27.4 PO28.1
services together. PO300 POI1.1
PML-MAS-AGRMT-REF Alpha 30 PO150 PO23.6
Mas Agrmt Ref PO25.1 PO25.7
PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PML-LINE-NBR Numeric 6 PO150 PO23.6
Line Number This field contains the line number. PO25.1 PO25.7
PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PML-VEN-ITEM Alpha 32 PO150 PO23.6
Vendor Item The vendor's item identifer. PO25.1 PO25.7
PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PML-ITEM Alpha 32 PO150 PO23.6
Item Number This field contains the item PO25.1 PO25.7
identifier. PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PML-NDC-NBR Alpha 15 PO150 PO23.6
National Drug Code National Drug Code. PO25.1 PO25.7
PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PML-MANUF-NBR Alpha 15 PO150 PO23.6
Manufacturer's Item This is the identifier that the PO25.1 PO25.7
Number manufacturer has assigned to an item. PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PML-DESCRIPTION Alpha 30 (Lower Case) PO150 PO23.6
Description This field displays the description. PO25.1 PO25.7
PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PML-DESCRIPTION2 Alpha 30 (Lower Case) PO150 PO23.6
Second Description This field contains the second line of PO25.1 PO25.7
the description. PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PML-UOM Alpha 4 PO150 PO23.6
Unit of Measure This field contains the valid stock PO25.1 PO25.7
unit of measure for this item. PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PML-UOM-MULT Signed 13.7 PO150 PO23.6
Unit of Measure This field contains the multiplier for PO25.1 PO25.7
Multiplier converting this unit of measure to the PO25.8 PO27.2
stock unit of measure. PO27.4 PO28.1
PO300 POI1.1
PML-BASE-COST Signed 13.5 PO150 PO23.6
Base Cost This unit cost is the standard cost or PO25.1 PO25.7
saved average cost used to calculate a PO25.8 PO27.2
cost variance. The average cost PO27.4 PO28.1
variance comes into play if the stock on PO300 POI1.1
hand quantity is allowed to go negative
and the company costing method is
average cost.
PML-COST-OPTION Alpha 1 PO150 PO23.6
Cost Option 1 = Cost Required PO25.1 PO25.7
2 = No Charge PO25.8 PO27.2
3 = Vendor Determined PO27.4 PO28.1
PO300 POI1.1
POMAGRMTLN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PMLSET1 PROCURE-GROUP PO150 PO225
MAS-AGRMT-REF PO23.6 PO25.1
LINE-NBR PO25.7 PO25.8
PO27.2 PO27.4
PO28.1 PO300
POI1.1
PMLSET2 PROCURE-GROUP KeyChange, Subset PO150 PO23.6
ITEM Where ITEM != Spaces PO25.1 PO25.7
MAS-AGRMT-REF PO25.8 PO27.2
LINE-NBR PO27.4 PO28.1
PO300 POI1.1
PMLSET3 PROCURE-GROUP KeyChange, Subset PO13.1 PO150
VEN-ITEM Where VEN-ITEM != Spaces PO23.6 PO25.1
MAS-AGRMT-REF PO25.7 PO25.8
LINE-NBR PO27.2 PO27.4
PO28.1 PO300
POI1.1
PMLSET4 PROCURE-GROUP KeyChange PO150 PO23.6
MAS-AGRMT-REF PO25.1 PO25.7
VEN-ITEM PO25.8 PO27.2
ITEM PO27.4 PO28.1
LINE-NBR PO300 POI1.1
PMLSET5 PROCURE-GROUP KeyChange PO150 PO23.6
MAS-AGRMT-REF PO25.1 PO25.7
ITEM PO25.8 PO27.2
LINE-NBR PO27.4 PO28.1
PO300 POI1.1
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
|