This file is used to interface input from the Lawson Inventory Control and
Lawson Order Entry systems into the Purchase Order system. It is also used as
a model for the Lawson Requisition system. The originating systems load this
file and Purchase Order creates unreleased Purchase Orders from this file.
When Order Entry uses this file, Purchase Order responds (on this file) with
information about the Purchase Order created, such as Purchase Order number
and date, date and quantity received, and approved price and quantity.
FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
PIF-PROCURE-GROUP Element: Procure Group | Alpha 4 Type or select a procurement group. A
procurement group is a group of
companies that share a common
procurement effort. They buy items and
services together.
|
|
PIF-COMPANY Element: Company | Numeric 4 The company number.
|
|
PIF-ORIGIN-CD Element: Origin Code | Alpha 2 System origin code
RQ = Requisitions IC = Inventory Control OE = Order Entry CX = Case Carts PH = Pharmacy PT = Procurement Templates |
|
PIF-SOURCE-DOC-A Element: Source Doc A | Alpha 10 (Right Justified) This is the source document number if
the document number in the source system
is alphanumeric.
|
|
PIF-SOURCE-DOC-N Element: Source Doc N | Numeric 8 This is the source document number if
the document number in the source system
is numeric.
|
|
PIF-OPER-COMPANY Element: Oper Company | Numeric 4
|
|
PIF-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the line number.
|
|
PIF-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code.
|
|
PIF-BUYER-CODE Element: Buyer | Alpha 3 The user-defined buyer identifier.
|
|
PIF-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code.
|
|
PIF-PURCH-FR-LOC Element: Purch Fr Loc | Alpha 4 The vendor's purchase from location.
|
|
PIF-VENDOR-NAME Element: Vendor Name | Alpha 30 The requester can enter the recommended
vendor's name for the requested items.
|
|
PIF-VEN-ITEM Element: Item | Alpha 32 This field contains the item
identifier.
|
|
PIF-AGREEMENT-REF Element: Agreement Ref | Alpha 30
|
|
PIF-ITEM-TYPE Element: Item Type | Alpha 1 This field identifies the line item
type.
I = Inventoried N = Non-stock S = Service X = Special |
|
PIF-SERVICE-CODE Element: Service Code | Alpha 1
A = Amount Q = Quantity " " = Not Service Item |
|
PIF-ITEM Element: Item | Alpha 32 This field contains the item
identifier.
|
|
PIF-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field displays the description.
|
|
PIF-TAX-CODE Element: Tax Code | Alpha 10 This field contains a code representing
specific tax information. This must be
valid tax code in Tax.
|
|
PIF-TAXABLE-FLAG Element: Taxable Flag | Alpha 1 Defines if taxable.
N = No Y = Yes |
|
PIF-DROPSHIP-FL Element: Dropship Fl | Alpha 1 This field defines whether or not the
items ordered from this line are to be
dropshipped. If this flag is set to Yes,
then the drop-ship flag on the purchase
order created for this line item is also
Yes.
N = No Y = Yes |
|
PIF-ENTERED-UOM Element: Uom | Alpha 4 This field contains the valid stock
unit of measure for this item.
|
|
PIF-ENT-UOM-MULT Element: Uom Mult | Signed 13.7 This field contains the multiplier for
converting this unit of measure to the
stock unit of measure.
|
|
PIF-VPRI-UOM Element: Uom | Alpha 4 This field contains the valid stock
unit of measure for this item.
|
|
PIF-VPRI-UOM-MULT Element: Uom Mult | Signed 13.7 This field contains the multiplier for
converting this unit of measure to the
stock unit of measure.
|
|
PIF-QUANTITY Element: Quantity | Signed 13.4 The quantity to be ordered for this
item.
|
|
PIF-ENT-UNIT-CST Element: Intl Cost | Signed 18.5
|
|
PIF-OVERIDE-CST-FL Element: Overide Cst Fl | Alpha 1
Y = Yes N = No |
|
PIF-LOCATION Element: Location | Alpha 5 This field contains a valid stock
location within the company inventory.
|
|
PIF-SH-NAME Element: Name | Alpha 30 (Lower Case) This is the ship-to name for a
non-standard ship-to address.
|
|
PIF-SH-ADDR1 Element: Addr1 | Alpha 30 (Lower Case) Ship-to address line one.
|
|
PIF-SH-ADDR2 Element: Addr1 | Alpha 30 (Lower Case) Ship-to address line two.
|
|
PIF-SH-ADDR3 Element: Addr1 | Alpha 30 (Lower Case) Ship-to address line three.
|
|
PIF-SH-ADDR4 Element: Addr1 | Alpha 30 (Lower Case) Ship-to address line four.
|
|
PIF-SH-CITY-ADDR5 Element: City | Alpha 18 (Lower Case) This is the ship-to city or the ship-to
address line five.
|
|
PIF-SH-STATE-PROV Element: State Prov | Alpha 2 This is the ship-to state or the
ship-to province.
|
|
PIF-SH-POST-CODE Element: Sh Post Code | Alpha 10 (Lower Case) This is the ship-to mailing code.
|
|
PIF-SH-COUNTRY-CD Element: Sh Country Cd | Alpha 2
|
|
PIF-SH-COUNTRY Element: Country | Alpha 30 (Lower Case) This is the ship-to country.
|
|
PIF-SH-COUNTY Element: County | Alpha 25 (Lower Case) The county for the company address.
|
|
PIF-SH-PHONE-PREF Element: Phone Prefix | Alpha 6 This is the ship-to telephone number
prefix.
|
|
PIF-SH-PHONE Element: Phone | Alpha 15 This is the ship-to telephone number.
|
|
PIF-SH-PHONE-EXT Element: Phone Ext | Alpha 5 This field contains the telephone
extension number.
|
|
PIF-SH-CONTACT Element: Addr Contact | Alpha 30 (Lower Case) This is the ship-to contact.
|
|
PIF-REQ-DEL-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date
when this was created.
|
|
PIF-LATE-DL-DATE Element: Late Dl Date | Numeric 8 (yyyymmdd) This field contains the late delivery
date.
|
|
PIF-PROCESS-LEVEL Element: Process Level | Alpha 5 This field contains the process level,
which is the reporting hierarchy below
company.
|
|
PIF-PURCH-MAJCL Element: Major Class | Alpha 4
|
|
PIF-PURCH-MINCL Element: Minor Class | Alpha 4
|
|
PIF-MANUF-CODE Element: Manuf Code | Alpha 4 This field contains a user defined code
that indicates the manufacturer of an
item.
|
|
PIF-MANUF-DIVISION Element: Manuf Division | Alpha 4 This is a user defined code that
indicates which division of a
manufacturer is tied to an item.
|
|
PIF-MANUF-NBR Element: Manuf Nbr | Alpha 35 This is the identifier that the
manufacturer has assigned to an item.
|
|
PIF-MSDS-FLAG Element: All Flag | Alpha 1
|
|
PIF-USER-DATE-3 Element: Date | Numeric 8 (yyyymmdd) This field displays the system date
when this was created.
|
|
PIF-USER-DATE-4 Element: Date | Numeric 8 (yyyymmdd) This field displays the system date
when this was created.
|
|
PIF-PO-USER-FLD-2 Element: Po User Fld 2 | Alpha 2 Purchase order line user defined field.
|
|
PIF-PO-USER-FLD-4 Element: User Fld2 | Alpha 30 (Lower Case)
|
|
PIF-PO-USER-FLD-6 Element: User Fld3 | Alpha 15 (Lower Case)
|
|
PIF-USER-DATE-1 Element: Date | Numeric 8 (yyyymmdd) This field displays the system date
when this was created.
|
|
PIF-USER-DATE-2 Element: Date | Numeric 8 (yyyymmdd) This field displays the system date
when this was created.
|
|
PIF-PO-USER-FLD-1 Element: Po User Fld 1 | Alpha 1 Purchase Order header user field one.
|
|
PIF-PO-USER-FLD-3 Element: User Field2 | Alpha 30 This is the second user definable
field. This field can be used to enter
any data that the user wants to capture
for this item. The title of the field
is setup in IC00.
|
|
PIF-PO-USER-FLD-5 Element: User Fld2 | Alpha 30 (Lower Case)
|
|
PIF-INSP-REQ-FL Element: All Flag | Alpha 1 This flag indicates whether this item
has to be inspected when received via
purchase order.
N = No Y = Yes |
|
PIF-CERT-REQ-FL Element: Cert Req Fl | Alpha 1 This flag indicates whether a
certification is required for this line
when it is purchased. This field value
is passed to the purchase order when the
purchase order line is created. Valid
values are:
N = Certification not required.
Y = Certification required.
|
|
PIF-COST-OPTION Element: Cost Option | Alpha 1
1 = Cost Required 2 = No Charge 3 = Vendor Determined |
|
PIF-REQ-LOCATION Element: Req Location | Alpha 5 The location requisitioning items. This
location can be an inventory or
non-stock location.
|
|
PIF-REQUESTER Element: Requester | Alpha 10 (Lower Case) This is the person who requested this
requisition.
|
|
PIF-DELIVER-TO Element: Deliver To | Alpha 30 (Lower Case) This field can be used to specify where
to deliver the items. This field prints
on the delivery ticket when you run
Delivery Ticket Print program.
|
|
PIF-COST-CD Element: Cost Cd | Alpha 1 Unit cost origin code
E = Entered L = Last Cost C = Contract T = Catalog/Quote B = Blanket P = Last PO Created I = Inventory Cost G = Punchout Y = Tier - Company Participant N = Tier - IC Location Participant Q = Tier - Req Loc Participant W = Website V = Procurement Template Agrmt Ref |
|
PIF-ALLOC-PRI Element: Alloc Pri | Numeric 2 This is the allocation priority for
this requisition. Valid values are from
0 to 99, with 99 being the highest. This
field defaults to 50. This field is
used in the Warehouse module to
determine the order in which inventory
demand gets allocated.
|
|
PIF-RQSRC-MACHINE Element: Rqsrc Machine | Alpha 6
DROYAL ESIOB HBOC OMNICL PAREXC PERSE PYXIS INTER |
|
PIF-PAR-ORDER-ID Element: Par Order Id | Alpha 20
|
|
PIF-PUNCHOUT-ID Element: Punchout Id | Alpha 64
|
|
PIF-TRAN-CURR-CODE Element: Currency Code | Alpha 5 This field contains the company base
currency code established in Company
(GL10.1 ).
|
|
PIF-CNV-RATE Element: Cnv Rate | Signed 14.7
|
|
PIF-POB-NAME Element: Name | Alpha 30 (Lower Case) Displays the company description.
|
|
PIF-POB-ADDR1 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of
address information.
|
|
PIF-POB-ADDR2 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of
address information.
|
|
PIF-POB-ADDR3 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of
address information.
|
|
PIF-POB-ADDR4 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of
address information.
|
|
PIF-POB-CITY-ADDR5 Element: City | Alpha 18 (Lower Case) This field contains the city of the
address.
|
|
PIF-POB-STATE-PROV Element: State Prov | Alpha 2 The state or province.
|
|
PIF-POB-POSTAL-CD Element: Postal Code | Alpha 10 (Lower Case) This field contains the postal code.
|
|
PIF-POB-COUNTRY-CD Element: Country Code | Alpha 2 The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
|
|
PIF-POB-COUNTY Element: County | Alpha 25 (Lower Case) The county for the company address.
|
|
PIF-POB-CONTACT Element: Addr Contact | Alpha 30 (Lower Case) This is the name of the main contact.
|
|
PIF-EXCEPTION-FL Element: Exception Fl | Alpha 1
" " = No Exception Y = Exception |
|
PIF-WORKSHEET-FL Element: Worksheet Fl | Numeric 1
0 = No 1 = Yes Not Selected 2 = Yes Selected |
|
PIF-ONE-SRC-ONE-PO Element: One Src One Po | Numeric 1
0 = No 1 = Yes |
|
PIF-EVT-WORKSHEET Element: Evt Worksheet | Numeric 1
0 = No 1 = Yes |
|
PIF-COMMODITY-CODE Element: Commodity Code | Alpha 35
|
|
PIF-P-CARD-FLAG Element: Flag Num | Numeric 1
|
|
PIF-PCARD-NBR Element: Pcard Nbr | Alpha 16
|
|
PIF-POB-PHONE-PREF Element: Phone Prefix | Alpha 6
|
|
PIF-POB-PHONE Element: Phone | Alpha 15
|
|
PIF-POB-PHONE-EXT Element: Phone Ext | Alpha 5
|
|
PIF-POB-EMAIL-ADDR Element: Email Address | Alpha 60 (Lower Case)
|
|
PIF-PROD-TAX-CAT Element: Prod Tax Cat | Alpha 15
|
|
PIF-GTIN Element: Gtin | Numeric 14
|
|
PIF-PO-USER-FLD-7 Element: User Fld 7 | Alpha 10 (Lower Case)
|
|
PIF-EAM-OPER-NBR Element: Operation Nbr | Numeric 4
|
|
PIF-EAM-SEQ-NBR Element: Seq Nbr | Numeric 4
|
|
PIF-EAM-WO-NBR Element: Work Order | Numeric 8
|
|
PIF-PVN-OBJ-ID Element: Obj Id | Numeric 12
|
|
PIF-PATIENT-LNAME Element: Last Name | Alpha 30 (Lower Case) This is the patient last name, used for
item tracking purposes.
|
|
PIF-PATIENT-FNAME Element: First Name | Alpha 15 (Lower Case) This is the patient first name, used for
item tracking purposes.
|
|
PIF-PATIENT-MINIT Element: Middle Init | Alpha 1 This is the patient middle initial, used
for item tracking purposes.
|
|
PIF-PAT-VISIT-NBR Element: Visit Nbr | Alpha 12 This is the patient visit number, used
for item tracking purposes.
|
|
PIF-SERIAL Element: Serial | Alpha 16
|
|
PIF-HPP-OBJ-ID Element: Obj Id | Numeric 12
|
|
PIF-CN-CODE Element: Consign Code | Alpha 2
|
|
PIF-GLBL-LINE-TYPE Element: Glbl Line Type | Alpha 15
|
|
PIF-GLBL-DOC-TYPE Element: Glbl Doc Type | Alpha 10
|
|