 |
Lawson Insight Technical Documentation |
|
POVAGRMTHD FILE
REFERENCED BY
POA3.1 DR100 IC141 IC142 IC83.1 PO225
PO226 PO227 PO26.1 PO28.1 POI1.1 POIH.1
RQ11.1 POI4.1 POI6.1 AP300 API3.1 API4.1
UPDATED BY
POIJ.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PVH-PROCURE-GROUP Alpha 4 DR100 IC141
Procure Group This field contains the identifier for a IC142 IC83.1
group of companies that share a common PO227 PO26.1
procurement effort. They buy items and PO28.1 POI1.1
services together. POIJ.1 RQ11.1
PVH-VEN-AGRMT-REF Alpha 30 DR100 IC141
Ven Agrmt Ref IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-VENDOR Alpha 9 (Right Justified) DR100 IC141
Vendor ID The vendor's identification code. IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-PURCH-FR-LOC Alpha 4 DR100 IC141
Purchase From The vendor's purchase from location. IC142 IC83.1
Location Code PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-MAS-AGRMT-REF Alpha 30 DR100 IC141
Mas Agrmt Ref IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-DESCRIPTION Alpha 30 (Lower Case) DR100 IC141
Description This field displays the description. IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-DESCRIPTION2 Alpha 30 (Lower Case) DR100 IC141
Second Description This field contains the second line of IC142 IC83.1
the description. PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-EFFECTIVE-DT Numeric 8 (yyyymmdd) DR100 IC141
Effective Date IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-EXPIRE-DT Numeric 8 (yyyymmdd) DR100 IC141
Expire Dt IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-REVIEW-DATE Numeric 8 (yyyymmdd) DR100 IC141
Review Date IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-BUYER Alpha 3 DR100 IC141
Buyer IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-AGRMT-ADMIN Alpha 10 (Lower Case) DR100 IC141
Agrmt Admin IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-HOLD-FLAG Alpha 1 DR100 IC141
On Hold Flag This field enables this entire lot to IC142 IC83.1
be put on hold, not allowing any issues PO227 PO26.1
or transfers to be made for this lot. PO28.1 POI1.1
Y = Yes POIJ.1 RQ11.1
N = No
PVH-PRIORITY Numeric 1 DR100 IC141
Priority Number Indicates order of precedence for IC142 IC83.1
contracts to determine costing defaults PO227 PO26.1
for items. PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-FREIGHT-TERMS Alpha 1 DR100 IC141
Freight Terms Freight terms are used to define who IC142 IC83.1
pays for freight costs incurred when PO227 PO26.1
goods are shipped. Prepaid, for PO28.1 POI1.1
instance, would normally mean that the POIJ.1 RQ11.1
vendor would pay for freight. Collect
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.
PVH-FOB-CODE Alpha 3 DR100 IC141
Shipping Term Code The user defined Free On Board Code. IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-TERM-CODE Alpha 5 DR100 IC141
Terms Code A user-defined code representing a IC142 IC83.1
method of determining invoice due and PO227 PO26.1
discount dates. PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-CURRENCY-CODE Alpha 5 DR100 IC141
Currency Code This field contains the company base IC142 IC83.1
currency code established in Company PO227 PO26.1
(GL10.1 ). PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-TAX-CODE Alpha 10 DR100 IC141
Tax Code This field contains a code representing IC142 IC83.1
specific tax information. This must be PO227 PO26.1
valid Tax Code. PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-DFLT-TAXBL-FL Alpha 1 DR100 IC141
Default Taxable Flag This taxable flag is used for IC142 IC83.1
defaulting a 'Y'es, 'N'o into Special PO227 PO26.1
and Service items when applying them to PO28.1 POI1.1
a Purchase Order. POIJ.1 RQ11.1
Non-stock and Inventory items will
have this flag defined in the Lawson
Inventory System.
Y = Yes
N = No
PVH-DFLT-ACCOUNT Numeric 6 DR100 IC141
Dflt Account IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-DFLT-SUB-ACCT Numeric 4 DR100 IC141
Dflt Sub Acct IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-DFLT-ACTIVITY Alpha 15 DR100 IC141
Dflt Activity IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-DFLT-ACCT-CAT Alpha 5 DR100 IC141
Dflt Acct Cat IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-GRP-PURCH-ORG Alpha 9 (Right Justified) DR100 IC141
Grp Purch Org IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-MANUF-CODE Alpha 4 DR100 IC141
Manufacturer's Code This field contains a user defined code IC142 IC83.1
that indicates the manufacturer of an PO227 PO26.1
item. PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-MANUF-DIVISION Alpha 4 DR100 IC141
Manufacturer's This is a user defined code that IC142 IC83.1
Division indicates which division of a PO227 PO26.1
manufacturer is tied to an item. PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-AGMT-TYPE Alpha 1 DR100 IC141
Agmt Type C = Contract IC142 IC83.1
B = Blanket PO227 PO26.1
S = Standing PO28.1 POI1.1
T = Catalog/Quote POIJ.1 RQ11.1
V = Service
PVH-PO-NUMBER Alpha 14 (Right Justified) DR100 IC141
PO Number This field contains the number IC142 IC83.1
representing the purchase order. PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-PO-CODE Alpha 4 DR100 IC141
Po Code This is the purchase order code. IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-LAST-PO-REL Numeric 4 DR100 IC141
Last Std Order IC142 IC83.1
Release Number PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-PO-USER-FLD-1 Alpha 1 DR100 IC141
Purchase Order User Purchase Order header user field one. IC142 IC83.1
Field 1 PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-PO-USER-FLD-3 Alpha 10 (Lower Case) DR100 IC141
Purchase Order User Purchase Order header user field two. IC142 IC83.1
Field 3 PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-PO-USER-FLD-5 Alpha 30 (Lower Case) DR100 IC141
Purchase Order User Purchase Order header user field three. IC142 IC83.1
Field 5 PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-NOTIFY-FLAG Alpha 1 DR100 IC141
Notify Flag Y = Admin Notified IC142 IC83.1
N = No PO227 PO26.1
" " PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-AGRMT-MAX-AMT Numeric 13 DR100 IC141
Agrmt Max Amt IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-AGRMT-MAX-PCT Numeric 3 DR100 IC141
Agrmt Max Pct If a value is entered here, a value must IC142 IC83.1
have been entered in the agreement PO227 PO26.1
maximum amount field. A valid login must PO28.1 POI1.1
also have been entered for the agreement POIJ.1 RQ11.1
administrator. Then, when the amount
ordered on the agreement divided by the
agreement max amount equals or exceeds
the percent entered in this field, a
message will be sent to the agreement
administrator.
PVH-ORDER-MIN-AMT Numeric 13 DR100 IC141
Order Min Amt IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-ORDER-MAX-AMT Numeric 13 DR100 IC141
Order Max Amt IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-PCT-ORDERED Percent 6.3 (Percent) DR100 IC141
Pct Ordered IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-PCT-REMAINING Percent 6.3 (Percent) DR100 IC141
Pct Remaining IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-STOCKLESS-FL Alpha 1 DR100 IC141
Stockless Fl Y = Yes IC142 IC83.1
N = No PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-AMT-ORDERED Signed 15.2 DR100 IC141
Amt Ordered IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-AMT-REMAINING Signed 15.2 DR100 IC141
Amt Remaining IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-LAST-LINE-NBR Numeric 6 DR100 IC141
Last Line Number This field contains the number of the IC142 IC83.1
last line item added to the document. It PO227 PO26.1
is used to determine what the next line PO28.1 POI1.1
number is when you add another POIJ.1 RQ11.1
item.
PVH-LN-BRK-LEV-FL Alpha 1 DR100 IC141
Ln Brk Lev Fl A = Agreement IC142 IC83.1
O = Order PO227 PO26.1
" " PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-SCH-FREQUENCY Alpha 1 DR100 IC141
Sch Frequency W = Weekly IC142 IC83.1
B = Bi Weekly PO227 PO26.1
M = Monthly PO28.1 POI1.1
Q = Quarterly POIJ.1 RQ11.1
PVH-SCH-NO-OF-REL Numeric 4 DR100 IC141
Sch No Of Rel IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-ISSUE-FLAG Alpha 1 DR100 IC141
Issue Flag 1 = Do Not Issue IC142 IC83.1
" " PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-LAST-REL-DATE Numeric 8 (yyyymmdd) DR100 IC141
Last Rel Date IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-MATCH-UOM-FL Alpha 1 DR100 IC141
Match Uom Fl Y = Yes IC142 IC83.1
N = No PO227 PO26.1
" " PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-OVERID-UOM-FL Alpha 1 DR100 IC141
Overid Uom Fl Y = Yes IC142 IC83.1
N = No PO227 PO26.1
PO28.1 POI1.1
POIJ.1 RQ11.1
PVH-ALLW-UNDEF-ITM Alpha 1
Allw Undef Itm Y = Yes
N = No
POVAGRMTHD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PVHSET1 PROCURE-GROUP DR100 IC141
VEN-AGRMT-REF IC142 IC83.1
PO225 PO226
PO227 PO26.1
PO28.1 POI1.1
POIH.1 POIJ.1
RQ11.1
PVHSET2 PROCURE-GROUP KeyChange, Subset DR100 IC141
PO-NUMBER* Where PO-NUMBER != Spaces IC142 IC83.1
PO227 PO26.1
PO28.1 POI1.1
POI4.1 POI6.1
POIJ.1 RQ11.1
PVHSET3 PROCURE-GROUP KeyChange AP300 API3.1
VENDOR API4.1 PO227
PURCH-FR-LOC
VEN-AGRMT-REF
PVHSET4 PROCURE-GROUP Subset
MAS-AGRMT-REF Where MAS-AGRMT-REF != Spaces
VEN-AGRMT-REF
PVHSET5 PROCURE-GROUP
AGMT-TYPE
VEN-AGRMT-REF
PVHSET6 PROCURE-GROUP Subset
VEN-AGRMT-REF Where AGMT-TYPE = "S"
PVHSET7 PROCURE-GROUP Subset
VENDOR Where AGMT-TYPE = "V"
PO-NUMBER
POVAGRMTHD FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Poagmtpart POAGMTPART
PVH-PROCURE-GROUP -> PRK-PROCURE-GROUP (PRKSET1)
PVH-VEN-AGRMT-REF -> PRK-VEN-AGRMT-REF
PRK-COMPANY
PRK-LOCATION
PRK-REQ-LOCATION
Poagmtpric POAGMTPRIC
PVH-PROCURE-GROUP -> PRI-PROCURE-GROUP
PVH-MAS-AGRMT-REF -> PRI-MAS-AGRMT-REF
PVH-VEN-AGRMT-REF -> PRI-VEN-AGRMT-REF
PRI-EFFECTIVE-DT
Pocompany POCOMPANY
PVH-PROCURE-GROUP -> PCY-PROCURE-GROUP
PCY-COMPANY
Poline POLINE
PVH-PROCURE-GROUP -> PLI-PROCURE-GROUP
PVH-VEN-AGRMT-REF -> PLI-AGREEMENT-REF
PLI-COMPANY
PLI-PO-NUMBER
PLI-PO-RELEASE
PLI-PO-CODE
PLI-LINE-NBR
Povagrmtln POVAGRMTLN
PVH-PROCURE-GROUP -> PVN-PROCURE-GROUP
PVH-VEN-AGRMT-REF -> PVN-VEN-AGRMT-REF
PVN-LINE-NBR
|