POLINE FILE Line Items This file contains purchase order line item information. REFERENCED BY CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1 IC50.2 MA140 MA190 MA278 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 PO10.1 PO122 PO131 PO133 PO135 PO180 PO220 PO221 PO223 PO224 PO230 PO231 PO236 PO24.1 PO26.1 PO272 PO274 PO295 PO39.1 PO50.1 PO52.1 PO529 PO60.1 PO64.1 PO66.1 PO67.1 PO85.1 POA3.1 RQ120 RQ44.1 RQ44.2 WH130 WH132 WH190 WH222 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 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 PO227 PO233 PO62.1 PO275 PO276 PO277 PO280 PO61.1 IC11.1 IC12.1 PO16.1 PO16.2 PO550 PO63.1 PO94.1 UPDATED BY AP125 AP126 AP225 AP226 AP25.1 AP25.2 AP26.1 BL92.1 CX05.1 DR100 IC140 IC141 IC142 IC522 IC523 IC524 IC525 IC526 IC83.1 PC120 PC20.1 PC540 IN20.1 MA300 MA40.1 MA41.4 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA520 MA530 MA540 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 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO120 PO121 PO123 PO130 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.6 PO216 PO22.1 PO22.2 PO22.3 PO23.2 PO30.1 PO30.2 PO31.1 PO33.1 PO34.1 PO35.1 PO530 PO821 PO822 PO990 RQ10.1 RQ10.3 RQ11.1 RQ20.1 RQ20.2 RQ20.3 RQ20.4 RQ35.1 RQ500 SEA3.1 WH20.2 WH20.7 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY PLI-COMPANY Numeric 4 BL92.1 MA520 Company The company number represents a defined OE10.1 OE10.2 company and is entered on all actions. OE10.3 OE10.4 OE10.5 OE10.6 For conversion: OE10.7 OE10.8 Fatal Error - If equal to spaces, or OE11.1 OE11.4 zeros, or not numeric, or either OE11.8 OE11.9 Purchase Order company, Inventory OE110 OE113 Control company, or Accounts Payable OE114 OE129 company is not found, then no purchase OE14.4 OE15.1 order lines are loaded to the purchase OE15.2 OE15.3 order. OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO23.2 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-PO-NUMBER Alpha 7 (Right Justified) BL92.1 MA520 PO Number This field contains the number OE10.1 OE10.2 representing the purchase order. OE10.3 OE10.4 OE10.5 OE10.6 For conversion: OE10.7 OE10.8 Fatal Error - If not equal to spaces, OE11.1 OE11.4 or purchase order company flag says it OE11.8 OE11.9 must be numeric and it is not, or the OE110 OE113 purchase order cannot be found, then no OE114 OE129 purchase order lines are loaded for this OE14.4 OE15.1 purchase order. OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO23.2 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-PO-RELEASE Numeric 6 BL92.1 MA520 PO Release Number Used to identify a purchase order OE10.1 OE10.2 release (created from a Blanket or OE10.3 OE10.4 Standing order). OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO23.2 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-LINE-NBR Numeric 6 BL92.1 MA520 Line Number This field contains the line number. OE10.1 OE10.2 OE10.3 OE10.4 For conversion: OE10.5 OE10.6 Fatal Error - If not numeric, then do OE10.7 OE10.8 not load this purchase order line. If OE11.1 OE11.4 the line already exists and was OE11.8 OE11.9 previously processed, then skip this OE110 OE113 line record. If the line already exists OE114 OE129 and was not previously processed, then OE14.4 OE15.1 the purchase order line is not loaded. OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO23.2 PO30.2 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-ITEM Alpha 32 BL92.1 MA520 Item Number This field contains the item identifier. OE10.1 OE10.2 OE10.3 OE10.4 For conversion: OE10.5 OE10.6 Fatal Error - If equal to spaces, then OE10.7 OE10.8 the purchase order line is not loaded. OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.1 PO22.2 PO22.3 PO30.2 PO31.1 PO66.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-ITEM-TYPE Alpha 1 BL92.1 MA520 Item Type Identifies the line item type. OE10.1 OE10.2 OE10.3 OE10.4 For conversion: OE10.5 OE10.6 Nonfatal Error - For Inventory type OE10.7 OE10.8 items, either inventory tracking flag OE11.1 OE11.4 equals N, or this is a dropship purchase OE11.8 OE11.9 order, or item location record not OE110 OE113 found, then set type to Non-stock). OE114 OE129 Fatal Error - If not equal to I, N, S, OE14.4 OE15.1 X or item master record not found for I OE15.2 OE15.3 and N type items, then the purchase OE15.4 OE15.5 order line is not loaded. OE15.7 OE510 I = Inventory OE810 OE920 S = Service PO100 PO20.1 X = Special PO21.1 PO22.2 N = Non-stock PO22.3 PO30.2 PO31.1 PO66.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-DESCRIPTION Alpha 30 (Lower Case) BL92.1 MA520 Description This field contains the description. OE10.1 OE10.2 OE10.3 OE10.4 For conversion: OE10.5 OE10.6 Nonfatal Error - If equal to spaces and OE10.7 OE10.8 a Service or Special (X) type item, or OE11.1 OE11.4 an Inventory or Non-stock type item and OE11.8 OE11.9 not equal to spaces. OE110 OE113 Default - Standard default description OE114 OE129 for a Special (X) and Service type OE14.4 OE15.1 items. OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO30.2 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-QUANTITY Signed 13.4 BL92.1 MA520 Quantity The order quantity in entered unit of OE10.1 OE10.2 measure terms. OE10.3 OE10.4 OE10.5 OE10.6 For Conversion: OE10.7 OE10.8 Allowed to be changed for matching load OE11.1 OE11.4 program. OE11.8 OE11.9 Fatal Error: Cannot be changed if this OE110 OE113 is below received or approved quantity, OE114 OE129 or line is canceled. OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO21.6 PO22.2 PO22.3 PO30.1 PO30.2 PO31.1 PO33.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-VPRI-QUANTITY Signed 13.4 BL92.1 IN20.1 Vendor Price The entered line quantity system MA520 OE10.1 Quantity converted to vendor pricing terms. OE10.2 OE10.3 OE10.4 OE10.5 For conversion: OE10.6 OE10.7 Fatal Error - If not numeric, then the OE10.8 OE11.1 purchase order line is not loaded. OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO30.1 PO30.2 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-REC-QTY Signed 13.4 MA520 PO100 Received Quantity This is the total received quantity for PO22.2 PO22.3 this line item. PO30.1 PO30.2 PO33.1 PO35.1 For Conversion: PO530 PO821 This is allowed to be changed for matching load program. Fatal Error: Cannot go below approved and unreleased approved quantity. PLI-CATCH-WT-QTY Signed 13.4 MA520 PO30.1 Catch Weight This field contains the quantity PO30.2 PO33.1 Quantity received for catch weight shipments. PO821 For conversion: Fatal Error - If not numeric then this purchase order line is not loaded. PLI-CONTRACT-NBR Alpha 14 MA520 PO100 Contract Number This field contains a number to PO20.1 PO22.2 indicate to the vendor which price PO22.3 PO821 agreement an item or items are operating RQ20.1 RQ20.4 under. If this number is entered on or defaulted to a purchase order line, it is an indication of the vendor contract that line is tied to. The contract number can be defaulted to the purchase order line by leaving the field blank when creating the purchase order and having the system attempt to find a contract number from a contract type standard order based on the item number for the line and vendor for the purchase order. If no contract number is entered on or defaulted to the line from a contract type standard order, a contract number entered on the purchase order header will default to the line. A contract number can also be tied to a blanket type standard order, and any purchase orders created from the blanket order will have the contract number from the blanket on the header and lines. The contract number can also be defaulted to a requisition line as the requisition line is created. The contract number will then be carried over to the purchase order line that is created from the requisition line. PLI-RECQTY-TO-APP Signed 13.4 AP125 AP126 Receiver Quantity This is the receipt quantity that is to AP225 AP226 To Approve be approved. This is in the vendor AP26.1 MA520 pricing unit of measure. MA530 MA540 PO22.2 PO22.3 For conversion: PO30.1 PO30.2 Fatal Error - If not numeric, then this PO31.1 PO33.1 purchase order line is not loaded. PO35.1 PO530 PO821 PLI-APPROVE-QTY Signed 13.4 AP125 AP126 Approved Quantity The total approved quantity for this AP225 AP226 line item. AP25.1 AP25.2 AP26.1 MA520 For conversion: MA530 MA540 Fatal Error - If not numeric, then this PO100 PO22.2 purchase order line is not loaded. PO22.3 PO30.2 PO31.1 PO821 PLI-UNREL-APP-QTY Signed 13.4 AP125 AP126 Unreleased Approval Approval quantity upon entry of an AP225 AP226 Quantity Invoice line item. This quantity is AP25.1 AP25.2 established before the Invoice has AP26.1 MA40.1 been released. MA41.4 MA43.1 MA43.2 MA43.4 MA52.1 MA520 MA530 MA540 PO22.2 PO22.3 PO30.2 PO31.1 PO821 PLI-SUBST-QTY Signed 13.4 MA520 PO22.2 Substitute Quantity This is the quantity of substitute PO22.3 PO30.1 items received in on this product. PO30.2 PO33.1 PO35.1 PO530 For conversion: PO821 Nonfatal Error - If equal to zeros and the original line number is numeric, then set original line number to the purchase order line number. 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 MA520 PO22.2 Inspection Reject This is the total inspection rejection PO22.3 PO30.2 Quantity quantity for this line item. PO34.1 PO821 PLI-ENT-UNIT-CST Signed 13.5 BL92.1 MA520 Entered Unit Cost The entered unit cost. Unit costs for OE10.1 OE10.2 Inventoried, Non-Stock, X (special OE10.3 OE10.4 order), and Service items default on OE10.5 OE10.6 purchase orders as follows: OE10.7 OE10.8 OE11.1 OE11.4 UNIT COST ORIGINATION OE11.8 OE11.9 Manually Entered Amount I N X S OE110 OE113 Contract Unit Cost I N X S OE114 OE129 Std. Order Unit Cost I N X S OE14.4 OE15.1 PO14 Quote (Loc-Specific) I N OE15.2 OE15.3 PO14 Quote (No Location) I N OE15.4 OE15.5 Last Received Cost I N OE15.7 OE510 Last PO Created I N X OE810 OE920 PO100 PO20.1 If a unit cost is manually entered, and PO21.1 PO22.2 the system finds a contract cost, a PO22.3 PO227 warning message will be created. PO31.1 PO821 Clearing the unit cost will then default RQ20.1 RQ20.4 the contract cost. WH20.2 WH20.7 For conversion: Allowed to be changed, with no editing, for matching load program. Fatal Error - If not numeric, or equal to zeros, and is a Special (X) or a Service type item, then the purchase order line is not loaded. Default - Normal add item default hierarchy. Blanket or standard order unit cost; purchase order quotes at a location; purchase order quotes without a location; Inventory type items - last received or approved unit cost; Last purchase order line entered unit cost. PLI-TAXBL-UNT-CST Signed 13.5 BL92.1 MA520 Taxable Unit Cost This is the portion of the item unit OE10.1 OE10.2 cost which is taxable. OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-COST-CD Alpha 1 BL92.1 MA520 Unit Cost Origin Unit cost origin code. OE10.1 OE10.2 Code OE10.3 OE10.4 For conversion: OE10.5 OE10.6 Nonfatal Error - If not equal to E, L, OE10.7 OE10.8 S, Q, then set to E (the default). OE11.1 OE11.4 OE11.8 OE11.9 E = Entered OE110 OE113 L = Last Cost OE114 OE129 Q = Quote OE14.4 OE15.1 S = Standard Order OE15.2 OE15.3 O = Order Entry OE15.4 OE15.5 C = Contract OE15.7 OE510 N = Last PO Created OE810 OE920 Y = Copied from PO PO100 PO20.1 P = Override Contract PO21.1 PO22.2 D = Standard Cost PO22.3 PO31.1 A = Average Cost PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-ENT-BUY-UOM Alpha 4 BL92.1 IN20.1 Entered Buy Unit Of Entered buy unit of measure. MA520 OE10.1 Measure OE10.2 OE10.3 For conversion: OE10.4 OE10.5 Fatal Error - If equal to spaces and an OE10.6 OE10.7 Inventory or Non-stock type item and OE10.8 OE11.1 unit of measure required, then the OE11.4 OE11.8 purchase order line is not loaded. OE11.9 OE110 If a unit of measure is not required OE113 OE114 and a valid unit of measure cannot be OE129 OE14.4 found, or an invalid unit of measure is OE15.1 OE15.2 supplied, the purchase order line is not OE15.3 OE15.4 loaded. OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO30.2 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-EBUY-UOM-MULT Signed 13.7 BL92.1 IN20.1 Entered Buy UOM Entered buy unit of measure conversion MA520 OE10.1 Multiplier multiplier. OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO30.2 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-VPRI-UOM Alpha 4 BL92.1 IN20.1 Vendor Price Unit This is the vendor pricing unit of MA520 OE10.1 of Measure measure. OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO30.2 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-VPRI-UOM-MULT Signed 13.7 BL92.1 IN20.1 Vendor Price UOM This is the vendor pricing unit of MA520 OE10.1 Multiplier measure multiplier. It is used to OE10.2 OE10.3 convert unit cost to stock unit of OE10.4 OE10.5 measure terms. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO30.2 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-LAND-UNIT-CST Signed 13.5 BL92.1 MA520 Landed Unit Costs Landed unit cost for this item. OE10.1 OE10.2 This includes the tax landing costs, OE10.3 OE10.4 add-on cost landing costs besides the OE10.5 OE10.6 product unit cost. OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO20.1 PO21.1 PO21.2 PO21.6 PO22.2 PO22.3 PO31.1 PO821 RQ20.1 RQ20.3 RQ20.4 WH20.2 WH20.7 PLI-EARLY-DL-DATE Numeric 8 (yyyymmdd) BL92.1 MA520 Early Delivery Date This field contains the early delivery OE10.1 OE10.2 (Rqst DT) date. OE10.3 OE10.4 OE10.5 OE10.6 For conversion: OE10.7 OE10.8 Nonfatal Error - If equal to zeros and OE11.1 OE11.4 not a Service type item, or date error OE11.8 OE11.9 exists, or the purchase order date is OE110 OE113 later, or delivery date is earlier. OE114 OE129 Default - Purchase order header default OE14.4 OE15.1 delivery date. OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-LATE-DL-DATE Numeric 8 (yyyymmdd) BL92.1 MA520 Late Delivery Date This field contains the late delivery OE10.1 OE10.2 date. OE10.3 OE10.4 OE10.5 OE10.6 For conversion: OE10.7 OE10.8 Nonfatal - If not numeric, or date OE11.1 OE11.4 error exists, or the purchase order date OE11.8 OE11.9 or early delivery date is later. OE110 OE113 Default - Zeros. OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.3 PO821 WH20.2 WH20.7 PLI-REC-ACT-DATE Numeric 8 (yyyymmdd) MA520 PO100 Receiving Activity Last receiving activity date. PO22.2 PO22.3 Date PO30.1 PO33.1 PO34.1 PO35.1 PO530 PO821 PLI-CLOSE-DATE Numeric 8 (yyyymmdd) AP125 AP126 Close Date Purchase order line close date. AP225 AP226 AP25.1 AP25.2 AP26.1 BL92.1 MA520 MA530 MA540 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 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO120 PO123 PO20.1 PO21.6 PO22.2 PO22.3 PO30.1 PO31.1 PO33.1 PO35.1 PO530 PO821 WH20.2 WH20.7 PLI-LOCATION Alpha 5 BL92.1 MA520 Location Code This field contains a valid stock OE10.1 OE10.2 location within the company inventory. OE10.3 OE10.4 OE10.5 OE10.6 For conversion: OE10.7 OE10.8 Default - Purchase order header ship-to OE11.1 OE11.4 location. OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO30.2 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-REQ-LOCATION Alpha 5 PO100 PO20.1 To Location The location requisitioning items. This PO21.1 PO22.2 location can be an inventory or nonstock PO22.3 RQ20.1 location. RQ20.4 PLI-BUYER-CODE Alpha 3 BL92.1 IN20.1 Buyer Code The user defined buyer identifier. MA520 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 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-VENDOR Alpha 9 BL92.1 IN20.1 Vendor ID The vendor's identification code. MA520 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 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-PURCH-FR-LOC Alpha 4 BL92.1 IN20.1 Purchase From The vendor's purchase from location. MA520 OE10.1 Location Code OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO31.1 PO821 PO85.1 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-DIST-CODE Alpha 9 BL92.1 MA520 Distribution Code A user-defined code that may be used to OE10.1 OE10.2 set up common distribution attributes. OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO21.3 PO22.2 PO22.3 WH20.2 WH20.7 PLI-VAR-ACCT-UNIT Alpha 15 PO100 PO821 Cost Variance The variance account accounting unit. Accounting Unit PLI-VAR-ACCOUNT Numeric 6 PO100 PO821 Cost Variance The variance account account number. Account Number PLI-VAR-SUB-ACCT Numeric 4 PO100 PO821 Cost Variance The variance account subaccount number. Subaccount PLI-TAX-CODE Alpha 10 BL92.1 MA520 Tax Code This field contains a code representing OE10.1 OE10.2 specific tax information. This must be OE10.3 OE10.4 valid tax code in the Tax system. OE10.5 OE10.6 OE10.7 OE10.8 For conversion: OE11.1 OE11.4 Nonfatal Error - If not found in the OE11.8 OE11.9 Tax system. OE110 OE113 Fatal Error - If tax is landed for OE114 OE129 standard cost company. OE14.4 OE15.1 Default - If taxable flag equals Y, OE15.2 OE15.3 normal add time default hierarchy OE15.4 OE15.5 applied. Item location purchasing tax OE15.7 OE510 code; item master purchasing tax code; OE810 OE920 Purchase Order header tax code; Accounts PO100 PO20.1 Payable vendor location tax code; PO21.1 PO22.2 Accounts Payable vendor master tax code. PO22.3 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-ORIG-LINE-NBR Numeric 6 BL92.1 MA520 Original Line Number Original line number used for OE10.1 OE10.2 substitute receivings. This is the line OE10.3 OE10.4 number of the original line item when OE10.5 OE10.6 this line is a substitute line item. OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO30.2 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-WEIGHT Signed 9.3 BL92.1 MA520 Unit Weight This field contains the unit weight of OE10.1 OE10.2 the item based on the stock unit of OE10.3 OE10.4 measure. OE10.5 OE10.6 OE10.7 OE10.8 For conversion: OE11.1 OE11.4 Nonfatal Error - If not numeric, then OE11.8 OE11.9 set to zeros. OE110 OE113 Default - If an Inventory or Non-stock OE114 OE129 type item, then inventory control OE14.4 OE15.1 default. OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO30.2 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-CUBIC-FEET Signed 9.3 BL92.1 MA520 Cubic Feet This field contains the unit cubit feet OE10.1 OE10.2 of the item based on the stock unit of OE10.3 OE10.4 measure. OE10.5 OE10.6 OE10.7 OE10.8 For conversion: OE11.1 OE11.4 Nonfatal Error - If not numeric, then OE11.8 OE11.9 set to zeros. OE110 OE113 Default - If an Inventory or a OE114 OE129 Non-stock type item, then use Inventory OE14.4 OE15.1 Control default. OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO30.2 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-SOURCE-DOC Alpha 10 (Right Justified) BL92.1 MA520 Source Document Source document that caused the OE10.1 OE10.2 creation of this line item. OE10.3 OE10.4 OE10.5 OE10.6 For conversion: OE10.7 OE10.8 Nonfatal Error - If not equal to spaces OE11.1 OE11.4 and not right justified. OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-ORIGIN-CD Alpha 2 BL92.1 MA520 Origin Code This field identifies the system that OE10.1 OE10.2 created this record. OE10.3 OE10.4 OE10.5 OE10.6 For conversion: OE10.7 OE10.8 Nonfatal Error - If not equal to IC, OE11.1 OE11.4 DR, RQ, OE, and spaces. OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO22.2 PO22.3 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-ORDER-NBR Numeric 8 BL92.1 MA520 Order Number This field contains the order number. 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 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO821 WH20.2 WH20.7 PLI-REC-PRT-FL Alpha 1 BL92.1 MA520 Receiver Print Flag Print the receiver flag. OE10.1 OE10.2 OE10.3 OE10.4 For conversion: OE10.5 OE10.6 Nonfatal Error - If not equal to Y or OE10.7 OE10.8 N, then set to N. OE11.1 OE11.4 Default - Purchase order header's print OE11.8 OE11.9 receivings flag. OE110 OE113 N = No OE114 OE129 Y = Yes OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO130 PO20.1 PO21.1 PO22.2 PO22.3 PO30.1 PO31.1 PO35.1 PO530 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-CANCEL-BO-FL Alpha 1 BL92.1 MA520 Cancel Back Order Determines if the backorder for this OE10.1 OE10.2 Flag line item is canceled. OE10.3 OE10.4 OE10.5 OE10.6 For conversion: OE10.7 OE10.8 Nonfatal Error - If not equal to Yes or OE11.1 OE11.4 No, then set to No (the default). OE11.8 OE11.9 N = No OE110 OE113 Y = Yes OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO30.1 PO30.2 PO31.1 PO33.1 PO34.1 PO35.1 PO530 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-NO-CHARGE-FL Alpha 1 BL92.1 MA520 No Charge Flag Determines if this is a No Charge order OE10.1 OE10.2 line item. OE10.3 OE10.4 OE10.5 OE10.6 For conversion: OE10.7 OE10.8 Allowed to be changed for matching load OE11.1 OE11.4 program. OE11.8 OE11.9 Nonfatal Error - If not equal to Yes or OE110 OE113 No, then set to No (the default). OE114 OE129 OE14.4 OE15.1 Fatal Error: OE15.2 OE15.3 Cannot change if unit cost is not zero. OE15.4 OE15.5 Cannot change from Yes to No. OE15.7 OE510 N = No OE810 OE920 Y = Yes PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-CERT-REQ-FL Alpha 1 BL92.1 MA520 Certification This flag defines if certification is OE10.1 OE10.2 Required Flag required for this line item. OE10.3 OE10.4 OE10.5 OE10.6 For conversion: OE10.7 OE10.8 Nonfatal Error - If not equal to Yes or OE11.1 OE11.4 No, then set to No (the default). OE11.8 OE11.9 N = No OE110 OE113 Y = Yes OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO30.2 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-INSP-REQ-FL Alpha 1 BL92.1 MA520 Inspection Required Defines if inspection is required for OE10.1 OE10.2 Flag this line item. Set at purchase order OE10.3 OE10.4 entry time. OE10.5 OE10.6 OE10.7 OE10.8 For conversion: OE11.1 OE11.4 Nonfatal Error - If the purchase order OE11.8 OE11.9 is dropship, then set inspection OE110 OE113 required flag to No. If not equal to Yes OE114 OE129 or No, then set to No (the default). OE14.4 OE15.1 N = No OE15.2 OE15.3 Y = Yes OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-REC-INSP-FL Alpha 1 BL92.1 MA520 Receiving Defines if inspection is required for OE10.1 OE10.2 Inspection Flag this line item. It is set at receiving OE10.3 OE10.4 time. OE10.5 OE10.6 OE10.7 OE10.8 For conversion: OE11.1 OE11.4 Nonfatal Error - If not equal to Yes or OE11.8 OE11.9 No, then set to No (the default). OE110 OE113 N = No OE114 OE129 Y = Yes OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO30.1 PO30.2 PO31.1 PO35.1 PO530 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-MSDS-FLAG Alpha 1 BL92.1 MA520 Material Safety This flag indicates if this item OE10.1 OE10.2 DataSheet Flag requires a Material Safety Data Sheet. OE10.3 OE10.4 Y = Yes OE10.5 OE10.6 N = No OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-NO-LT-CALC-FL Alpha 1 BL92.1 MA520 No Lead Time Determines if leadtime generated by OE10.1 OE10.2 Calculation Flag this order is used in calculating OE10.3 OE10.4 leadtime for the inventoried item order OE10.5 OE10.6 by this line. OE10.7 OE10.8 OE11.1 OE11.4 For conversion: OE11.8 OE11.9 Nonfatal Error - If not equal to Yes or OE110 OE113 No, then set to No (the default). OE114 OE129 N = No OE14.4 OE15.1 Y = Yes OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-TAXABLE-FLAG Alpha 1 BL92.1 MA520 Taxable or Defines if taxable. OE10.1 OE10.2 Non-Taxable Flag OE10.3 OE10.4 For conversion: OE10.5 OE10.6 Nonfatal Error - If not equal to Yes, OE10.7 OE10.8 No or spaces, then set to spaces. OE11.1 OE11.4 Default - If tax code not equal to OE11.8 OE11.9 spaces, then set to Yes. Otherwise, OE110 OE113 normal add time default taxable flag OE114 OE129 hierarchy applied. Item location OE14.4 OE15.1 purchasing taxable flag; Item master OE15.2 OE15.3 purchasing taxable flag; purchase order OE15.4 OE15.5 header default taxable flag. OE15.7 OE510 Y = Yes OE810 OE920 N = No PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-OSHIP-TOL-PCT Percent 5.3 (Percent) BL92.1 MA520 Overshipment Quantity overshipment tolerance OE10.1 OE10.2 Tolerance Percent percentage. OE10.3 OE10.4 OE10.5 OE10.6 For conversion: OE10.7 OE10.8 Nonfatal Error - If not numeric, or a OE11.1 OE11.4 Service type item and not equal to OE11.8 OE11.9 zeroes, then set to zeros. OE110 OE113 Default - Zeros. OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO20.1 PO22.2 PO22.3 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-USHIP-TOL-PCT Percent 6.3 (Percent) BL92.1 MA520 Cancel Backorder This is the quantity undership OE10.1 OE10.2 Percent percentage for automatic back order OE10.3 OE10.4 cancellation. If a value of 10% is OE10.5 OE10.6 entered here, for instance, and a OE10.7 OE10.8 quantity of 91 is shipped against an OE11.1 OE11.4 ordered quantity of 100, that would be OE11.8 OE11.9 considered a 9% undershipment. Since OE110 OE113 this is less than the 10% limit, the OE114 OE129 backordered amount would be canceled. OE14.4 OE15.1 OE15.2 OE15.3 This process takes place at receiving OE15.4 OE15.5 time. If a backorder is not canceled OE15.7 OE510 manually, the system checks, in order, OE810 OE920 the purchase order line, the purchase PO20.1 PO22.2 order vendor purchase from record, the PO22.3 PO821 purchase order vendor record, and the RQ20.1 RQ20.4 company record. If an undershipment WH20.2 WH20.7 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-COST-TOL-PCT Percent 5.3 (Percent) BL92.1 MA52.1 Unit Cost Tolerance This is the unit cost tolerance percent. MA520 OE10.1 Percent OE10.2 OE10.3 For conversion: OE10.4 OE10.5 Allowed to change, with no edits, for OE10.6 OE10.7 matching load program. OE10.8 OE11.1 Nonfatal Error - If not numeric, then OE11.4 OE11.8 set to zeros. OE11.9 OE110 Default - Zeros. OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO20.1 PO22.2 PO22.3 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-USER-DATE-3 Numeric 8 (yyyymmdd) BL92.1 MA520 User Date 3 The description for this user date 3 is OE10.1 OE10.2 defined in MA00.1 (Company Setup). OE10.3 OE10.4 OE10.5 OE10.6 For conversion: OE10.7 OE10.8 Nonfatal Error - If date error exists, OE11.1 OE11.4 then set to zeros. OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO23.2 PO821 WH20.2 WH20.7 PLI-USER-DATE-4 Numeric 8 (yyyymmdd) BL92.1 MA520 User Date 4 The description for this user date 4 is OE10.1 OE10.2 defined in MA00.1 (Company Setup). OE10.3 OE10.4 OE10.5 OE10.6 For conversion: OE10.7 OE10.8 Nonfatal Error - If date error exists, OE11.1 OE11.4 then set to zeros. OE11.8 OE11.9 Default - Zeros. OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO23.2 PO821 WH20.2 WH20.7 PLI-COMMENT-CODE Alpha 4 Occurs 2 Times BL92.1 MA520 Comment Code These fields define the last two OE10.1 OE10.2 standard comments that were added to OE10.3 OE10.4 this line item. OE10.5 OE10.6 OE10.7 OE10.8 For conversion: OE11.1 OE11.4 Nonfatal Error - If invalid comment OE11.8 OE11.9 code, or code has no comment lines. OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO20.1 PO30.2 PO821 WH20.2 WH20.7 PLI-PURCH-MAJCL Alpha 4 BL92.1 MA520 Major Purchasing The user-defined major purchasing class OE10.1 OE10.2 Class identifier. OE10.3 OE10.4 OE10.5 OE10.6 For conversion: OE10.7 OE10.8 Nonfatal Error - If not found in OE11.1 OE11.4 Inventory Control. OE11.8 OE11.9 Default - Inventory Control defaults. OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO30.2 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-PURCH-MINCL Alpha 4 BL92.1 MA520 Minor Purchasing The user-defined minor purchasing class OE10.1 OE10.2 Class identifier. OE10.3 OE10.4 OE10.5 OE10.6 For conversion: OE10.7 OE10.8 Non-Fatal Error - If not found in OE11.1 OE11.4 Inventory Control. OE11.8 OE11.9 Default - Inventory Control defaults. OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO30.2 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-PCLASS-MAJMIN Derived Pclass Majmin This field is a combination of purchase major and minor class used for transaction analysis. PLI-MANUF-CODE Alpha 4 PO100 PO20.1 Manufacturer's Code This field contains a user defined code PO31.1 PO821 that indicates the manufacturer of an RQ20.1 RQ20.4 item. PLI-MANUF-DIVISION Alpha 4 PO100 PO20.1 Manufacturer's This is a user defined code that PO31.1 PO821 Division indicates which division of a RQ20.1 RQ20.4 manufacturer is tied to an item. PLI-MF-CODE-DIV Derived Mf Code Div This field is a combination of manufacturer's code and division used for transaction analysis. PLI-MANUF-NBR Alpha 15 PO100 PO20.1 Manufacturer's Item This is the identifier that the PO31.1 PO821 Number manufacturer has assigned to an item. RQ20.1 RQ20.4 PLI-LAST-COMM-SEQ Numeric 3 MA520 PO100 Last Comment Sequence number of the last line of PO20.1 PO21.4 Sequence Number comments for this line item. PO22.2 PO22.3 PO30.2 PO821 PO822 RQ20.1 RQ20.4 PLI-LAST-DST-SEQ Numeric 3 BL92.1 MA43.3 Last Distribution Sequence number of the last line of MA520 OE10.1 Sequence Nbr distribution for this line item. OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO21.3 PO22.2 PO22.3 PO30.2 PO31.1 PO821 PO990 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-RELEASED-FL Alpha 1 BL92.1 IN20.1 Released Released Flag. Record is now MA520 OE10.1 available for further processing in OE10.2 OE10.3 the system. OE10.4 OE10.5 N = No OE10.6 OE10.7 Y = Yes OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO21.3 PO21.6 PO22.1 PO22.2 PO22.3 PO31.1 PO821 RQ20.1 RQ20.3 RQ20.4 WH20.2 WH20.7 PLI-PRINTED-FL Alpha 1 BL92.1 MA520 Printed Flag The purchase order line item printed OE10.1 OE10.2 status flag. OE10.3 OE10.4 OE10.5 OE10.6 For conversion: OE10.7 OE10.8 Nonfatal Error - If not equal to Y or OE11.1 OE11.4 N, then set to opposite of purchase OE11.8 OE11.9 order header print purchase order flag. OE110 OE113 Default - Opposite of purchase order OE114 OE129 header print purchase order flag. OE14.4 OE15.1 N = No OE15.2 OE15.3 Y = Yes OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO120 PO121 PO123 PO20.1 PO21.1 PO22.2 PO22.3 PO30.1 PO31.1 PO35.1 PO530 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-REVISED-FL Alpha 1 BL92.1 MA520 Revised Flag This is the purchase order line item OE10.1 OE10.2 revised flag. OE10.3 OE10.4 OE10.5 OE10.6 For conversion: OE10.7 OE10.8 Nonfatal Error - If not equal to Y or OE11.1 OE11.4 N, then set to N. OE11.8 OE11.9 Default - N. OE110 OE113 OE114 OE129 OE14.4 OE15.1 N = No OE15.2 OE15.3 Y = Yes OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO120 PO121 PO123 PO20.1 PO21.1 PO21.4 PO21.6 PO22.2 PO22.3 PO30.1 PO31.1 PO33.1 PO35.1 PO530 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-CANCELLED-FL Alpha 1 BL92.1 IN20.1 Canceled Flag The canceled flag. MA520 OE10.1 OE10.2 OE10.3 For conversion: OE10.4 OE10.5 Allowed to change for matching load OE10.6 OE10.7 program. OE10.8 OE11.1 Nonfatal Error - If not equal to Y or OE11.4 OE11.8 N, then set to N. OE11.9 OE110 If equal to Y and received quantity is OE113 OE114 not equal to zeros. then set to N and OE129 OE14.4 set Cancel Backorder flag to Y. OE15.1 OE15.2 If equal to Y and approved quantity is OE15.3 OE15.4 not equal to zeros, then set to N. OE15.5 OE15.7 Default - Purchase order header OE510 OE810 canceled flag. OE920 PO100 Fatal Error: Cannot change from Yes to PO20.1 PO21.1 No for matching file load. PO22.2 PO22.3 N = No PO31.1 PO821 Y = Yes RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-CLOSED-FL Alpha 1 AP125 AP126 Closed Flag The closed flag. AP225 AP226 AP25.1 AP25.2 For conversion: AP26.1 BL92.1 Default - If the purchase order line MA520 MA530 close criteria is met, then set to Y. MA540 OE10.1 Otherwise set to N. OE10.2 OE10.3 N = No OE10.4 OE10.5 Y = Yes OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO120 PO123 PO20.1 PO21.1 PO21.6 PO22.2 PO22.3 PO30.1 PO31.1 PO33.1 PO35.1 PO530 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-ZERO-OSHIP-FL Alpha 1 BL92.1 MA520 Zero Overshipment The purchase order line overshipment OE10.1 OE10.2 Flag zero tolerance flag. OE10.3 OE10.4 OE10.5 OE10.6 For conversion: OE10.7 OE10.8 Nonfatal Error - If Over Ship Tolerance OE11.1 OE11.4 Percent not equal to zeros and flag OE11.8 OE11.9 equal to Y, then set flag to N. OE110 OE113 Default - N. OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 N = No OE15.4 OE15.5 Y = Yes OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-ZERO-USHIP-FL Alpha 1 BL92.1 MA520 Zero Undershipment Set this flag to "Y" to indicate that OE10.1 OE10.2 Flag the undershipment tolerance percent OE10.3 OE10.4 should be set to "zero" at this level. OE10.5 OE10.6 This means that no backorders will be OE10.7 OE10.8 canceled. OE11.1 OE11.4 OE11.8 OE11.9 The undershipment tolerance percent OE110 OE113 must be blank to set this flag to "Y". OE114 OE129 N = No OE14.4 OE15.1 Y = Yes OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-ZERO-COST-FL Alpha 1 BL92.1 MA520 Zero Cost Flag The purchase order line unit cost OE10.1 OE10.2 tolerance flag. OE10.3 OE10.4 OE10.5 OE10.6 For conversion: OE10.7 OE10.8 Allowed to be changed by the matching OE11.1 OE11.4 load program. OE11.8 OE11.9 Nonfatal Error - If Cost Tolerance OE110 OE113 Percent not equal to zeros and flag OE114 OE129 equal to Yes, then set flag to No. OE14.4 OE15.1 Defaults to No. OE15.2 OE15.3 Fatal Error: OE15.4 OE15.5 Cost tolerance percent must be zero OE15.7 OE510 when setting flag to Yes. OE810 OE920 N = No PO100 PO20.1 Y = Yes PO21.1 PO22.2 PO22.3 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-EXCL-AOC-SPRD Alpha 1 BL92.1 MA520 Exclude from AOC Exclude this line item from the add-on OE10.1 OE10.2 Spread Method cost spread methods. OE10.3 OE10.4 N = No OE10.5 OE10.6 Y = Yes OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO21.1 PO22.2 PO22.3 PO31.1 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-REMAINING Derived Remaining PLI-AMOUNT-CL-FL Alpha 1 MA520 PO821 Amount Closed Flag Not in use. PLI-PO-USER-FLD-2 Alpha 2 BL92.1 MA520 Purchase Order User Purchase order line user defined field. OE10.1 OE10.2 Field 2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO22.2 PO22.3 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-PO-USER-FLD-4 Alpha 30 (Lower Case) BL92.1 MA520 Purchase Order User Purchase order line user defined field. OE10.1 OE10.2 Field 4 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO22.2 PO22.3 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-PO-USER-FLD-6 Alpha 15 (Lower Case) BL92.1 MA520 Purchase Order User Purchase order line user defined field. OE10.1 OE10.2 Field 6 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO20.1 PO22.2 PO22.3 PO821 RQ20.1 RQ20.4 WH20.2 WH20.7 PLI-SUBSTITUTE Derived Substitute PLI-PO-CLOSE-DATE Derived Purchase Order Closed Date PLI-PO-PRINTED-FL Derived Purchase Order Printed Flag PLI-PO-CNCLD-FL Derived Purchase Order Canceled Flag PLI-PO-CLOSED-FLAG Derived Purchase Order Closed Flag PLI-PO-RELEASED-FL Derived PO Released Flag 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-PO-INV-ACCT-UN Derived PO Inventory Accounting Unit PLI-PO-INV-ACCT Derived Purchase Order Inventory Acct PLI-PO-INV-SUB-ACC Derived PO Inventory Subaccount PLI-APPR-AND-REJ Derived Appr And Rej PLI-EXT-COST Derived Ext Cost POLINE FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN PLISET1 COMPANY AP125 AP126 PO-NUMBER AP225 AP226 PO-RELEASE AP25.1 AP25.2 LINE-NBR AP26.1 BL92.1 CX05.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1 DR100 IC140 IC141 IC142 IC50.2 IC522 IC523 IC524 IC525 IC526 IC83.1 ... PLISET2 COMPANY KeyChange PO227 CONTRACT-NBR PO-NUMBER PO-RELEASE LINE-NBR PLISET3 COMPANY KeyChange, Subset PO130 PO233 LOCATION Where LINE-NBR = ORIG-LINE-NBR PO30.1 PO35.1 PO-NUMBER And ITEM-TYPE != "S" PO530 PO-RELEASE And CANCELLED-FL != "Y" LINE-NBR PLISET4 COMPANY KeyChange PO62.1 BUYER-CODE EARLY-DL-DATE LOCATION PO-NUMBER PO-RELEASE LINE-NBR PLISET5 COMPANY KeyChange PO275 PO276 LOCATION PO277 PO280 EARLY-DL-DATE PO61.1 PO-NUMBER PO-RELEASE LINE-NBR PLISET6 COMPANY KeyChange BL92.1 CX05.1 ITEM DR100 IC11.1 LOCATION IC12.1 IC140 EARLY-DL-DATE* IC141 IC142 PO-NUMBER IC522 IC523 PO-RELEASE IC524 IC525 LINE-NBR IC526 IC83.1 PC120 PC20.1 PC540 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 ... PLISET7 COMPANY KeyChange MA540 PO122 PO-NUMBER PO22.2 PO30.1 PO-RELEASE PO530 ITEM LINE-NBR PLISET8 COMPANY KeyChange PO94.1 LOCATION VENDOR EARLY-DL-DATE PO-NUMBER PO-RELEASE ORIG-LINE-NBR LINE-NBR PLISET9 COMPANY KeyChange, Subset PO130 PO30.1 PO-NUMBER Where ITEM-TYPE != "S" PO30.2 PO530 PO-RELEASE And CANCELLED-FL != "Y" ORIG-LINE-NBR LINE-NBR 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 PLI-COMPANY -> BUY-COMPANY 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-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 When PLI-ITEM-TYPE = "I" 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 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 Spaces -> MUA-LOCATION "PT" -> MUA-DOC-TYPE PLI-PO-NUMBER -> MUA-DOC-NBR PLI-PO-RELEASE -> MUA-DOC-NBR-NUM PLI-LINE-NBR -> MUA-LINE-NBR Pcr Buyer BUYER Required PLI-COMPANY -> BUY-COMPANY PCR-BUYER-CODE -> BUY-BUYER-CODE Pocompany POCOMPANY Required PLI-COMPANY -> PCY-COMPANY Pointerface POINTERFAC Not Required PLI-COMPANY -> PIF-COMPANY PLI-PO-NUMBER -> PIF-PO-NUMBER PLI-PO-RELEASE -> PIF-PO-RELEASE PLI-LINE-NBR -> PIF-PO-LINE-NBR Poitemven POITEMVEN Not Required PLI-COMPANY -> PIV-COMPANY PLI-ITEM -> PIV-ITEM PCR-VENDOR -> PIV-VENDOR Poquotes POQUOTES Not Required PLI-COMPANY -> POQ-COMPANY PLI-LOCATION -> POQ-LOCATION PLI-ITEM -> POQ-ITEM PCR-VENDOR -> POQ-VENDOR PCR-PURCH-FR-LOC -> POQ-PURCH-FR-LOC Process Level POPROCLEV Not Required PLI-COMPANY -> POP-COMPANY PCR-PROCESS-LEVEL -> POP-PROCESS-LEVEL Purchorder PURCHORDER Required PLI-COMPANY -> PCR-COMPANY PLI-PO-NUMBER -> PCR-PO-NUMBER PLI-PO-RELEASE -> PCR-PO-RELEASE Return Header PORETURNHD Required When PLI-RETURN-NUMBER != Zeroes PLI-COMPANY -> PTH-COMPANY PCR-RETURN-NUMBER -> PTH-RETURN-NUMBER Substitute POLINE Required When PLI-PO-NUMBER = PLI-PO-NUMBER And PLI-PO-RELEASE = PLI-PO-RELEASE And PLI-ORIG-LINE-NBR != PLI-LINE-NBR PLI-COMPANY -> PLI-COMPANY PLI-PO-NUMBER -> PLI-PO-NUMBER PLI-PO-RELEASE -> PLI-PO-RELEASE PLI-ORIG-LINE-NBR -> PLI-LINE-NBR 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 POLINE FILE RELATIONS ONE TO MANY RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Customer Order COLINE Valid When PLI-ORIGIN-CD = "OE" PLI-COMPANY -> COL-COMPANY PLI-ORDER-NBR -> COL-ORDER-NBR COL-LINE-NBR Has Return PORETURNLN PLI-COMPANY -> PTL-COMPANY PTL-RETURN-NUMBER PTL-RET-LINE-NBR Mmdist MMDIST Delete Cascades Valid When PLI-ITEM-TYPE != "I" PLI-COMPANY -> MMD-COMPANY "PO" -> MMD-SYSTEM-CD Spaces -> MMD-LOCATION "PT" -> MMD-DOC-TYPE PLI-PO-NUMBER -> MMD-DOC-NBR PLI-PO-RELEASE -> MMD-DOC-NBR-NUM PLI-LINE-NBR -> MMD-LINE-NBR Zeroes -> MMD-COMPONENT-SEQ Spaces -> MMD-AOC-CODE MMD-LINE-SEQ Poaocappv Date POAPPROVE PLI-COMPANY -> POA-COMPANY PLI-PO-NUMBER -> POA-PO-NUMBER PLI-PO-RELEASE -> POA-PO-RELEASE PLI-LINE-NBR -> POA-LINE-NBR POA-UPDATE-DATE POA-UPDATE-TIME POA-VENDOR POA-INVOICE POA-SUFFIX POA-AOC-CODE Poaocdtl POAOCDTL Delete Cascades PLI-COMPANY -> PAO-COMPANY Spaces -> PAO-ORDER-NAME PLI-PO-NUMBER -> PAO-PO-NUMBER PLI-PO-RELEASE -> PAO-PO-RELEASE PLI-LINE-NBR -> PAO-LINE-NBR PAO-AOC-CODE Poaoclinedtl POAOCDTL PLI-COMPANY -> PAO-COMPANY PLI-PO-NUMBER -> PAO-PO-NUMBER PLI-PO-RELEASE -> PAO-PO-RELEASE PLI-LINE-NBR -> PAO-LINE-NBR PAO-AOC-CODE Poappr By Date POAPPROVE PLI-COMPANY -> POA-COMPANY PLI-PO-NUMBER -> POA-PO-NUMBER PLI-PO-RELEASE -> POA-PO-RELEASE PLI-LINE-NBR -> POA-LINE-NBR POA-UPDATE-DATE POA-UPDATE-TIME POA-VENDOR POA-INVOICE POA-SUFFIX POA-AOC-CODE Poapprove POAPPROVE PLI-COMPANY -> POA-COMPANY PLI-PO-NUMBER -> POA-PO-NUMBER PLI-PO-RELEASE -> POA-PO-RELEASE PLI-LINE-NBR -> POA-LINE-NBR PLI-VENDOR -> POA-VENDOR POA-INVOICE POA-SUFFIX POA-AOC-CODE Poaudit POAUDIT PLI-COMPANY -> PAU-COMPANY PLI-PO-NUMBER -> PAU-PO-NUMBER PLI-PO-RELEASE -> PAU-PO-RELEASE PLI-LINE-NBR -> PAU-PO-LINE-NBR PAU-FLD-NBR PAU-AOC-CODE PAU-UPDATE-DATE PAU-UPDATE-TIME Pocomments POCOMMENTS Delete Cascades PLI-COMPANY -> POC-COMPANY Spaces -> POC-ORDER-NAME Zeroes -> POC-RETURN-NUMBER PLI-PO-NUMBER -> POC-PO-NUMBER PLI-PO-RELEASE -> POC-PO-RELEASE PLI-LINE-NBR -> POC-LINE-NBR POC-SEQ Poquoteswin POQUOTES Valid When ((PLI-LOCATION = PLI-LOCATION) Or (PLI-LOCATION = Spaces )) And (PLI-PURCH-FR-LOC = PLI-PURCH-FR-LOC) And (PLI-CURRENCY-CODE = PLI-CURRENCY-CODE) PLI-COMPANY -> POQ-COMPANY PLI-ITEM -> POQ-ITEM POQ-VENDOR POQ-LOCATION POQ-PURCH-FR-LOC Porec By Date PORECLINE PLI-COMPANY -> PRL-COMPANY 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-TRAN-COUNTER PRL-DOCUMENT PRL-LINE-NBR Porecline PORECLINE Delete Restricted PLI-COMPANY -> PRL-COMPANY PLI-PO-NUMBER -> PRL-PO-NUMBER PLI-PO-RELEASE -> PRL-PO-RELEASE PLI-ORIG-LINE-NBR -> PRL-PO-LINE-NBR PRL-DOC-TYPE PRL-DOCUMENT PRL-LINE-NBR Potaxappv Date POAPPROVE PLI-COMPANY -> POA-COMPANY PLI-PO-NUMBER -> POA-PO-NUMBER PLI-PO-RELEASE -> POA-PO-RELEASE PLI-LINE-NBR -> POA-LINE-NBR POA-UPDATE-DATE POA-UPDATE-TIME POA-VENDOR POA-INVOICE POA-SUFFIX POA-AOC-CODE Requisitions REQLINE Valid When PLI-ORIGIN-CD = "RQ" PLI-COMPANY -> RLN-COMPANY PLI-PO-NUMBER -> RLN-PO-NUMBER PLI-PO-RELEASE -> RLN-PO-RELEASE PLI-LINE-NBR -> RLN-PO-LINE-NBR RLN-REQ-NUMBER RLN-LINE-NBR Return Line PORETURNLN PLI-COMPANY -> PTL-COMPANY PLI-PO-NUMBER -> PTL-ORIG-PO-NBR PLI-PO-RELEASE -> PTL-ORIG-PO-REL PLI-LINE-NBR -> PTL-ORIG-PO-LN-NBR PTL-RETURN-NUMBER PTL-RET-LINE-NBR Std Comment STCOMMENTS Required When PLI-COMMENT-CODE != Spaces PLI-COMPANY -> STC-COMPANY PLI-COMMENT-CODE -> STC-COMMENT-CODE STC-LANGUAGE-CODE STC-SEQ Stpolines STPOLINE PLI-COMPANY -> SPL-COMPANY PLI-ITEM -> SPL-ITEM SPL-ITEM-TYPE SPL-ORDER-NAME Vendoritems POITEMVEN PLI-COMPANY -> PIV-COMPANY PLI-ITEM -> PIV-ITEM PIV-VENDOR |