POHDROUT 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 PO522 RQ20.1 RQ20.3 RQ20.4 WH20.2 WH20.7 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY PHO-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 PHO-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 PHO-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 PHO-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 PHO-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 PHO-CREATION-TIME Numeric 6 (hhmmss) PO100 PO120 Creation Time The creation time. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-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 PHO-RECORD-STAT Numeric 1 PO100 PO120 Record Stat PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-ORDER-NAME Alpha 10 PO100 PO120 Standard Order Name The user defined Standard Order name. PO121 PO123 The Standard Order name is defined in PO20.1 RQ20.1 the Purchase Order system. RQ20.3 RQ20.4 PHO-RETURN-NUMBER Numeric 10 PO100 PO120 Return Number This is the number assigned to the PO121 PO123 return for purposes of referencing the PO20.1 RQ20.1 return internally and with the customer RQ20.3 RQ20.4 or vendor. PHO-VENDOR Alpha 9 PO100 PO120 Vendor ID The vendor's identification code. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-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 PHO-BUYER-CODE Alpha 3 PO100 PO120 Buyer Code The user defined buyer identifier. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-PO-DATE Numeric 8 (yyyymmdd) PO100 PO120 Purchase Order Date PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-CURRENCY-CODE Alpha 5 PO100 PO120 Currency Code This field contains the company base PO121 PO123 currency code established in GL10.1 PO20.1 RQ20.1 (Company). RQ20.3 RQ20.4 PHO-ENT-CNV-RATE Signed 12.6 PO100 PO120 Entered Conversion Currency conversion rate at Purchase PO121 PO123 Rate Order entry time. PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-REC-CNV-RATE Signed 12.6 PO100 PO120 Receiving Exchange Currency conversion rate for the PO121 PO123 Rate Purchase Order at receiving time. PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-CURRENCY-FLAG Alpha 1 PO100 PO120 Currency Flag Conversion Method for Curency - PO121 PO123 Multiply/Divide. PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-CURR-SET-FLAG Alpha 1 PO100 PO120 Currency Set Flag Flag defines when the currency rate PO121 PO123 has been set for the Purchase Order. PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-CURR-TRAN-ND Numeric 1 PO100 PO120 Currency Transaction currency number of decimals. PO121 PO123 Transaction Nbr Dec PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-REVALUE-FLAG Alpha 1 PO100 PO120 Revalue Currency will be re-evaluated when PO121 PO123 Accounts Payable prints check in a PO20.1 RQ20.1 currency other than established on RQ20.3 RQ20.4 the Purchase Order/Invoice. PHO-DFLT-DL-DATE Numeric 8 (yyyymmdd) PO100 PO120 Default Delivery Default Early Delivery Date. PO121 PO123 Date PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-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 PHO-SH-NAME Alpha 30 (Lower Case) PO100 PO120 Ship To Name This is the ship to name for a non PO121 PO123 standard ship to address. PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-SH-ADDR1 Alpha 30 (Lower Case) PO100 PO120 Ship To Address This is the ship to address line one. PO121 PO123 Line 1 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-SH-ADDR2 Alpha 30 (Lower Case) PO100 PO120 Ship To Address This is the ship to address line two. PO121 PO123 Line 2 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-SH-ADDR3 Alpha 30 (Lower Case) PO100 PO120 Ship To Address This is the ship to address line PO121 PO123 Line 3 three. PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-SH-ADDR4 Alpha 30 (Lower Case) PO100 PO120 Ship To Address This is the ship to address line four. PO121 PO123 Line 4 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-SH-CITY-ADDR5 Alpha 18 (Lower Case) PO100 PO120 Ship To City or This is the ship to city or the PO121 PO123 Address Line 5 ship to address line five. PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-SH-STATE-PROV Alpha 2 PO100 PO120 Ship To State or This is the ship to state or the PO121 PO123 Province ship to province. PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-SH-POST-CODE Alpha 10 (Lower Case) PO100 PO120 Ship To Postal Code This is the ship to mail code. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-SH-COUNTRY Alpha 30 (Lower Case) PO100 PO120 Ship To Country Ship to country. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-SH-PHONE-PREF Alpha 6 PO100 PO120 Ship To Telephone This is the ship to phone number PO121 PO123 Country Code prefix. PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-SH-PHONE Alpha 15 PO100 PO120 Ship To Telephone This is the ship to phone number. PO121 PO123 Number PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-SH-PHONE-EXT Alpha 5 PO100 PO120 Ship To Telephone PO121 PO123 Extension PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-SH-CONTACT Alpha 30 (Lower Case) PO100 PO120 Ship To Contact Ship to contact. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-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. PHO-NBR-LINES Numeric 6 PO100 PO120 Number of Lines This is the number of detail lines. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-CLOSED-LINES Numeric 6 PO100 PO120 Closed Lines This is the number of closed detail PO121 PO123 lines on the requisition. When the PO20.1 RQ20.1 number of closed lines equals the number RQ20.3 RQ20.4 of lines, the requisition status will be set to closed in RQ120. PHO-DROPSHIP-FL Alpha 1 PO100 PO120 Dropship Flag This flag indicates whether goods being PO121 PO123 shipped by the vendor directly to a non PO20.1 RQ20.1 standard location need to have the RQ20.3 RQ20.4 receiving process performed. PHO-PRT-PO-FLAG Alpha 1 PO100 PO120 Print PO Flag PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-PRT-REC-FLAG Alpha 1 PO100 PO120 Print Receiver Flag PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-PRT-REV-FLAG Alpha 1 PO100 PO120 Print Revision Flag PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-REPRINT-FLAG Alpha 1 PO100 PO120 Reprint Flag PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-EDI-PO-FLAG Alpha 1 PO100 PO120 Fax/EDI Flag PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-EDI-REV-FLAG Alpha 1 PO100 PO120 EDI Revision Flag PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-BLANKET-CD Alpha 1 PO100 PO120 Blanket Cd PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-FAX-PREFIX Alpha 6 PO100 PO120 Fax Country Code The fax number prefix. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-FAX-NUMBER Alpha 15 PO100 PO120 Fax Number This field contains the fax number. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-FAX-EXT Alpha 5 PO100 PO120 Fax Extension This field contains the fax number PO121 PO123 extension. PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-HDR-COMM-CODE Alpha 4 Occurs 2 Times PO100 PO120 Header Comment Code PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-TRL-COMM-CODE Alpha 4 Occurs 2 Times PO100 PO120 Trailer Comment Code PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-PROCESS-LEVEL Alpha 5 PO100 PO120 Process Level This field contains the process level, PO121 PO123 which is the reporting hierarchy below PO20.1 RQ20.1 company. RQ20.3 RQ20.4 PHO-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 PHO-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 PHO-FREIGHT-TERMS Alpha 1 PO100 PO120 Freight Terms Freight terms are used to define who PO121 PO123 pays for freight costs incurred when PO20.1 RQ20.1 goods are shipped. Prepaid, for RQ20.3 RQ20.4 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. PHO-FOB-CODE Alpha 2 PO100 PO120 Shipping Term Code The user defined Free On Board Code. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-FOB-DESC Alpha 30 (Lower Case) PO100 PO120 Shipping Term The shipping term description. PO121 PO123 Description PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-SHIP-VIA Alpha 12 (Lower Case) PO100 PO120 Ship Via Description PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-DUE-DAYS Numeric 3 PO100 PO120 Vendor Due Days PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-DISC-DAYS Numeric 3 PO100 PO120 Discount Days PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-DISC-RATE Signed 7.5 PO100 PO120 Discount Rate PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-TERMS-CODE Alpha 5 PO100 PO120 Terms Code PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-TERMS Alpha 20 PO100 PO120 Terms The payment terms in a narrative form. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-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 PHO-TOT-LND-AMT Signed 15.2 PO100 PO120 Total Landing Amount PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-TOT-PRD-AMT Signed 15.2 PO100 PO120 Total Product Amount This is the total product amount PO121 PO123 associated with the Purchase Order. PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-TOT-TAXBLE-AMT Signed 15.2 PO100 PO120 Tot Taxble Amt PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-NBR-TAXBLE-LN Numeric 6 PO100 PO120 Nbr Taxble Ln PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-LETTER-OF-CR Alpha 20 PO100 PO120 Letter of Credit This field contains the letter of PO121 PO123 credit. PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-TOT-ORDER-AMT Signed 15.2 PO100 PO120 Total Order Amount PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-USER-DATE-1 Numeric 8 (yyyymmdd) PO100 PO120 User Date 1 PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-USER-DATE-2 Numeric 8 (yyyymmdd) PO100 PO120 User Date 2 PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-LAST-LINE-NBR Numeric 6 PO100 PO120 Last Line Number This field contains the number of the PO121 PO123 last line item added to the requisition. PO20.1 RQ20.1 It is used to determine the number when RQ20.3 RQ20.4 the next line is added to the requisition. PHO-LAST-HDR-SEQ Numeric 3 PO100 PO120 Last Header Comment This is the sequence number of the last PO121 PO123 Sequence header comment line. PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-LAST-TRLR-SEQ Numeric 3 PO100 PO120 Last Trailer PO121 PO123 Comment Sequence PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-DFLT-TAXBL-FL Alpha 1 PO100 PO120 Default Taxable Flag This taxable flag is used for PO121 PO123 defaulting a 'Y'es, 'N'o into Special PO20.1 RQ20.1 and Service items when applying them to RQ20.3 RQ20.4 a Purchase Order. Non-stock and Inventory items will have this flag defined in the Lawson Inventory System. PHO-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 PHO-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 PHO-REVISED-FL Alpha 1 PO100 PO120 Revised Flag PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-CANCELLED-FL Alpha 1 PO100 PO120 Canceled Flag The canceled flag. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-CLOSED-FL Alpha 1 PO100 PO120 Closed Flag The Closed Flag. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-LAST-ACTIVITY Numeric 8 (yyyymmdd) PO100 PO120 Last Activity PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-CLOSE-DATE Numeric 8 (yyyymmdd) PO100 PO120 Close Date Add on cost close date. PO121 PO123 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-PO-USER-FLD-1 Alpha 1 PO100 PO120 Purchase Order User Purchase Order header user field one. PO121 PO123 Field 1 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-PO-USER-FLD-3 Alpha 10 (Lower Case) PO100 PO120 Purchase Order User Purchase Order header user field two. PO121 PO123 Field 3 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-PO-USER-FLD-5 Alpha 30 (Lower Case) PO100 PO120 Purchase Order User Purchase Order header user field three. PO121 PO123 Field 5 PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-INVC-MTHD-CODE Alpha 3 PO100 PO120 Invc Mthd Code The method the vendor is to use to PO121 PO123 invoice the order (manual, EDI, or PO20.1 RQ20.1 evaluated receipts settlement). RQ20.3 RQ20.4 PHO-INVC-AUTO-REL Alpha 1 PO100 PO120 Invc Auto Rel Indicates whether the invoice should be PO121 PO123 automatically released. PO20.1 RQ20.1 RQ20.3 RQ20.4 PHO-INTRASTAT-NBR Numeric 10 PO100 PO120 Intrastat Nbr The number assigned by the Intrastat PO121 PO123 system to a transaction that involves PO20.1 RQ20.1 Intrastat reporting after it has been RQ20.3 RQ20.4 added. PHO-TO-CNTRY-CD Alpha 2 PO100 PO120 To Cntry Cd The Ship-To country code. Must be PO121 PO123 defined in IN01.1 (Country PO20.1 RQ20.1 Maintenaance). RQ20.3 RQ20.4 PHO-SHIP-TO-REGION Alpha 2 PO100 PO120 Ship To Region The ship-to region code. PO121 PO123 Must be a valid region for the country, PO20.1 RQ20.1 defined in IN02.1 (Region RQ20.3 RQ20.4 Maintenance). POHDROUT FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN PHOSET1 COMPANY PO522 PO-NUMBER PO-RELEASE PO-REVISION CREATION-DATE CREATION-TIME PHOSET2 COMPANY VENDOR PO-NUMBER PO-RELEASE CREATION-DATE CREATION-TIME PHOSET3 COMPANY BL92.1 OE10.1 LOCATION OE10.2 OE10.3 PO-NUMBER OE10.4 OE10.5 PO-RELEASE OE10.6 OE10.7 CREATION-DATE OE10.8 OE11.1 CREATION-TIME 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 ... POHDROUT FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Hdrouticcout ICCOUT Required PHO-COMPANY -> OWC-COMPANY PHO-LOCATION -> OWC-LOCATION POHDROUT FILE RELATIONS ONE TO MANY RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Hdroutlineout POLINEOUT PHO-COMPANY -> PLT-COMPANY PHO-PO-NUMBER -> PLT-PO-NUMBER PHO-PO-RELEASE -> PLT-PO-RELEASE PHO-PO-REVISION -> PLT-PO-REVISION PHO-CREATION-DATE -> PLT-CREATION-DATE PHO-CREATION-TIME -> PLT-CREATION-TIME PLT-LINE-NBR |