POVAGRMTLN FILE
REFERENCED BY
PO225 PO227 PO26.1 PO28.1 POA3.1 POI1.1
IC11.1
UPDATED BY
PO125 POIH.1 POIJ.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PVN-PROCURE-GROUP Alpha 4 PO26.1 PO28.1
Procure Group This field contains the identifier for a POI1.1 POIJ.1
group of companies that share a common
procurement effort. They buy items and
services together.
PVN-VEN-AGRMT-REF Alpha 30 PO26.1 PO28.1
Ven Agrmt Ref POI1.1 POIJ.1
PVN-LINE-NBR Numeric 6 PO26.1 PO28.1
Line Number This field contains the line number. POI1.1 POIJ.1
PVN-MAS-LINE-NBR Numeric 6 PO26.1 PO28.1
Mas Line Nbr POI1.1 POIJ.1
PVN-AGMT-TYPE Alpha 1 PO26.1 PO28.1
Agmt Type C = Contract POI1.1 POIJ.1
B = Blanket
S = Standing
T = Catalog/Quote
V = Service
PVN-VENDOR Alpha 9 (Right Justified) PO26.1 PO28.1
Vendor ID The vendor's identification code. POI1.1 POIJ.1
PVN-PURCH-FR-LOC Alpha 4 PO26.1 PO28.1
Purchase From The vendor's purchase from location. POI1.1 POIJ.1
Location Code
PVN-MAS-AGRMT-REF Alpha 30 PO26.1 PO28.1
Mas Agrmt Ref POI1.1 POIJ.1
PVN-ITEM Alpha 32 PO26.1 PO28.1
Item Number This field contains the item POI1.1 POIJ.1
identifier.
PVN-VEN-ITEM Alpha 32 PO26.1 PO28.1
Vendor Item The vendor's item identifer. POI1.1 POIJ.1
PVN-NDC-NBR Alpha 15 PO26.1 PO28.1
National Drug Code National Drug Code. POI1.1 POIJ.1
PVN-MANUF-NBR Alpha 15 PO26.1 PO28.1
Manufacturer's Item This is the identifier that the POI1.1 POIJ.1
Number manufacturer has assigned to an item.
PVN-DESCRIPTION Alpha 30 (Lower Case) PO125 PO26.1
Description This field displays the description. PO28.1 POI1.1
POIJ.1
PVN-DESCRIPTION2 Alpha 30 (Lower Case) PO26.1 PO28.1
Second Description This field contains the second line of POI1.1 POIJ.1
the description.
PVN-BASE-COST Signed 13.5 PO26.1 PO28.1
Base Cost This unit cost is the standard cost or POI1.1 POIJ.1
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.
PVN-COST-OPTION Alpha 1 PO26.1 PO28.1
Cost Option 1 = Cost Required POI1.1 POIJ.1
2 = No Charge
3 = Vendor Determined
PVN-BASE-PERCENT Percent 6.3 (Percent) PO26.1 PO28.1
Base Percent POI1.1 POIJ.1
PVN-CURRENT-PCT Percent 6.3 (Percent) PO26.1 PO28.1
Current Pct POI1.1 POIH.1
POIJ.1
PVN-BEG-NET-CST Signed 13.5 PO26.1 PO28.1
Beg Net Cst POI1.1 POIJ.1
PVN-CURR-NET-CST Signed 13.5 PO26.1 PO28.1
Curr Net Cst POI1.1 POIH.1
POIJ.1
PVN-DEFBUY-UCOST Numeric 13 PO26.1 PO28.1
Defbuy Ucost POI1.1 POIJ.1
PVN-QUANTITY Signed 13.4 PO26.1 PO28.1
Quantity This field contains the desired POI1.1 POIJ.1
quantity.
PVN-UOM Alpha 4 PO26.1 PO28.1
Unit of Measure This field contains the valid stock POI1.1 POIJ.1
unit of measure for this item.
PVN-UOM-MULT Signed 13.7 PO125 PO26.1
Unit of Measure This field contains the multiplier for PO28.1 POI1.1
Multiplier converting this unit of measure to the POIJ.1
stock unit of measure.
PVN-MATCH-UOM-FL Alpha 1 PO26.1 PO28.1
Match Uom Fl Y = Yes POI1.1 POIJ.1
N = No
PVN-ITEM-TYPE Alpha 1 PO26.1 PO28.1
Item Type This field identifies the line item POI1.1 POIJ.1
type.
" " = Item Master Exists
X = Special
S = Services
PVN-SERVICE-CODE Alpha 1 PO26.1 PO28.1
Service Code Q = Quantity POI1.1 POIJ.1
A = Amount
PVN-MARKUP-DISC Alpha 1 PO26.1 PO28.1
Markup Disc M = Markup POI1.1 POIJ.1
D = Discount
PVN-STOCKLESS-FL Alpha 1 PO26.1 PO28.1
Stockless Fl Y = Yes POI1.1 POIJ.1
N = No
PVN-PRIORITY Numeric 1 PO26.1 PO28.1
Priority Number Indicates order of precedence for POI1.1 POIJ.1
contracts to determine costing defaults
for items.
PVN-HOLD-FLAG Alpha 1 PO26.1 PO28.1
On Hold Flag This field enables this entire lot to POI1.1 POIJ.1
be put on hold, not allowing any issues
or transfers to be made for this lot.
Y = Yes
N = No
PVN-ACCOUNT Numeric 6 PO26.1 PO28.1
Account This field along with the accounting POI1.1 POIJ.1
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
PVN-SUB-ACCT Numeric 4 PO26.1 PO28.1
Subaccount This field contains the subaccount from POI1.1 POIJ.1
your general ledger chart of accounts
that was charged with the amount carried
on this record.
PVN-ACTIVITY Alpha 15 PO26.1 PO28.1
Activity Activities are the processes or POI1.1 POIJ.1
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
PVN-ACCT-CATEGORY Alpha 5 PO26.1 PO28.1
Account Category Account categories are groupings of POI1.1 POIJ.1
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
PVN-AGRMT-MAX-QTY Numeric 10 PO26.1 PO28.1
Agrmt Max Qty POI1.1 POIJ.1
PVN-AGRMT-MAX-AMT Numeric 13 PO26.1 PO28.1
Agrmt Max Amt POI1.1 POIJ.1
PVN-ORDER-MIN-QTY Numeric 10 PO26.1 PO28.1
Order Min Qty POI1.1 POIJ.1
PVN-ORDER-MIN-AMT Numeric 13 PO26.1 PO28.1
Order Min Amt POI1.1 POIJ.1
PVN-ORDER-MAX-QTY Numeric 10 PO26.1 PO28.1
Order Max Qty POI1.1 POIJ.1
PVN-ORDER-MAX-AMT Numeric 13 PO26.1 PO28.1
Order Max Amt POI1.1 POIJ.1
PVN-PO-USER-FLD-2 Alpha 2 PO26.1 PO28.1
Purchase Order User Purchase order line user defined field. POI1.1 POIJ.1
Field 2
PVN-PO-USER-FLD-4 Alpha 30 (Lower Case) PO26.1 PO28.1
Purchase Order User Purchase order line user defined field. POI1.1 POIJ.1
Field 4
PVN-PO-USER-FLD-6 Alpha 15 (Lower Case) PO26.1 PO28.1
Purchase Order User Purchase order line user defined field. POI1.1 POIJ.1
Field 6
PVN-TAX-CODE Alpha 10 PO26.1 PO28.1
Tax Code This field contains a code representing POI1.1 POIJ.1
specific tax information. This must be
valid Tax Code.
PVN-TAXABLE-FLAG Alpha 1 PO26.1 PO28.1
Taxable or Defines if Taxable. POI1.1 POIJ.1
Non-Taxable Flag Y = Yes
N = No
PVN-TAX-USAGE-CD Alpha 10 PO26.1 PO28.1
Tax Usage Cd The tax usage coe for the vendor. This POI1.1 POIJ.1
filed is required if the AP Company
inidcates that VAT reporting required.
PVN-LNBRK-QAFLAG Alpha 1 PO26.1 PO28.1
Lnbrk Qaflag Q = Quantity POI1.1 POIJ.1
A = Amount
PVN-LNBRK-QTYAMT1 Numeric 13 PO26.1 PO28.1
Lnbrk Qtyamt1 POI1.1 POIJ.1
PVN-LNBRK-QTYAMT2 Numeric 13 PO26.1 PO28.1
Lnbrk Qtyamt2 POI1.1 POIJ.1
PVN-LNBRK-QTYAMT3 Numeric 13 PO26.1 PO28.1
Lnbrk Qtyamt3 POI1.1 POIJ.1
PVN-LNBRK-QTYAMT4 Numeric 13 PO26.1 PO28.1
Lnbrk Qtyamt4 POI1.1 POIJ.1
PVN-LNBRK-QTYAMT5 Numeric 13 PO26.1 PO28.1
Lnbrk Qtyamt5 POI1.1 POIJ.1
PVN-LNBRK-PERCENT1 Percent 6.3 (Percent) PO26.1 PO28.1
Lnbrk Percent1 POI1.1 POIJ.1
PVN-LNBRK-PERCENT2 Percent 6.3 (Percent) PO26.1 PO28.1
Lnbrk Percent2 POI1.1 POIJ.1
PVN-LNBRK-PERCENT3 Percent 6.3 (Percent) PO26.1 PO28.1
Lnbrk Percent3 POI1.1 POIJ.1
PVN-LNBRK-PERCENT4 Percent 6.3 (Percent) PO26.1 PO28.1
Lnbrk Percent4 POI1.1 POIJ.1
PVN-LNBRK-PERCENT5 Percent 6.3 (Percent) PO26.1 PO28.1
Lnbrk Percent5 POI1.1 POIJ.1
PVN-LNBRK-COST1 Signed 13.5 PO26.1 PO28.1
Lnbrk Cost1 POI1.1 POIJ.1
PVN-LNBRK-COST2 Signed 13.5 PO26.1 PO28.1
Lnbrk Cost2 POI1.1 POIJ.1
PVN-LNBRK-COST3 Signed 13.5 PO26.1 PO28.1
Lnbrk Cost3 POI1.1 POIJ.1
PVN-LNBRK-COST4 Signed 13.5 PO26.1 PO28.1
Lnbrk Cost4 POI1.1 POIJ.1
PVN-LNBRK-COST5 Signed 13.5 PO26.1 PO28.1
Lnbrk Cost5 POI1.1 POIJ.1
PVN-AMT-ORDERED Signed 15.2 PO26.1 PO28.1
Amt Ordered POI1.1 POIJ.1
PVN-QTY-ORDERED Numeric 10 PO26.1 PO28.1
Qty Ordered POI1.1 POIJ.1
POVAGRMTLN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PVNSET1 PROCURE-GROUP PO125 PO225
VEN-AGRMT-REF PO227 PO26.1
LINE-NBR PO28.1 POA3.1
POI1.1 POIH.1
POIJ.1
PVNSET2 PROCURE-GROUP KeyChange, Subset PO28.1 POI1.1
AGMT-TYPE Where HOLD-FLAG = "N" POIH.1
VENDOR And ((AGMT-TYPE = "C" )
ITEM Or (AGMT-TYPE = "B" )
PRIORITY Or (AGMT-TYPE = "T" ))
DEFBUY-UCOST And STOCKLESS-FL = "N"
VEN-AGRMT-REF
LINE-NBR
PVNSET3 PROCURE-GROUP KeyChange, Subset PO28.1 POI1.1
AGMT-TYPE Where HOLD-FLAG = "N" POIH.1
ITEM And ((AGMT-TYPE = "C" )
PRIORITY Or (AGMT-TYPE = "B" )
DEFBUY-UCOST Or (AGMT-TYPE = "T" ))
VEN-AGRMT-REF And STOCKLESS-FL = "N"
LINE-NBR
PVNSET4 PROCURE-GROUP KeyChange PO26.1 PO28.1
VEN-AGRMT-REF POI1.1 POIH.1
ITEM POIJ.1
DEFBUY-UCOST
LINE-NBR
PVNSET5 PROCURE-GROUP KeyChange IC11.1 PO28.1
ITEM POI1.1
VEN-AGRMT-REF
LINE-NBR
PVNSET6 PROCURE-GROUP KeyChange, Subset PO28.1 POI1.1
ITEM Where STOCKLESS-FL = "Y" POIH.1
PRIORITY And AGMT-TYPE = "C"
DEFBUY-UCOST And HOLD-FLAG = "N"
VEN-AGRMT-REF
LINE-NBR
PVNSET7 PROCURE-GROUP Subset
MAS-AGRMT-REF Where MAS-AGRMT-REF != Spaces
MAS-LINE-NBR
VEN-AGRMT-REF
LINE-NBR
PVNSET8 PROCURE-GROUP KeyChange, Subset
VEN-ITEM Where VEN-ITEM != Spaces
VEN-AGRMT-REF
LINE-NBR
PVNSET9 PROCURE-GROUP KeyChange POIJ.1
VEN-AGRMT-REF
ITEM
UOM
LINE-NBR
POVAGRMTLN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemndc ITEMNDC Required
PCG-ITEM-GROUP -> IDC-ITEM-GROUP
PVN-ITEM -> IDC-ITEM
PVN-NDC-NBR -> IDC-NDC-NBR
Procuregrp PROCUREGRP Required
PVN-PROCURE-GROUP -> PCG-PROCURE-GROUP
POVAGRMTLN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Poagmtpart POAGMTPART
PVN-PROCURE-GROUP -> PRK-PROCURE-GROUP
PVN-VEN-AGRMT-REF -> PRK-VEN-AGRMT-REF
PRK-COMPANY
PRK-LOCATION
PRK-REQ-LOCATION
Poagmtpric POAGMTPRIC
PVN-PROCURE-GROUP -> PRI-PROCURE-GROUP
PVN-MAS-AGRMT-REF -> PRI-MAS-AGRMT-REF
PVN-VEN-AGRMT-REF -> PRI-VEN-AGRMT-REF
PRI-EFFECTIVE-DT
Poaocdtl POAOCDTL Delete Cascades
PVN-PROCURE-GROUP -> PAO-PROCURE-GROUP
PVN-VEN-AGRMT-REF -> PAO-VEN-AGRMT-REF
PVN-LINE-NBR -> PAO-LINE-NBR
PAO-AOC-CODE
|
