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
This field contains the identifier for
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 |
|
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 |
|
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-ORIGINAL-UOM
Element: Uom | Alpha 4
|
|
PIF-ORIGINAL-COST
Element: Intl Cost | Signed 18.5
|
|
