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