POHDROUT FILE
UPDATED BY
PO522 POI7.1 POIJ.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PIH-COMPANY Numeric 4 POI7.1 POIJ.1
Company The company number represents an
established company and is entered on
all function codes.
PIH-PO-NUMBER Alpha 14 (Right Justified) POI7.1 POIJ.1
PO Number This field contains the number
representing the purchase order.
PIH-PO-RELEASE Numeric 4 POI7.1 POIJ.1
PO Release Number Used to identify a purchase order
release (created from a Blanket or
Standing order).
PIH-PO-CODE Alpha 4 POI7.1 POIJ.1
Po Code This is the purchase order code.
PIH-PO-REVISION Numeric 3 POI7.1 POIJ.1
PO Revision Number The PO Revision number. Assigned
sequentially by the system when the PO
is revised.
PIH-CREATION-DATE Numeric 8 (yyyymmdd) POI7.1 POIJ.1
Creation Date This is the date that this line was
added to the requisition.
PIH-CREATION-TIME Numeric 6 (hhmmss) POI7.1 POIJ.1
Creation Time The creation time.
PIH-RECORD-TYPE Alpha 1 POI7.1 POIJ.1
Record Type This field identifies the type of
record defined.
Valid values are:
S = Summary
D = Detail
PIH-RECORD-STAT Numeric 1 POI7.1 POIJ.1
Record Stat
PIH-RETURN-NUMBER Numeric 10 POI7.1 POIJ.1
Return Number This is the number assigned to the
return for purposes of referencing the
return internally and with the customer
or vendor.
PIH-VENDOR Alpha 9 (Right Justified) POI7.1 POIJ.1
Vendor ID The vendor's identification code.
PIH-PURCH-FR-LOC Alpha 4 POI7.1 POIJ.1
Purchase From The vendor's purchase from location.
Location Code
PIH-BUYER-CODE Alpha 3 POI7.1 POIJ.1
Buyer Code The user defined buyer identifier.
PIH-BLKT-STD-AGRMT Alpha 30 POI7.1 POIJ.1
Blkt Std Agrmt This field has a value attached to it
when a purchase order is a release from
a blanket or standing order. The field
is equal to the agreement reference
number for the blanket or standing
order.
PIH-PO-DATE Numeric 8 (yyyymmdd) POI7.1 POIJ.1
Purchase Order Date
PIH-CURRENCY-CODE Alpha 5 POI7.1 POIJ.1
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PIH-ENT-CNV-RATE Signed 12.6 POI7.1 POIJ.1
Entered Conversion Currency conversion rate at Purchase
Rate Order entry time.
PIH-REC-CNV-RATE Signed 12.6 POI7.1 POIJ.1
Receiving Exchange Currency conversion rate for the
Rate Purchase Order at receiving time.
PIH-CURR-SET-FLAG Alpha 1 POI7.1 POIJ.1
Currency Set Flag Flag defines when the currency rate
has been set for the Purchase Order.
PIH-REVALUE-FLAG Alpha 1 POI7.1 POIJ.1
Revalue Currency will be re-evaluated when
Accounts Payable prints check in a
currency other than established on
the Purchase Order/Invoice.
PIH-DFLT-DL-DATE Numeric 8 (yyyymmdd) POI7.1 POIJ.1
Default Delivery Default Early Delivery Date.
Date
PIH-LOCATION Alpha 5 POI7.1 POIJ.1
Location Code This field contains a valid stocking
location within the company inventory.
PIH-SH-NAME Alpha 30 (Lower Case) POI7.1 POIJ.1
Ship To Name This is the ship to name for a non
standard ship to address.
PIH-SH-ADDR1 Alpha 30 (Lower Case) POI7.1 POIJ.1
Ship To Address This is the ship to address line one.
Line 1
PIH-SH-ADDR2 Alpha 30 (Lower Case) POI7.1 POIJ.1
Ship To Address This is the ship to address line two.
Line 2
PIH-SH-ADDR3 Alpha 30 (Lower Case) POI7.1 POIJ.1
Ship To Address This is the ship to address line
Line 3 three.
PIH-SH-ADDR4 Alpha 30 (Lower Case) POI7.1 POIJ.1
Ship To Address This is the ship to address line four.
Line 4
PIH-SH-CITY-ADDR5 Alpha 18 (Lower Case) POI7.1 POIJ.1
Ship To City or This is the ship to city or the
Address Line 5 ship to address line five.
PIH-SH-STATE-PROV Alpha 2 POI7.1 POIJ.1
Ship To State or This is the ship to state or the
Province ship to province.
PIH-SH-POST-CODE Alpha 10 (Lower Case) POI7.1 POIJ.1
Ship To Postal Code This is the ship to mail code.
PIH-SH-COUNTRY Alpha 30 (Lower Case) POI7.1 POIJ.1
Ship To Country Ship to country.
PIH-SH-COUNTY Alpha 25 (Lower Case) POI7.1 POIJ.1
Sh County
PIH-SH-PHONE-PREF Alpha 6 POI7.1 POIJ.1
Ship To Telephone This is the ship to phone number
Country Code prefix.
PIH-SH-PHONE Alpha 15 POI7.1 POIJ.1
Ship To Telephone This is the ship to phone number.
Number
PIH-SH-PHONE-EXT Alpha 5 POI7.1 POIJ.1
Ship To Telephone
Extension
PIH-SH-CONTACT Alpha 30 (Lower Case) POI7.1 POIJ.1
Ship To Contact Ship to contact.
PIH-NBR-LINES Numeric 6 POI7.1 POIJ.1
Number of Lines This is the number of detail lines.
PIH-CLOSED-LINES Numeric 6 POI7.1 POIJ.1
Closed Lines This is the number of closed detail
lines on the requisition. When the
number of closed lines equals the number
of lines, the requisition status will be
set to closed in RQ120.
PIH-DROPSHIP-FL Alpha 1 POI7.1 POIJ.1
Dropship Flag This flag indicates whether goods being
shipped by the vendor directly to a non
standard location need to have the
receiving process performed.
PIH-PRT-REC-FLAG Alpha 1 POI7.1 POIJ.1
Print Receiver Flag
PIH-FAX-PREFIX Alpha 6 POI7.1 POIJ.1
Fax Country Code The fax number prefix.
PIH-FAX-NUMBER Alpha 15 POI7.1 POIJ.1
Fax Number This field contains the fax number.
PIH-FAX-EXT Alpha 5 POI7.1 POIJ.1
Fax Extension This field contains the fax number
extension.
PIH-PROCESS-LEVEL Alpha 5 POI7.1 POIJ.1
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
PIH-WEIGHT Signed 9.3 POI7.1 POIJ.1
Unit Weight This field contains the unit weight of
the item based on the stocking UOM.
PIH-CUBIC-FEET Signed 9.3 POI7.1 POIJ.1
Cubic Feet This field contains the unit cubit feet
of the item based on the stocking UOM.
PIH-FREIGHT-TERMS Alpha 1 POI7.1 POIJ.1
Freight Terms 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.
PIH-FOB-CODE Alpha 3 POI7.1 POIJ.1
Shipping Term Code The user defined Free On Board Code.
PIH-SHIP-VIA Alpha 12 (Lower Case) POI7.1 POIJ.1
Ship Via Description
PIH-TERMS-CODE Alpha 5 POI7.1 POIJ.1
Terms Code
PIH-TAX-CODE Alpha 10 POI7.1 POIJ.1
Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
PIH-TOT-PRD-AMT Signed 15.2 POI7.1 POIJ.1
Total Product Amount This is the total product amount
associated with the Purchase Order.
PIH-TOT-TAXBLE-AMT Signed 15.2 POI7.1 POIJ.1
Tot Taxble Amt
PIH-LETTER-OF-CR Alpha 20 POI7.1 POIJ.1
Letter of Credit This field contains the letter of
credit.
PIH-TOT-ORDER-AMT Signed 15.2 POI7.1 POIJ.1
Total Order Amount
PIH-USER-DATE-1 Numeric 8 (yyyymmdd) POI7.1 POIJ.1
User Date 1
PIH-USER-DATE-2 Numeric 8 (yyyymmdd) POI7.1 POIJ.1
User Date 2
PIH-LAST-LINE-NBR Numeric 6 POI7.1 POIJ.1
Last Line Number This field contains the number of the
last line item added to the document. It
is used to determine what the next line
number is when you add another
item.
PIH-DFLT-TAXBL-FL Alpha 1 POI7.1 POIJ.1
Default Taxable Flag This taxable flag is used for
defaulting a 'Y'es, 'N'o into Special
and Service items when applying them to
a Purchase Order.
Non-stock and Inventory items will
have this flag defined in the Lawson
Inventory System.
PIH-DFLT-ACCT-UNIT Alpha 15 POI7.1 POIJ.1
Dflt Acct Unit
PIH-DFLT-ACCOUNT Numeric 6 POI7.1 POIJ.1
Dflt Account
PIH-DFLT-SUB-ACCT Numeric 4 POI7.1 POIJ.1
Dflt Sub Acct
PIH-DFLT-DIST-CO Numeric 4 POI7.1 POIJ.1
Dflt Dist Co
PIH-DFLT-ACTIVITY Alpha 15 POI7.1 POIJ.1
Dflt Activity
PIH-DFLT-ACCT-CAT Alpha 5 POI7.1 POIJ.1
Dflt Acct Cat
PIH-DFLT-REQ-LOC Alpha 5 POI7.1 POIJ.1
Dflt Req Loc
PIH-DFLT-REQUESTER Alpha 10 (Lower Case) POI7.1 POIJ.1
Dflt Requester
PIH-DFLT-DEL-TO Alpha 30 (Lower Case) POI7.1 POIJ.1
Dflt Del To
PIH-DFLT-SRC-DOC Alpha 10 POI7.1 POIJ.1
Dflt Src Doc
PIH-RELEASED-FL Alpha 1 POI7.1 POIJ.1
Released Released Flag. Record is now
available for further processing in
the system.
PIH-ISSUED-FLAG Alpha 1 POI7.1 POIJ.1
Issued Flag This is the issue status of the purchase
order source record. If the PO has been
issued at least once since the PO source
record was created, this flag will be
set to a value of "Y". Once set to "Y",
it never changes.
PIH-REVISED-FL Alpha 1 POI7.1 POIJ.1
Revised Flag
PIH-CANCELLED-FL Alpha 1 POI7.1 POIJ.1
Canceled Flag The canceled flag.
PIH-CLOSED-FL Alpha 1 POI7.1 POIJ.1
Closed Flag The Closed Flag.
PIH-LAST-ACTIVITY Numeric 8 (yyyymmdd) POI7.1 POIJ.1
Last Activity
PIH-CLOSE-DATE Numeric 8 (yyyymmdd) POI7.1 POIJ.1
Close Date Add on cost close date.
PIH-PO-USER-FLD-1 Alpha 1 POI7.1 POIJ.1
Purchase Order User Purchase Order header user field one.
Field 1
PIH-PO-USER-FLD-3 Alpha 10 (Lower Case) POI7.1 POIJ.1
Purchase Order User Purchase Order header user field two.
Field 3
PIH-PO-USER-FLD-5 Alpha 30 (Lower Case) POI7.1 POIJ.1
Purchase Order User Purchase Order header user field three.
Field 5
PIH-INVC-MTHD-CODE Alpha 3 POI7.1 POIJ.1
Invc Mthd Code The method the vendor is to use to
invoice the order (manual, EDI, or
evaluated receipts settlement).
PIH-ISSUE-METH Alpha 1 POI7.1 POIJ.1
Issue Meth Specifies the method that will be used
to issue the purchase order to the
vendor.
PIH-REVISIONS-INCL Alpha 1 POI7.1 POIJ.1
Revisions Incl Specifies what information will be
included when a revised Purchase Order
is re-issued.
You may specify that only the revised
information is included, along with
messages that indicate what was revised
(option O - Revisions Only).
Alternately, you may specify that the
entire PO is included, along with
messages that indicate the revisions.
Finally, you may specify that the entire
PO is re-issued. No revision messages
will appear.
If the PO has not been printed, or the
revised PO is not to be re-issued, this
field will be blank (Not Applicable).
PIH-ISSUE-PENDING Alpha 1 POI7.1 POIJ.1
Issue Pending Indicates whether the purchase order
will be processed if it meets the
selection criteria specified in PO120
(Purchase Order Issue).
PIH-USER-ID Alpha 10 (Lower Case) POI7.1 POIJ.1
User ID Name Contains the user ID of the person who
last changed this record.
PIH-PO-AOC-TOTAL Signed 15.2 POI7.1 POIJ.1
Po Aoc Total The total amount for add on costs that
are printed on the purchase order.
PIH-PO-TAX-TOTAL Signed 15.2 POI7.1 POIJ.1
Po Tax Total The total amount of invoiced taxes that
are printed on the purchase order.
PIH-PO-PRINT-TOTAL Signed 15.2 POI7.1 POIJ.1
Po Print Total The total amount printed on the purchase
order. This equals the total for
product, add on costs that are printed
on the purchase order, and taxes that
are printed on the purchase order.
PIH-POV-AOC-TOTAL Signed 15.2 POI7.1 POIJ.1
Pov Aoc Total The total for all add on costs from the
purchase order vendor, whether they are
printed on the purchase order or not.
PIH-POV-ITAX-TOTAL Signed 15.2 POI7.1 POIJ.1
Pov Itax Total The total tax that the purchase order
vendor will invoice. Includes invoiced
taxes for product as well as invoiced
taxes for add on costs from the
purchase order vendor, regardless of
whether the add on cost is printed on
the purchase order.
PIH-POV-GRD-TOTAL Signed 15.2 POI7.1 POIJ.1
Pov Grd Total The total amount the purchase order
vendor will invoice for this order.
Includes all product costs, add on costs
charged by the purchase order vendor,
and invoiced taxes for the above.
PIH-OV-AOC-TOTAL Signed 15.2 POI7.1 POIJ.1
Ov Aoc Total The total amount for add on costs from
third party vendors.
PIH-OV-ITAX-TOTAL Signed 15.2 POI7.1 POIJ.1
Ov Itax Total The total tax that third party vendors
will invoice for the purchase order.
PIH-OV-GRD-TOTAL Signed 15.2 POI7.1 POIJ.1
Ov Grd Total The total amount that third party
vendors will invoice for the purchase
order.
PIH-ACCR-TAX-TOTAL Signed 15.2 POI7.1 POIJ.1
Accr Tax Total The total accrued tax for the purchase
order.
PIH-OPEN-PO-AMT Signed 15.2 POI7.1 POIJ.1
Open PO Amount The portion of the total or extended
ordered amount that is still open --
that is, it has not been cancelled or
paid. This is always expressed in the
company base currency, and includes only
product costs (add on costs and taxes
are not included).
PIH-INTRASTAT-NBR Numeric 12
Intrastat Nbr The number assigned by the Intrastat
system to a transaction that involves
Intrastat reporting after it has been
added.
PIH-TO-CNTRY-CD Alpha 2
To Cntry Cd The Ship-To country code. Must be
defined in IN01.1 (Country
Maintenaance).
PIH-SHIP-TO-REGION Alpha 2
Ship To Region The ship-to region code.
Must be a valid region for the country,
defined in IN02.1 (Region
Maintenance).
POHDROUT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PIHSET1 COMPANY PO522
PO-CODE
PO-NUMBER
PO-RELEASE
CREATION-DATE
CREATION-TIME
PIHSET2 COMPANY
VENDOR
PO-CODE
PO-NUMBER
PO-RELEASE
PIHSET3 COMPANY POI7.1 POIJ.1
LOCATION
PO-CODE
PO-NUMBER
PO-RELEASE
POHDROUT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Hdrouticcout ICCOUT Required
PIH-COMPANY -> OWC-COMPANY
PIH-LOCATION -> OWC-LOCATION
POHDROUT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Hdroutlineout POLINEOUT
PIH-COMPANY -> PLT-COMPANY
PIH-PO-CODE -> PLT-PO-CODE
PIH-PO-NUMBER -> PLT-PO-NUMBER
PIH-PO-RELEASE -> PLT-PO-RELEASE
PIH-CREATION-DATE -> PLT-CREATION-DATE
PIH-CREATION-TIME -> PLT-CREATION-TIME
PLT-LINE-NBR
|
