Lawson Insight Technical Documentation |
|
POLINE
POLINE FILE
Line Items
This file contains purchase order line item information.
REFERENCED BY
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 MA231 MA236 MA278
MA53.1 MA53.7 MA540 MA63.1 MA64.6 PO133
PO135 PO190 PO220 PO223 PO224 PO230
PO231 PO254 PO26.1 PO274 PO295 PO54.1
PO54.2 PO54.3 PO54.4 PO58.2 PO58.1 PO64.1
PO66.1 PO67.1 PO700 POA3.1 POCP.1 POI1.1
POID.1 POIE.1 POIF.1 POIG.1 POIH.1 POIM.1
POIT.1 MM280 MM80.1 MM80.2 RQ140 RQ300
RQ35.1 RQ40.1 RQ41.1 RQ42.1 RQ44.1 RQ44.2
RQIF.1 WH130 WH132 WH190 WH25.1 WH25.2
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 WO132 WO140
MA65.1 AP220 IC145 IC44.1 IC45.1 WHD2.1
PO529 PO227 PO233 PO275 PO276 PO277
PO280 PO285 IC11.1 IC12.1 PC20.1 PO16.1
PO16.2 PO216 PO550 PO63.1 PO258 PO94.1
PO139
UPDATED BY
AP125 AP126 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
MA41.2 MA41.7 MA43.1 MA43.2 MA43.3 MA43.9
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.1 PO100 PO101 PO122 PO130
PO131 PO136 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
POD0.1 POD1.1 POI3.1 POI7.1 POII.1 POIJ.1
RQ10.1 RQ10.2 RQ10.3 RQIE.1 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PLI-COMPANY Numeric 4 AP125 AP126
Element: 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 AP30.4 API1.1
Control company, or Accounts Payable IC28.1 MA180
company is not found, then no purchase MA278 MA41.2
order lines are loaded to the purchase MA41.7 MA43.1
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.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
Element: 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 AP30.4 API1.1
purchase order cannot be found, then no IC28.1 MA180
purchase order lines are loaded for this MA278 MA41.2
purchase order. MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-PO-RELEASE Numeric 4 AP125 AP126
Element: PO Release NumUsed 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-PO-CODE Alpha 4 AP125 AP126
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-LINE-NBR Numeric 6 AP125 AP126
Element: 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 AP30.4 API1.1
line record. If the line already exists IC28.1 MA180
and was not previously processed, then MA278 MA41.1
the purchase order line is not loaded. MA41.2 MA41.7
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
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
...
PLI-ITEM Alpha 32 AP125 AP126
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.1
MA41.2 MA41.7
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
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
...
PLI-ITEM-TYPE Alpha 1 AP125 AP126
Element: 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 AP30.4 API1.1
found, then set type to Non-stock). IC28.1 MA180
Fatal Error - If not equal to I, N, S, MA278 MA41.2
X or item master record not found for I MA41.7 MA43.1
and N type items, then the purchase MA43.2 MA43.3
order line is not loaded. MA43.4 MA43.5
I = Inventoried MA43.9 MA530
S = Service MA531 MA540
X = Special MA60.2 MA60.3
N = Non-stock MA60.5 MA61.1
MA63.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-SERVICE-CODE Alpha 1 AP125 AP126
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-DESCRIPTION Alpha 30 (Lower Case) AP125 AP126
Element: 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. AP30.4 API1.1
Default - Standard default description IC28.1 MA180
for a Special (X) and Service type MA278 MA41.2
items. MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-PROCURE-GROUP Alpha 4 AP125 AP126
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-PO-OBJ-ID Alpha 10 (Right Justified) AP125 AP126
Element: 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 AP30.4 API1.1
passed on to the PO line when the PO IC28.1 MA180
line is created. The PO Object ID is MA278 MA41.2
populated on the PO line only for the MA41.7 MA43.1
duration of time that a WHDEMAND supply MA43.2 MA43.3
type record exists for the PO line (from MA43.4 MA43.5
PO line creation until full receipt or MA43.9 MA530
cancel or the PO line). MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-QUANTITY Signed 13.4 AP125 AP126
Element: 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 AP30.4 API1.1
is below received or approved quantity, IC28.1 MA180
or line is canceled. MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-VPRI-QUANTITY Signed 13.4 AP125 AP126
Element: Quantity The entered line quantity system AP131 AP20.1
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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-REC-QTY Signed 13.4 AP125 AP126
Element: Received QuantThis 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: AP30.4 API1.1
Cannot go below approved and unreleased IC28.1 MA180
approved quantity. MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-CATCH-WT-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the quantity AP131 AP20.1
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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-AGREEMENT-REF Alpha 30 AP125 AP126
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-AGRMT-REF-AMT Signed 15.2 AP125 AP126
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-LST-MATCH-UCST Signed 13.5 AP125 AP126
Element: Lst Match UcstThis field is used only when the po cost AP131 AP20.1
is adjusted during the PO COst Message AP20.2 AP20.3
process. 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-MATCHED-QTY Signed 13.4 AP125 AP126
Element: Quantity This is the Qty from this POLINE that AP131 AP20.1
has been matched 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-MATCHED-AMOUNT Signed 13.5 AP125 AP126
Element: Matched AmountTHis is the amount from this POLINE that AP131 AP20.1
has been matched. 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-SUBST-QTY Signed 13.4 AP125 AP126
Element: 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 AP30.4 API1.1
purchase order line number. IC28.1 MA180
Fatal Error - If not equal to zeros and MA278 MA41.2
original line number either not numeric MA41.7 MA43.1
or equal to zeros, then the purchase MA43.2 MA43.3
order line is not loaded. 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-REJECT-QTY Signed 13.4 AP125 AP126
Element: Quantity This is the total inspection rejection AP131 AP20.1
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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-ENT-UNIT-CST Signed 13.5 AP125 AP126
Element: Base 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 AP30.4 API1.1
(special order), and Service items IC28.1 MA180
default on purchase orders from the cost MA278 MA41.2
default routine. MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO227 PO23.1
...
PLI-VBUY-UNIT-CST Signed 13.5 AP125 AP126
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-TAXBL-UNT-CST Signed 13.5 AP125 AP126
Element: Base Cost 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.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 AP30.4 API1.1
L = Last Cost IC28.1 MA180
C = Contract MA278 MA41.2
T = Catalog/Quote MA41.7 MA43.1
B = Blanket MA43.2 MA43.3
P = Last PO Created MA43.4 MA43.5
S = Standing MA43.9 MA530
G = Punchout MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-ENT-BUY-UOM Alpha 4 AP125 AP126
Element: Unit of MeasurEntered buy unit of measure. AP131 AP20.1
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. AP30.4 API1.1
If a unit of measure is not required IC28.1 MA180
and a valid unit of measure cannot be MA278 MA41.2
found, or an invalid unit of measure is MA41.7 MA43.1
supplied, the purchase order line is not MA43.2 MA43.3
loaded. 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-EBUY-UOM-MULT Signed 13.7 AP125 AP126
Unit of Measure 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-VPRI-UOM Alpha 4 AP125 AP126
Element: Unit of Measure 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-VPRI-UOM-MULT Signed 13.7 AP125 AP126
Unit of Measure AP131 AP20.1
Multiplier 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-LAND-UNIT-CST Signed 13.5 AP125 AP126
Element: Base Cost 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO135 PO136
PO190 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
...
PLI-EARLY-DL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field contains the early delivery AP131 AP20.1
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 AP30.4 API1.1
later, or delivery date is earlier. IC28.1 MA180
Default - Purchase order header default MA278 MA41.2
delivery date. MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-LATE-DL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: 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. AP30.4 API1.1
Default - Zeros. IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-REC-ACT-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date Last receiving activity 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-CLOSE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-LOCATION Alpha 5 AP125 AP126
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-BUYER-CODE Alpha 3 AP125 AP126
Element: Buyer 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-VENDOR Alpha 9 (Right Justified) AP125 AP126
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-VEN-ITEM Alpha 32 AP125 AP126
Element: Item Number 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-DIST-CODE Alpha 9 AP125 AP126
Element: Distribution CA 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-TAX-CODE Alpha 10 AP125 AP126
Element: 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. AP30.4 API1.1
Fatal Error - If tax is landed for IC28.1 MA180
standard cost company. MA278 MA41.2
Default - If taxable flag equals Y, MA41.7 MA43.1
normal add time default hierarchy MA43.2 MA43.3
applied. Item location purchasing tax MA43.4 MA43.5
code; item master purchasing tax code; MA43.9 MA530
Purchase Order header tax code; Accounts MA531 MA540
Payable vendor location tax code; MA60.2 MA60.3
Accounts Payable vendor master tax code. MA60.5 MA61.1
MA63.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-WEIGHT Signed 9.3 AP125 AP126
Element: Unit Weight This field contains the total 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. AP30.4 API1.1
Default - If an Inventory or Non-stock IC28.1 MA180
type item, then inventory control MA278 MA41.2
default. MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-CUBIC-FEET Signed 9.3 AP125 AP126
Element: Cubic Feet This field contains the total cubic 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. AP30.4 API1.1
Default - If an Inventory or a Non-stock IC28.1 MA180
type item, then use Inventory Control MA278 MA41.2
default. MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-REC-PRT-FL Alpha 1 AP125 AP126
Element: All 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 AP30.4 API1.1
receivings flag. IC28.1 MA180
N = No MA278 MA41.2
Y = Yes MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO130
PO131 PO136
PO190 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
...
PLI-COST-OPTION Alpha 1 AP125 AP126
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.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 AP30.4 API1.1
Y = Yes IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-REC-INSP-FL Alpha 1 AP125 AP126
Element: All Flag Defines if inspection is required for AP131 AP20.1
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). AP30.4 API1.1
N = No IC28.1 MA180
Y = Yes MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-INSP-REQ-FL Alpha 1 AP125 AP126
Element: All Flag Defines if inspection is required for AP131 AP20.1
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 AP30.4 API1.1
required flag to No. If not equal to Yes IC28.1 MA180
or No, then set to No (the default). MA278 MA41.2
N = No MA41.7 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.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-MSDS-FLAG Alpha 1 AP125 AP126
Element: All Flag Y = Yes AP131 AP20.1
N = No 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-NO-LT-CALC-FL Alpha 1 AP125 AP126
Element: All Flag Determines if leadtime generated by AP131 AP20.1
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 AP30.4 API1.1
No, then set to No (the default). IC28.1 MA180
N = No MA278 MA41.2
Y = Yes MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.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, AP30.4 API1.1
normal add time default taxable flag IC28.1 MA180
hierarchy applied. Item location MA278 MA41.2
purchasing taxable flag; Item master MA41.7 MA43.1
purchasing taxable flag; purchase order MA43.2 MA43.3
header default taxable flag. MA43.4 MA43.5
Y = Yes MA43.9 MA530
N = No MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-OSHIP-TOL-PCT Percent 5.3 (Percent) AP125 AP126
Element: Cost Pct Quantity overshipment tolerance AP131 AP20.1
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. AP30.4 API1.1
Default - Zeros. IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.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 AP30.4 API1.1
this is less than the 10% limit, the IC28.1 MA180
backordered amount would be canceled. MA278 MA41.2
MA41.7 MA43.1
This process takes place at receiving MA43.2 MA43.3
time. If a backorder is not canceled MA43.4 MA43.5
manually, the system checks, in order, MA43.9 MA530
the purchase order line, the purchase MA531 MA540
order vendor purchase from record, the MA60.2 MA60.3
purchase order vendor record, and the MA60.5 MA61.1
company record. If an undershipment MA63.1 MA65.1
percentage of a zero percent flag set to MA66.2 MA66.3
Y is encountered at any level, that MA67.1 MA67.2
value is used. MA70.1 MA75.1
NOTE-The percentage can be set at 100%, MA80.1 MAI1.1
which would cancel all backorders. PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-USER-DATE-3 Numeric 8 (yyyymmdd) AP125 AP126
Element: Date 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-USER-DATE-4 Numeric 8 (yyyymmdd) AP125 AP126
Element: Date 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. AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-PURCH-MAJCL Alpha 4 AP125 AP126
Element: Major Class The user-defined major purchasing class AP131 AP20.1
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. AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-PURCH-MINCL Alpha 4 AP125 AP126
Element: Minor Class The user-defined minor purchasing class AP131 AP20.1
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. AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-MANUF-CODE Alpha 4 AP125 AP126
Element: Manufacturer'sThis 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-LAST-DST-SEQ Numeric 3 AP125 AP126
Element: Sequence NumbeSequence number of the last line of AP131 AP20.1
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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-LAST-SRC-LINE Numeric 4 AP125 AP126
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-RELEASED-FL Alpha 1 AP125 AP126
Element: All Flag 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-ISSUED-FLAG Alpha 1 AP125 AP126
Element: All 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
AP30.4 API1.1
For conversion: IC28.1 MA180
Nonfatal Error - If not equal to Y or N, MA278 MA41.2
then set to N. MA41.7 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.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-REVISED-FL Alpha 1 AP125 AP126
Element: All 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. AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
N = No MA41.7 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.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-CLOSED-FL Alpha 1 AP125 AP126
Element: All 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-ZERO-OSHIP-FL Alpha 1 AP125 AP126
Element: All Flag The purchase order line overshipment AP131 AP20.1
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. AP30.4 API1.1
Default - N. IC28.1 MA180
MA278 MA41.2
MA41.7 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.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-ZERO-USHIP-FL Alpha 1 AP125 AP126
Element: All Flag Set this flag to "Y" to indicate that AP131 AP20.1
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 AP30.4 API1.1
must be blank to set this flag to "Y". IC28.1 MA180
N = No MA278 MA41.2
Y = Yes MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-PO-USER-FLD-4 Alpha 30 (Lower Case) AP125 AP126
Element: User Defined Field 2 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-PO-USER-FLD-6 Alpha 15 (Lower Case) AP125 AP126
Element: User Defined Field 3 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-MATCH-CLASS Alpha 10 AP125 AP126
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-MATCH-DTL-KEY Alpha 85 AP125 AP126
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.1
MA41.2 MA41.7
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
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO136
PO190 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
...
PLI-ARCHIVE-QTY Signed 13.4 AP125 AP126
Element: Quantity 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-MATCHED-NO-REC Signed 13.4 AP125 AP126
Element: Document Total 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-CHARGEBACK-QTY Signed 13.4 AP125 AP126
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-WRITE-OFF-QTY Signed 13.4 AP125 AP126
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-RET-LINE-NBR Numeric 6 AP125 AP126
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-TAX-USAGE-CD Alpha 10 AP125 AP126
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-EXTENDED-AMT Signed 15.2 AP125 AP126
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-CXL-QTY Signed 13.4 AP125 AP126
Element: Quantity The cancelled quantity. This quantity AP131 AP20.1
is kept in "Entered Unit-of-Measure" AP20.2 AP20.3
terms. All or a portion of the line may AP20.4 AP20.5
be cancelled. The cancelled quantity is AP20.7 AP23.1
not expected to be received from or AP25.1 AP25.2
invoiced by the vendor. AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-QTY-TO-PROC Signed 13.4 AP125 AP126
Element: Quantity 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-VPRI-QTY-TO-PR Signed 13.4 AP125 AP126
Element: Quantity 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-INVC-TAX-AMT Signed 15.2 AP125 AP126
Element: Adj Amt 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-ACCR-TAX-AMT Signed 15.2 AP125 AP126
Element: Adj Amt 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-EXT-TAXBL-AMT Signed 15.2 AP125 AP126
Element: Adj Amt 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-OPEN-PO-AMT Signed 15.2 AP125 AP126
Element: Adj Amt 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-ICN-CODE Alpha 8 AP125 AP126
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-SUPLMNTARY-QTY Signed 13.4 AP125 AP126
Element: Quantity 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-RQSRC-MACHINE Alpha 6 AP125 AP126
Element: Rqsrc Machine The name of the dispenser machine that AP131 AP20.1
is keeping track of the medical supply AP20.2 AP20.3
and that produces the requisition AP20.4 AP20.5
request when the quantity of that supply AP20.7 AP23.1
goes below the par level. AP25.1 AP25.2
DROYAL AP26.1 AP27.1
ESIOB AP30.4 API1.1
HBOC IC28.1 MA180
OMNICL MA278 MA41.2
PAREXC MA41.7 MA43.1
PERSE MA43.2 MA43.3
PYXIS MA43.4 MA43.5
SSI 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-PAR-ORDER-ID Alpha 20 AP125 AP126
Element: Par Order Id This is the identifier of the order or AP131 AP20.1
request when the quantity of a medical AP20.2 AP20.3
supply falls below the par level at one AP20.4 AP20.5
of the special dispensers that can AP20.7 AP23.1
produce such a request. AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-PUNCHOUT-ID Alpha 32 AP125 AP126
Element: Punchout Id 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
MA41.7 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 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO223
PO23.1 PO25.1
...
PLI-PCLASS-MAJMIN Derived
Element: Pclass Majmin This field is a combination of purchase
major and minor class used for
transaction analysis.
PLI-MF-CODE-DIV Derived
Element: Mf Code Div This field is a combination of
manufacturer's code and division used
for transaction analysis.
PLI-REMAINING Derived
Element: Remaining
PLI-PO-PRINTED-FL Derived
Purchase Order
Printed Flag
PLI-PO-RELEASED-FL Derived
Element: PO Released Flag
PLI-PO-CNCLED-FL Derived
Element: Po Cncled Fl
PLI-PO-CLOSED-FL Derived
Element: Po Closed Fl
PLI-PO-DROP-SHIP Derived
Purchase Order Drop
Ship
PLI-ICL-LOC-PO-NM Derived
Element: Icl Loc Po Nm
PLI-PURCH-FR-NAME Derived
Element: Purch Fr Name
PLI-ITEM-DESC-1 Derived
Element: Item Desc 1
PLI-ITEM-DESC-2 Derived
Element: Item Desc 2
PLI-PO-GL-CATEGORY Derived
Purchase Order GL
Category
PLI-APPR-AND-REJ Derived
Element: Appr And Rej
PLI-DISP-PO-REL-CD Derived
Element: Disp Po Rel Cd
PLI-DISP-PO-REL Derived
Element: Disp Po Rel
PLI-DISP-DOC-NBR Derived
Element: 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
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
...
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 AP30.4
API1.1 IC28.1
MA180 MA278
MA41.1 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
...
PLISET12 PO-OBJ-ID This index is used to relate POLINE IC145 IC44.1
LINE-NBR records to WHDEMAND records. The IC45.1 WHD2.1
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
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
PLISET14 COMPANY Subset MA531 PO529
PO-NUMBER Where ITEM-TYPE != "S" POID.1
PO-RELEASE And RELEASED-FL = "Y"
PO-CODE And CLOSED-FL = "N"
LINE-NBR And QTY-TO-PROC > REC-QTY
PLISET15 COMPANY KeyChange MA540
PO-NUMBER
PO-RELEASE
PO-CODE
VEN-ITEM
LINE-NBR
PLISET2 PROCURE-GROUP KeyChange, Subset AP125 AP126
AGREEMENT-REF Where AGREEMENT-REF != Spaces AP131 AP20.1
COMPANY And RELEASED-FL = "Y" AP20.2 AP20.3
PO-NUMBER AP20.4 AP20.5
PO-RELEASE AP20.7 AP23.1
PO-CODE AP25.1 AP25.2
LINE-NBR AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
...
PLISET3 COMPANY KeyChange, Subset AP125 AP126
LOCATION Where (ITEM-TYPE != "S" ) AP131 AP20.1
PO-NUMBER AP20.2 AP20.3
PO-RELEASE AP20.4 AP20.5
PO-CODE AP20.7 AP23.1
LINE-NBR AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC130 IC28.1
MA180 MA278
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.9
MA530 MA531
...
PLISET4 COMPANY KeyChange AP125 AP126
BUYER-CODE AP131 AP20.1
EARLY-DL-DATE AP20.2 AP20.3
LOCATION AP20.4 AP20.5
PO-NUMBER AP20.7 AP23.1
PO-RELEASE AP25.1 AP25.2
PO-CODE AP26.1 AP27.1
LINE-NBR AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
...
PLISET5 COMPANY KeyChange AP125 AP126
LOCATION AP131 AP20.1
EARLY-DL-DATE AP20.2 AP20.3
PO-NUMBER AP20.4 AP20.5
PO-RELEASE AP20.7 AP23.1
PO-CODE AP25.1 AP25.2
LINE-NBR AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
...
PLISET6 COMPANY KeyChange AP125 AP126
ITEM AP131 AP20.1
LOCATION AP20.2 AP20.3
EARLY-DL-DATE* AP20.4 AP20.5
PO-NUMBER* AP20.7 AP23.1
PO-RELEASE* AP25.1 AP25.2
PO-CODE AP26.1 AP27.1
LINE-NBR* AP30.4 API1.1
IC11.1 IC12.1
IC28.1 PC20.1
MA180 MA278
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.9
...
PLISET7 COMPANY KeyChange AP125 AP126
PO-NUMBER AP131 AP20.1
PO-RELEASE AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
ITEM AP20.7 AP23.1
LINE-NBR AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA236 MA278
MA41.1 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
...
PLISET8 COMPANY KeyChange, Subset AP125 AP126
LOCATION Where (ITEM-TYPE != "S" ) AP131 AP20.1
VENDOR AP20.2 AP20.3
EARLY-DL-DATE AP20.4 AP20.5
PO-NUMBER AP20.7 AP23.1
PO-RELEASE AP25.1 AP25.2
PO-CODE AP26.1 AP27.1
LINE-NBR AP30.4 API1.1
IC28.1 MA180
MA278 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
...
PLISET9 COMPANY KeyChange, Subset AP125 AP126
PO-NUMBER Where (ITEM-TYPE != "S" ) 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
IC28.1 MA180
MA278 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
MA531 MA540
...
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 PCR-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
|