POLINE – Line Items

System
Purchase Order (PO)
Prefix
PLI
Primary key
COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR
Fields
165
Updated by
246 programs
Referenced by
92 programs

POLINE is the Line Items table in Lawson Purchase Order (prefix PLI). It is indexed by COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR (PLISET1); alternate indexes: PLISET10, PLISET11, PLISET12, PLISET13, PLISET14, PLISET15, PLISET2, PLISET3 and 6 more. It is related 1:1 to AMPOASTHDR, AMPODFLTS, APCOMPANY, APVENMAST, BUYER, COMMCODES, POLINE, HCPATPROC and 23 more and 1:M to AMPOASTDTL, APDISTPAY, APINVOICE, APVENDIV, PORETURNLN, POVAGRMTLN, MAAOCDTL, MAINVDTL and 11 more. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 238 more and referenced by AM17.1, AM19.1, AM19.2, AM219, AP115, AP133, AP220, AP233 and 84 more. The table has 165 fields, 15 indexes and 56 documented relations.

About POLINE

This file contains purchase order line item information.

Fields (165)

Column = COBOL field name without the PLI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PLI-COMPANY PK
COMPANY
Numeric 4The company number represents a defined company and is entered on all actions. For conversion: Fatal Error - If equal to spaces, or zeros, or not numeric, or either Purchase Order company, Inventory Control company, or Accounts Payable company is not found, then no purchase order lines are loaded to the purchase order.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PO-NUMBER PK
PO_NUMBER
Alpha 14 (Right Justified)This field contains the number representing the purchase order. For conversion: Fatal Error - If not equal to spaces, or purchase order company flag says it must be numeric and it is not, or the purchase order cannot be found, then no purchase order lines are loaded for this purchase order.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PO-RELEASE PK
PO_RELEASE
Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PO-CODE PK
PO_CODE
Alpha 4This is the purchase order code.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-LINE-NBR PK
LINE_NBR
Numeric 6This field contains the line number. For conversion: Fatal Error - If not numeric, then do not load this purchase order line. If the line already exists and was previously processed, then skip this line record. If the line already exists and was not previously processed, then the purchase order line is not loaded.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-ITEM
ITEM
Alpha 32This field contains the item identifier. For conversion: Fatal Error - If equal to spaces, then the purchase order line is not loaded.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-ITEM-TYPE
ITEM_TYPE
Alpha 1Identifies the line item type. For conversion: Nonfatal Error - For inventory type items, either inventory tracking flag equals N, or this is a dropship purchase order, or item location record not found, then set type to non-stock). Fatal Error - If not equal to I, N, S, 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
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-SERVICE-CODE
SERVICE_CODE
Alpha 1" " = Non Service Item
  • A Amount
  • Q Quantity
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field contains the description. For conversion: Nonfatal Error - If equal to spaces and a service or special (X) type item, or an inventory or non-stock type item and not equal to spaces. Default - Standard default description for a special (X) and service type items.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PROCURE-GROUP
PROCURE_GROUP
Alpha 4This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PO-OBJ-ID
PO_OBJ_ID
Alpha 10 (Right Justified)The PO Object ID is used as a document number for the warehouse demand records. This field, along with the PO Line number, is used to relate POLINE records to WHDEMAND records. A unique PO Object ID is obtained when the PO number is assigned in PO creation. It is passed on to the PO line when the PO 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).AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-QUANTITY
QUANTITY
Signed 13.4The order quantity in entered unit of measure terms. For Conversion: Allowed to be changed for matching load program. Fatal Error: Cannot be changed if this is below received or approved quantity, or line is canceled.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-VPRI-QUANTITY
VPRI_QUANTITY
Signed 13.4The entered line quantity system converted to vendor pricing terms. For conversion: Fatal Error - If not numeric, then the purchase order line is not loaded.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-REC-QTY
REC_QTY
Signed 13.4This is the total received quantity for this line item. For Conversion: This is allowed to be changed for matching load program. Fatal Error: Cannot go below approved and unreleased approved quantity.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-CATCH-WT-QTY
CATCH_WT_QTY
Signed 13.4This field contains the quantity received for catch weight shipments. For conversion: Fatal Error - If not numeric then this purchase order line is not loaded.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-AGREEMENT-REF
AGREEMENT_REF
Alpha 30AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-AGRMT-REF-AMT
AGRMT_REF_AMT
Signed 18.2AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-LST-MATCH-UCST
LST_MATCH_UCST
Signed 18.5This field is used only when the PO Cost is adjusted during the PO Cost message process.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-MATCHED-QTY
MATCHED_QTY
Signed 13.4This is the total quantity to date match for this ordered item.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-MATCHED-AMOUNT
MATCHED_AMOUNT
Signed 18.5AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-SUBST-QTY
SUBST_QTY
Signed 13.4This is the quantity of substitute items received in on this product. For conversion: Nonfatal Error - If equal to zeros and the original line number is numeric, then set original line number to the purchase order line number. Fatal Error - If not equal to zeros and original line number either not numeric or equal to zeros, then the purchase order line is not loaded.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-REJECT-QTY
REJECT_QTY
Signed 13.4This is the total inspection rejection quantity for this line item.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-ENT-UNIT-CST
ENT_UNIT_CST
Signed 18.5The entered unit cost in vendor price unit of measure terms. This value may be entered directly on line or calculated from entry of cost in buy unit of measure terms. If cost is not manually entered in either unit of measure, unit costs for inventoried, non-stock, X (special order), and service items default on purchase orders from the cost default routine.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-VBUY-UNIT-CST
VBUY_UNIT_CST
Signed 18.5AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-TAXBL-UNT-CST
TAXBL_UNT_CST
Signed 18.5AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-COST-CD
COST_CD
Alpha 1Unit cost origin code. For conversion: Nonfatal Error - If not equal to E, L, S, Q, then set to E (the default).
  • E Entered
  • L Last Cost
  • C Contract
  • T Catalog/Quote
  • B Blanket
  • P Last PO Created
  • S Standing
  • G Punchout
  • R Strategic Sourcing
  • Y Tier - Company Participant
  • N Tier - IC Location Participant
  • Q Tier - Req Loc Participant
  • W Website
  • V Procurement Template Agrmt Ref
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-ENT-BUY-UOM
ENT_BUY_UOM
Alpha 4Entered buy unit of measure. For conversion: Fatal Error - If equal to spaces and an inventory or non-stock type item and unit of measure required, then the purchase order line is not loaded. If a unit of measure is not required and a valid unit of measure cannot be found, or an invalid unit of measure is supplied, the purchase order line is not loaded.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-EBUY-UOM-MULT
EBUY_UOM_MULT
Signed 13.7Entered buy unit of measure conversion multiplier.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-VPRI-UOM
VPRI_UOM
Alpha 4This field contains the valid stock unit of measure for this item.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-VPRI-UOM-MULT
VPRI_UOM_MULT
Signed 13.7This field contains the multiplier for converting this unit of measure to the stock unit of measure.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-LAND-UNIT-CST
LAND_UNIT_CST
Signed 18.5Landed unit cost for this item. This includes the tax landing costs, add-on cost landing costs besides the product unit cost.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-EARLY-DL-DATE
EARLY_DL_DATE
Numeric 8 (yyyymmdd)This field contains the early delivery date. For conversion: Nonfatal Error - If equal to zeros and not a Service type item, or date error exists, or the purchase order date is later, or delivery date is earlier. Default - Purchase order header default delivery date.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-LATE-DL-DATE
LATE_DL_DATE
Numeric 8 (yyyymmdd)This field contains the late delivery date. For conversion: Nonfatal - If not numeric, or date error exists, or the purchase order date or early delivery date is later. Default - Zeros.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-REC-ACT-DATE
REC_ACT_DATE
Numeric 8 (yyyymmdd)Last receiving activity date.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-CLOSE-DATE
CLOSE_DATE
Numeric 8 (yyyymmdd)Purchase order line close date.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-LOCATION
LOCATION
Alpha 5This field contains a valid stocking location within the company inventory. For conversion: Default - PO header ship to location.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-BUYER-CODE
BUYER_CODE
Alpha 3AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-VENDOR
VENDOR
Alpha 9 (Right Justified)The vendor's identification code.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PURCH-FR-LOC
PURCH_FR_LOC
Alpha 4The vendor's purchase from location.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-VEN-ITEM
VEN_ITEM
Alpha 32This field contains the item identifier.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-DIST-CODE
DIST_CODE
Alpha 9A user-defined code that may be used to set up common distribution attributes.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-TAX-CODE
TAX_CODE
Alpha 10This field contains a code representing specific tax information. This must be valid tax code in Tax. For conversion: Nonfatal Error - If not found in Tax. Fatal Error - If tax is landed for 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.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-WEIGHT
WEIGHT
Signed 9.3This field contains the total weight of the item based on the stock unit of measure. For conversion: Nonfatal Error - If not numeric, then set to zeros. Default - If an inventory or non-stock type item, then Inventory Control defaults.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-CUBIC-FEET
CUBIC_FEET
Signed 9.3This field contains the total cubic feet of the item based on the stock unit of measure. For conversion: Nonfatal Error - If not numeric, then set to zeros. Default - If an inventory or a non-stock type item, then use Inventory Control default.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-REC-PRT-FL
REC_PRT_FL
Alpha 1Indicates the line has been printed on PO130 (Receiving Document) For conversion: Nonfatal Error - If not equal to Y or N, then set to N. Default - Purchase order header's print receivings flag.
  • N No
  • Y Yes
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-COST-OPTION
COST_OPTION
Alpha 1
  • 1 Cost Required
  • 2 No Charge
  • 3 Vendor Determined
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-CERT-REQ-FL
CERT_REQ_FL
Alpha 1This flag defines if certification is required for this line item. For conversion: Nonfatal Error - If not equal to Yes or No, then set to No (the default).
  • N No
  • Y Yes
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-REC-INSP-FL
REC_INSP_FL
Alpha 1Defines if inspection is required for this line item. It is set at receiving time. For conversion: Nonfatal Error - If not equal to Yes or No, then set to No (the default).
  • N No
  • Y Yes
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-INSP-REQ-FL
INSP_REQ_FL
Alpha 1Defines if inspection is required for this line item. Set at purchase order entry time. For conversion: Nonfatal Error - If the purchase order is dropship, then set inspection required flag to No. If not equal to Yes or No, then set to No (default).
  • N No
  • Y Yes
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-MSDS-FLAG
MSDS_FLAG
Alpha 1
  • Y Yes
  • N No
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-NO-LT-CALC-FL
NO_LT_CALC_FL
Alpha 1Determines if leadtime generated by this order is used in calculating leadtime for the inventoried item order by this line. For conversion: Nonfatal Error - If not equal to Yes or No, then set to No (the default).
  • N No
  • Y Yes
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-TAXABLE-FLAG
TAXABLE_FLAG
Alpha 1Defines if taxable. For conversion: Nonfatal Error - If not equal to Yes, No or spaces, then set to spaces. Default - If tax code not equal to spaces, then set to Yes. Otherwise, normal add time default taxable flag hierarchy applied. Item location purchasing taxable flag; Item master purchasing taxable flag; purchase order header default taxable flag.
  • Y Yes
  • N No
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-OSHIP-TOL-PCT
OSHIP_TOL_PCT
Percent 5.3 (Percent)Quantity overshipment tolerance percentage. For conversion: Nonfatal Error - If not numeric, or a Service type item and not equal to zeroes, then set to zeros. Default - Zeros.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-USHIP-TOL-PCT
USHIP_TOL_PCT
Percent 6.3 (Percent)This is the quantity undership percentage for automatic back order cancellation. If a value of 10% is entered here, for instance, and a quantity of 91 is shipped against an ordered quantity of 100, that would be considered a 9% undershipment. Since this is less than the 10% limit, the 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.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-USER-DATE-3
USER_DATE_3
Numeric 8 (yyyymmdd)The description for this user date 3 is defined in MA00.1 (Company Setup). For conversion: Nonfatal Error - If date error exists, then set to zeros.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-USER-DATE-4
USER_DATE_4
Numeric 8 (yyyymmdd)The description for this user date 4 is defined in MA00.1 (Company Setup). For conversion: Nonfatal Error - If date error exists, then set to zeros. Default - Zeros.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PURCH-MAJCL
PURCH_MAJCL
Alpha 4The user-defined major purchasing class identifier. For conversion: Non-Fatal Error - If not found in Inventory Control. Default - Inventory Control defaults.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PURCH-MINCL
PURCH_MINCL
Alpha 4The user-defined minor purchasing class identifier. For conversion: Non-Fatal Error - If not found in Inventory Control. Default - Inventory Control defaults.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-MANUF-CODE
MANUF_CODE
Alpha 4This field contains a user defined code that indicates the manufacturer of an item.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-MANUF-DIVISION
MANUF_DIVISION
Alpha 4This is a user defined code that indicates which division of a manufacturer is tied to an item.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-MANUF-NBR
MANUF_NBR
Alpha 35This is the identifier that the manufacturer has assigned to an item.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-LAST-DST-SEQ
LAST_DST_SEQ
Numeric 3Sequence number of the last line of distribution for this line item.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-LAST-SRC-LINE
LAST_SRC_LINE
Numeric 4This is the Source Line Number of the last PO Line Source record for this PO line.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-RELEASED-FL
RELEASED_FL
Alpha 1Released Flag. Record is now available for further processing in the system.
  • N No
  • Y Yes
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-ISSUED-FLAG
ISSUED_FLAG
Alpha 1This is the issue status of the PO line record. If the PO has been issued at least once since the PO line record was created, this flag will be set to a value of "Y". Once set to "Y", it never changes. For conversion: Nonfatal Error - If not equal to Y or N, then set to N.
  • N No
  • Y Yes
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-REVISED-FL
REVISED_FL
Alpha 1This is the purchase order line item revised flag. For conversion: Nonfatal Error - If not equal to Y or N, then set to N. Default - N.
  • N No
  • Y Yes
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-CLOSED-FL
CLOSED_FL
Alpha 1The closed flag. For conversion: Default - If the purchase order line close criteria is met, then set to Y. Otherwise set to N.
  • N No
  • Y Yes
  • H Historical
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-ZERO-OSHIP-FL
ZERO_OSHIP_FL
Alpha 1The purchase order line overshipment zero tolerance flag. For conversion: Nonfatal Error - If Over Ship Tolerance Percent not equal to zeros and flag equal to Y, then set flag to N. Default - N.
  • N No
  • Y Yes
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-ZERO-USHIP-FL
ZERO_USHIP_FL
Alpha 1Set this flag to Yes to indicate that the undershipment tolerance percent should be set to "zero" at this level. This means that no backorders will be canceled. The undershipment tolerance percent must be blank to set this flag to Yes.
  • N No
  • Y Yes
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-EXCL-AOC-SPRD
EXCL_AOC_SPRD
Alpha 1Exclude this line item from the add-on cost spread methods.
  • N No
  • Y Yes
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PO-USER-FLD-2
PO_USER_FLD_2
Alpha 2Purchase order line user defined field.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PO-USER-FLD-4
PO_USER_FLD_4
Alpha 30 (Lower Case)AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PO-USER-FLD-6
PO_USER_FLD_6
Alpha 15 (Lower Case)AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-MATCH-CLASS
MATCH_CLASS
Alpha 10AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-MATCH-DTL-KEY
MATCH_DTL_KEY
Alpha 85AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-ARCHIVE-QTY
ARCHIVE_QTY
Signed 13.4This field contains the desired quantity.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-MATCHED-NO-REC
MATCHED_NO_REC
Signed 13.4AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-CHARGEBACK-QTY
CHARGEBACK_QTY
Signed 13.4AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-WRITE-OFF-QTY
WRITE_OFF_QTY
Signed 13.4AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-RET-LINE-NBR
RET_LINE_NBR
Numeric 6This field contains the line number.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-TAX-USAGE-CD
TAX_USAGE_CD
Alpha 10The tax usage code for the vendor. This field is required if the Accounts Payable company indicates that VAT reporting is required.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-EXTENDED-AMT
EXTENDED_AMT
Signed 18.2AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-CXL-QTY
CXL_QTY
Signed 13.4The cancelled quantity. This quantity is kept in "Entered Unit-of-Measure" terms. All or a portion of the line may be cancelled. The cancelled quantity is not expected to be received from or invoiced by the vendor.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-QTY-TO-PROC
QTY_TO_PROC
Signed 13.4This is the total quantity to date received for this ordered item.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-VPRI-QTY-TO-PR
VPRI_QTY_TO_PR
Signed 13.4This is the total quantity to date received for this ordered item.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-INVC-TAX-AMT
INVC_TAX_AMT
Signed 18.2AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-ACCR-TAX-AMT
ACCR_TAX_AMT
Signed 18.2AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-EXT-TAXBL-AMT
EXT_TAXBL_AMT
Signed 18.2AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-OPEN-PO-AMT
OPEN_PO_AMT
Signed 18.2AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-ICN-CODE
ICN_CODE
Alpha 8AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-SUPLMNTARY-QTY
SUPLMNTARY_QTY
Signed 13.4This field contains the desired quantity.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-RQSRC-MACHINE
RQSRC_MACHINE
Alpha 6DROYAL ESIOB HBOC OMNICL PAREXC PERSE PYXIS INTERAM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PAR-ORDER-ID
PAR_ORDER_ID
Alpha 20AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PUNCHOUT-ID
PUNCHOUT_ID
Alpha 64AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-FREIGHT-TERMS
FREIGHT_TERMS
Alpha 1Freight terms are used to define who pays for freight costs incurred when goods are shipped. Prepaid, for instance, would normally mean that the vendor would pay for freight. Collect would mean the customer would pay for freight. A freight terms code can be entered on a purchase order, or defaulted by vendor or company.
PLI-FOB-CODE
FOB_CODE
Alpha 3The user defined Free On Board Code.
PLI-TERM-CODE
TERM_CODE
Alpha 5A user-defined code representing a method of determining invoice due and discount dates.
PLI-CATCH-WGT-COST
CATCH_WGT_COST
Signed 18.5
PLI-PREV-RELEASED
PREV_RELEASED
Numeric 1
  • 0 No
  • 1 Yes
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-OPEN-PO-TRAN
OPEN_PO_TRAN
Signed 18.2The portion of the total or extended ordered amount that is still open -- that is, it has not been cancelled or paid. This is expressed in the Purchase Order currency, and includes only product costs (add on costs and taxes are not included).AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-SS-EVENT-NBR
SS_EVENT_NBR
Numeric 8AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-COMMODITY-CODE
COMMODITY_CODE
Alpha 35AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-P-CARD-FLAG
P_CARD_FLAG
Numeric 1
  • 0 No
  • 1 Yes
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-CHARGE-QTY
CHARGE_QTY
Signed 13.4This field contains the desired quantity.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-CHG-NO-REC-QTY
CHG_NO_REC_QTY
Signed 13.4This field contains the desired quantity.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-CHRG-APPRV-QTY
CHRG_APPRV_QTY
Signed 13.4This field contains the desired quantity.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-CHRG-DISPT-QTY
CHRG_DISPT_QTY
Signed 13.4This field contains the desired quantity.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-CONTRACT-GROUP
CONTRACT_GROUP
Alpha 4AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-CM-CONTRACT
CM_CONTRACT
Numeric 15AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-TIER
TIER
Alpha 4AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PREFERRED-FLAG
PREFERRED_FLAG
Numeric 1
  • 0 No
  • 1 Contract
  • 2 Manufacturer
  • 3 Contract and Manufacturer
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-ORIG-LINE-NBR
ORIG_LINE_NBR
Numeric 6AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PCLASS-MAJMIN
PCLASS_MAJMIN
DerivedThis field is a combination of purchase major and minor class used for transaction analysis.
PLI-MF-CODE-DIV
MF_CODE_DIV
DerivedThis field is a combination of manufacturer's code and division used for transaction analysis.
PLI-REMAINING
REMAINING
Derived
PLI-PO-PRINTED-FL
PO_PRINTED_FL
Derived
PLI-PO-RELEASED-FL
PO_RELEASED_FL
Derived
PLI-PO-CNCLED-FL
PO_CNCLED_FL
Derived
PLI-PO-CLOSED-FL
PO_CLOSED_FL
Derived
PLI-PO-DROP-SHIP
PO_DROP_SHIP
Derived
PLI-ICL-LOC-PO-NM
ICL_LOC_PO_NM
Derived
PLI-PURCH-FR-NAME
PURCH_FR_NAME
Derived
PLI-ITEM-DESC-1
ITEM_DESC_1
Derived
PLI-ITEM-DESC-2
ITEM_DESC_2
Derived
PLI-PO-GL-CATEGORY
PO_GL_CATEGORY
Derived
PLI-APPR-AND-REJ
APPR_AND_REJ
Derived
PLI-DISP-PO-REL-CD
DISP_PO_REL_CD
Derived
PLI-DISP-PO-REL
DISP_PO_REL
Derived
PLI-DISP-DOC-NBR
DISP_DOC_NBR
Derived
PLI-RETAINAGE
RETAINAGE
Numeric 1
  • 0 No
  • 1 Yes
  • 3 Retainage on Vendor Agreement
AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-RET-PCT-1
RET_PCT_1
Percent 5.2 (Percent)AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-RET-PCT-2
RET_PCT_2
Percent 5.2 (Percent)AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-RET-UP-TO-PCT
RET_UP_TO_PCT
Percent 5.2 (Percent)AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-RET-PCT-COMP
RET_PCT_COMP
Percent 5.2 (Percent)AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-RET-OVRD-PCT
RET_OVRD_PCT
Percent 5.2 (Percent)AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-CHARGEBACK-AMT
CHARGEBACK_AMT
Signed 18.2AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PVN-OBJ-ID
PVN_OBJ_ID
Numeric 12AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PART-SEQ-NBR
PART_SEQ_NBR
Numeric 6AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-MFG-CONTRACT
MFG_CONTRACT
Numeric 15AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-ICSEGMENT
ICSEGMENT
Alpha 2AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-ICFAMILY
ICFAMILY
Alpha 2AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-ICCLASS
ICCLASS
Alpha 2AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-ICCOMMODITY
ICCOMMODITY
Alpha 2AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-MEMO-QTY
MEMO_QTY
Signed 13.4AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PROD-TAX-CAT
PROD_TAX_CAT
Alpha 15AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-SERV-CXL-AMT
SERV_CXL_AMT
Signed 18.5For amount type service items only. This is the amount that is cancelled on an amount type service line item.AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-MEMO-AMT
MEMO_AMT
Signed 18.2
PLI-GTIN
GTIN
Numeric 14AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PO-USER-FLD-7
PO_USER_FLD_7
Alpha 10 (Lower Case)
PLI-EAM-OPER-NBR
EAM_OPER_NBR
Numeric 4AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-EAM-SEQ-NBR
EAM_SEQ_NBR
Numeric 4AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-EAM-WO-NBR
EAM_WO_NBR
Numeric 8AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-PATIENT-LNAME
PATIENT_LNAME
Alpha 30 (Lower Case)This is the patient last name, used for item tracking purposes.
PLI-PATIENT-FNAME
PATIENT_FNAME
Alpha 15 (Lower Case)This is the patient first name, used for item tracking purposes.
PLI-PATIENT-MINIT
PATIENT_MINIT
Alpha 1This is the patient middle initial, used for item tracking purposes.
PLI-PAT-VISIT-NBR
PAT_VISIT_NBR
Alpha 12This is the patient visit number, used for item tracking purposes.
PLI-SERIAL
SERIAL
Alpha 16
PLI-CREATED-BY
CREATED_BY
Alpha 10POIJ.1
PLI-LAST-UPDATE-BY
LAST_UPDATE_BY
Alpha 10AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLI-LAST-UPDT-DATE
LAST_UPDT_DATE
Numeric 8 (yyyymmdd)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLI-LAST-UPDT-TIME
LAST_UPDT_TIME
Numeric 8AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLI-RETURN-QTY
RETURN_QTY
Signed 13.4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLI-HPP-OBJ-ID
HPP_OBJ_ID
Numeric 12AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-CN-CODE
CN_CODE
Alpha 2AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)
PLI-GLBL-LINE-TYPE
GLBL_LINE_TYPE
Alpha 15AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source)

Indexes (15)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PLISET1COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBRPrimaryAM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source)
PLISET10COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LOCATION, MATCH-DTL-KEY, LINE-NBRKeyChangeAM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source)
PLISET11COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, MATCH-DTL-KEY, LINE-NBRKeyChangeAM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source)
PLISET12PO-OBJ-ID, LINE-NBRKeyChange, SubsetWhere PO-OBJ-ID != SpacesIC145, IC44.1, IC45.1, WHD2.1
PLISET13COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, AGREEMENT-REF, ITEM, VEN-ITEM, ENT-BUY-UOM, LINE-NBRKeyChange, SubsetWhere AGREEMENT-REF != Spaces And RELEASED-FL = "N"AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PLISET14COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, MANUF-NBR, LINE-NBRKeyChangePO24.1, PO30.1
PLISET15COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, VEN-ITEM, LINE-NBRKeyChangeMA41.1, MA43.1, MA43.4, MA44.1, MA44.2, MA540, PO30.1
PLISET2PROCURE-GROUP, AGREEMENT-REF, COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBRKeyChange, SubsetWhere AGREEMENT-REF != Spaces And RELEASED-FL = "Y"AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source)
PLISET3COMPANY, LOCATION, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBRKeyChange, SubsetWhere (ITEM-TYPE != "S")AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source)
PLISET4COMPANY, BUYER-CODE, EARLY-DL-DATE, LOCATION, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBRKeyChangeAM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source)
PLISET5COMPANY, LOCATION, EARLY-DL-DATE, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBRKeyChangeAM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source)
PLISET6COMPANY, ITEM, LOCATION, EARLY-DL-DATE*, PO-NUMBER*, PO-RELEASE*, PO-CODE, LINE-NBR*KeyChangeAM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source)
PLISET7COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, ITEM, LINE-NBRKeyChangeAM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source)
PLISET8COMPANY, LOCATION, VENDOR, EARLY-DL-DATE, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBRKeyChange, SubsetWhere (ITEM-TYPE != "S")AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source)
PLISET9COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBRKeyChange, SubsetWhere (ITEM-TYPE != "S")AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source)

Relations

One to one (32) — lookups and parents

RelationTableRulesConditionField map
AmpoasthdrAMPOASTHDRNot RequiredPLI-COMPANYAOH-COMPANY, PLI-PO-NUMBERAOH-PO-NUMBER, PLI-PO-RELEASEAOH-PO-RELEASE, PLI-PO-CODEAOH-PO-CODE, PLI-LINE-NBRAOH-LINE-NBR
AmpodfltsAMPODFLTSNot RequiredPLI-COMPANYAOT-COMPANY, PLI-PO-NUMBERAOT-PO-NUMBER, PLI-PO-RELEASEAOT-PO-RELEASE, PLI-PO-CODEAOT-PO-CODE, PLI-LINE-NBRAOT-LINE-NBR
ApcompanyAPCOMPANYRequiredPLI-COMPANYCPY-COMPANY
ApvenmastAPVENMASTRequiredCPY-VENDOR-GROUPVEN-VENDOR-GROUP, PLI-VENDORVEN-VENDOR
BuyerBUYERRequiredPCY-PROCURE-GROUPBUY-PROCURE-GROUP, PLI-BUYER-CODEBUY-BUYER-CODE
CommcodesCOMMCODESNot RequiredITE-ITEM-GROUPISC-ITEM-GROUP, PLI-COMMODITY-CODEISC-COMMODITY-CODE
Has Vend ItemPOLINERequiredWhen PLI-VEN-ITEM != SpacesPLI-COMPANYPLI-COMPANY, PLI-PO-NUMBERPLI-PO-NUMBER, PLI-PO-RELEASEPLI-PO-RELEASE, PLI-PO-CODEPLI-PO-CODE, PLI-LINE-NBRPLI-LINE-NBR
HcpatprocHCPATPROCNot RequiredPLI-HPP-OBJ-IDHPP-OBJ-ID
IccategoryICCATEGORYRequiredWhen (PLI-ITEM-TYPE = "I")PLI-COMPANYICA-COMPANY, PLI-LOCATIONICA-LOCATION, ITL-GL-CATEGORYICA-GL-CATEGORY
IccompanyICCOMPANYRequiredPLI-COMPANYICC-COMPANY
IclocationICLOCATIONRequiredPLI-COMPANYICL-COMPANY, PLI-LOCATIONICL-LOCATION
IcmanfcodeICMANFCODERequiredWhen PLI-MANUF-CODE != SpacesITE-ITEM-GROUPIMC-ITEM-GROUP, PLI-MANUF-CODEIMC-MANUF-CODE, PLI-MANUF-DIVISIONIMC-MANUF-DIVISION
ItemlocITEMLOCRequiredPLI-COMPANYITL-COMPANY, PLI-LOCATIONITL-LOCATION, PLI-ITEMITL-ITEM
ItemmastITEMMASTRequiredWhen PLI-ITEM-TYPE = "I" Or PLI-ITEM-TYPE = "N"ICC-ITEM-GROUPITE-ITEM-GROUP, PLI-ITEMITE-ITEM
MacompanyMACOMPANYRequiredPLI-COMPANYMAY-COMPANY
Major ClassMAJORCLRequiredWhen PLI-PURCH-MAJCL != SpacesICC-ITEM-GROUPMAJ-ITEM-GROUP, "P"MAJ-CLASS-TYPE, PLI-PURCH-MAJCLMAJ-MAJOR-CLASS
Minor ClassMINORCLRequiredWhen PLI-PURCH-MINCL != SpacesICC-ITEM-GROUPMIN-ITEM-GROUP, "P"MIN-CLASS-TYPE, PLI-PURCH-MAJCLMIN-MAJOR-CLASS, PLI-PURCH-MINCLMIN-MINOR-CLASS
MmuavalMMUAVALNot RequiredPLI-COMPANYMUA-COMPANY, "PO"MUA-SYSTEM-CD, PLI-LOCATIONMUA-LOCATION, "PT"MUA-DOC-TYPE, PLI-PO-NUMBERMUA-DOC-NUMBER, PLI-PO-RELEASEMUA-DOC-NBR-NUM, PLI-PO-CODEMUA-PO-CODE, PLI-LINE-NBRMUA-LINE-NBR, ZeroesMUA-API-OBJ-ID, ZeroesMUA-SEQ-NBR
PocompanyPOCOMPANYRequiredPLI-COMPANYPCY-COMPANY
PocontractPOCONTRACTRequiredWhen PLI-CM-CONTRACT != ZeroesPLI-CONTRACT-GROUPCMH-CONTRACT-GROUP, PLI-CM-CONTRACTCMH-CM-CONTRACT
PocontrgrpPOCONTGRPRequiredWhen PLI-CM-CONTRACT != ZeroesPLI-CONTRACT-GROUPCNG-CONTRACT-GROUP
PoitemvenPOITEMVENRequiredPLI-PROCURE-GROUPPIV-PROCURE-GROUP, PLI-ITEMPIV-ITEM, PLI-VENDORPIV-VENDOR, PLI-VEN-ITEMPIV-VEN-ITEM
PopliufPOPLIUFNot RequiredPLI-COMPANYUFN-COMPANY, PLI-PO-NUMBERUFN-PO-NUMBER, PLI-PO-RELEASEUFN-PO-RELEASE, PLI-PO-CODEUFN-PO-CODE, PLI-LINE-NBRUFN-LINE-NBR
PovagrmtlnPOVAGRMTLNNot RequiredPLI-PVN-OBJ-IDPVN-PVN-OBJ-ID
PovapartlnPOVAPARTLNNot RequiredPLI-PROCURE-GROUPTPL-PROCURE-GROUP, PLI-AGREEMENT-REFTPL-VEN-AGRMT-REF, PLI-PVN-OBJ-IDTPL-PVN-OBJ-ID, PLI-PART-SEQ-NBRTPL-PART-SEQ-NBR
PovendorPOVENDORNot RequiredCPY-VENDOR-GROUPPOV-VENDOR-GROUP, PLI-VENDORPOV-VENDOR
PurchorderPURCHORDERRequiredPLI-COMPANYPCR-COMPANY, PLI-PO-CODEPCR-PO-CODE, PLI-PO-NUMBERPCR-PO-NUMBER, PLI-PO-RELEASEPCR-PO-RELEASE
Repl Po ReturnPORETURNLNRequiredPLI-COMPANYPTL-COMPANY, PCR-RETURN-NUMBERPTL-RETURN-NUMBER, PLI-RET-LINE-NBRPTL-RET-LINE-NBR
Return HeaderPORETURNHDNot RequiredValid When PCR-RETURN-NUMBER != ZeroesPLI-COMPANYPTH-COMPANY, PCR-RETURN-NUMBERPTH-RETURN-NUMBER
VendorAPVENMASTNot RequiredCPY-VENDOR-GROUPVEN-VENDOR-GROUP, PLI-VENDORVEN-VENDOR
VendorlocationAPVENLOCRequiredWhen PLI-PURCH-FR-LOC != SpacesCPY-VENDOR-GROUPVLO-VENDOR-GROUP, PLI-VENDORVLO-VENDOR, PLI-PURCH-FR-LOCVLO-LOCATION-CODE
WhdemandWHDEMANDNot RequiredValid When PLI-PO-OBJ-ID != SpacesPLI-COMPANYWDM-COMPANY, PLI-LOCATIONWDM-LOCATION, "PO"WDM-SYSTEM-CD, PLI-PO-OBJ-IDWDM-DOC-NBR, PLI-LINE-NBRWDM-LINE-NBR, ZeroesWDM-COMPONENT-SEQ

One to many (24) — child tables

RelationTableRulesConditionField map
AmpoastdtlAMPOASTDTLPLI-COMPANYAOD-COMPANY, PLI-PO-NUMBERAOD-PO-NUMBER, PLI-PO-RELEASEAOD-PO-RELEASE, PLI-PO-CODEAOD-PO-CODE, PLI-LINE-NBRAOD-LINE-NBR, AOD-DTL-SEQ-NBR
ApdistpayAPDISTPAYPLI-COMPANYDTY-COMPANY, PLI-PO-NUMBERDTY-PO-NUMBER, PLI-PO-RELEASEDTY-PO-RELEASE, PLI-PO-CODEDTY-PO-CODE, PLI-LINE-NBRDTY-LINE-NBR, DTY-MAD-SEQ-NBR, DTY-VENDOR, DTY-INVOICE, DTY-SUFFIX, DTY-PMT-SEQ-NBR, DTY-DIST-SEQ-NBR
ApinvoiceAPINVOICEPLI-COMPANYAPI-COMPANY, PLI-VENDORAPI-VENDOR, PLI-PO-NUMBERAPI-PO-NUMBER, PLI-PO-RELEASEAPI-PO-RELEASE, PLI-PO-CODEAPI-PO-CODE, API-LOCATION, API-INVOICE, API-SUFFIX, API-CANCEL-SEQ
ApvendivAPVENDIVCPY-VENDOR-GROUPVDC-VENDOR-GROUP, PLI-VENDORVDC-VENDOR, VDC-LOCATION-CODE, VDC-DIVERSE-CODE, VDC-DCERT-DATE
Has ReturnPORETURNLNPLI-COMPANYPTL-COMPANY, PTL-RETURN-NUMBER, PTL-RET-LINE-NBR
IpovagrmtlnPOVAGRMTLNPLI-PROCURE-GROUPPVN-PROCURE-GROUP, PLI-ITEMPVN-ITEM, PVN-VEN-AGRMT-REF, PVN-LINE-NBR
MaaocdtlMAAOCDTLPLI-COMPANYMAA-COMPANY, PLI-PO-NUMBERMAA-PO-NUMBER, PLI-PO-RELEASEMAA-PO-RELEASE, PLI-PO-CODEMAA-PO-CODE, PLI-LINE-NBRMAA-LINE-NBR, PLI-VENDORMAA-VENDOR, MAA-INVOICE, MAA-SUFFIX, MAA-AOC-CODE, MAA-SEQ-NBR
MainvdtlMAINVDTLPLI-COMPANYMAD-COMPANY, PLI-PO-NUMBERMAD-PO-NUMBER, PLI-PO-RELEASEMAD-PO-RELEASE, PLI-PO-CODEMAD-PO-CODE, PLI-LINE-NBRMAD-LINE-NBR, PLI-VENDORMAD-VENDOR, MAD-INVOICE, MAD-SUFFIX, MAD-SEQ-NBR
MamaahistMAMAAHISTPLI-COMPANYMMH-COMPANY, PLI-PO-NUMBERMMH-PO-NUMBER, PLI-PO-RELEASEMMH-PO-RELEASE, PLI-PO-CODEMMH-PO-CODE, PLI-LINE-NBRMMH-LINE-NBR, PLI-VENDORMMH-VENDOR, MMH-INVOICE, MMH-SUFFIX, MMH-AOC-CODE, MMH-SEQ-NBR
MamadhistMAMADHISTPLI-COMPANYMH1-COMPANY, PLI-PO-NUMBERMH1-PO-NUMBER, PLI-PO-RELEASEMH1-PO-RELEASE, PLI-PO-CODEMH1-PO-CODE, PLI-LINE-NBRMH1-LINE-NBR, PLI-VENDORMH1-VENDOR, MH1-INVOICE, MH1-SUFFIX, MH1-AOC-CODE, MH1-SEQ-NBR
MmdistMMDISTValid When PLI-ITEM-TYPE != "I"PLI-COMPANYMMD-COMPANY, "PO"MMD-SYSTEM-CD, PLI-LOCATIONMMD-LOCATION, "PT"MMD-DOC-TYPE, PLI-PO-NUMBERMMD-DOC-NUMBER, PLI-PO-RELEASEMMD-DOC-NBR-NUM, PLI-PO-CODEMMD-PO-CODE, PLI-LINE-NBRMMD-LINE-NBR, ZeroesMMD-COMPONENT-SEQ, SpacesMMD-AOC-CODE, MMD-LINE-SEQ, MMD-REQ-LOCATION, MMD-API-OBJ-ID
Pliset6POLINEPLI-COMPANYPLI-COMPANY, PLI-ITEMPLI-ITEM, PLI-LOCATIONPLI-LOCATION, PLI-EARLY-DL-DATE, PLI-PO-NUMBER, PLI-PO-RELEASE, PLI-PO-CODE, PLI-LINE-NBR
PoaocdtlPOAOCDTLPLI-COMPANYPAO-COMPANY, SpacesPAO-PROCURE-GROUP, SpacesPAO-VEN-AGRMT-REF, PLI-PO-NUMBERPAO-PO-NUMBER, PLI-PO-RELEASEPAO-PO-RELEASE, PLI-PO-CODEPAO-PO-CODE, PLI-LINE-NBRPAO-LINE-NBR, PAO-AOC-CODE
Poapr By DateMAINVDTLPLI-COMPANYMAD-COMPANY, PLI-PO-NUMBERMAD-PO-NUMBER, PLI-PO-RELEASEMAD-PO-RELEASE, PLI-PO-CODEMAD-PO-CODE, PLI-LINE-NBRMAD-LINE-NBR, MAD-UPDATE-DATE, MAD-UPDATE-TIME, MAD-VENDOR, MAD-INVOICE, MAD-SUFFIX, MAD-SEQ-NBR
Poapr By Dte2MAINVDTLPLI-COMPANYMAD-COMPANY, PLI-PO-NUMBERMAD-PO-NUMBER, PLI-PO-RELEASEMAD-PO-RELEASE, PLI-PO-CODEMAD-PO-CODE, PLI-LINE-NBRMAD-LINE-NBR, MAD-UPDATE-DATE, MAD-UPDATE-TIME, MAD-VENDOR, MAD-INVOICE, MAD-SUFFIX, MAD-SEQ-NBR
PoauditPOAUDITPLI-COMPANYPAU-COMPANY, PLI-PO-NUMBERPAU-PO-NUMBER, PLI-PO-RELEASEPAU-PO-RELEASE, PLI-PO-CODEPAU-PO-CODE, PLI-LINE-NBRPAU-PO-LINE-NBR, PAU-PO-REVISION, PAU-AOC-CODE, PAU-LINE-SEQ, PAU-UPDATE-DATE, PAU-UPDATE-TIME, PAU-FLD-NBR, PAU-AUDIT-TYPE, PAU-AUDIT-ACTION
PolinesrcPOLINESRCPLI-COMPANYPLS-COMPANY, PLI-PO-CODEPLS-PO-CODE, PLI-PO-NUMBERPLS-PO-NUMBER, PLI-PO-RELEASEPLS-PO-RELEASE, PLI-LINE-NBRPLS-LINE-NBR, PLS-ORIGIN-CD, PLS-OPER-COMPANY, PLS-SOURCE-DOC-N, PLS-SOURCE-DOC-A, PLS-SRC-LINE-NBR
PomatchobjPOMATCHOBJPLI-COMPANYPMJ-COMPANY, PLI-PO-NUMBERPMJ-PO-NUMBER, PLI-PO-RELEASEPMJ-PO-RELEASE, PLI-PO-CODEPMJ-PO-CODE, PLI-LINE-NBRPMJ-LINE-NBR, PMJ-TRAN-DATE, PMJ-TRAN-TIME, PMJ-MATCH-OBJ-ID, PMJ-MATCH-SEQ-NBR, PMJ-TYPE
Porec By DatePORECLINEPLI-COMPANYPRL-COMPANY, PLI-PO-CODEPRL-PO-CODE, PLI-PO-NUMBERPRL-PO-NUMBER, PLI-PO-RELEASEPRL-PO-RELEASE, PLI-LINE-NBRPRL-PO-LINE-NBR, PRL-UPDATE-DATE, PRL-UPDATE-TIME, PRL-REC-NUMBER, PRL-LINE-NBR
PorecadjlnPORECADJLNPLI-COMPANYPJL-COMPANY, PLI-PO-NUMBERPJL-PO-NUMBER, PLI-PO-RELEASEPJL-PO-RELEASE, PLI-PO-CODEPJL-PO-CODE, PLI-LINE-NBRPJL-PO-LINE-NBR, PJL-DATE, PJL-DOC-TYPE, PJL-DOC-NBR-NUM, PJL-LINE-NBR
PoreclinePORECLINEPLI-COMPANYPRL-COMPANY, PLI-PO-CODEPRL-PO-CODE, PLI-PO-NUMBERPRL-PO-NUMBER, PLI-PO-RELEASEPRL-PO-RELEASE, PLI-LOCATIONPRL-LOCATION, PLI-MATCH-DTL-KEYPRL-MATCH-DTL-KEY, PLI-LINE-NBRPRL-PO-LINE-NBR, PRL-REC-NUMBER, PRL-LINE-NBR
Return LinePORETURNLNPLI-COMPANYPTL-COMPANY, PLI-PO-NUMBERPTL-ORIG-PO-NBR, PLI-PO-RELEASEPTL-ORIG-PO-REL, PLI-PO-CODEPTL-ORIG-PO-CODE, PLI-LINE-NBRPTL-ORIG-PO-LN-NBR, PTL-RETURN-NUMBER, PTL-RET-LINE-NBR
TxtaxrateTXTAXRATEPLI-TAX-CODETXR-TAX-CODE, TXR-PROD-TAX-CAT, TXR-EFFECT-DATE
VpovagrmtlnPOVAGRMTLNPLI-PROCURE-GROUPPVN-PROCURE-GROUP, PLI-VEN-ITEMPVN-VEN-ITEM, PVN-VEN-AGRMT-REF, PVN-LINE-NBR

Programs

Updated by (246)

Referenced by (92)