 |
Lawson Insight Technical Documentation |
|
POMAGRMTHD FILE
REFERENCED BY
PO150 PO225 PO23.6 PO27.2 PO27.4 PO28.1
POI1.1 POI7.1
UPDATED BY
PO25.1 PO300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PMH-PROCURE-GROUP Alpha 4 PO150 PO23.6
Procure Group This field contains the identifier for a PO25.1 PO25.2
group of companies that share a common PO25.3 PO25.7
procurement effort. They buy items and PO25.8 PO27.2
services together. PO27.4 PO28.1
PO300 POI1.1
PMH-MAS-AGRMT-REF Alpha 30 PO150 PO23.6
Mas Agrmt Ref PO25.1 PO25.2
PO25.3 PO25.7
PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PMH-VENDOR Alpha 9 (Right Justified) PO150 PO23.6
Vendor ID The vendor's identification code. PO25.1 PO25.2
PO25.3 PO25.7
PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PMH-PURCH-FR-LOC Alpha 4 PO150 PO23.6
Purchase From The vendor's purchase from location. PO25.1 PO25.2
Location Code PO25.3 PO25.7
PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PMH-AGMT-TYPE Alpha 1 PO150 PO23.6
Agmt Type C = Contract PO25.1 PO25.2
B = Blanket PO25.3 PO25.7
T = Catalog/Quote PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PMH-DESCRIPTION Alpha 30 (Lower Case) PO150 PO23.6
Description This field displays the description. PO25.1 PO25.2
PO25.3 PO25.7
PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PMH-DESCRIPTION2 Alpha 30 (Lower Case) PO150 PO23.6
Second Description This field contains the second line of PO25.1 PO25.2
the description. PO25.3 PO25.7
PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PMH-GRP-PURCH-ORG Alpha 9 (Right Justified) PO150 PO23.6
Grp Purch Org PO25.1 PO25.2
PO25.3 PO25.7
PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PMH-AGRMT-ADMIN Alpha 10 (Lower Case) PO150 PO23.6
Agrmt Admin PO25.1 PO25.2
PO25.3 PO25.7
PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PMH-MANUF-CODE Alpha 4 PO150 PO23.6
Manufacturer's Code This field contains a user defined code PO25.1 PO25.2
that indicates the manufacturer of an PO25.3 PO25.7
item. PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PMH-MANUF-DIVISION Alpha 4 PO150 PO23.6
Manufacturer's This is a user defined code that PO25.1 PO25.2
Division indicates which division of a PO25.3 PO25.7
manufacturer is tied to an item. PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PMH-TERM-CODE Alpha 5 PO150 PO23.6
Terms Code A user-defined code representing a PO25.1 PO25.2
method of determining invoice due and PO25.3 PO25.7
discount dates. PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PMH-EFFECTIVE-DT Numeric 8 (yyyymmdd) PO150 PO23.6
Effective Date PO25.1 PO25.2
PO25.3 PO25.7
PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PMH-EXPIRE-DT Numeric 8 (yyyymmdd) PO150 PO23.6
Expire Dt PO25.1 PO25.2
PO25.3 PO25.7
PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PMH-FREIGHT-TERMS Alpha 1 PO150 PO23.6
Freight Terms Freight terms are used to define who PO25.1 PO25.2
pays for freight costs incurred when PO25.3 PO25.7
goods are shipped. Prepaid, for PO25.8 PO27.2
instance, would normally mean that the PO27.4 PO28.1
vendor would pay for freight. Collect PO300 POI1.1
would mean the customer would pay for
freight.
A freight terms code can be entered on
a purchase order, or defaulted by vendor
or company.
PMH-FOB-CODE Alpha 3 PO150 PO23.6
Shipping Term Code The user defined Free On Board Code. PO25.1 PO25.2
PO25.3 PO25.7
PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PMH-CURRENCY-CODE Alpha 5 PO150 PO23.6
Currency Code This field contains the company base PO25.1 PO25.2
currency code established in Company PO25.3 PO25.7
(GL10.1 ). PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PMH-ORDER-MIN-AMT Numeric 13 PO150 PO23.6
Order Min Amt PO25.1 PO25.2
PO25.3 PO25.7
PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PMH-DS-AGRMT-REF Alpha 30 PO150 PO23.6
Ds Agrmt Ref PO25.1 PO25.2
PO25.3 PO25.7
PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
PMH-LAST-LINE-NBR Numeric 6 PO150 PO23.6
Last Line Number This field contains the number of the PO25.1 PO25.2
last line item added to the document. It PO25.3 PO25.7
is used to determine what the next line PO25.8 PO27.2
number is when you add another PO27.4 PO28.1
item. PO300 POI1.1
PMH-STOCKLESS-FL Alpha 1 PO150 PO23.6
Stockless Fl Y = Yes PO25.1 PO25.2
N = No PO25.3 PO25.7
PO25.8 PO27.2
PO27.4 PO28.1
PO300 POI1.1
POMAGRMTHD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PMHSET1 PROCURE-GROUP PO150 PO225
MAS-AGRMT-REF PO23.6 PO25.1
PO25.2 PO25.3
PO25.7 PO25.8
PO27.2 PO27.4
PO28.1 PO300
POI1.1 POI7.1
PMHSET2 PROCURE-GROUP This key was added to allow alternate PO300
MAS-AGRMT-REF file access for correcting DBAPIERROR
VENDOR problems.
KeyChange
POMAGRMTHD FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Poagmtpric POAGMTPRIC
PMH-PROCURE-GROUP -> PRI-PROCURE-GROUP
PMH-MAS-AGRMT-REF -> PRI-MAS-AGRMT-REF
Spaces -> PRI-VEN-AGRMT-REF
PRI-EFFECTIVE-DT
Pomagrmtln POMAGRMTLN
PMH-PROCURE-GROUP -> PML-PROCURE-GROUP
PMH-MAS-AGRMT-REF -> PML-MAS-AGRMT-REF
PML-LINE-NBR
Povagrmthd POVAGRMTHD
PMH-PROCURE-GROUP -> PVH-PROCURE-GROUP
PMH-MAS-AGRMT-REF -> PVH-MAS-AGRMT-REF
PVH-VEN-AGRMT-REF
|