 |
Lawson Insight Technical Documentation |
|
POLINE FILE
Line Items
This file contains purchase order line item information.
REFERENCED BY
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP23.1 API2.1 IC130 IC20.1 IC20.2 IC21.1
IC21.2 IC22.1 IC22.2 IC23.1 IC23.2 IC24.1
IC24.2 IC25.1 IC50.2 IC500 MA278 MA41.1
MA41.2 MA540 MA63.1 PO133 PO135 PO190
PO220 PO223 PO224 PO230 PO231 PO24.1
PO254 PO26.1 PO274 PO295 PO54.1 PO54.2
PO54.3 PO54.4 PO64.1 PO66.1 PO67.1 PO700
POA3.1 POCP.1 POI1.1 POID.1 POIF.1 POIG.1
POIH.1 POIM.1 POIT.1 RQ35.1 RQ44.1 RQ44.2
WH130 WH132 WH190 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830 MA65.1 AP220 IC145 IC45.1 PO529
PO227 PO233 PO275 PO276 PO277 PO280
IC11.1 IC12.1 PO16.1 PO16.2 PO216 PO550
PO94.1
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 API1.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 PO130 PO131 PO136 PO20.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.1
PO25.2 PO25.6 PO25.7 PO25.8 PO27.3 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
POI7.1 POIE.1 POII.1 POIJ.1 RQ10.1 RQ10.2
RQ10.3 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PLI-COMPANY Numeric 4 AP125 AP126
Company The company number represents a defined AP131 AP20.1
company and is entered on all actions. AP20.2 AP20.3
AP20.4 AP20.5
For conversion: AP20.7 AP23.1
Fatal Error - If equal to spaces, or AP25.1 AP25.2
zeros, or not numeric, or either AP26.1 AP27.1
Purchase Order company, Inventory API1.1 IC28.1
Control company, or Accounts Payable MA180 MA278
company is not found, then no purchase MA41.2 MA43.1
order lines are loaded to the purchase MA43.2 MA43.3
order. MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
PO Number This field contains the number AP131 AP20.1
representing the purchase order. AP20.2 AP20.3
AP20.4 AP20.5
For conversion: AP20.7 AP23.1
Fatal Error - If not equal to spaces, AP25.1 AP25.2
or purchase order company flag says it AP26.1 AP27.1
must be numeric and it is not, or the API1.1 IC28.1
purchase order cannot be found, then no MA180 MA278
purchase order lines are loaded for this MA41.2 MA43.1
purchase order. MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-PO-RELEASE Numeric 4 AP125 AP126
PO Release Number Used to identify a purchase order AP131 AP20.1
release (created from a Blanket or AP20.2 AP20.3
Standing order). AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-PO-CODE Alpha 4 AP125 AP126
Po Code This is the purchase order code. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-LINE-NBR Numeric 6 AP125 AP126
Line Number This field contains the line number. AP131 AP20.1
AP20.2 AP20.3
For conversion: AP20.4 AP20.5
Fatal Error - If not numeric, then do AP20.7 AP23.1
not load this purchase order line. If AP25.1 AP25.2
the line already exists and was AP26.1 AP27.1
previously processed, then skip this API1.1 IC28.1
line record. If the line already exists MA180 MA278
and was not previously processed, then MA41.1 MA41.2
the purchase order line is not loaded. MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO254
PO27.3 PO29.1
...
PLI-ITEM Alpha 32 AP125 AP126
Item Number This field contains the item identifier. AP131 AP20.1
AP20.2 AP20.3
For conversion: AP20.4 AP20.5
Fatal Error - If equal to spaces, then AP20.7 AP23.1
the purchase order line is not loaded. AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.1 MA41.2
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO254
PO27.3 PO29.1
...
PLI-ITEM-TYPE Alpha 1 AP125 AP126
Item Type Identifies the line item type. AP131 AP20.1
AP20.2 AP20.3
For conversion: AP20.4 AP20.5
Nonfatal Error - For Inventory type AP20.7 AP23.1
items, either inventory tracking flag AP25.1 AP25.2
equals N, or this is a dropship purchase AP26.1 AP27.1
order, or item location record not API1.1 IC28.1
found, then set type to Non-stock). MA180 MA278
Fatal Error - If not equal to I, N, S, MA41.2 MA43.1
X or item master record not found for I MA43.2 MA43.3
and N type items, then the purchase MA43.4 MA43.5
order line is not loaded. MA43.9 MA530
I = Inventoried MA531 MA540
S = Service MA60.2 MA60.3
X = Special MA60.5 MA61.1
N = Non-stock MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-SERVICE-CODE Alpha 1 AP125 AP126
Service Code A = Amount AP131 AP20.1
Q = Quantity AP20.2 AP20.3
" " = Non Service Item AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-DESCRIPTION Alpha 30 (Lower Case) AP125 AP126
Description This field contains the description. AP131 AP20.1
AP20.2 AP20.3
For conversion: AP20.4 AP20.5
Nonfatal Error - If equal to spaces and AP20.7 AP23.1
a Service or Special (X) type item, or AP25.1 AP25.2
an Inventory or Non-stock type item and AP26.1 AP27.1
not equal to spaces. API1.1 IC28.1
Default - Standard default description MA180 MA278
for a Special (X) and Service type MA41.2 MA43.1
items. MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-PROCURE-GROUP Alpha 4 AP125 AP126
Procure Group This field contains the identifier for a AP131 AP20.1
group of companies that share a common AP20.2 AP20.3
procurement effort. They buy items and AP20.4 AP20.5
services together. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-PO-OBJ-ID Alpha 10 (Right Justified) AP125 AP126
Po Obj Id The PO Object ID is used as a document AP131 AP20.1
number for the warehouse demand records. AP20.2 AP20.3
This field, along with the PO Line AP20.4 AP20.5
number, is used to relate POLINE AP20.7 AP23.1
records to WHDEMAND records. A unique AP25.1 AP25.2
PO Object ID is obtained when the PO AP26.1 AP27.1
number is assigned in PO creation. It is API1.1 IC28.1
passed on to the PO line when the PO MA180 MA278
line is created. The PO Object ID is MA41.2 MA43.1
populated on the PO line only for the MA43.2 MA43.3
duration of time that a WHDEMAND supply MA43.4 MA43.5
type record exists for the PO line (from MA43.9 MA530
PO line creation until full receipt or MA531 MA540
cancel or the PO line). MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-QUANTITY Signed 13.4 AP125 AP126
Quantity The order quantity in entered unit of AP131 AP20.1
measure terms. AP20.2 AP20.3
AP20.4 AP20.5
For Conversion: AP20.7 AP23.1
Allowed to be changed for matching load AP25.1 AP25.2
program. AP26.1 AP27.1
Fatal Error: Cannot be changed if this API1.1 IC28.1
is below received or approved quantity, MA180 MA278
or line is canceled. MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO254
PO27.3 PO29.1
...
PLI-VPRI-QUANTITY Signed 13.4 AP125 AP126
Vendor Price The entered line quantity system AP131 AP20.1
Quantity converted to vendor pricing terms. AP20.2 AP20.3
AP20.4 AP20.5
For conversion: AP20.7 AP23.1
Fatal Error - If not numeric, then the AP25.1 AP25.2
purchase order line is not loaded. AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-REC-QTY Signed 13.4 AP125 AP126
Received Quantity This is the total received quantity for AP131 AP20.1
this line item. AP20.2 AP20.3
AP20.4 AP20.5
For Conversion: AP20.7 AP23.1
This is allowed to be changed for AP25.1 AP25.2
matching load program. AP26.1 AP27.1
Fatal Error: API1.1 IC28.1
Cannot go below approved and unreleased MA180 MA278
approved quantity. MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-CATCH-WT-QTY Signed 13.4 AP125 AP126
Catch Weight This field contains the quantity AP131 AP20.1
Quantity received for catch weight shipments. AP20.2 AP20.3
AP20.4 AP20.5
For conversion: AP20.7 AP23.1
Fatal Error - If not numeric then this AP25.1 AP25.2
purchase order line is not loaded. AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-AGREEMENT-REF Alpha 30 AP125 AP126
Agreement Ref AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-AGRMT-REF-AMT Signed 15.2 AP125 AP126
Agrmt Ref Amt AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-LST-MATCH-UCST Signed 13.5 AP125 AP126
Lst Match Ucst AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO254
PO27.3 PO29.1
...
PLI-MATCHED-QTY Signed 13.4 AP125 AP126
Matched Qty AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
...
PLI-MATCHED-AMOUNT Signed 13.5 AP125 AP126
Matched Amount AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO254
PO27.3 PO29.1
...
PLI-SUBST-QTY Signed 13.4 AP125 AP126
Substitute Quantity This is the quantity of substitute AP131 AP20.1
items received in on this product. AP20.2 AP20.3
AP20.4 AP20.5
For conversion: AP20.7 AP23.1
Nonfatal Error - If equal to zeros and AP25.1 AP25.2
the original line number is numeric, AP26.1 AP27.1
then set original line number to the API1.1 IC28.1
purchase order line number. MA180 MA278
Fatal Error - If not equal to zeros and MA41.2 MA43.1
original line number either not numeric MA43.2 MA43.3
or equal to zeros, then the purchase MA43.4 MA43.5
order line is not loaded. MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-REJECT-QTY Signed 13.4 AP125 AP126
Inspection Reject This is the total inspection rejection AP131 AP20.1
Quantity quantity for this line item. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-ENT-UNIT-CST Signed 13.5 AP125 AP126
Entered Unit Cost The entered unit cost in vendor price AP131 AP20.1
unit of measure terms. This value may be AP20.2 AP20.3
entered directly on line or calculated AP20.4 AP20.5
from entry of cost in buy unit of AP20.7 AP23.1
measure terms. If cost is not manually AP25.1 AP25.2
entered in either unit of measure, unit AP26.1 AP27.1
costs for Inventoried, Non-Stock, X API1.1 IC28.1
(special order), and Service items MA180 MA278
default on purchase orders from the cost MA41.2 MA43.1
default routine. MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO227
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO254
PO27.3 PO29.1
...
PLI-VBUY-UNIT-CST Signed 13.5 AP125 AP126
Vbuy Unit Cst Unit cost for a purchase order line in AP131 AP20.1
PO line buy unit of measure terms. This AP20.2 AP20.3
cost can be entered directly on a AP20.4 AP20.5
purchase order line, or calculated if AP20.7 AP23.1
cost in vendor price unit of measure AP25.1 AP25.2
terms is entered directly. AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-TAXBL-UNT-CST Signed 13.5 AP125 AP126
Taxable Unit Cost The portion of the line unit cost which AP131 AP20.1
is taxable. If left blank, this field AP20.2 AP20.3
will default to the line unit cost in AP20.4 AP20.5
vendor price unit of measure terms. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-COST-CD Alpha 1 AP125 AP126
Unit Cost Origin Unit cost origin code. AP131 AP20.1
Code AP20.2 AP20.3
For conversion: AP20.4 AP20.5
Nonfatal Error - If not equal to E, L, AP20.7 AP23.1
S, Q, then set to E (the default). AP25.1 AP25.2
AP26.1 AP27.1
E = Entered API1.1 IC28.1
L = Last Cost MA180 MA278
C = Contract MA41.2 MA43.1
T = Catalog/Quote MA43.2 MA43.3
B = Blanket MA43.4 MA43.5
P = Last PO Created MA43.9 MA530
S = Standing MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-ENT-BUY-UOM Alpha 4 AP125 AP126
Entered Buy Unit Of Entered buy unit of measure. AP131 AP20.1
Measure AP20.2 AP20.3
For conversion: AP20.4 AP20.5
Fatal Error - If equal to spaces and an AP20.7 AP23.1
Inventory or Non-stock type item and AP25.1 AP25.2
unit of measure required, then the AP26.1 AP27.1
purchase order line is not loaded. API1.1 IC28.1
If a unit of measure is not required MA180 MA278
and a valid unit of measure cannot be MA41.2 MA43.1
found, or an invalid unit of measure is MA43.2 MA43.3
supplied, the purchase order line is not MA43.4 MA43.5
loaded. MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-EBUY-UOM-MULT Signed 13.7 AP125 AP126
Entered Buy UOM Entered buy unit of measure conversion AP131 AP20.1
Multiplier multiplier. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-VPRI-UOM Alpha 4 AP125 AP126
Vendor Price Unit This is the vendor pricing unit of AP131 AP20.1
of Measure measure. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-VPRI-UOM-MULT Signed 13.7 AP125 AP126
Vendor Price UOM This is the vendor pricing unit of AP131 AP20.1
Multiplier measure multiplier. It is used to AP20.2 AP20.3
convert unit cost to stock unit of AP20.4 AP20.5
measure terms. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-LAND-UNIT-CST Signed 13.5 AP125 AP126
Landed Unit Costs Landed unit cost for this item. AP131 AP20.1
This includes the tax landing costs, AP20.2 AP20.3
add-on cost landing costs besides the AP20.4 AP20.5
product unit cost. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-EARLY-DL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Early Delivery Date This field contains the early delivery AP131 AP20.1
(Rqst DT) date. AP20.2 AP20.3
AP20.4 AP20.5
For conversion: AP20.7 AP23.1
Nonfatal Error - If equal to zeros and AP25.1 AP25.2
not a Service type item, or date error AP26.1 AP27.1
exists, or the purchase order date is API1.1 IC28.1
later, or delivery date is earlier. MA180 MA278
Default - Purchase order header default MA41.2 MA43.1
delivery date. MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-LATE-DL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Late Delivery Date This field contains the late delivery AP131 AP20.1
date. AP20.2 AP20.3
AP20.4 AP20.5
For conversion: AP20.7 AP23.1
Nonfatal - If not numeric, or date AP25.1 AP25.2
error exists, or the purchase order date AP26.1 AP27.1
or early delivery date is later. API1.1 IC28.1
Default - Zeros. MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-REC-ACT-DATE Numeric 8 (yyyymmdd) AP125 AP126
Receiving Activity Last receiving activity date. AP131 AP20.1
Date AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-CLOSE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Close Date Purchase order line close date. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO254
PO27.3 PO29.1
...
PLI-LOCATION Alpha 5 AP125 AP126
Location Code This field contains a valid stocking AP131 AP20.1
location within the company inventory. AP20.2 AP20.3
AP20.4 AP20.5
For conversion: AP20.7 AP23.1
Default - PO header ship to location. AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-BUYER-CODE Alpha 3 AP125 AP126
Buyer Code The user defined buyer identifier. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-VENDOR Alpha 9 (Right Justified) AP125 AP126
Vendor ID The vendor's identification code. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-PURCH-FR-LOC Alpha 4 AP125 AP126
Purchase From The vendor's purchase from location. AP131 AP20.1
Location Code AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-VEN-ITEM Alpha 32 AP125 AP126
Vendor Item The vendor's item identifer. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-DIST-CODE Alpha 9 AP125 AP126
Distribution Code A user-defined code that may be used to AP131 AP20.1
set up common distribution attributes. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-TAX-CODE Alpha 10 AP125 AP126
Tax Code This field contains a code representing AP131 AP20.1
specific tax information. This must be AP20.2 AP20.3
valid tax code in the Tax system. AP20.4 AP20.5
AP20.7 AP23.1
For conversion: AP25.1 AP25.2
Nonfatal Error - If not found in the AP26.1 AP27.1
Tax system. API1.1 IC28.1
Fatal Error - If tax is landed for MA180 MA278
standard cost company. MA41.2 MA43.1
Default - If taxable flag equals Y, MA43.2 MA43.3
normal add time default hierarchy MA43.4 MA43.5
applied. Item location purchasing tax MA43.9 MA530
code; item master purchasing tax code; MA531 MA540
Purchase Order header tax code; Accounts MA60.2 MA60.3
Payable vendor location tax code; MA60.5 MA61.1
Accounts Payable vendor master tax code. MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-WEIGHT Signed 9.3 AP125 AP126
Unit Weight This field contains the unit weight of AP131 AP20.1
the item based on the stock unit of AP20.2 AP20.3
measure. AP20.4 AP20.5
AP20.7 AP23.1
For conversion: AP25.1 AP25.2
Nonfatal Error - If not numeric, then AP26.1 AP27.1
set to zeros. API1.1 IC28.1
Default - If an Inventory or Non-stock MA180 MA278
type item, then inventory control MA41.2 MA43.1
default. MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-CUBIC-FEET Signed 9.3 AP125 AP126
Cubic Feet This field contains the unit cubit feet AP131 AP20.1
of the item based on the stock unit of AP20.2 AP20.3
measure. AP20.4 AP20.5
AP20.7 AP23.1
For conversion: AP25.1 AP25.2
Nonfatal Error - If not numeric, then AP26.1 AP27.1
set to zeros. API1.1 IC28.1
Default - If an Inventory or a MA180 MA278
Non-stock type item, then use Inventory MA41.2 MA43.1
Control default. MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-REC-PRT-FL Alpha 1 AP125 AP126
Receiver Print Flag Indicates the line has been printed on AP131 AP20.1
PO130 (Receiving Document) AP20.2 AP20.3
AP20.4 AP20.5
For conversion: AP20.7 AP23.1
Nonfatal Error - If not equal to Y or N, AP25.1 AP25.2
then set to N. AP26.1 AP27.1
Default - Purchase order header's print API1.1 IC28.1
receivings flag. MA180 MA278
N = No MA41.2 MA43.1
Y = Yes MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO130 PO131
PO136 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO254
PO27.3 PO29.1
...
PLI-COST-OPTION Alpha 1 AP125 AP126
Cost Option 1 = Cost Required AP131 AP20.1
2 = No Charge AP20.2 AP20.3
3 = Vendor Determined AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-CERT-REQ-FL Alpha 1 AP125 AP126
Certification This flag defines if certification is AP131 AP20.1
Required Flag required for this line item. AP20.2 AP20.3
AP20.4 AP20.5
For conversion: AP20.7 AP23.1
Nonfatal Error - If not equal to Yes or AP25.1 AP25.2
No, then set to No (the default). AP26.1 AP27.1
N = No API1.1 IC28.1
Y = Yes MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-REC-INSP-FL Alpha 1 AP125 AP126
Receiving Defines if inspection is required for AP131 AP20.1
Inspection Flag this line item. It is set at receiving AP20.2 AP20.3
time. AP20.4 AP20.5
AP20.7 AP23.1
For conversion: AP25.1 AP25.2
Nonfatal Error - If not equal to Yes or AP26.1 AP27.1
No, then set to No (the default). API1.1 IC28.1
N = No MA180 MA278
Y = Yes MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-INSP-REQ-FL Alpha 1 AP125 AP126
Inspection Required Defines if inspection is required for AP131 AP20.1
Flag this line item. Set at purchase order AP20.2 AP20.3
entry time. AP20.4 AP20.5
AP20.7 AP23.1
For conversion: AP25.1 AP25.2
Nonfatal Error - If the purchase order AP26.1 AP27.1
is dropship, then set inspection API1.1 IC28.1
required flag to No. If not equal to Yes MA180 MA278
or No, then set to No (the default). MA41.2 MA43.1
N = No MA43.2 MA43.3
Y = Yes MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-MSDS-FLAG Alpha 1 AP125 AP126
Material Safety This flag indicates if this item AP131 AP20.1
DataSheet Flag requires a Material Safety Data Sheet. AP20.2 AP20.3
Y = Yes AP20.4 AP20.5
N = No AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-NO-LT-CALC-FL Alpha 1 AP125 AP126
No Lead Time Determines if leadtime generated by AP131 AP20.1
Calculation Flag this order is used in calculating AP20.2 AP20.3
leadtime for the inventoried item order AP20.4 AP20.5
by this line. AP20.7 AP23.1
AP25.1 AP25.2
For conversion: AP26.1 AP27.1
Nonfatal Error - If not equal to Yes or API1.1 IC28.1
No, then set to No (the default). MA180 MA278
N = No MA41.2 MA43.1
Y = Yes MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-TAXABLE-FLAG Alpha 1 AP125 AP126
Taxable or Defines if taxable. AP131 AP20.1
Non-Taxable Flag AP20.2 AP20.3
For conversion: AP20.4 AP20.5
Nonfatal Error - If not equal to Yes, AP20.7 AP23.1
No or spaces, then set to spaces. AP25.1 AP25.2
Default - If tax code not equal to AP26.1 AP27.1
spaces, then set to Yes. Otherwise, API1.1 IC28.1
normal add time default taxable flag MA180 MA278
hierarchy applied. Item location MA41.2 MA43.1
purchasing taxable flag; Item master MA43.2 MA43.3
purchasing taxable flag; purchase order MA43.4 MA43.5
header default taxable flag. MA43.9 MA530
Y = Yes MA531 MA540
N = No MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-OSHIP-TOL-PCT Percent 5.3 (Percent) AP125 AP126
Overshipment Quantity overshipment tolerance AP131 AP20.1
Tolerance Percent percentage. AP20.2 AP20.3
AP20.4 AP20.5
For conversion: AP20.7 AP23.1
Nonfatal Error - If not numeric, or a AP25.1 AP25.2
Service type item and not equal to AP26.1 AP27.1
zeroes, then set to zeros. API1.1 IC28.1
Default - Zeros. MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-USHIP-TOL-PCT Percent 6.3 (Percent) AP125 AP126
Cancel Backorder This is the quantity undership AP131 AP20.1
Percent percentage for automatic back order AP20.2 AP20.3
cancellation. If a value of 10% is AP20.4 AP20.5
entered here, for instance, and a AP20.7 AP23.1
quantity of 91 is shipped against an AP25.1 AP25.2
ordered quantity of 100, that would be AP26.1 AP27.1
considered a 9% undershipment. Since API1.1 IC28.1
this is less than the 10% limit, the MA180 MA278
backordered amount would be canceled. MA41.2 MA43.1
MA43.2 MA43.3
This process takes place at receiving MA43.4 MA43.5
time. If a backorder is not canceled MA43.9 MA530
manually, the system checks, in order, MA531 MA540
the purchase order line, the purchase MA60.2 MA60.3
order vendor purchase from record, the MA60.5 MA61.1
purchase order vendor record, and the MA63.1 MA65.1
company record. If an undershipment MA66.3 MA67.1
percentage of a zero percent flag set to MA67.2 MA70.1
Y is encountered at any level, that MAI1.1 PO100
value is used. PO101 PO122
NOTE-The percentage can be set at 100%, PO131 PO136
which would cancel all backorders. PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-USER-DATE-3 Numeric 8 (yyyymmdd) AP125 AP126
User Date 3 The description for this user date 3 is AP131 AP20.1
defined in MA00.1 (Company Setup). AP20.2 AP20.3
AP20.4 AP20.5
For conversion: AP20.7 AP23.1
Nonfatal Error - If date error exists, AP25.1 AP25.2
then set to zeros. AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-USER-DATE-4 Numeric 8 (yyyymmdd) AP125 AP126
User Date 4 The description for this user date 4 is AP131 AP20.1
defined in MA00.1 (Company Setup). AP20.2 AP20.3
AP20.4 AP20.5
For conversion: AP20.7 AP23.1
Nonfatal Error - If date error exists, AP25.1 AP25.2
then set to zeros. AP26.1 AP27.1
Default - Zeros. API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-PURCH-MAJCL Alpha 4 AP125 AP126
Major Purchasing The user-defined major purchasing class AP131 AP20.1
Class identifier. AP20.2 AP20.3
AP20.4 AP20.5
For conversion: AP20.7 AP23.1
Nonfatal Error - If not found in AP25.1 AP25.2
Inventory Control. AP26.1 AP27.1
Default - Inventory Control defaults. API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-PURCH-MINCL Alpha 4 AP125 AP126
Minor Purchasing The user-defined minor purchasing class AP131 AP20.1
Class identifier. AP20.2 AP20.3
AP20.4 AP20.5
For conversion: AP20.7 AP23.1
Non-Fatal Error - If not found in AP25.1 AP25.2
Inventory Control. AP26.1 AP27.1
Default - Inventory Control defaults. API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-MANUF-CODE Alpha 4 AP125 AP126
Manufacturer's Code This field contains a user defined code AP131 AP20.1
that indicates the manufacturer of an AP20.2 AP20.3
item. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-MANUF-DIVISION Alpha 4 AP125 AP126
Manufacturer's This is a user defined code that AP131 AP20.1
Division indicates which division of a AP20.2 AP20.3
manufacturer is tied to an item. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-MANUF-NBR Alpha 15 AP125 AP126
Manufacturer's Item This is the identifier that the AP131 AP20.1
Number manufacturer has assigned to an item. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-LAST-DST-SEQ Numeric 3 AP125 AP126
Last Distribution Sequence number of the last line of AP131 AP20.1
Sequence Nbr distribution for this line item. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-LAST-SRC-LINE Numeric 4 AP125 AP126
Last Src Line This is the Source Line Number of the AP131 AP20.1
last PO Line Source record for this PO AP20.2 AP20.3
line. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-RELEASED-FL Alpha 1 AP125 AP126
Released Released Flag. Record is now AP131 AP20.1
available for further processing in AP20.2 AP20.3
the system. AP20.4 AP20.5
N = No AP20.7 AP23.1
Y = Yes AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-ISSUED-FLAG Alpha 1 AP125 AP126
Issued Flag This is the issue status of the PO line AP131 AP20.1
record. If the PO has been issued at AP20.2 AP20.3
least once since the PO line record was AP20.4 AP20.5
created, this flag will be set to a AP20.7 AP23.1
value of "Y". Once set to "Y", it never AP25.1 AP25.2
changes. AP26.1 AP27.1
API1.1 IC28.1
For conversion: MA180 MA278
Nonfatal Error - If not equal to Y or N, MA41.2 MA43.1
then set to N. MA43.2 MA43.3
N = No MA43.4 MA43.5
Y = Yes MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-REVISED-FL Alpha 1 AP125 AP126
Revised Flag This is the purchase order line item AP131 AP20.1
revised flag. AP20.2 AP20.3
AP20.4 AP20.5
For conversion: AP20.7 AP23.1
Nonfatal Error - If not equal to Y or AP25.1 AP25.2
N, then set to N. AP26.1 AP27.1
Default - N. API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
N = No MA43.2 MA43.3
Y = Yes MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-CLOSED-FL Alpha 1 AP125 AP126
Closed Flag The closed flag. AP131 AP20.1
AP20.2 AP20.3
For conversion: AP20.4 AP20.5
Default - If the purchase order line AP20.7 AP23.1
close criteria is met, then set to Y. AP25.1 AP25.2
Otherwise set to N. AP26.1 AP27.1
N = No AP30.4 API1.1
Y = Yes IC28.1 MA180
H = Historical MA278 MA41.2
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO254
PO27.3 PO29.1
...
PLI-ZERO-OSHIP-FL Alpha 1 AP125 AP126
Zero Overshipment The purchase order line overshipment AP131 AP20.1
Flag zero tolerance flag. AP20.2 AP20.3
AP20.4 AP20.5
For conversion: AP20.7 AP23.1
Nonfatal Error - If Over Ship Tolerance AP25.1 AP25.2
Percent not equal to zeros and flag AP26.1 AP27.1
equal to Y, then set flag to N. API1.1 IC28.1
Default - N. MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
N = No MA43.4 MA43.5
Y = Yes MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-ZERO-USHIP-FL Alpha 1 AP125 AP126
Zero Undershipment Set this flag to "Y" to indicate that AP131 AP20.1
Flag the undershipment tolerance percent AP20.2 AP20.3
should be set to "zero" at this level. AP20.4 AP20.5
This means that no backorders will be AP20.7 AP23.1
canceled. AP25.1 AP25.2
AP26.1 AP27.1
The undershipment tolerance percent API1.1 IC28.1
must be blank to set this flag to "Y". MA180 MA278
N = No MA41.2 MA43.1
Y = Yes MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-EXCL-AOC-SPRD Alpha 1 AP125 AP126
Exclude from AOC Exclude this line item from the add-on AP131 AP20.1
Spread Method cost spread methods. AP20.2 AP20.3
N = No AP20.4 AP20.5
Y = Yes AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-PO-USER-FLD-2 Alpha 2 AP125 AP126
Purchase Order User Purchase order line user defined field. AP131 AP20.1
Field 2 AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-PO-USER-FLD-4 Alpha 30 (Lower Case) AP125 AP126
Purchase Order User Purchase order line user defined field. AP131 AP20.1
Field 4 AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-PO-USER-FLD-6 Alpha 15 (Lower Case) AP125 AP126
Purchase Order User Purchase order line user defined field. AP131 AP20.1
Field 6 AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-MATCH-CLASS Alpha 10 AP125 AP126
Match Class AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-MATCH-DTL-KEY Alpha 55 AP125 AP126
Match Dtl Key AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.1 MA41.2
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO254
PO27.3 PO29.1
...
PLI-ARCHIVE-QTY Signed 13.4 AP125 AP126
Archive Qty AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-MATCHED-NO-REC Signed 13.4 AP125 AP126
Matched No Rec AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-CHARGEBACK-QTY Signed 13.4 AP125 AP126
Chargeback Qty AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-WRITE-OFF-QTY Signed 13.4 AP125 AP126
Write Off Qty AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-RET-LINE-NBR Numeric 6 AP125 AP126
Return Line Number This is the return line number. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-TAX-USAGE-CD Alpha 10 AP125 AP126
Tax Usage Cd The tax usage code for the vendor. This AP131 AP20.1
field is required if the AP Company AP20.2 AP20.3
indicates that VAT reporting required. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-EXTENDED-AMT Signed 15.2 AP125 AP126
Extended Amt AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-CXL-QTY Signed 13.4 AP125 AP126
Cancel Quantity The cancelled quantity. All or a AP131 AP20.1
portion of the line may be cancelled. AP20.2 AP20.3
The cancelled quantity is not expected AP20.4 AP20.5
to be received from or invoiced by the AP20.7 AP23.1
vendor. AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-QTY-TO-PROC Signed 13.4 AP125 AP126
Qty To Proc This is a calculated field created to AP131 AP20.1
make edits and updates easier by doing AP20.2 AP20.3
the calculation in one place. The field AP20.4 AP20.5
shows what quantity on a PO line must be AP20.7 AP23.1
processed through the receiving and AP25.1 AP25.2
match process. This field is in buy AP26.1 AP27.1
unit of measure terms. The formula used API1.1 IC28.1
to calculate the field is quantity less MA180 MA278
cxl-qty. MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-VPRI-QTY-TO-PR Signed 13.4 AP125 AP126
Vpri Qty To Pr This is a calculated field created to AP131 AP20.1
make edits and updates easier by doing AP20.2 AP20.3
the calculations in one place. The field AP20.4 AP20.5
shows what quantity on a PO line must be AP20.7 AP23.1
processed through the receiving and AP25.1 AP25.2
match process. This field is in vendor AP26.1 AP27.1
price unit of measure terms. The formula API1.1 IC28.1
used to calculate the field is vpri-qty MA180 MA278
less (cxl-qty times vpri-uom-mult). MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-INVC-TAX-AMT Signed 15.2 AP125 AP126
Invc Tax Amt The tax amount that is to be invoiced. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-ACCR-TAX-AMT Signed 15.2 AP125 AP126
Accr Tax Amt The tax amount that is to be accrued. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-EXT-TAXBL-AMT Signed 15.2 AP125 AP126
Ext Taxbl Amt The extended taxable amount -- taxable AP131 AP20.1
unit cost * (quantity - cancelled AP20.2 AP20.3
quantity). AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-OPEN-PO-AMT Signed 15.2 AP125 AP126
Open PO Amount The portion of the total or extended AP131 AP20.1
ordered amount that is still open -- AP20.2 AP20.3
that is, it has not been cancelled or AP20.4 AP20.5
paid. This is always expressed in the AP20.7 AP23.1
company base currency, and includes only AP25.1 AP25.2
product costs (add on costs and taxes AP26.1 AP27.1
are not included). API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-ICN-CODE Alpha 8 AP125 AP126
Icn Code AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-SUPLMNTARY-QTY Signed 13.4 AP125 AP126
Suplmntary Qty AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
PO29.1 PO30.1
...
PLI-RQSRC-MACHINE Alpha 6
Rqsrc Machine
PLI-PAR-ORDER-ID Alpha 20
Par Order Id
PLI-PCLASS-MAJMIN Derived
Pclass Majmin This field is a combination of purchase
major and minor class used for
transaction analysis.
PLI-MF-CODE-DIV Derived
Mf Code Div This field is a combination of
manufacturer's code and division used
for transaction analysis.
PLI-REMAINING Derived
Remaining
PLI-PO-PRINTED-FL Derived
Purchase Order
Printed Flag
PLI-PO-RELEASED-FL Derived
PO Released Flag
PLI-PO-CNCLED-FL Derived
Po Cncled Fl
PLI-PO-CLOSED-FL Derived
Po Closed Fl
PLI-PO-DROP-SHIP Derived
Purchase Order Drop
Ship
PLI-ICL-LOC-PO-NM Derived
Icl Loc Po Nm
PLI-PURCH-FR-NAME Derived
Purch Fr Name
PLI-ITEM-DESC-1 Derived
Item Desc 1
PLI-ITEM-DESC-2 Derived
Item Desc 2
PLI-PO-GL-CATEGORY Derived
Purchase Order GL
Category
PLI-APPR-AND-REJ Derived
Appr And Rej
PLI-DISP-PO-REL-CD Derived
Disp Po Rel Cd
PLI-DISP-PO-REL Derived
Disp Po Rel
PLI-DISP-DOC-NBR Derived
Disp Doc Nbr
POLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PLISET1 COMPANY AP125 AP126
PO-NUMBER AP131 AP20.1
PO-RELEASE AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
LINE-NBR AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
API2.1 IC130
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
...
PLISET10 COMPANY KeyChange AP125 AP126
PO-NUMBER AP131 AP20.1
PO-RELEASE AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
LOCATION AP20.7 AP23.1
MATCH-DTL-KEY AP25.1 AP25.2
LINE-NBR AP26.1 AP27.1
API1.1 IC28.1
MA180 MA278
MA41.2 MA43.1
MA43.2 MA43.4
MA43.5 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
...
PLISET11 COMPANY KeyChange AP125 AP126
PO-NUMBER AP131 AP20.1
PO-RELEASE AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
MATCH-DTL-KEY AP20.7 AP220
LINE-NBR AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA278 MA41.1
MA41.2 MA43.1
MA43.2 MA43.4
MA43.5 MA43.9
MA530 MA531
MA540 MA60.2
...
PLISET12 PO-OBJ-ID This index is used to relate POLINE IC145 IC45.1
LINE-NBR records to WHDEMAND records. The
PO-OBJ-ID field is populated when a
WHDEMAND supply type record exists for
the POLINE. When the WHDEMAND supply
type record is deleted (when the POLINE
is received) the PO-OBJ-ID field is
erased.
KeyChange, Subset
Where PO-OBJ-ID != Spaces
PLISET13 COMPANY KeyChange, Subset AP125 AP126
PO-NUMBER Where AGREEMENT-REF != Spaces AP131 AP20.1
PO-RELEASE And RELEASED-FL = "N" AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
AGREEMENT-REF AP20.7 AP23.1
LINE-NBR AP25.1 AP25.2
AP26.1 AP27.1
IC28.1 MA180
MA41.2 MA43.2
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
...
PLISET14 COMPANY Subset PO529
PO-NUMBER Where ITEM-TYPE != "S"
PO-RELEASE And RELEASED-FL = "Y"
PO-CODE And CLOSED-FL = "N"
LINE-NBR And QTY-TO-PROC > REC-QTY
PLISET2 PROCURE-GROUP KeyChange, Subset AP125 AP126
AGREEMENT-REF Where AGREEMENT-REF != Spaces AP131 AP25.1
COMPANY And RELEASED-FL = "Y" AP25.2 AP26.1
PO-NUMBER AP27.1 API1.1
PO-RELEASE IC28.1 MA180
PO-CODE MA278 MA43.1
LINE-NBR MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
...
PLISET3 COMPANY KeyChange, Subset AP125 AP126
LOCATION Where (ITEM-TYPE != "S" ) AP131 AP25.1
PO-NUMBER AP25.2 AP26.1
PO-RELEASE AP27.1 API1.1
PO-CODE IC130 IC28.1
LINE-NBR MA180 MA278
MA43.1 MA43.4
MA43.5 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
...
PLISET4 COMPANY KeyChange AP125 AP126
BUYER-CODE AP131 AP25.1
EARLY-DL-DATE AP25.2 AP26.1
LOCATION AP27.1 API1.1
PO-NUMBER IC28.1 MA180
PO-RELEASE MA278 MA43.1
PO-CODE MA43.4 MA43.5
LINE-NBR MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
...
PLISET5 COMPANY KeyChange AP125 AP126
LOCATION AP131 AP25.1
EARLY-DL-DATE AP25.2 AP26.1
PO-NUMBER AP27.1 API1.1
PO-RELEASE IC28.1 MA180
PO-CODE MA278 MA43.1
LINE-NBR MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
...
PLISET6 COMPANY KeyChange AP125 AP126
ITEM AP131 AP25.1
LOCATION AP25.2 AP26.1
EARLY-DL-DATE* AP27.1 API1.1
PO-NUMBER* IC11.1 IC12.1
PO-RELEASE* IC28.1 MA180
PO-CODE MA278 MA43.1
LINE-NBR* MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
...
PLISET7 COMPANY KeyChange AP125 AP126
PO-NUMBER AP131 AP25.1
PO-RELEASE AP25.2 AP26.1
PO-CODE AP27.1 API1.1
ITEM IC28.1 MA180
LINE-NBR MA278 MA41.1
MA43.1 MA43.4
MA43.5 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
...
PLISET8 COMPANY KeyChange, Subset AP125 AP126
LOCATION Where (ITEM-TYPE != "S" ) AP131 AP25.1
VENDOR AP25.2 AP26.1
EARLY-DL-DATE AP27.1 API1.1
PO-NUMBER IC28.1 MA180
PO-RELEASE MA278 MA43.1
PO-CODE MA43.4 MA43.5
LINE-NBR MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
...
PLISET9 COMPANY KeyChange, Subset AP125 AP126
PO-NUMBER Where (ITEM-TYPE != "S" ) AP131 AP25.1
PO-RELEASE AP25.2 AP26.1
PO-CODE AP27.1 API1.1
LINE-NBR IC28.1 MA180
MA278 MA43.1
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
...
POLINE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
PLI-COMPANY -> CPY-COMPANY
Buyer BUYER Required
PCY-PROCURE-GROUP -> BUY-PROCURE-GROUP
PLI-BUYER-CODE -> BUY-BUYER-CODE
Has Vend Item POLINE Required
When PLI-VEN-ITEM != Spaces
PLI-COMPANY -> PLI-COMPANY
PLI-PO-NUMBER -> PLI-PO-NUMBER
PLI-PO-RELEASE -> PLI-PO-RELEASE
PLI-PO-CODE -> PLI-PO-CODE
PLI-LINE-NBR -> PLI-LINE-NBR
Iccategory ICCATEGORY Required
When (PLI-ITEM-TYPE = "I" )
PLI-COMPANY -> ICA-COMPANY
PLI-LOCATION -> ICA-LOCATION
ITL-GL-CATEGORY -> ICA-GL-CATEGORY
Iccompany ICCOMPANY Required
PLI-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
PLI-COMPANY -> ICL-COMPANY
PLI-LOCATION -> ICL-LOCATION
Icmanfcode ICMANFCODE Required
When PLI-MANUF-CODE != Spaces
ITE-ITEM-GROUP -> IMC-ITEM-GROUP
PLI-MANUF-CODE -> IMC-MANUF-CODE
PLI-MANUF-DIVISION -> IMC-MANUF-DIVISION
Itemloc ITEMLOC Required
PLI-COMPANY -> ITL-COMPANY
PLI-LOCATION -> ITL-LOCATION
PLI-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
When PLI-ITEM-TYPE = "I"
Or PLI-ITEM-TYPE = "N"
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
PLI-ITEM -> ITE-ITEM
Macompany MACOMPANY Required
PLI-COMPANY -> MAY-COMPANY
Major Class MAJORCL Required
When PLI-PURCH-MAJCL != Spaces
ICC-ITEM-GROUP -> MAJ-ITEM-GROUP
"P" -> MAJ-CLASS-TYPE
PLI-PURCH-MAJCL -> MAJ-MAJOR-CLASS
Minor Class MINORCL Required
When PLI-PURCH-MINCL != Spaces
ICC-ITEM-GROUP -> MIN-ITEM-GROUP
"P" -> MIN-CLASS-TYPE
PLI-PURCH-MAJCL -> MIN-MAJOR-CLASS
PLI-PURCH-MINCL -> MIN-MINOR-CLASS
Mmuaval MMUAVAL Required
PLI-COMPANY -> MUA-COMPANY
"PO" -> MUA-SYSTEM-CD
PLI-LOCATION -> MUA-LOCATION
"PT" -> MUA-DOC-TYPE
PLI-PO-NUMBER -> MUA-DOC-NUMBER
PLI-PO-RELEASE -> MUA-DOC-NBR-NUM
PLI-PO-CODE -> MUA-PO-CODE
PLI-LINE-NBR -> MUA-LINE-NBR
Zeroes -> MUA-API-OBJ-ID
Zeroes -> MUA-SEQ-NBR
Pocompany POCOMPANY Required
PLI-COMPANY -> PCY-COMPANY
Poitemven POITEMVEN Required
PLI-PROCURE-GROUP -> PIV-PROCURE-GROUP
PLI-ITEM -> PIV-ITEM
PLI-VENDOR -> PIV-VENDOR
Popliuf POPLIUF Not Required
PLI-COMPANY -> UFN-COMPANY
PLI-PO-NUMBER -> UFN-PO-NUMBER
PLI-PO-RELEASE -> UFN-PO-RELEASE
PLI-PO-CODE -> UFN-PO-CODE
PLI-LINE-NBR -> UFN-LINE-NBR
Povendor POVENDOR Required
CPY-VENDOR-GROUP -> POV-VENDOR-GROUP
PLI-VENDOR -> POV-VENDOR
Purchorder PURCHORDER Required
PLI-COMPANY -> PCR-COMPANY
PLI-PO-CODE -> PCR-PO-CODE
PLI-PO-NUMBER -> PCR-PO-NUMBER
PLI-PO-RELEASE -> PCR-PO-RELEASE
Repl Po Return PORETURNLN Required
PLI-COMPANY -> PTL-COMPANY
PCR-RETURN-NUMBER -> PTL-RETURN-NUMBER
PLI-RET-LINE-NBR -> PTL-RET-LINE-NBR
Return Header PORETURNHD Required
When PLI-RETURN-NUMBER != Zeroes
PLI-COMPANY -> PTH-COMPANY
PCR-RETURN-NUMBER -> PTH-RETURN-NUMBER
Vendor APVENMAST Not Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
PLI-VENDOR -> VEN-VENDOR
Vendorlocation APVENLOC Required
When PLI-PURCH-FR-LOC != Spaces
CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP
PLI-VENDOR -> VLO-VENDOR
PLI-PURCH-FR-LOC -> VLO-LOCATION-CODE
Whdemand WHDEMAND Not Required
Valid When PLI-PO-OBJ-ID != Spaces
PLI-COMPANY -> WDM-COMPANY
PLI-LOCATION -> WDM-LOCATION
"PO" -> WDM-SYSTEM-CD
PLI-PO-OBJ-ID -> WDM-DOC-NBR
PLI-LINE-NBR -> WDM-LINE-NBR
Zeroes -> WDM-COMPONENT-SEQ
POLINE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apinvoice APINVOICE
PLI-COMPANY -> API-COMPANY
PLI-VENDOR -> API-VENDOR
PLI-PO-NUMBER -> API-PO-NUMBER
PLI-PO-RELEASE -> API-PO-RELEASE
PLI-PO-CODE -> API-PO-CODE
API-LOCATION
API-INVOICE
API-SUFFIX
API-CANCEL-SEQ
Has Return PORETURNLN
PLI-COMPANY -> PTL-COMPANY
PTL-RETURN-NUMBER
PTL-RET-LINE-NBR
Ipovagrmtln POVAGRMTLN
PLI-PROCURE-GROUP -> PVN-PROCURE-GROUP
PLI-ITEM -> PVN-ITEM
PVN-VEN-AGRMT-REF
PVN-LINE-NBR
Mainvdtl MAINVDTL
PLI-COMPANY -> MAD-COMPANY
PLI-PO-NUMBER -> MAD-PO-NUMBER
PLI-PO-RELEASE -> MAD-PO-RELEASE
PLI-PO-CODE -> MAD-PO-CODE
PLI-LINE-NBR -> MAD-LINE-NBR
PLI-VENDOR -> MAD-VENDOR
MAD-INVOICE
MAD-SUFFIX
MAD-AOC-CODE
MAD-SEQ-NBR
Mamadhist MAMADHIST
PLI-COMPANY -> MH1-COMPANY
PLI-PO-NUMBER -> MH1-PO-NUMBER
PLI-PO-RELEASE -> MH1-PO-RELEASE
PLI-PO-CODE -> MH1-PO-CODE
PLI-LINE-NBR -> MH1-LINE-NBR
PLI-VENDOR -> MH1-VENDOR
MH1-INVOICE
MH1-SUFFIX
MH1-AOC-CODE
MH1-SEQ-NBR
Mmdist MMDIST
Valid When PLI-ITEM-TYPE != "I"
PLI-COMPANY -> MMD-COMPANY
"PO" -> MMD-SYSTEM-CD
PLI-LOCATION -> MMD-LOCATION
"PT" -> MMD-DOC-TYPE
PLI-PO-NUMBER -> MMD-DOC-NUMBER
PLI-PO-RELEASE -> MMD-DOC-NBR-NUM
PLI-PO-CODE -> MMD-PO-CODE
PLI-LINE-NBR -> MMD-LINE-NBR
Zeroes -> MMD-COMPONENT-SEQ
Spaces -> MMD-AOC-CODE
MMD-LINE-SEQ
MMD-REQ-LOCATION
MMD-API-OBJ-ID
Pliset6 POLINE
PLI-COMPANY -> PLI-COMPANY
PLI-ITEM -> PLI-ITEM
PLI-LOCATION -> PLI-LOCATION
PLI-EARLY-DL-DATE
PLI-PO-NUMBER
PLI-PO-RELEASE
PLI-PO-CODE
PLI-LINE-NBR
Poaocdtl POAOCDTL
PLI-COMPANY -> PAO-COMPANY
Spaces -> PAO-PROCURE-GROUP
Spaces -> PAO-VEN-AGRMT-REF
PLI-PO-NUMBER -> PAO-PO-NUMBER
PLI-PO-RELEASE -> PAO-PO-RELEASE
PLI-PO-CODE -> PAO-PO-CODE
PLI-LINE-NBR -> PAO-LINE-NBR
PAO-AOC-CODE
Poappr By Date MAINVDTL
PLI-COMPANY -> MAD-COMPANY
PLI-PO-NUMBER -> MAD-PO-NUMBER
PLI-PO-RELEASE -> MAD-PO-RELEASE
PLI-PO-CODE -> MAD-PO-CODE
PLI-LINE-NBR -> MAD-LINE-NBR
MAD-UPDATE-DATE
MAD-UPDATE-TIME
MAD-VENDOR
MAD-INVOICE
MAD-SUFFIX
MAD-AOC-CODE
MAD-SEQ-NBR
Poappr By Dte2 MAINVDTL
PLI-COMPANY -> MAD-COMPANY
PLI-PO-NUMBER -> MAD-PO-NUMBER
PLI-PO-RELEASE -> MAD-PO-RELEASE
PLI-PO-CODE -> MAD-PO-CODE
PLI-LINE-NBR -> MAD-LINE-NBR
MAD-UPDATE-DATE
MAD-UPDATE-TIME
MAD-VENDOR
MAD-INVOICE
MAD-SUFFIX
MAD-AOC-CODE
MAD-SEQ-NBR
Poaudit POAUDIT
PLI-COMPANY -> PAU-COMPANY
PLI-PO-NUMBER -> PAU-PO-NUMBER
PLI-PO-RELEASE -> PAU-PO-RELEASE
PLI-PO-CODE -> PAU-PO-CODE
PLI-LINE-NBR -> PAU-PO-LINE-NBR
PAU-PO-REVISION
PAU-AOC-CODE
PAU-UPDATE-DATE
PAU-UPDATE-TIME
PAU-FLD-NBR
PAU-AUDIT-TYPE
PAU-AUDIT-ACTION
Polinesrc POLINESRC
PLI-COMPANY -> PLS-COMPANY
PLI-PO-CODE -> PLS-PO-CODE
PLI-PO-NUMBER -> PLS-PO-NUMBER
PLI-PO-RELEASE -> PLS-PO-RELEASE
PLI-LINE-NBR -> PLS-LINE-NBR
PLS-ORIGIN-CD
PLS-OPER-COMPANY
PLS-SOURCE-DOC-N
PLS-SOURCE-DOC-A
PLS-SRC-LINE-NBR
Porec By Date PORECLINE
PLI-COMPANY -> PRL-COMPANY
PLI-PO-CODE -> PRL-PO-CODE
PLI-PO-NUMBER -> PRL-PO-NUMBER
PLI-PO-RELEASE -> PRL-PO-RELEASE
PLI-LINE-NBR -> PRL-PO-LINE-NBR
PRL-UPDATE-DATE
PRL-UPDATE-TIME
PRL-REC-NUMBER
PRL-LINE-NBR
Porecadjln PORECADJLN
PLI-COMPANY -> PJL-COMPANY
PLI-PO-NUMBER -> PJL-PO-NUMBER
PLI-PO-RELEASE -> PJL-PO-RELEASE
PLI-PO-CODE -> PJL-PO-CODE
PLI-LINE-NBR -> PJL-PO-LINE-NBR
PJL-DATE
PJL-DOC-TYPE
PJL-DOC-NBR-NUM
PJL-LINE-NBR
Porecline PORECLINE
PLI-COMPANY -> PRL-COMPANY
PLI-PO-CODE -> PRL-PO-CODE
PLI-PO-NUMBER -> PRL-PO-NUMBER
PLI-PO-RELEASE -> PRL-PO-RELEASE
PLI-LOCATION -> PRL-LOCATION
PLI-MATCH-DTL-KEY -> PRL-MATCH-DTL-KEY
PLI-LINE-NBR -> PRL-PO-LINE-NBR
PRL-REC-NUMBER
PRL-LINE-NBR
Return Line PORETURNLN
PLI-COMPANY -> PTL-COMPANY
PLI-PO-NUMBER -> PTL-ORIG-PO-NBR
PLI-PO-RELEASE -> PTL-ORIG-PO-REL
PLI-PO-CODE -> PTL-ORIG-PO-CODE
PLI-LINE-NBR -> PTL-ORIG-PO-LN-NBR
PTL-RETURN-NUMBER
PTL-RET-LINE-NBR
Txtaxrate TXTAXRATE
PLI-TAX-CODE -> TXR-TAX-CODE
TXR-PROD-TAX-CAT
TXR-EFFECT-DATE
Vpovagrmtln POVAGRMTLN
PLI-PROCURE-GROUP -> PVN-PROCURE-GROUP
PLI-VEN-ITEM -> PVN-VEN-ITEM
PVN-VEN-AGRMT-REF
PVN-LINE-NBR
|