Lawson Insight Technical Documentation |
|
POLINE
POLINE FILE
Line Items
This file contains purchase order line item information.
REFERENCED BY
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 IC50.2 IC500 MA231 MA236
MA278 MA540 MA64.6 PO133 PO135 PO190
PO220 PO223 PO224 PO230 PO231 PO251
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
POIF.1 POIG.1 POIH.1 POIM.1 POIT.1 MM280
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 PO529 PO227 PO233 PO275 PO276
PO277 PO280 PO285 IC11.1 IC12.1 PO16.1
PO16.2 PO216 PO550 PO63.1 PO258 PO94.1
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 IC28.1 MA180 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
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE111 OE113 OE114 OE116 OE129
OE13.2 OE13.3 OE13.5 OE13.6 OE14.4 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE530 OE81.1 OE810 OE830
OE90.1 OE90.2 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
POI3.1 POI7.1 POIE.1 POII.1 POIJ.1 RQ10.1
RQ10.2 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 AP25.1
company and is entered on all actions. AP25.2 AP26.1
AP27.1 AP30.4
For conversion: API1.1 BL120
Fatal Error - If equal to spaces, or BL122 BL130
zeros, or not numeric, or either BL20.1 BL20.3
Purchase Order company, Inventory BL21.2 BL21.5
Control company, or Accounts Payable BL29.1 BL29.2
company is not found, then no purchase BL520 BL820
order lines are loaded to the purchase BL92.1 IC28.1
order. MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
Element: PO Number This field contains the number AP131 AP25.1
representing the purchase order. AP25.2 AP26.1
AP27.1 AP30.4
For conversion: API1.1 BL120
Fatal Error - If not equal to spaces, BL122 BL130
or purchase order company flag says it BL20.1 BL20.3
must be numeric and it is not, or the BL21.2 BL21.5
purchase order cannot be found, then no BL29.1 BL29.2
purchase order lines are loaded for this BL520 BL820
purchase order. BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-PO-RELEASE Numeric 4 AP125 AP126
Element: PO Release NumUsed to identify a purchase order AP131 AP25.1
release (created from a Blanket or AP25.2 AP26.1
Standing order). AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-PO-CODE Alpha 4 AP125 AP126
Element: Po Code This is the purchase order code. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This field contains the line number. AP131 AP25.1
AP25.2 AP26.1
For conversion: AP27.1 AP30.4
Fatal Error - If not numeric, then do API1.1 BL120
not load this purchase order line. If BL122 BL130
the line already exists and was BL20.1 BL20.3
previously processed, then skip this BL21.2 BL21.5
line record. If the line already exists BL29.1 BL29.2
and was not previously processed, then BL520 BL820
the purchase order line is not loaded. BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-ITEM Alpha 32 AP125 AP126
Element: Item Number This field contains the item identifier. AP131 AP25.1
AP25.2 AP26.1
For conversion: AP27.1 AP30.4
Fatal Error - If equal to spaces, then API1.1 BL120
the purchase order line is not loaded. BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-ITEM-TYPE Alpha 1 AP125 AP126
Element: Item Type Identifies the line item type. AP131 AP25.1
AP25.2 AP26.1
For conversion: AP27.1 AP30.4
Nonfatal Error - For Inventory type API1.1 BL120
items, either inventory tracking flag BL122 BL130
equals N, or this is a dropship purchase BL20.1 BL20.3
order, or item location record not BL21.2 BL21.5
found, then set type to Non-stock). BL29.1 BL29.2
Fatal Error - If not equal to I, N, S, BL520 BL820
X or item master record not found for I BL92.1 IC28.1
and N type items, then the purchase MA180 MA278
order line is not loaded. MA530 MA531
I = Inventoried MA540 MA60.2
S = Service MA60.3 MA60.5
X = Special MA61.1 MA65.1
N = Non-stock MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-SERVICE-CODE Alpha 1 AP125 AP126
Element: Service Code A = Amount AP131 AP25.1
Q = Quantity AP25.2 AP26.1
" " = Non Service Item AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-DESCRIPTION Alpha 30 (Lower Case) AP125 AP126
Element: Description This field contains the description. AP131 AP25.1
AP25.2 AP26.1
For conversion: AP27.1 AP30.4
Nonfatal Error - If equal to spaces and API1.1 BL120
a Service or Special (X) type item, or BL122 BL130
an Inventory or Non-stock type item and BL20.1 BL20.3
not equal to spaces. BL21.2 BL21.5
Default - Standard default description BL29.1 BL29.2
for a Special (X) and Service type BL520 BL820
items. BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-PROCURE-GROUP Alpha 4 AP125 AP126
Element: Procure Group This field contains the identifier for a AP131 AP25.1
group of companies that share a common AP25.2 AP26.1
procurement effort. They buy items and AP27.1 AP30.4
services together. API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-PO-OBJ-ID Alpha 10 (Right Justified) AP125 AP126
Element: Po Obj Id The PO Object ID is used as a document AP131 AP25.1
number for the warehouse demand records. AP25.2 AP26.1
This field, along with the PO Line AP27.1 AP30.4
number, is used to relate POLINE API1.1 BL120
records to WHDEMAND records. A unique BL122 BL130
PO Object ID is obtained when the PO BL20.1 BL20.3
number is assigned in PO creation. It is BL21.2 BL21.5
passed on to the PO line when the PO BL29.1 BL29.2
line is created. The PO Object ID is BL520 BL820
populated on the PO line only for the BL92.1 IC28.1
duration of time that a WHDEMAND supply MA180 MA278
type record exists for the PO line (from MA530 MA531
PO line creation until full receipt or MA540 MA60.2
cancel or the PO line). MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-QUANTITY Signed 13.4 AP125 AP126
Element: Quantity The order quantity in entered unit of AP131 AP25.1
measure terms. AP25.2 AP26.1
AP27.1 AP30.4
For Conversion: API1.1 BL120
Allowed to be changed for matching load BL122 BL130
program. BL20.1 BL20.3
Fatal Error: Cannot be changed if this BL21.2 BL21.5
is below received or approved quantity, BL29.1 BL29.2
or line is canceled. BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-VPRI-QUANTITY Signed 13.4 AP125 AP126
Element: Quantity The entered line quantity system AP131 AP25.1
converted to vendor pricing terms. AP25.2 AP26.1
AP27.1 AP30.4
For conversion: API1.1 BL120
Fatal Error - If not numeric, then the BL122 BL130
purchase order line is not loaded. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-REC-QTY Signed 13.4 AP125 AP126
Element: Received QuantThis is the total received quantity for AP131 AP25.1
this line item. AP25.2 AP26.1
AP27.1 AP30.4
For Conversion: API1.1 BL120
This is allowed to be changed for BL122 BL130
matching load program. BL20.1 BL20.3
Fatal Error: BL21.2 BL21.5
Cannot go below approved and unreleased BL29.1 BL29.2
approved quantity. BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-CATCH-WT-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the quantity AP131 AP25.1
received for catch weight shipments. AP25.2 AP26.1
AP27.1 AP30.4
For conversion: API1.1 BL120
Fatal Error - If not numeric then this BL122 BL130
purchase order line is not loaded. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-AGREEMENT-REF Alpha 30 AP125 AP126
Element: Agreement Ref AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-AGRMT-REF-AMT Signed 18.2 AP125 AP126
Element: Intl Amt AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-LST-MATCH-UCST Signed 18.5 AP125 AP126
Element: Intl Cost THis field is used only when the PO Cost AP131 AP25.1
is adjusted during the PO COst message AP25.2 AP26.1
process. AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-MATCHED-QTY Signed 13.4 AP125 AP126
Element: Receiving Quantity AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-MATCHED-AMOUNT Signed 18.5 AP125 AP126
Element: Intl Cost AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-SUBST-QTY Signed 13.4 AP125 AP126
Element: Quantity This is the quantity of substitute AP131 AP25.1
items received in on this product. AP25.2 AP26.1
AP27.1 AP30.4
For conversion: API1.1 BL120
Nonfatal Error - If equal to zeros and BL122 BL130
the original line number is numeric, BL20.1 BL20.3
then set original line number to the BL21.2 BL21.5
purchase order line number. BL29.1 BL29.2
Fatal Error - If not equal to zeros and BL520 BL820
original line number either not numeric BL92.1 IC28.1
or equal to zeros, then the purchase MA180 MA278
order line is not loaded. MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-REJECT-QTY Signed 13.4 AP125 AP126
Element: Quantity This is the total inspection rejection AP131 AP25.1
quantity for this line item. AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-ENT-UNIT-CST Signed 18.5 AP125 AP126
Element: Intl Cost The entered unit cost in vendor price AP131 AP25.1
unit of measure terms. This value may be AP25.2 AP26.1
entered directly on line or calculated AP27.1 AP30.4
from entry of cost in buy unit of API1.1 BL120
measure terms. If cost is not manually BL122 BL130
entered in either unit of measure, unit BL20.1 BL20.3
costs for Inventoried, Non-Stock, X BL21.2 BL21.5
(special order), and Service items BL29.1 BL29.2
default on purchase orders from the cost BL520 BL820
default routine. BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-VBUY-UNIT-CST Signed 18.5 AP125 AP126
Element: Intl Cost Unit cost for a purchase order line in AP131 AP25.1
PO line buy unit of measure terms. This AP25.2 AP26.1
cost can be entered directly on a AP27.1 AP30.4
purchase order line, or calculated if API1.1 BL120
cost in vendor price unit of measure BL122 BL130
terms is entered directly. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-TAXBL-UNT-CST Signed 18.5 AP125 AP126
Element: Intl Cost The portion of the line unit cost which AP131 AP25.1
is taxable. If left blank, this field AP25.2 AP26.1
will default to the line unit cost in AP27.1 AP30.4
vendor price unit of measure terms. API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-COST-CD Alpha 1 AP125 AP126
Unit Cost Origin Unit cost origin code. AP131 AP25.1
Code AP25.2 AP26.1
For conversion: AP27.1 AP30.4
Nonfatal Error - If not equal to E, L, API1.1 BL120
S, Q, then set to E (the default). BL122 BL130
BL20.1 BL20.3
E = Entered BL21.2 BL21.5
L = Last Cost BL29.1 BL29.2
C = Contract BL520 BL820
T = Catalog/Quote BL92.1 IC28.1
B = Blanket MA180 MA278
P = Last PO Created MA530 MA531
S = Standing MA540 MA60.2
G = Punchout MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-ENT-BUY-UOM Alpha 4 AP125 AP126
Element: Unit of MeasurEntered buy unit of measure. AP131 AP25.1
AP25.2 AP26.1
For conversion: AP27.1 AP30.4
Fatal Error - If equal to spaces and an API1.1 BL120
Inventory or Non-stock type item and BL122 BL130
unit of measure required, then the BL20.1 BL20.3
purchase order line is not loaded. BL21.2 BL21.5
If a unit of measure is not required BL29.1 BL29.2
and a valid unit of measure cannot be BL520 BL820
found, or an invalid unit of measure is BL92.1 IC28.1
supplied, the purchase order line is not MA180 MA278
loaded. MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-EBUY-UOM-MULT Signed 13.7 AP125 AP126
Unit of Measure Entered buy unit of measure conversion AP131 AP25.1
Multiplier multiplier. AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-VPRI-UOM Alpha 4 AP125 AP126
Element: Unit of MeasurThis is the vendor pricing unit of AP131 AP25.1
measure. AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-VPRI-UOM-MULT Signed 13.7 AP125 AP126
Unit of Measure This is the vendor pricing unit of AP131 AP25.1
Multiplier measure multiplier. It is used to AP25.2 AP26.1
convert unit cost to stock unit of AP27.1 AP30.4
measure terms. API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-LAND-UNIT-CST Signed 18.5 AP125 AP126
Element: Intl Cost Landed unit cost for this item. AP131 AP25.1
This includes the tax landing costs, AP25.2 AP26.1
add-on cost landing costs besides the AP27.1 AP30.4
product unit cost. API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-EARLY-DL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Early Delivery Date This field contains the early delivery AP131 AP25.1
(Rqst DT) date. AP25.2 AP26.1
AP27.1 AP30.4
For conversion: API1.1 BL120
Nonfatal Error - If equal to zeros and BL122 BL130
not a Service type item, or date error BL20.1 BL20.3
exists, or the purchase order date is BL21.2 BL21.5
later, or delivery date is earlier. BL29.1 BL29.2
Default - Purchase order header default BL520 BL820
delivery date. BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-LATE-DL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Late Delivery This field contains the late delivery AP131 AP25.1
date. AP25.2 AP26.1
AP27.1 AP30.4
For conversion: API1.1 BL120
Nonfatal - If not numeric, or date BL122 BL130
error exists, or the purchase order date BL20.1 BL20.3
or early delivery date is later. BL21.2 BL21.5
Default - Zeros. BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-REC-ACT-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date Last receiving activity date. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-CLOSE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Close Date Purchase order line close date. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-LOCATION Alpha 5 AP125 AP126
Element: Location Code This field contains a valid stocking AP131 AP25.1
location within the company inventory. AP25.2 AP26.1
AP27.1 AP30.4
For conversion: API1.1 BL120
Default - PO header ship to location. BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-BUYER-CODE Alpha 3 AP125 AP126
Element: Buyer The user defined buyer identifier. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-VENDOR Alpha 9 (Right Justified) AP125 AP126
Element: Vendor ID The vendor's identification code. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-PURCH-FR-LOC Alpha 4 AP125 AP126
Purchase From The vendor's purchase from location. AP131 AP25.1
Location Code AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-VEN-ITEM Alpha 32 AP125 AP126
Element: Item Number The vendor's item identifer. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-DIST-CODE Alpha 9 AP125 AP126
Element: Distribution CA user-defined code that may be used to AP131 AP25.1
set up common distribution attributes. AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-TAX-CODE Alpha 10 AP125 AP126
Element: Tax Code This field contains a code representing AP131 AP25.1
specific tax information. This must be AP25.2 AP26.1
valid tax code in the Tax system. AP27.1 AP30.4
API1.1 BL120
For conversion: BL122 BL130
Nonfatal Error - If not found in the BL20.1 BL20.3
Tax system. BL21.2 BL21.5
Fatal Error - If tax is landed for BL29.1 BL29.2
standard cost company. BL520 BL820
Default - If taxable flag equals Y, BL92.1 IC28.1
normal add time default hierarchy MA180 MA278
applied. Item location purchasing tax MA530 MA531
code; item master purchasing tax code; MA540 MA60.2
Purchase Order header tax code; Accounts MA60.3 MA60.5
Payable vendor location tax code; MA61.1 MA65.1
Accounts Payable vendor master tax code. MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-WEIGHT Signed 9.3 AP125 AP126
Element: Unit Weight This field contains the unit weight of AP131 AP25.1
the item based on the stock unit of AP25.2 AP26.1
measure. AP27.1 AP30.4
API1.1 BL120
For conversion: BL122 BL130
Nonfatal Error - If not numeric, then BL20.1 BL20.3
set to zeros. BL21.2 BL21.5
Default - If an Inventory or Non-stock BL29.1 BL29.2
type item, then inventory control BL520 BL820
default. BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-CUBIC-FEET Signed 9.3 AP125 AP126
Element: Cubic Feet This field contains the unit cubit feet AP131 AP25.1
of the item based on the stock unit of AP25.2 AP26.1
measure. AP27.1 AP30.4
API1.1 BL120
For conversion: BL122 BL130
Nonfatal Error - If not numeric, then BL20.1 BL20.3
set to zeros. BL21.2 BL21.5
Default - If an Inventory or a BL29.1 BL29.2
Non-stock type item, then use Inventory BL520 BL820
Control default. BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-REC-PRT-FL Alpha 1 AP125 AP126
Element: All Flag Indicates the line has been printed on AP131 AP25.1
PO130 (Receiving Document) AP25.2 AP26.1
AP27.1 AP30.4
For conversion: API1.1 BL120
Nonfatal Error - If not equal to Y or N, BL122 BL130
then set to N. BL20.1 BL20.3
Default - Purchase order header's print BL21.2 BL21.5
receivings flag. BL29.1 BL29.2
N = No BL520 BL820
Y = Yes BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-COST-OPTION Alpha 1 AP125 AP126
Element: Cost Option 1 = Cost Required AP131 AP25.1
2 = No Charge AP25.2 AP26.1
3 = Vendor Determined AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-CERT-REQ-FL Alpha 1 AP125 AP126
Certification This flag defines if certification is AP131 AP25.1
Required Flag required for this line item. AP25.2 AP26.1
AP27.1 AP30.4
For conversion: API1.1 BL120
Nonfatal Error - If not equal to Yes or BL122 BL130
No, then set to No (the default). BL20.1 BL20.3
N = No BL21.2 BL21.5
Y = Yes BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-REC-INSP-FL Alpha 1 AP125 AP126
Element: All Flag Defines if inspection is required for AP131 AP25.1
this line item. It is set at receiving AP25.2 AP26.1
time. AP27.1 AP30.4
API1.1 BL120
For conversion: BL122 BL130
Nonfatal Error - If not equal to Yes or BL20.1 BL20.3
No, then set to No (the default). BL21.2 BL21.5
N = No BL29.1 BL29.2
Y = Yes BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-INSP-REQ-FL Alpha 1 AP125 AP126
Element: All Flag Defines if inspection is required for AP131 AP25.1
this line item. Set at purchase order AP25.2 AP26.1
entry time. AP27.1 AP30.4
API1.1 BL120
For conversion: BL122 BL130
Nonfatal Error - If the purchase order BL20.1 BL20.3
is dropship, then set inspection BL21.2 BL21.5
required flag to No. If not equal to Yes BL29.1 BL29.2
or No, then set to No (the default). BL520 BL820
N = No BL92.1 IC28.1
Y = Yes MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-MSDS-FLAG Alpha 1 AP125 AP126
Element: All Flag This flag indicates if this item AP131 AP25.1
requires a Material Safety Data Sheet. AP25.2 AP26.1
Y = Yes AP27.1 AP30.4
N = No API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-NO-LT-CALC-FL Alpha 1 AP125 AP126
Element: All Flag Determines if leadtime generated by AP131 AP25.1
this order is used in calculating AP25.2 AP26.1
leadtime for the inventoried item order AP27.1 AP30.4
by this line. API1.1 BL120
BL122 BL130
For conversion: BL20.1 BL20.3
Nonfatal Error - If not equal to Yes or BL21.2 BL21.5
No, then set to No (the default). BL29.1 BL29.2
N = No BL520 BL820
Y = Yes BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-TAXABLE-FLAG Alpha 1 AP125 AP126
Taxable or Defines if taxable. AP131 AP25.1
Non-Taxable Flag AP25.2 AP26.1
For conversion: AP27.1 AP30.4
Nonfatal Error - If not equal to Yes, API1.1 BL120
No or spaces, then set to spaces. BL122 BL130
Default - If tax code not equal to BL20.1 BL20.3
spaces, then set to Yes. Otherwise, BL21.2 BL21.5
normal add time default taxable flag BL29.1 BL29.2
hierarchy applied. Item location BL520 BL820
purchasing taxable flag; Item master BL92.1 IC28.1
purchasing taxable flag; purchase order MA180 MA278
header default taxable flag. MA530 MA531
Y = Yes MA540 MA60.2
N = No MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-OSHIP-TOL-PCT Percent 5.3 (Percent) AP125 AP126
Overshipment Quantity overshipment tolerance AP131 AP25.1
Tolerance Percent percentage. AP25.2 AP26.1
AP27.1 AP30.4
For conversion: API1.1 BL120
Nonfatal Error - If not numeric, or a BL122 BL130
Service type item and not equal to BL20.1 BL20.3
zeroes, then set to zeros. BL21.2 BL21.5
Default - Zeros. BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-USHIP-TOL-PCT Percent 6.3 (Percent) AP125 AP126
Cancel Backorder This is the quantity undership AP131 AP25.1
Percent percentage for automatic back order AP25.2 AP26.1
cancellation. If a value of 10% is AP27.1 AP30.4
entered here, for instance, and a API1.1 BL120
quantity of 91 is shipped against an BL122 BL130
ordered quantity of 100, that would be BL20.1 BL20.3
considered a 9% undershipment. Since BL21.2 BL21.5
this is less than the 10% limit, the BL29.1 BL29.2
backordered amount would be canceled. BL520 BL820
BL92.1 IC28.1
This process takes place at receiving MA180 MA278
time. If a backorder is not canceled MA530 MA531
manually, the system checks, in order, MA540 MA60.2
the purchase order line, the purchase MA60.3 MA60.5
order vendor purchase from record, the MA61.1 MA65.1
purchase order vendor record, and the MA66.2 MA66.3
company record. If an undershipment MA67.1 MA67.2
percentage of a zero percent flag set to MA70.1 MA75.1
Y is encountered at any level, that MA80.1 MAI1.1
value is used. OE10.1 OE10.2
NOTE-The percentage can be set at 100%, OE10.3 OE10.4
which would cancel all backorders. OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-USER-DATE-3 Numeric 8 (yyyymmdd) AP125 AP126
Element: Date The description for this user date 3 is AP131 AP25.1
defined in MA00.1 (Company Setup). AP25.2 AP26.1
AP27.1 AP30.4
For conversion: API1.1 BL120
Nonfatal Error - If date error exists, BL122 BL130
then set to zeros. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-USER-DATE-4 Numeric 8 (yyyymmdd) AP125 AP126
Element: Date The description for this user date 4 is AP131 AP25.1
defined in MA00.1 (Company Setup). AP25.2 AP26.1
AP27.1 AP30.4
For conversion: API1.1 BL120
Nonfatal Error - If date error exists, BL122 BL130
then set to zeros. BL20.1 BL20.3
Default - Zeros. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-PURCH-MAJCL Alpha 4 AP125 AP126
Element: Major Class The user-defined major purchasing class AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 AP30.4
For conversion: API1.1 BL120
Nonfatal Error - If not found in BL122 BL130
Inventory Control. BL20.1 BL20.3
Default - Inventory Control defaults. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-PURCH-MINCL Alpha 4 AP125 AP126
Element: Minor Class The user-defined minor purchasing class AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 AP30.4
For conversion: API1.1 BL120
Non-Fatal Error - If not found in BL122 BL130
Inventory Control. BL20.1 BL20.3
Default - Inventory Control defaults. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-MANUF-CODE Alpha 4 AP125 AP126
Element: Manufacturer'sThis field contains a user defined code AP131 AP25.1
that indicates the manufacturer of an AP25.2 AP26.1
item. AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-MANUF-DIVISION Alpha 4 AP125 AP126
Manufacturer's This is a user defined code that AP131 AP25.1
Division indicates which division of a AP25.2 AP26.1
manufacturer is tied to an item. AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-MANUF-NBR Alpha 15 AP125 AP126
Manufacturer's Item This is the identifier that the AP131 AP25.1
Number manufacturer has assigned to an item. AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-LAST-DST-SEQ Numeric 3 AP125 AP126
Element: Sequence NumbeSequence number of the last line of AP131 AP25.1
distribution for this line item. AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-LAST-SRC-LINE Numeric 4 AP125 AP126
Element: Last Src Line This is the Source Line Number of the AP131 AP25.1
last PO Line Source record for this PO AP25.2 AP26.1
line. AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-RELEASED-FL Alpha 1 AP125 AP126
Element: All Flag Released Flag. Record is now AP131 AP25.1
available for further processing in AP25.2 AP26.1
the system. AP27.1 AP30.4
N = No API1.1 BL120
Y = Yes BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-ISSUED-FLAG Alpha 1 AP125 AP126
Element: All Flag This is the issue status of the PO line AP131 AP25.1
record. If the PO has been issued at AP25.2 AP26.1
least once since the PO line record was AP27.1 AP30.4
created, this flag will be set to a API1.1 BL120
value of "Y". Once set to "Y", it never BL122 BL130
changes. BL20.1 BL20.3
BL21.2 BL21.5
For conversion: BL29.1 BL29.2
Nonfatal Error - If not equal to Y or N, BL520 BL820
then set to N. BL92.1 IC28.1
N = No MA180 MA278
Y = Yes MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-REVISED-FL Alpha 1 AP125 AP126
Element: All Flag This is the purchase order line item AP131 AP25.1
revised flag. AP25.2 AP26.1
AP27.1 AP30.4
For conversion: API1.1 BL120
Nonfatal Error - If not equal to Y or BL122 BL130
N, then set to N. BL20.1 BL20.3
Default - N. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
N = No BL92.1 IC28.1
Y = Yes MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-CLOSED-FL Alpha 1 AP125 AP126
Element: Closed Flag The closed flag. AP131 AP25.1
AP25.2 AP26.1
For conversion: AP27.1 AP30.4
Default - If the purchase order line API1.1 BL120
close criteria is met, then set to Y. BL122 BL130
Otherwise set to N. BL20.1 BL20.3
N = No BL21.2 BL21.5
Y = Yes BL29.1 BL29.2
H = Historical BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-ZERO-OSHIP-FL Alpha 1 AP125 AP126
Element: All Flag The purchase order line overshipment AP131 AP25.1
zero tolerance flag. AP25.2 AP26.1
AP27.1 AP30.4
For conversion: API1.1 BL120
Nonfatal Error - If Over Ship Tolerance BL122 BL130
Percent not equal to zeros and flag BL20.1 BL20.3
equal to Y, then set flag to N. BL21.2 BL21.5
Default - N. BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
N = No MA180 MA278
Y = Yes MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-ZERO-USHIP-FL Alpha 1 AP125 AP126
Element: All Flag Set this flag to "Y" to indicate that AP131 AP25.1
the undershipment tolerance percent AP25.2 AP26.1
should be set to "zero" at this level. AP27.1 AP30.4
This means that no backorders will be API1.1 BL120
canceled. BL122 BL130
BL20.1 BL20.3
The undershipment tolerance percent BL21.2 BL21.5
must be blank to set this flag to "Y". BL29.1 BL29.2
N = No BL520 BL820
Y = Yes BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-EXCL-AOC-SPRD Alpha 1 AP125 AP126
Exclude from AOC Exclude this line item from the add-on AP131 AP25.1
Spread Method cost spread methods. AP25.2 AP26.1
N = No AP27.1 AP30.4
Y = Yes API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-PO-USER-FLD-2 Alpha 2 AP125 AP126
Purchase Order User Purchase order line user defined field. AP131 AP25.1
Field 2 AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-PO-USER-FLD-4 Alpha 30 (Lower Case) AP125 AP126
Element: User Defined FPurchase order line user defined field. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-PO-USER-FLD-6 Alpha 15 (Lower Case) AP125 AP126
Element: User Defined FPurchase order line user defined field. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-MATCH-CLASS Alpha 10 AP125 AP126
Element: Match Class AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-MATCH-DTL-KEY Alpha 85 AP125 AP126
Element: Match Dtl Key AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-ARCHIVE-QTY Signed 13.4 AP125 AP126
Element: Quantity AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-MATCHED-NO-REC Signed 13.4 AP125 AP126
Element: Matched No Rec AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-CHARGEBACK-QTY Signed 13.4 AP125 AP126
Element: Chargeback Qty AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-WRITE-OFF-QTY Signed 13.4 AP125 AP126
Element: Write Off Qty AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-RET-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This is the return line number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-TAX-USAGE-CD Alpha 10 AP125 AP126
Element: Tax Usage Cd The tax usage code for the vendor. This AP131 AP25.1
field is required if the AP Company AP25.2 AP26.1
indicates that VAT reporting required. AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-EXTENDED-AMT Signed 18.2 AP125 AP126
Element: Intl Amt AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-CXL-QTY Signed 13.4 AP125 AP126
Element: Receiving QuanThe cancelled quantity. This quantity AP131 AP25.1
is kept in "Entered Unit-of-Measure" AP25.2 AP26.1
terms. All or a portion of the line may AP27.1 AP30.4
be cancelled. The cancelled quantity is API1.1 BL120
not expected to be received from or BL122 BL130
invoiced by the vendor. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-QTY-TO-PROC Signed 13.4 AP125 AP126
Element: Receiving QuanThis is a calculated field created to AP131 AP25.1
make edits and updates easier by doing AP25.2 AP26.1
the calculation in one place. The field AP27.1 AP30.4
shows what quantity on a PO line must be API1.1 BL120
processed through the receiving and BL122 BL130
match process. This field is in buy BL20.1 BL20.3
unit of measure terms. The formula used BL21.2 BL21.5
to calculate the field is quantity less BL29.1 BL29.2
cxl-qty. BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-VPRI-QTY-TO-PR Signed 13.4 AP125 AP126
Element: Receiving QuanThis is a calculated field created to AP131 AP25.1
make edits and updates easier by doing AP25.2 AP26.1
the calculations in one place. The field AP27.1 AP30.4
shows what quantity on a PO line must be API1.1 BL120
processed through the receiving and BL122 BL130
match process. This field is in vendor BL20.1 BL20.3
price unit of measure terms. The formula BL21.2 BL21.5
used to calculate the field is vpri-qty BL29.1 BL29.2
less (cxl-qty times vpri-uom-mult). BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-INVC-TAX-AMT Signed 18.2 AP125 AP126
Element: Intl Amt The tax amount that is to be invoiced. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-ACCR-TAX-AMT Signed 18.2 AP125 AP126
Element: Intl Amt The tax amount that is to be accrued. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-EXT-TAXBL-AMT Signed 18.2 AP125 AP126
Element: Intl Amt The extended taxable amount -- taxable AP131 AP25.1
unit cost * (quantity - cancelled AP25.2 AP26.1
quantity). AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-OPEN-PO-AMT Signed 18.2 AP125 AP126
Element: Intl Amt The portion of the total or extended AP131 AP25.1
ordered amount that is still open -- AP25.2 AP26.1
that is, it has not been cancelled or AP27.1 AP30.4
paid. This is always expressed in the API1.1 BL120
company base currency, and includes only BL122 BL130
product costs (add on costs and taxes BL20.1 BL20.3
are not included). BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-ICN-CODE Alpha 8 AP125 AP126
Element: Icn Code AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-SUPLMNTARY-QTY Signed 13.4 AP125 AP126
Element: Quantity AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-RQSRC-MACHINE Alpha 6 AP125 AP126
Element: Rqsrc Machine DROYAL AP131 AP25.1
ESIOB AP25.2 AP26.1
HBOC AP27.1 AP30.4
OMNICL API1.1 BL120
PAREXC BL122 BL130
PERSE BL20.1 BL20.3
PYXIS BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-PAR-ORDER-ID Alpha 20 AP125 AP126
Element: Par Order Id AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-PUNCHOUT-ID Alpha 32 AP125 AP126
Element: Punchout Id AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-LANDED-FL Alpha 1 AP125 AP126
Element: Landed Fl This flag will denote if the AOC of AP131 AP25.1
record is landed or not landed. Landed AP25.2 AP26.1
means the AOC takes on the AP27.1 AP30.4
characteristics of the goods it is API1.1 BL120
landed to. BL122 BL130
" " = No BL20.1 BL20.3
1 = Landed BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-FREIGHT-TERMS Alpha 1
Element: Freight Terms Freight terms are used to define who
pays for freight costs incurred when
goods are shipped. Prepaid, for
instance, would normally mean that the
vendor would pay for freight. Collect
would mean the customer would pay for
freight.
A freight terms code can be entered on
a purchase order, or defaulted by vendor
or company.
PLI-FOB-CODE Alpha 3
Element: Shipping Term The user defined Free On Board Code.
PLI-TERM-CODE Alpha 5
Element: Terms Code A user-defined code representing a
method of determining invoice due and
discount dates.
PLI-CATCH-WGT-COST Signed 18.5
Element: Intl Cost
PLI-PREV-RELEASED Numeric 1 AP125 AP126
Element: Prev Released 0 = No AP131 AP25.1
1 = Yes AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
PLI-OPEN-PO-TRAN Signed 18.2
Element: Intl Amt The portion of the total or extended
ordered amount that is still open --
that is, it has not been cancelled or
paid. This is expressed in the Purchase
Order currency, and includes only
product costs (add on costs and taxes
are not included).
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 AP25.1
PO-RELEASE AP25.2 AP26.1
PO-CODE AP27.1 AP30.4
LINE-NBR API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC130 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
...
PLISET10 COMPANY KeyChange AP125 AP126
PO-NUMBER AP131 AP25.1
PO-RELEASE AP25.2 AP26.1
PO-CODE AP27.1 AP30.4
LOCATION API1.1 BL120
MATCH-DTL-KEY BL122 BL130
LINE-NBR BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
...
PLISET11 COMPANY KeyChange AP125 AP126
PO-NUMBER AP131 AP220
PO-RELEASE AP25.1 AP25.2
PO-CODE AP26.1 AP27.1
MATCH-DTL-KEY AP30.4 API1.1
LINE-NBR BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA278 MA530
MA531 MA540
MA60.2 MA60.3
...
PLISET12 PO-OBJ-ID This index is used to relate POLINE IC145 IC44.1
LINE-NBR records to WHDEMAND records. The IC45.1 OE13.4
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 AP25.1
PO-RELEASE And RELEASED-FL = "N" AP25.2 AP26.1
PO-CODE AP27.1 AP30.4
AGREEMENT-REF BL120 BL122
LINE-NBR BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
...
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
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 AP25.1
COMPANY And RELEASED-FL = "Y" AP25.2 AP26.1
PO-NUMBER AP27.1 AP30.4
PO-RELEASE API1.1 BL120
PO-CODE BL122 BL130
LINE-NBR BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
...
PLISET3 COMPANY KeyChange, Subset AP125 AP126
LOCATION Where (ITEM-TYPE != "S" ) AP131 AP25.1
PO-NUMBER AP25.2 AP26.1
PO-RELEASE AP27.1 AP30.4
PO-CODE API1.1 BL120
LINE-NBR BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC130
IC28.1 MA180
MA278 MA530
MA531 MA540
MA60.2 MA60.3
...
PLISET4 COMPANY KeyChange AP125 AP126
BUYER-CODE AP131 AP25.1
EARLY-DL-DATE AP25.2 AP26.1
LOCATION AP27.1 AP30.4
PO-NUMBER API1.1 BL120
PO-RELEASE BL122 BL130
PO-CODE BL20.1 BL20.3
LINE-NBR BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
...
PLISET5 COMPANY KeyChange AP125 AP126
LOCATION AP131 AP25.1
EARLY-DL-DATE AP25.2 AP26.1
PO-NUMBER AP27.1 AP30.4
PO-RELEASE API1.1 BL120
PO-CODE BL122 BL130
LINE-NBR BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
...
PLISET6 COMPANY KeyChange AP125 AP126
ITEM AP131 AP25.1
LOCATION AP25.2 AP26.1
EARLY-DL-DATE* AP27.1 AP30.4
PO-NUMBER* API1.1 BL120
PO-RELEASE* BL122 BL130
PO-CODE BL20.1 BL20.3
LINE-NBR* BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC11.1
IC12.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
...
PLISET7 COMPANY KeyChange AP125 AP126
PO-NUMBER AP131 AP25.1
PO-RELEASE AP25.2 AP26.1
PO-CODE AP27.1 AP30.4
ITEM API1.1 BL120
LINE-NBR BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA236
MA278 MA530
MA531 MA540
MA60.2 MA60.3
...
PLISET8 COMPANY KeyChange, Subset AP125 AP126
LOCATION Where (ITEM-TYPE != "S" ) AP131 AP25.1
VENDOR AP25.2 AP26.1
EARLY-DL-DATE AP27.1 AP30.4
PO-NUMBER API1.1 BL120
PO-RELEASE BL122 BL130
PO-CODE BL20.1 BL20.3
LINE-NBR BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
...
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 AP30.4
LINE-NBR API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA278
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
...
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 Not 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 Not 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 Not Required
Valid 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
Maaocdtl MAAOCDTL
PLI-COMPANY -> MAA-COMPANY
PLI-PO-NUMBER -> MAA-PO-NUMBER
PLI-PO-RELEASE -> MAA-PO-RELEASE
PLI-PO-CODE -> MAA-PO-CODE
PLI-LINE-NBR -> MAA-LINE-NBR
PLI-VENDOR -> MAA-VENDOR
MAA-INVOICE
MAA-SUFFIX
MAA-AOC-CODE
MAA-SEQ-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-SEQ-NBR
Mamaahist MAMAAHIST
PLI-COMPANY -> MMH-COMPANY
PLI-PO-NUMBER -> MMH-PO-NUMBER
PLI-PO-RELEASE -> MMH-PO-RELEASE
PLI-PO-CODE -> MMH-PO-CODE
PLI-LINE-NBR -> MMH-LINE-NBR
PLI-VENDOR -> MMH-VENDOR
MMH-INVOICE
MMH-SUFFIX
MMH-AOC-CODE
MMH-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
Poapr 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-SEQ-NBR
Poapr 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-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
|