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 / column | Type | Description & values | Updated by |
|---|---|---|---|
PLI-COMPANY PKCOMPANY | Numeric 4 | The 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 PKPO_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 PKPO_RELEASE | Numeric 4 | Used 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 PKPO_CODE | Alpha 4 | This 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 PKLINE_NBR | Numeric 6 | This 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-ITEMITEM | Alpha 32 | This 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-TYPEITEM_TYPE | Alpha 1 | Identifies 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.
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-SERVICE-CODESERVICE_CODE | Alpha 1 | " " = Non Service Item
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-DESCRIPTIONDESCRIPTION | 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-GROUPPROCURE_GROUP | Alpha 4 | This 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-IDPO_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-QUANTITYQUANTITY | Signed 13.4 | The 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-QUANTITYVPRI_QUANTITY | Signed 13.4 | The 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-QTYREC_QTY | Signed 13.4 | This 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-QTYCATCH_WT_QTY | Signed 13.4 | This 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-REFAGREEMENT_REF | Alpha 30 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-AGRMT-REF-AMTAGRMT_REF_AMT | Signed 18.2 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-LST-MATCH-UCSTLST_MATCH_UCST | Signed 18.5 | This 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-QTYMATCHED_QTY | Signed 13.4 | This 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-AMOUNTMATCHED_AMOUNT | Signed 18.5 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-SUBST-QTYSUBST_QTY | Signed 13.4 | This 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-QTYREJECT_QTY | Signed 13.4 | This 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-CSTENT_UNIT_CST | Signed 18.5 | The 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-CSTVBUY_UNIT_CST | Signed 18.5 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-TAXBL-UNT-CSTTAXBL_UNT_CST | Signed 18.5 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-COST-CDCOST_CD | Alpha 1 | Unit cost origin code. For conversion: Nonfatal Error - If not equal to E, L, S, Q, then set to E (the default).
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-ENT-BUY-UOMENT_BUY_UOM | Alpha 4 | Entered 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-MULTEBUY_UOM_MULT | Signed 13.7 | Entered 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-UOMVPRI_UOM | Alpha 4 | This 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-MULTVPRI_UOM_MULT | Signed 13.7 | This 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-CSTLAND_UNIT_CST | Signed 18.5 | Landed 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-DATEEARLY_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-DATELATE_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-DATEREC_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-DATECLOSE_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-LOCATIONLOCATION | Alpha 5 | This 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-CODEBUYER_CODE | Alpha 3 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-VENDORVENDOR | 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-LOCPURCH_FR_LOC | Alpha 4 | The vendor's purchase from location. | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-VEN-ITEMVEN_ITEM | Alpha 32 | This field contains the item identifier. | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-DIST-CODEDIST_CODE | Alpha 9 | A 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-CODETAX_CODE | Alpha 10 | This 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-WEIGHTWEIGHT | Signed 9.3 | This 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-FEETCUBIC_FEET | Signed 9.3 | This 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-FLREC_PRT_FL | Alpha 1 | Indicates 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.
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-COST-OPTIONCOST_OPTION | Alpha 1 | —
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-CERT-REQ-FLCERT_REQ_FL | Alpha 1 | This 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).
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-REC-INSP-FLREC_INSP_FL | Alpha 1 | Defines 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).
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-INSP-REQ-FLINSP_REQ_FL | Alpha 1 | Defines 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).
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-MSDS-FLAGMSDS_FLAG | Alpha 1 | —
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-NO-LT-CALC-FLNO_LT_CALC_FL | Alpha 1 | Determines 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).
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-TAXABLE-FLAGTAXABLE_FLAG | Alpha 1 | Defines 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.
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-OSHIP-TOL-PCTOSHIP_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-PCTUSHIP_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-3USER_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-4USER_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-MAJCLPURCH_MAJCL | Alpha 4 | The 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-MINCLPURCH_MINCL | Alpha 4 | The 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-CODEMANUF_CODE | Alpha 4 | This 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-DIVISIONMANUF_DIVISION | Alpha 4 | This 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-NBRMANUF_NBR | Alpha 35 | This 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-SEQLAST_DST_SEQ | Numeric 3 | Sequence 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-LINELAST_SRC_LINE | Numeric 4 | This 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-FLRELEASED_FL | Alpha 1 | Released Flag. Record is now available for further processing in the system.
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-ISSUED-FLAGISSUED_FLAG | Alpha 1 | This 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.
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-REVISED-FLREVISED_FL | Alpha 1 | This 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.
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-CLOSED-FLCLOSED_FL | Alpha 1 | The closed flag. For conversion: Default - If the purchase order line close criteria is met, then set to Y. Otherwise set to N.
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-ZERO-OSHIP-FLZERO_OSHIP_FL | Alpha 1 | The 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.
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-ZERO-USHIP-FLZERO_USHIP_FL | Alpha 1 | Set 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.
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-EXCL-AOC-SPRDEXCL_AOC_SPRD | Alpha 1 | Exclude this line item from the add-on cost spread methods.
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-PO-USER-FLD-2PO_USER_FLD_2 | Alpha 2 | Purchase 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-4PO_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-6PO_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-CLASSMATCH_CLASS | Alpha 10 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-MATCH-DTL-KEYMATCH_DTL_KEY | Alpha 85 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-ARCHIVE-QTYARCHIVE_QTY | Signed 13.4 | This 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-RECMATCHED_NO_REC | Signed 13.4 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-CHARGEBACK-QTYCHARGEBACK_QTY | Signed 13.4 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-WRITE-OFF-QTYWRITE_OFF_QTY | Signed 13.4 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-RET-LINE-NBRRET_LINE_NBR | Numeric 6 | This 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-CDTAX_USAGE_CD | Alpha 10 | The 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-AMTEXTENDED_AMT | Signed 18.2 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-CXL-QTYCXL_QTY | Signed 13.4 | The 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-PROCQTY_TO_PROC | Signed 13.4 | This 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-PRVPRI_QTY_TO_PR | Signed 13.4 | This 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-AMTINVC_TAX_AMT | Signed 18.2 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-ACCR-TAX-AMTACCR_TAX_AMT | Signed 18.2 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-EXT-TAXBL-AMTEXT_TAXBL_AMT | Signed 18.2 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-OPEN-PO-AMTOPEN_PO_AMT | Signed 18.2 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-ICN-CODEICN_CODE | Alpha 8 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-SUPLMNTARY-QTYSUPLMNTARY_QTY | Signed 13.4 | This field contains the desired quantity. | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-RQSRC-MACHINERQSRC_MACHINE | Alpha 6 | DROYAL ESIOB HBOC OMNICL PAREXC PERSE PYXIS INTER | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-PAR-ORDER-IDPAR_ORDER_ID | Alpha 20 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-PUNCHOUT-IDPUNCHOUT_ID | Alpha 64 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-FREIGHT-TERMSFREIGHT_TERMS | Alpha 1 | Freight terms are used to define who pays for freight costs incurred when goods are shipped. Prepaid, for instance, would normally mean that the vendor would pay for freight. Collect would mean the customer would pay for freight. A freight terms code can be entered on a purchase order, or defaulted by vendor or company. | — |
PLI-FOB-CODEFOB_CODE | Alpha 3 | The user defined Free On Board Code. | — |
PLI-TERM-CODETERM_CODE | Alpha 5 | A user-defined code representing a method of determining invoice due and discount dates. | — |
PLI-CATCH-WGT-COSTCATCH_WGT_COST | Signed 18.5 | — | — |
PLI-PREV-RELEASEDPREV_RELEASED | Numeric 1 | —
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-OPEN-PO-TRANOPEN_PO_TRAN | Signed 18.2 | The portion of the total or extended ordered amount that is still open -- that is, it has not been cancelled or paid. This is expressed in the Purchase Order currency, and includes only product costs (add on costs and taxes are not included). | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-SS-EVENT-NBRSS_EVENT_NBR | Numeric 8 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-COMMODITY-CODECOMMODITY_CODE | Alpha 35 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-P-CARD-FLAGP_CARD_FLAG | Numeric 1 | —
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-CHARGE-QTYCHARGE_QTY | Signed 13.4 | This 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-QTYCHG_NO_REC_QTY | Signed 13.4 | This 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-QTYCHRG_APPRV_QTY | Signed 13.4 | This 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-QTYCHRG_DISPT_QTY | Signed 13.4 | This field contains the desired quantity. | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-CONTRACT-GROUPCONTRACT_GROUP | Alpha 4 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-CM-CONTRACTCM_CONTRACT | Numeric 15 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-TIERTIER | Alpha 4 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-PREFERRED-FLAGPREFERRED_FLAG | Numeric 1 | —
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-ORIG-LINE-NBRORIG_LINE_NBR | Numeric 6 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-PCLASS-MAJMINPCLASS_MAJMIN | Derived | This field is a combination of purchase major and minor class used for transaction analysis. | — |
PLI-MF-CODE-DIVMF_CODE_DIV | Derived | This field is a combination of manufacturer's code and division used for transaction analysis. | — |
PLI-REMAININGREMAINING | Derived | — | — |
PLI-PO-PRINTED-FLPO_PRINTED_FL | Derived | — | — |
PLI-PO-RELEASED-FLPO_RELEASED_FL | Derived | — | — |
PLI-PO-CNCLED-FLPO_CNCLED_FL | Derived | — | — |
PLI-PO-CLOSED-FLPO_CLOSED_FL | Derived | — | — |
PLI-PO-DROP-SHIPPO_DROP_SHIP | Derived | — | — |
PLI-ICL-LOC-PO-NMICL_LOC_PO_NM | Derived | — | — |
PLI-PURCH-FR-NAMEPURCH_FR_NAME | Derived | — | — |
PLI-ITEM-DESC-1ITEM_DESC_1 | Derived | — | — |
PLI-ITEM-DESC-2ITEM_DESC_2 | Derived | — | — |
PLI-PO-GL-CATEGORYPO_GL_CATEGORY | Derived | — | — |
PLI-APPR-AND-REJAPPR_AND_REJ | Derived | — | — |
PLI-DISP-PO-REL-CDDISP_PO_REL_CD | Derived | — | — |
PLI-DISP-PO-RELDISP_PO_REL | Derived | — | — |
PLI-DISP-DOC-NBRDISP_DOC_NBR | Derived | — | — |
PLI-RETAINAGERETAINAGE | Numeric 1 | —
| AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-RET-PCT-1RET_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-2RET_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-PCTRET_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-COMPRET_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-PCTRET_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-AMTCHARGEBACK_AMT | Signed 18.2 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-PVN-OBJ-IDPVN_OBJ_ID | Numeric 12 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-PART-SEQ-NBRPART_SEQ_NBR | Numeric 6 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-MFG-CONTRACTMFG_CONTRACT | Numeric 15 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-ICSEGMENTICSEGMENT | Alpha 2 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-ICFAMILYICFAMILY | Alpha 2 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-ICCLASSICCLASS | Alpha 2 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-ICCOMMODITYICCOMMODITY | Alpha 2 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-MEMO-QTYMEMO_QTY | Signed 13.4 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-PROD-TAX-CATPROD_TAX_CAT | Alpha 15 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-SERV-CXL-AMTSERV_CXL_AMT | Signed 18.5 | For 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-AMTMEMO_AMT | Signed 18.2 | — | — |
PLI-GTINGTIN | Numeric 14 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-PO-USER-FLD-7PO_USER_FLD_7 | Alpha 10 (Lower Case) | — | — |
PLI-EAM-OPER-NBREAM_OPER_NBR | Numeric 4 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-EAM-SEQ-NBREAM_SEQ_NBR | Numeric 4 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-EAM-WO-NBREAM_WO_NBR | Numeric 8 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-PATIENT-LNAMEPATIENT_LNAME | Alpha 30 (Lower Case) | This is the patient last name, used for item tracking purposes. | — |
PLI-PATIENT-FNAMEPATIENT_FNAME | Alpha 15 (Lower Case) | This is the patient first name, used for item tracking purposes. | — |
PLI-PATIENT-MINITPATIENT_MINIT | Alpha 1 | This is the patient middle initial, used for item tracking purposes. | — |
PLI-PAT-VISIT-NBRPAT_VISIT_NBR | Alpha 12 | This is the patient visit number, used for item tracking purposes. | — |
PLI-SERIALSERIAL | Alpha 16 | — | — |
PLI-CREATED-BYCREATED_BY | Alpha 10 | — | POIJ.1 |
PLI-LAST-UPDATE-BYLAST_UPDATE_BY | Alpha 10 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PLI-LAST-UPDT-DATELAST_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-TIMELAST_UPDT_TIME | Numeric 8 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PLI-RETURN-QTYRETURN_QTY | Signed 13.4 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PLI-HPP-OBJ-IDHPP_OBJ_ID | Numeric 12 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-CN-CODECN_CODE | Alpha 2 | — | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +52 more (list truncated in source) |
PLI-GLBL-LINE-TYPEGLBL_LINE_TYPE | Alpha 15 | — | AM17.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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PLISET1 | COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR | Primary | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source) | |
PLISET10 | COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LOCATION, MATCH-DTL-KEY, LINE-NBR | KeyChange | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source) | |
PLISET11 | COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, MATCH-DTL-KEY, LINE-NBR | KeyChange | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source) | |
PLISET12 | PO-OBJ-ID, LINE-NBR | KeyChange, Subset | Where PO-OBJ-ID != Spaces | IC145, IC44.1, IC45.1, WHD2.1 |
PLISET13 | COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, AGREEMENT-REF, ITEM, VEN-ITEM, ENT-BUY-UOM, LINE-NBR | KeyChange, Subset | Where 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) |
PLISET14 | COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, MANUF-NBR, LINE-NBR | KeyChange | PO24.1, PO30.1 | |
PLISET15 | COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, VEN-ITEM, LINE-NBR | KeyChange | MA41.1, MA43.1, MA43.4, MA44.1, MA44.2, MA540, PO30.1 | |
PLISET2 | PROCURE-GROUP, AGREEMENT-REF, COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR | KeyChange, Subset | Where AGREEMENT-REF != Spaces And RELEASED-FL = "Y" | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source) |
PLISET3 | COMPANY, LOCATION, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR | KeyChange, Subset | Where (ITEM-TYPE != "S") | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source) |
PLISET4 | COMPANY, BUYER-CODE, EARLY-DL-DATE, LOCATION, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR | KeyChange | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source) | |
PLISET5 | COMPANY, LOCATION, EARLY-DL-DATE, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR | KeyChange | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source) | |
PLISET6 | COMPANY, ITEM, LOCATION, EARLY-DL-DATE*, PO-NUMBER*, PO-RELEASE*, PO-CODE, LINE-NBR* | KeyChange | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source) | |
PLISET7 | COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, ITEM, LINE-NBR | KeyChange | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source) | |
PLISET8 | COMPANY, LOCATION, VENDOR, EARLY-DL-DATE, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR | KeyChange, Subset | Where (ITEM-TYPE != "S") | AM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source) |
PLISET9 | COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR | KeyChange, Subset | Where (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
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Ampoasthdr | AMPOASTHDR | Not Required | PLI-COMPANY → AOH-COMPANY, PLI-PO-NUMBER → AOH-PO-NUMBER, PLI-PO-RELEASE → AOH-PO-RELEASE, PLI-PO-CODE → AOH-PO-CODE, PLI-LINE-NBR → AOH-LINE-NBR | |
| Ampodflts | AMPODFLTS | Not Required | PLI-COMPANY → AOT-COMPANY, PLI-PO-NUMBER → AOT-PO-NUMBER, PLI-PO-RELEASE → AOT-PO-RELEASE, PLI-PO-CODE → AOT-PO-CODE, PLI-LINE-NBR → AOT-LINE-NBR | |
| Apcompany | APCOMPANY | Required | PLI-COMPANY → CPY-COMPANY | |
| Apvenmast | APVENMAST | Required | CPY-VENDOR-GROUP → VEN-VENDOR-GROUP, PLI-VENDOR → VEN-VENDOR | |
| Buyer | BUYER | Required | PCY-PROCURE-GROUP → BUY-PROCURE-GROUP, PLI-BUYER-CODE → BUY-BUYER-CODE | |
| Commcodes | COMMCODES | Not Required | ITE-ITEM-GROUP → ISC-ITEM-GROUP, PLI-COMMODITY-CODE → ISC-COMMODITY-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 |
| Hcpatproc | HCPATPROC | Not Required | PLI-HPP-OBJ-ID → HPP-OBJ-ID | |
| Iccategory | ICCATEGORY | Required | When (PLI-ITEM-TYPE = "I") | PLI-COMPANY → ICA-COMPANY, PLI-LOCATION → ICA-LOCATION, ITL-GL-CATEGORY → ICA-GL-CATEGORY |
| Iccompany | ICCOMPANY | Required | PLI-COMPANY → ICC-COMPANY | |
| Iclocation | ICLOCATION | Required | PLI-COMPANY → ICL-COMPANY, PLI-LOCATION → ICL-LOCATION | |
| Icmanfcode | ICMANFCODE | Required | When PLI-MANUF-CODE != Spaces | ITE-ITEM-GROUP → IMC-ITEM-GROUP, PLI-MANUF-CODE → IMC-MANUF-CODE, PLI-MANUF-DIVISION → IMC-MANUF-DIVISION |
| Itemloc | ITEMLOC | Required | PLI-COMPANY → ITL-COMPANY, PLI-LOCATION → ITL-LOCATION, PLI-ITEM → ITL-ITEM | |
| Itemmast | ITEMMAST | Required | When PLI-ITEM-TYPE = "I" Or PLI-ITEM-TYPE = "N" | ICC-ITEM-GROUP → ITE-ITEM-GROUP, PLI-ITEM → ITE-ITEM |
| Macompany | MACOMPANY | Required | PLI-COMPANY → MAY-COMPANY | |
| Major Class | MAJORCL | Required | When PLI-PURCH-MAJCL != Spaces | ICC-ITEM-GROUP → MAJ-ITEM-GROUP, "P" → MAJ-CLASS-TYPE, PLI-PURCH-MAJCL → MAJ-MAJOR-CLASS |
| Minor Class | MINORCL | Required | When PLI-PURCH-MINCL != Spaces | ICC-ITEM-GROUP → MIN-ITEM-GROUP, "P" → MIN-CLASS-TYPE, PLI-PURCH-MAJCL → MIN-MAJOR-CLASS, PLI-PURCH-MINCL → MIN-MINOR-CLASS |
| Mmuaval | MMUAVAL | Not Required | PLI-COMPANY → MUA-COMPANY, "PO" → MUA-SYSTEM-CD, PLI-LOCATION → MUA-LOCATION, "PT" → MUA-DOC-TYPE, PLI-PO-NUMBER → MUA-DOC-NUMBER, PLI-PO-RELEASE → MUA-DOC-NBR-NUM, PLI-PO-CODE → MUA-PO-CODE, PLI-LINE-NBR → MUA-LINE-NBR, Zeroes → MUA-API-OBJ-ID, Zeroes → MUA-SEQ-NBR | |
| Pocompany | POCOMPANY | Required | PLI-COMPANY → PCY-COMPANY | |
| Pocontract | POCONTRACT | Required | When PLI-CM-CONTRACT != Zeroes | PLI-CONTRACT-GROUP → CMH-CONTRACT-GROUP, PLI-CM-CONTRACT → CMH-CM-CONTRACT |
| Pocontrgrp | POCONTGRP | Required | When PLI-CM-CONTRACT != Zeroes | PLI-CONTRACT-GROUP → CNG-CONTRACT-GROUP |
| Poitemven | POITEMVEN | Required | PLI-PROCURE-GROUP → PIV-PROCURE-GROUP, PLI-ITEM → PIV-ITEM, PLI-VENDOR → PIV-VENDOR, PLI-VEN-ITEM → PIV-VEN-ITEM | |
| 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 | |
| Povagrmtln | POVAGRMTLN | Not Required | PLI-PVN-OBJ-ID → PVN-PVN-OBJ-ID | |
| Povapartln | POVAPARTLN | Not Required | PLI-PROCURE-GROUP → TPL-PROCURE-GROUP, PLI-AGREEMENT-REF → TPL-VEN-AGRMT-REF, PLI-PVN-OBJ-ID → TPL-PVN-OBJ-ID, PLI-PART-SEQ-NBR → TPL-PART-SEQ-NBR | |
| Povendor | POVENDOR | Not Required | CPY-VENDOR-GROUP → POV-VENDOR-GROUP, PLI-VENDOR → POV-VENDOR | |
| Purchorder | PURCHORDER | Required | PLI-COMPANY → PCR-COMPANY, PLI-PO-CODE → PCR-PO-CODE, PLI-PO-NUMBER → PCR-PO-NUMBER, PLI-PO-RELEASE → PCR-PO-RELEASE | |
| Repl Po Return | PORETURNLN | Required | PLI-COMPANY → PTL-COMPANY, PCR-RETURN-NUMBER → PTL-RETURN-NUMBER, PLI-RET-LINE-NBR → PTL-RET-LINE-NBR | |
| Return Header | PORETURNHD | Not Required | Valid When PCR-RETURN-NUMBER != Zeroes | PLI-COMPANY → PTH-COMPANY, PCR-RETURN-NUMBER → PTH-RETURN-NUMBER |
| Vendor | APVENMAST | Not Required | CPY-VENDOR-GROUP → VEN-VENDOR-GROUP, PLI-VENDOR → VEN-VENDOR | |
| Vendorlocation | APVENLOC | Required | When PLI-PURCH-FR-LOC != Spaces | CPY-VENDOR-GROUP → VLO-VENDOR-GROUP, PLI-VENDOR → VLO-VENDOR, PLI-PURCH-FR-LOC → VLO-LOCATION-CODE |
| Whdemand | WHDEMAND | Not Required | Valid When PLI-PO-OBJ-ID != Spaces | PLI-COMPANY → WDM-COMPANY, PLI-LOCATION → WDM-LOCATION, "PO" → WDM-SYSTEM-CD, PLI-PO-OBJ-ID → WDM-DOC-NBR, PLI-LINE-NBR → WDM-LINE-NBR, Zeroes → WDM-COMPONENT-SEQ |
One to many (24) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Ampoastdtl | AMPOASTDTL | PLI-COMPANY → AOD-COMPANY, PLI-PO-NUMBER → AOD-PO-NUMBER, PLI-PO-RELEASE → AOD-PO-RELEASE, PLI-PO-CODE → AOD-PO-CODE, PLI-LINE-NBR → AOD-LINE-NBR, → AOD-DTL-SEQ-NBR | ||
| Apdistpay | APDISTPAY | PLI-COMPANY → DTY-COMPANY, PLI-PO-NUMBER → DTY-PO-NUMBER, PLI-PO-RELEASE → DTY-PO-RELEASE, PLI-PO-CODE → DTY-PO-CODE, PLI-LINE-NBR → DTY-LINE-NBR, → DTY-MAD-SEQ-NBR, → DTY-VENDOR, → DTY-INVOICE, → DTY-SUFFIX, → DTY-PMT-SEQ-NBR, → DTY-DIST-SEQ-NBR | ||
| 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 | ||
| Apvendiv | APVENDIV | CPY-VENDOR-GROUP → VDC-VENDOR-GROUP, PLI-VENDOR → VDC-VENDOR, → VDC-LOCATION-CODE, → VDC-DIVERSE-CODE, → VDC-DCERT-DATE | ||
| Has Return | PORETURNLN | PLI-COMPANY → PTL-COMPANY, → PTL-RETURN-NUMBER, → PTL-RET-LINE-NBR | ||
| Ipovagrmtln | POVAGRMTLN | PLI-PROCURE-GROUP → PVN-PROCURE-GROUP, PLI-ITEM → PVN-ITEM, → PVN-VEN-AGRMT-REF, → PVN-LINE-NBR | ||
| Maaocdtl | MAAOCDTL | PLI-COMPANY → MAA-COMPANY, PLI-PO-NUMBER → MAA-PO-NUMBER, PLI-PO-RELEASE → MAA-PO-RELEASE, PLI-PO-CODE → MAA-PO-CODE, PLI-LINE-NBR → MAA-LINE-NBR, PLI-VENDOR → MAA-VENDOR, → MAA-INVOICE, → MAA-SUFFIX, → MAA-AOC-CODE, → MAA-SEQ-NBR | ||
| Mainvdtl | MAINVDTL | PLI-COMPANY → MAD-COMPANY, PLI-PO-NUMBER → MAD-PO-NUMBER, PLI-PO-RELEASE → MAD-PO-RELEASE, PLI-PO-CODE → MAD-PO-CODE, PLI-LINE-NBR → MAD-LINE-NBR, PLI-VENDOR → MAD-VENDOR, → MAD-INVOICE, → MAD-SUFFIX, → MAD-SEQ-NBR | ||
| Mamaahist | MAMAAHIST | PLI-COMPANY → MMH-COMPANY, PLI-PO-NUMBER → MMH-PO-NUMBER, PLI-PO-RELEASE → MMH-PO-RELEASE, PLI-PO-CODE → MMH-PO-CODE, PLI-LINE-NBR → MMH-LINE-NBR, PLI-VENDOR → MMH-VENDOR, → MMH-INVOICE, → MMH-SUFFIX, → MMH-AOC-CODE, → MMH-SEQ-NBR | ||
| Mamadhist | MAMADHIST | PLI-COMPANY → MH1-COMPANY, PLI-PO-NUMBER → MH1-PO-NUMBER, PLI-PO-RELEASE → MH1-PO-RELEASE, PLI-PO-CODE → MH1-PO-CODE, PLI-LINE-NBR → MH1-LINE-NBR, PLI-VENDOR → MH1-VENDOR, → MH1-INVOICE, → MH1-SUFFIX, → MH1-AOC-CODE, → MH1-SEQ-NBR | ||
| Mmdist | MMDIST | Valid When PLI-ITEM-TYPE != "I" | PLI-COMPANY → MMD-COMPANY, "PO" → MMD-SYSTEM-CD, PLI-LOCATION → MMD-LOCATION, "PT" → MMD-DOC-TYPE, PLI-PO-NUMBER → MMD-DOC-NUMBER, PLI-PO-RELEASE → MMD-DOC-NBR-NUM, PLI-PO-CODE → MMD-PO-CODE, PLI-LINE-NBR → MMD-LINE-NBR, Zeroes → MMD-COMPONENT-SEQ, Spaces → MMD-AOC-CODE, → MMD-LINE-SEQ, → MMD-REQ-LOCATION, → MMD-API-OBJ-ID | |
| Pliset6 | POLINE | PLI-COMPANY → PLI-COMPANY, PLI-ITEM → PLI-ITEM, PLI-LOCATION → PLI-LOCATION, → PLI-EARLY-DL-DATE, → PLI-PO-NUMBER, → PLI-PO-RELEASE, → PLI-PO-CODE, → PLI-LINE-NBR | ||
| Poaocdtl | POAOCDTL | PLI-COMPANY → PAO-COMPANY, Spaces → PAO-PROCURE-GROUP, Spaces → PAO-VEN-AGRMT-REF, PLI-PO-NUMBER → PAO-PO-NUMBER, PLI-PO-RELEASE → PAO-PO-RELEASE, PLI-PO-CODE → PAO-PO-CODE, PLI-LINE-NBR → PAO-LINE-NBR, → PAO-AOC-CODE | ||
| Poapr By Date | MAINVDTL | PLI-COMPANY → MAD-COMPANY, PLI-PO-NUMBER → MAD-PO-NUMBER, PLI-PO-RELEASE → MAD-PO-RELEASE, PLI-PO-CODE → MAD-PO-CODE, PLI-LINE-NBR → MAD-LINE-NBR, → MAD-UPDATE-DATE, → MAD-UPDATE-TIME, → MAD-VENDOR, → MAD-INVOICE, → MAD-SUFFIX, → MAD-SEQ-NBR | ||
| Poapr By Dte2 | MAINVDTL | PLI-COMPANY → MAD-COMPANY, PLI-PO-NUMBER → MAD-PO-NUMBER, PLI-PO-RELEASE → MAD-PO-RELEASE, PLI-PO-CODE → MAD-PO-CODE, PLI-LINE-NBR → MAD-LINE-NBR, → MAD-UPDATE-DATE, → MAD-UPDATE-TIME, → MAD-VENDOR, → MAD-INVOICE, → MAD-SUFFIX, → MAD-SEQ-NBR | ||
| Poaudit | POAUDIT | PLI-COMPANY → PAU-COMPANY, PLI-PO-NUMBER → PAU-PO-NUMBER, PLI-PO-RELEASE → PAU-PO-RELEASE, PLI-PO-CODE → PAU-PO-CODE, PLI-LINE-NBR → PAU-PO-LINE-NBR, → PAU-PO-REVISION, → PAU-AOC-CODE, → PAU-LINE-SEQ, → 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 | ||
| Pomatchobj | POMATCHOBJ | PLI-COMPANY → PMJ-COMPANY, PLI-PO-NUMBER → PMJ-PO-NUMBER, PLI-PO-RELEASE → PMJ-PO-RELEASE, PLI-PO-CODE → PMJ-PO-CODE, PLI-LINE-NBR → PMJ-LINE-NBR, → PMJ-TRAN-DATE, → PMJ-TRAN-TIME, → PMJ-MATCH-OBJ-ID, → PMJ-MATCH-SEQ-NBR, → PMJ-TYPE | ||
| 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 |
Programs
Updated by (246)
- AP125 Batch Release
- AP126 Mass Invoice Release
- AP131 Chargeback
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP21.1 View Distributions
- AP23.1 Transit Invoice Entry
- AP25.1 Batch Control
- AP25.2 Batch Review
- AP26.1 Invoice Release
- AP27.1 Single Invoice Release
- AP30.4 Invoice Cancel
- AP510 Vendor Conversion
- API1.1 Add Invoice
- API2.1 Add Invoice
- CX100 Pick List Print
- CX20.1 Case Build
- CX20.2 Case Detail
- CX20.4 Substitute Items
- CX20.5 Insert line
- CX220 Case, Preference Listing
- CX30.1 Case Completion Feedback
- CX300 Preference List Purge
- CX506 HL7 Schedules Import Interface
- CXCP.1 Copy preference to case
- DR100 Distribution Requirements Report
- IC11.1 Item Master
- IC12.1 Item Location
- IC140 Vendor Reorder Advice
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC145 Stock Status Report
- IC216 Open Transaction Report
- IC243 Killed Item Report
- IC330 Item Mass Change
- IC64.1 Global Location Nbr Assignment GL/IC Company
- IC64.2 Global Location Nbr Assignment IC Location
- IC64.3 Global Location Number Assignment RQ Location
- IC64.4 Global Location Number Assignment Manuf Code
- IC64.5 Global Location Number Assignment Manuf Div
- IC64.6 Global Location Number Assignment Vendor
- IC64.7 Global Location Number Assignment Vendor Location
- IC64.8 Global Location Number Assignment IC Bin
- IC64.9 Global Location Number Assignment Buyer
- IC66.1 Replenishment PO Worksheet
- IC83.1 Par Location Counts
- ICI9.1 Item GTIN Invoke Object
- MA180 Open Receipt Archive
- MA278 Cost Variance Analysis
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.2 Memo Line AOC Detail
- MA43.2 Purchase Order Lookup
- MA43.7 GL Distribution
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA53.1 Receipt Interface
- MA530 ERS Invoice Creation
- MA531 Receipt Interface
- MA540 Invoice Interface
- MA60.2 Invoice Level Match
- MA60.3 Detail Level Match
- MA60.5 Receipt Match Reference Adjustment
- MA61.1 Match Invoice Approval
- MA65.1 Invoice Line Adjustment
- MA66.2 Invoice Message - Details
- MA67.2 Invoice Match from frontend
- MA67.3 Detail Match from frontend
- MA68.2 Invoice Level Match - Prepaid
- MA68.3 Detail Level Match - Prepaid
- MA68.5 Receipt Match Reference Adjustment
- MA70.1 Invoice Unmatch
- MA75.1 PO Invoice Cancel
- MA80.1 Receipt Archive
- MAI1.1 Invoke for MAMATCH Object
- PD10.1 P-Card Card Request
- PD10.2 P-Card Cardholder
- PD130 P-Card Invoice and Release
- PD20.1 P-Card Charge Approval
- PD20.2 P-Card Charge Approval Level
- PD20.3 P-Card Charge Approval SEA
- PD570 P-Card Charge Import
- PO04.1 Buyer
- PO04.2 Buyer Purchasing Class
- PO10.1 PO Vendor
- PO10.2 Vendor Purchase From Location
- PO100 Purchase Order Interface from Lawson Applications
- PO101 Create Standing PO Release
- PO115 Procurement Template Mass Changes
- PO120 Mass PO Issue
- PO122 Transmitted PO Acknowledgement
- PO130 Receiving Document
- PO131 Receiving Log
- PO132 Print Vendor Return Material Authorization
- PO136 Matched, Not Received Report
- PO15.1 Procurement Templates
- PO15.2 Procurement Template Participants
- PO15.4 Procurement Template Line Detail
- PO150 Bid Load to Contract or Catalog
- PO17.1 Purchase Order Approval Review
- PO190 Close Purchase Order Header
- PO20.1 Purchase Order Entry
- PO20.6 Substitute Vendor Items
- PO20.7 Substitute Vendor Items Detail
- PO20.9 Multiple Lines
- PO204 Buyer Master Listing
- PO21.1 Select and Copy
- PO21.2 Add-On Cost Spread
- PO21.3 Account Distribution
- PO21.4 Miscellaneous Add-On Cost
- PO21.5 Item Add-On Cost
- PO22.1 Authorization, Release
- PO22.2 Mass Cancel or Delete Purchase Orders
- PO22.3 Mass Cancel or Delete Purchase Orders
- PO22.4 Mass Cancel or Delete Purchase Order Lines
- PO22.5 Purchase Order Line Inquiry
- PO220 PO Status Report
- PO222 Remaining PO Balance Report
- PO223 Buyer Expediting Report
- PO224 PO Revision Report
- PO225 Vendor Agreement Listing
- PO229 Vendor Agreement Format Print
- PO23.1 Purchase Order Worksheet
- PO230 Unreleased Receivings Listing
- PO231 Return Status Report
- PO234 PO Interface Listing Report
- PO24.1 Purchase Order Direct Approval
- PO25.1 Vendor Agreements
- PO25.5 Vendor Agreement Item Add-On Cost
- PO25.6 Vendor Agreement Line
- PO25.7 Service Agreement Line
- PO251 PO Buyer Message Listing
- PO254 PO Inquiry Report
- PO26.3 Vendor Agreement Commitments Spread
- PO26.7 Mass Release of Vendor Agreements
- PO26.9 Vendor Agreement Release
- PO27.2 Select Blanket Lines
- PO27.3 Create PO From Procurement Template
- PO27.4 Select and Copy Template
- PO275 Delivery Date Analysis
- PO276 Deliver Quantity Analysis
- PO277 Deliver Quality Analysis
- PO28.2 Vendor Agreement Line Detail List
- PO280 Purchases By Class
- PO285 PO Activity By Source Report
- PO29.1 Copy Purchase Order
- PO30.1 PO Receiving
- PO30.2 Substitute Item
- PO30.3 Additional Tracking Numbers
- PO30.4 PO Receiving Line Detail List
- PO300 PO and Receipt Purge
- PO31.1 Vendor Return
- PO31.2 Vendor Return Item Selection
- PO32.2 Item Detail
- PO32.4 Cancel Detail
- PO33.1 Receiving Adjustment
- PO34.1 Inspection Accept or Reject
- PO35.1 Receiving Approval and Release
- PO36.1 Identify Lawson Items by Vendor Agreement Line
- PO36.2 Vendor Agreement Import Manual Input
- PO38.1 Invoice AOC
- PO39.1 Additional Receiving Entry
- PO39.2 Additional Adjustment/Rejection Entry
- PO44.1 PO Line Source
- PO50.1 Buyer Message Entry
- PO52.1 Buyer Message - Receiving
- PO520 Purchase Order Interface from Non Lawson
- PO529 PO Receiving File Create
- PO536 Vendor Price Agreement Load
- PO54.1 Purchase Order Inquiry
- PO54.2 Purchase Order Inquiry
- PO54.3 Purchase Order Inquiry
- PO54.4 Purchase Order Inquiry
- PO54.5 PO Line Detail List
- PO55.3 Purchase Order Header Retainage
- PO55.4 Purchase Order Line Retainage
- PO983 PO Line Item UNSPSC
- POCP.1 POC Comments Copy
- POD0.1 Po Orphan Record Check
- POD1.1 Po Document Integrity Check
- POI3.1 Invoke for POPI70PD
- POI7.1 POI7 Print Object
- POID.1 PO Delivery Ticket Select
- POII.1 Invoke for POPCRUPD
- POIJ.1 Invoke for POPLIUPD
- POIZ.1 Poline update from M3 PFI
- RQ01.1 Requesting Locations
- RQ10.1 Requisition
- RQ10.2 Account Distribution
- RQ10.3 Select and Copy
- RQ10.4 Requisition Line Entry Detail
- RQ10.5 Substitutes
- RQ11.1 Kit Accessories
- RQ12.1 Approval Review
- RQ13.1 Direct Approval
- RQ13.2 Direct Line Approval
- RQ23.1 Procedure Information
- RQ35.1 Requisition Returns
- RQ44.1 Requisition Inquiry
- RQ500 Requisition Interface
- RQ810 Request Location Load
- RQIB.1 RQRQHUPD Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQII.1 Invoke for Reqheader Inquiry
- RQIJ.1 Requisition Copy
- WH130 Pick List Print
- WH132 Batch Feedback
- WH190 Shipment Release
- WH20.2 Nonstock and Special Allocation
- WH20.7 Substitute Location
- WH222 Shipments In Process
- WH30.1 Picking Feedback by Document
- WH30.2 Picking Feedback by Shipment
- WH30.3 Picking by Batch
- WH30.4 Bin Sequence Picking Feedback
- WH31.1 Packing Feedback by Document
- WH31.2 Packing Feedback by Shipment
- WH31.3 Packing by Batch
- WH31.4 Bin Sequence Packing Feedback
- WH32.1 Shipping Feedback by Document
- WH32.2 Shipping Feedback by Shipment
- WH32.3 Shipping by Batch
- WH32.4 Bin Sequence Shipping Feedback
- WH32.5 Shipping Line Feedback
- WH33.1 Bins
- WH33.2 Lots
- WH33.3 Serials
- WH33.4 UOMs
- WH33.5 Additional Shipment Information
- WH33.6 Catch Weight
- WH33.8 Preassembled Kits
- WH33.9 Line Options
- WH34.1 Component Bins
- WH34.2 Component Lots
- WH34.3 Component Serials
- WH34.4 Component UOMs
- WH40.1 Bill of Lading
- WH40.2 Bill of Lading Feedback
- WH520 Batch Feedback Interface
- WH830 Shipment Load Program
Referenced by (92)
- AM17.1 PO Line Asset Defaults
- AM19.1 PO Line Asset Detail
- AM19.2 Create Detail
- AM219 PO Asset Detail Report
- AP115 Vendor Merge
- AP133 Mass Retainage Payment Adjust
- AP220 Invoice Edit Report
- AP233 Retainage Invoice Listing
- AP305 Accounts Payable Company Purge
- AP33.1 Retainage Payment Adjustment
- AP97.2 Retainage Invoice Inquiry By Purchase Order
- AP97.3 Retainage Totals
- CX55.1 Case Procedure Inquiry
- IC130 General Ledger Interface
- IC20.1 Receipts
- IC20.2 Detail Receipts
- IC21.1 Issues
- IC21.2 Detail Issues
- IC22.1 Transfers
- IC22.2 Detail Transfer
- IC23.1 Intransit Receiving
- IC23.2 Detail Intransit Receiving
- IC24.1 Adjustments
- IC24.2 Detail Adjustments
- IC25.1 Document Release
- IC28.1 Cost Adjustments
- IC44.1 Inventory Stock Status
- IC45.1 Stock Status
- IC50.2 Detail Transaction History
- IC500 Transaction Interface
- MA126 Auto Matching
- MA231 Unmatched Receipt Listing
- MA236 Invoiced, Not Received Report
- MA237 Match Update Report
- MA26.1 PO Invoice Match
- MA63.1 Invoice Line Match
- MA64.1 Message Queue - Vendor
- MA64.2 Message Queue - PO
- MA64.3 Message Queue - Item
- MA64.4 Invoice Messaging Queue
- MA64.6 Message Detail by Invoice
- MA64.9 PO Cost Message Accept Upload
- MA69.1 AOC Level Detail Match
- MA90.1 Match Analysis
- MA90.2 All Transactions for Invoice
- MA90.3 Match Analysis Details
- MA90.5 Misc AOC for an Invoice
- MA90.6 Summarization
- MM280 Departmental Procurement Expense Report
- MM80.1 Departmental Procurement Expense Inquiry Selection
- MM80.2 Departmental Procurement Expense Inquiry Detail
- PO133 Receiving Adjustment Log
- PO135 Received, Not Invoiced Report
- PO139 Standard Cost Calculation
- PO16.1 Bid
- PO16.2 Bid Response
- PO18.1 Workflow Approval Maintenance
- PO216 Bid Analysis
- PO227 Contract Agreement Compliance Report
- PO233 PO Received Quantity Exceptions
- PO253 Item Receipt Volume Report
- PO258 Receipt Inquiry Report from PO58
- PO274 Returns Analysis
- PO278 RNI Aging Report
- PO295 Cash Requirements Forecast
- PO550 Bid Creation
- PO58.1 Receipt Inquiry
- PO58.2 Receipt Inquiry
- PO63.1 PO Inquiry By Item
- PO64.1 PO Line Item History
- PO66.1 PO Revision History
- PO67.1 PO Inquiry By AOC
- PO700 PO Hdr and Line Pivot UPGRADE
- PO94.1 Vendor Performance
- POA3.1 Data Load for Vendor Analysis
- POI1.1 POC Comments Copy
- POI2.1 POC Comments Copy
- POIE.1 Delivery Ticket Report
- POIF.1 MMDIST Activity Commit
- POIG.1 MMDIST Budget Check
- POIH.1 Invokeable Unit Cost Default
- POIM.1 GL Budget Ck for PO and RQ
- POIT.1 Invoke PO Total Method
- RQ140 Requisition Status Report
- RQ260 Requisitioned Items Report
- RQ300 Requisition Purge
- RQ40.1 Requisitions by Location
- RQ41.1 Requisition Status
- RQ42.1 Requisitions by Item
- WH25.1 Cancellation By Item
- WH25.2 Cancellation By Document
- WHD2.1 WH-IC Integrity Check