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