Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              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