POLINEOUT FILE UPDATED BY BL92.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO120 PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 WH20.2 WH20.7 PO522 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY PLT-COMPANY Numeric 4 PO100 PO120 Company The company number represents an PO121 PO123 established company and is entered on PO20.1 RQ20.1 all function codes. RQ20.3 RQ20.4 PLT-PO-NUMBER Alpha 7 (Right Justified) PO100 PO120 PO Number This field contains the number PO121 PO123 representing the purchase order. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-PO-RELEASE Numeric 6 PO100 PO120 PO Release Number Used to identify a purchase order PO121 PO123 release (created from a Blanket or PO20.1 RQ20.1 Standing order). RQ20.3 RQ20.4 PLT-PO-REVISION Numeric 3 PO100 PO120 PO Revision Number The PO Revision number. Assigned PO121 PO123 sequentially by the system when the PO PO20.1 RQ20.1 is revised. RQ20.3 RQ20.4 PLT-CREATION-DATE Numeric 8 (yyyymmdd) PO100 PO120 Creation Date This is the date that this line was PO121 PO123 added to the requisition. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-CREATION-TIME Numeric 6 (hhmmss) PO100 PO120 Creation Time The creation time. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-RECORD-TYPE Alpha 1 PO100 PO120 Record Type This field identifies the type of PO121 PO123 record defined. PO20.1 RQ20.1 RQ20.3 RQ20.4 Valid values are: S=Summary D=Detail PLT-RECORD-STAT Numeric 1 PO100 PO120 Record Stat PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-LINE-NBR Numeric 6 PO100 PO120 Line Number This field contains the line number. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-ITEM Alpha 32 PO100 PO120 Item Number This field contains the item PO121 PO123 identifier. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-ITEM-TYPE Alpha 1 PO100 PO120 Item Type This field identifies the line item PO121 PO123 type. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-DESCRIPTION Alpha 30 (Lower Case) PO100 PO120 Description This field contains the description. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-QUANTITY Signed 13.4 PO100 PO120 Quantity This field contains the requested PO121 PO123 quantity. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-VPRI-QUANTITY Signed 13.4 PO100 PO120 Vendor Price The entered line quantity system PO121 PO123 Quantity converted to vendor pricing terms. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-REC-QTY Signed 13.4 PO100 PO120 Receiving Quantity This is the total quantity to date PO121 PO123 received for this ordered item. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-CATCH-WT-QTY Signed 13.4 PO100 PO120 Catch Weight This field contains the quantity PO121 PO123 Quantity received for catch weight shipments. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-CONTRACT-NBR Alpha 14 PO100 PO120 Contract Number This is a number to indicate to the PO121 PO123 vendor which price agreement an item or PO20.1 RQ20.1 items are operating under. RQ20.3 RQ20.4 If this number is entered on or defaulted to a purchase order line, it is an indication of the vendor contract that line is tied to. The contract number can be defaulted to the purchase order line. The default occurs by leaving the field blank when creating the purchase order and having the system attempt to find a contract number from a contract-type standard order. The system finds the number based on the item number for the line and vendor for the purchase order. If no contract number is entered on or defaulted to the line from a contract type standard order, a contract number entered on the purchase order header will default to the line. A contract number can also be tied to a blanket type standard order, and any purchase orders created from the blanket order will have the contract number from the blanket on the header and lines. The contract number can also be defaulted to a requisition line as the requisition line is created. The contract number will then be carried over to the purchase order line that is created from the requisition line. PLT-RECQTY-TO-APP Signed 13.4 PO100 PO120 Receiver Quantity This is the receipt quantity that is PO121 PO123 To Approve to be approved. This is in the PO20.1 RQ20.1 Vendor pricing unit of measure. RQ20.3 RQ20.4 PLT-APPROVE-QTY Signed 13.4 PO100 PO120 Approved Quantity The total approved quantity for this PO121 PO123 line item. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-UNREL-APP-QTY Signed 13.4 PO100 PO120 Unreleased Approval Approval quantity upon entry of an PO121 PO123 Quantity Invoice line item. This quantity is PO20.1 RQ20.1 established before the Invoice has RQ20.3 RQ20.4 been released. PLT-SUBST-QTY Signed 13.4 PO100 PO120 Substitute Quantity This is the quantity of subsitute PO121 PO123 items received in on this product. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-REJECT-QTY Signed 13.4 PO100 PO120 Inspection Reject PO121 PO123 Quantity PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-ENT-UNIT-CST Signed 13.5 PO100 PO120 Entered Unit Cost The entered unit cost. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-TAXBL-UNT-CST Signed 13.5 PO100 PO120 Taxable Unit Cost PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-COST-CD Alpha 1 PO100 PO120 Unit Cost Origin Unit cost origin code PO121 PO123 Code PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-ENT-BUY-UOM Alpha 4 PO100 PO120 Entered Buy Unit Of Entered Buy Unit Of Measure. PO121 PO123 Measure PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-EBUY-UOM-MULT Signed 13.7 PO100 PO120 Entered Buy UOM Entered Buy Unit Of Measure Conversion PO121 PO123 Multiplier Multiplier. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-VPRI-UOM Alpha 4 PO100 PO120 Vendor Price Unit This is the vendor pricing unit of PO121 PO123 of Measure measure. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-VPRI-UOM-MULT Signed 13.7 PO100 PO120 Vendor Price UOM This is the vendor pricing unit of PO121 PO123 Multiplier measure multiplier. It is used to PO20.1 RQ20.1 convert unit cost to stock unit of RQ20.3 RQ20.4 measure terms. PLT-LAND-UNIT-CST Signed 13.5 PO100 PO120 Landed Unit Costs All add on costs that are landed PO121 PO123 in addition to the product unit cost. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-EARLY-DL-DATE Numeric 8 (yyyymmdd) PO100 PO120 Early Delivery Date This field contains the early delivery PO121 PO123 (Rqst DT) date. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-LATE-DL-DATE Numeric 8 (yyyymmdd) PO100 PO120 Late Delivery Date This field contains the late delivery PO121 PO123 date. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-REC-ACT-DATE Numeric 8 (yyyymmdd) PO100 PO120 Receiving Activity PO121 PO123 Date PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-CLOSE-DATE Numeric 8 (yyyymmdd) PO100 PO120 Close Date Add on cost close date. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-LOCATION Alpha 5 PO100 PO120 Location Code This field contains a valid stocking PO121 PO123 location within the company inventory. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-REQ-LOCATION Alpha 5 PO100 PO120 To Location The location requisitioning items. PO121 PO123 This location can be an inventory or PO20.1 RQ20.1 noninventory location. RQ20.3 RQ20.4 PLT-BUYER-CODE Alpha 3 PO100 PO120 Buyer Code The user defined buyer identifier. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-VENDOR Alpha 9 PO100 PO120 Vendor ID The vendor's identification code. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-PURCH-FR-LOC Alpha 4 PO100 PO120 Purchase From The vendor's purchase from location. PO121 PO123 Location Code PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-DIST-CODE Alpha 9 PO100 PO120 Distribution Code A user-defined code used to PO121 PO123 automatically create expense PO20.1 RQ20.1 distributions or expense distribution RQ20.3 RQ20.4 "shells" for invoices or to split an invoice distribution into multiple distributions. PLT-VAR-ACCT-UNIT Alpha 15 PO100 PO120 Cost Variance The variance account accounting unit. PO121 PO123 Accounting Unit PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-VAR-ACCOUNT Numeric 6 PO100 PO120 Cost Variance The variance account account number. PO121 PO123 Account Number PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-VAR-SUB-ACCT Numeric 4 PO100 PO120 Cost Variance The variance account subaccount number. PO121 PO123 Subaccount PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-TAX-CODE Alpha 10 PO100 PO120 Tax Code This field contains a code representing PO121 PO123 specific tax information. This must be PO20.1 RQ20.1 valid Tax Code. RQ20.3 RQ20.4 PLT-ORIG-LINE-NBR Numeric 6 PO100 PO120 Original Line Number PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-WEIGHT Signed 9.3 PO100 PO120 Unit Weight This field contains the unit weight of PO121 PO123 the item based on the stocking UOM. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-CUBIC-FEET Signed 9.3 PO100 PO120 Cubic Feet This field contains the unit cubit feet PO121 PO123 of the item based on the stocking UOM. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-SOURCE-DOC Alpha 10 (Right Justified) PO100 PO120 Source Document The source from which this record PO121 PO123 was created. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-ORIGIN-CD Alpha 2 PO100 PO120 Origin Code This field identifies the system that PO121 PO123 created this record. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-ORDER-NBR Numeric 8 PO100 PO120 Order Number This field contains the order number. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-REC-PRT-FL Alpha 1 PO100 PO120 Receiver Print Flag PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-CANCEL-BO-FL Alpha 1 PO100 PO120 Cancel Back Order This flag indicates whether the PO121 PO123 Flag backordered quantity is to be cancelled PO20.1 RQ20.1 and the line is to be considered closed. RQ20.3 RQ20.4 PLT-NO-CHARGE-FL Alpha 1 PO100 PO120 No Charge Flag This field indicates the item's price PO121 PO123 is zero. This defaults to (N)o. If PO20.1 RQ20.1 (Y)es, this field prevents the system RQ20.3 RQ20.4 from pricing the item. No charge invoices are not be passed to the Lawson Accounts Receivable system for collection. PLT-CERT-REQ-FL Alpha 1 PO100 PO120 Certification This flag indicates whether a PO121 PO123 Required Flag certification is required for this line PO20.1 RQ20.1 when it is purchased. This field value RQ20.3 RQ20.4 is passed to the PO when the PO line is created. Valid values are: "N" = Certification not required. "Y" = Certification required. PLT-INSP-REQ-FL Alpha 1 PO100 PO120 Inspection Required This flag indicates whether this item PO121 PO123 Flag has to be inspected when received via PO20.1 RQ20.1 PO. RQ20.3 RQ20.4 PLT-REC-INSP-FL Alpha 1 PO100 PO120 Receiving PO121 PO123 Inspection Flag PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-MSDS-FLAG Alpha 1 PO100 PO120 Material Safety This flag indicates if this item PO121 PO123 DataSheet Flag requires a Material Safety Data Sheet. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-NO-LT-CALC-FL Alpha 1 PO100 PO120 No Lead Time PO121 PO123 Calculation Flag PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-TAXABLE-FLAG Alpha 1 PO100 PO120 Taxable or Defines if Taxable. PO121 PO123 Non-Taxable Flag PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-OSHIP-TOL-PCT Percent 5.3 (Percent) PO100 PO120 Overshipment Quantity overshipment tolerance PO121 PO123 Tolerance Percent percentage. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-USHIP-TOL-PCT Percent 6.3 (Percent) PO100 PO120 Cancel Backorder This is the quantity undership PO121 PO123 Percent percentage for automatic back order PO20.1 RQ20.1 cancellation. If a value of 10% is RQ20.3 RQ20.4 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 cancelled. This process takes place at receiving time. If a backorder is not cancelled manually, the system checks, in order, the PO line, the PO vendor purchase from record, the PO 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. PLT-COST-TOL-PCT Percent 5.3 (Percent) PO100 PO120 Unit Cost Tolerance This is the unit Cost Tolerance Percent. PO121 PO123 Percent PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-USER-DATE-3 Numeric 8 (yyyymmdd) PO100 PO120 User Date 3 This field contains the third PO121 PO123 user-definable date. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-USER-DATE-4 Numeric 8 (yyyymmdd) PO100 PO120 User Date 4 This field contains the fourth PO121 PO123 user-definable date. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-COMMENT-CODE Alpha 4 Occurs 2 Times PO100 PO120 Comment Code Entering a standard comment code will PO121 PO123 copy the standard comments setup in PO PO20.1 RQ20.1 into the requisition header comment RQ20.3 RQ20.4 file. PLT-PURCH-MAJCL Alpha 4 PO100 PO120 Major Purchasing The user defined Major Purchasing Class PO121 PO123 Class identifier. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-PURCH-MINCL Alpha 4 PO100 PO120 Minor Purchasing The user defined Minor purchasing Class PO121 PO123 Class identifier. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-MANUF-CODE Alpha 4 PO100 PO120 Manufacturer's Code This field contains a user defined code PO121 PO123 that indicates the manufacturer of an PO20.1 RQ20.1 item. RQ20.3 RQ20.4 PLT-MANUF-DIVISION Alpha 4 PO100 PO120 Manufacturer's This is a user defined code that PO121 PO123 Division indicates which division of a PO20.1 RQ20.1 manufacturer is tied to an item. RQ20.3 RQ20.4 PLT-MANUF-NBR Alpha 15 PO100 PO120 Manufacturer's Item This is the identifier that the PO121 PO123 Number manufacturer has assigned to an item. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-LAST-COMM-SEQ Numeric 3 PO100 PO120 Last Comment This is the sequence number of the last PO121 PO123 Sequence Number comment line entered for this PO20.1 RQ20.1 requisition line. RQ20.3 RQ20.4 PLT-LAST-DST-SEQ Numeric 3 PO100 PO120 Last Distribution PO121 PO123 Sequence Nbr PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-RELEASED-FL Alpha 1 PO100 PO120 Released Released Flage. Record is now PO121 PO123 available for further processing in PO20.1 RQ20.1 the system. RQ20.3 RQ20.4 PLT-PRINTED-FL Alpha 1 PO100 PO120 Printed Flag This flag indicates if this requisition PO121 PO123 has been printed by RQ111. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-REVISED-FL Alpha 1 PO100 PO120 Revised Flag PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-CANCELLED-FL Alpha 1 PO100 PO120 Canceled Flag The canceled flag. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-CLOSED-FL Alpha 1 PO100 PO120 Closed Flag The Closed Flag. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-ZERO-OSHIP-FL Alpha 1 PO100 PO120 Zero Overshipment PO121 PO123 Flag PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-ZERO-USHIP-FL Alpha 1 PO100 PO120 Zero Undershipment Set this flag to "Y" to indicate that PO121 PO123 Flag the undershipment tolerance percent PO20.1 RQ20.1 should be set to "zero" at this level. RQ20.3 RQ20.4 This means that no backorders will be cancelled. The undershipment tolerance percent must be blank to set this flag to "Y". PLT-ZERO-COST-FL Alpha 1 PO100 PO120 Zero Cost Flag Zero Unit Cost Line Tolerance Flag. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-EXCL-AOC-SPRD Alpha 1 PO100 PO120 Exclude from AOC Exclude this line item from the PO121 PO123 Spread Method Add On Cost Spread Methods. PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-PO-USER-FLD-2 Alpha 2 PO100 PO120 Purchase Order User Purchase order line user defined field. PO121 PO123 Field 2 PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-PO-USER-FLD-4 Alpha 30 (Lower Case) PO100 PO120 Purchase Order User Purchase order line user defined field. PO121 PO123 Field 4 PO20.1 RQ20.1 RQ20.3 RQ20.4 PLT-PO-USER-FLD-6 Alpha 15 (Lower Case) PO100 PO120 Purchase Order User Purchase order line user defined field. PO121 PO123 Field 6 PO20.1 RQ20.1 RQ20.3 RQ20.4 POLINEOUT FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN PLTSET1 COMPANY BL92.1 OE10.1 PO-NUMBER OE10.2 OE10.3 PO-RELEASE OE10.4 OE10.5 PO-REVISION OE10.6 OE10.7 CREATION-DATE OE10.8 OE11.1 CREATION-TIME OE11.4 OE11.8 LINE-NBR OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO20.1 PO522 RQ20.4 ... PLTSET2 COMPANY BL92.1 OE10.1 PO-NUMBER OE10.2 OE10.3 PO-RELEASE OE10.4 OE10.5 CREATION-DATE OE10.6 OE10.7 CREATION-TIME OE10.8 OE11.1 LINE-NBR OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO100 PO120 PO121 ... POLINEOUT FILE RELATIONS ONE TO MANY RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Hdroutcomout POCOMOUT PLT-COMPANY -> PCM-COMPANY PLT-PO-NUMBER -> PCM-PO-NUMBER PLT-PO-RELEASE -> PCM-PO-RELEASE PLT-CREATION-DATE -> PCM-CREATION-DATE PLT-CREATION-TIME -> PCM-CREATION-TIME PLT-LINE-NBR -> PCM-LINE-NBR PCM-SEQ |