 |
Lawson Insight Technical Documentation |
|
POINTERFAC FILE
Interface File
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.
REFERENCED BY
POIF.1
UPDATED BY
CXCP.1 DR100 IC140 IC141 IC142 IC531
IC83.1 POCP.1 POIJ.1 RQ11.1 RQ12.1 RQ13.1
RQ140 RQ300 RQ40.1 RQ41.1 RQ42.1 RQ44.1
RQ44.2 WH130 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PIF-PROCURE-GROUP Alpha 4 CXCP.1 DR100
Procure Group This field contains the identifier for a IC140 IC141
group of companies that share a common IC142 IC531
procurement effort. They buy items and IC83.1 POCP.1
services together. POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-COMPANY Numeric 4 CXCP.1 DR100
Company The company number. IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-ORIGIN-CD Alpha 2 CXCP.1 DR100
Origin Code This field identifies the system that IC140 IC141
created this record. IC142 IC531
RQ = Requisitions IC83.1 POCP.1
IC = Inventory Control POIJ.1 RQ11.1
OE = Order Entry RQ12.1 RQ13.1
CX = Case Carts RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-SOURCE-DOC-A Alpha 10 (Right Justified) CXCP.1 DR100
Source Doc A This is the source document number if IC140 IC141
the document number in the source system IC142 IC531
is alphanumeric. IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-SOURCE-DOC-N Numeric 8 CXCP.1 DR100
Source Doc N This is the source document number if IC140 IC141
the document number in the source system IC142 IC531
is numeric. IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-OPER-COMPANY Numeric 4 CXCP.1 DR100
Oper Company IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-LINE-NBR Numeric 6 CXCP.1 DR100
Line Number This field contains the line number. IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-PO-CODE Alpha 4 CXCP.1 DR100
Po Code This is the purchase order code. IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-BUYER-CODE Alpha 3 CXCP.1 DR100
Buyer Code The user-defined buyer identifier. IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-VENDOR Alpha 9 (Right Justified) CXCP.1 DR100
Vendor ID The vendor's identification code. IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-PURCH-FR-LOC Alpha 4 CXCP.1 DR100
Purchase From The vendor's purchase from location. IC140 IC141
Location Code IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-VENDOR-NAME Alpha 30 CXCP.1 DR100
Vendor Name The requester can enter the recommended IC140 IC141
vendor's name for the requested items. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-VEN-ITEM Alpha 32 CXCP.1 DR100
Vendor Item The vendor's item identifer. IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-AGREEMENT-REF Alpha 30 CXCP.1 DR100
Agreement Ref IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-ITEM-TYPE Alpha 1 CXCP.1 DR100
Item Type This field identifies the line item IC140 IC141
type. IC142 IC531
I = Inventoried IC83.1 POCP.1
N = Non-stock POIJ.1 RQ11.1
S = Service RQ12.1 RQ13.1
X = Special RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-SERVICE-CODE Alpha 1 CXCP.1 DR100
Service Code A = Amount IC140 IC141
Q = Quantity IC142 IC531
" " = Not Service Item IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-ITEM Alpha 32 CXCP.1 DR100
Item Number This field contains the item IC140 IC141
identifier. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-DESCRIPTION Alpha 30 (Lower Case) CXCP.1 DR100
Description This field displays the description. IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-TAX-CODE Alpha 10 CXCP.1 DR100
Tax Code This field contains a code representing IC140 IC141
specific tax information. This must be IC142 IC531
valid tax code in the Tax system. IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-TAXABLE-FLAG Alpha 1 CXCP.1 DR100
Taxable or Defines if taxable. IC140 IC141
Non-Taxable Flag N = No IC142 IC531
Y = Yes IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-DROPSHIP-FL Alpha 1 CXCP.1 DR100
Dropship Flag This field defines whether or not the IC140 IC141
items ordered from this line are to be IC142 IC531
dropshipped. If this flag is set to Yes, IC83.1 POCP.1
then the drop-ship flag on the purchase POIJ.1 RQ11.1
order created for this line item is also RQ12.1 RQ13.1
Yes. RQ140 RQ300
N = No RQ40.1 RQ41.1
Y = Yes RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-ENTERED-UOM Alpha 4 CXCP.1 DR100
Entered Unit of This is the valid Unit Of Measure of IC140 IC141
Measure the entered quantity. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-ENT-UOM-MULT Signed 13.7 CXCP.1 DR100
Entered UOM This is the multiplier that relates the IC140 IC141
Multiplier entered UOM to stock UOM. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-VPRI-UOM Alpha 4 CXCP.1 DR100
Vendor Price Unit This is the vendor pricing unit of IC140 IC141
of Measure measure. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-VPRI-UOM-MULT Signed 13.7 CXCP.1 DR100
Vendor Price UOM This is the vendor pricing unit of IC140 IC141
Multiplier measure multiplier. It is used to IC142 IC531
convert unit cost to stock unit of IC83.1 POCP.1
measure terms. POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-QUANTITY Signed 13.4 CXCP.1 DR100
Quantity The quantity to be ordered for this IC140 IC141
item. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-ENT-UNIT-CST Signed 13.5 CXCP.1 DR100
Entered Unit Cost The entered unit cost. IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-OVERIDE-CST-FL Alpha 1 CXCP.1 DR100
Overide Cst Fl Y = Yes IC140 IC141
N = No IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-LOCATION Alpha 5 CXCP.1 DR100
Location Code This field contains a valid stock IC140 IC141
location within the company inventory. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-SH-NAME Alpha 30 (Lower Case) CXCP.1 DR100
Ship To Name This is the ship-to name for a IC140 IC141
non-standard ship-to address. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-SH-ADDR1 Alpha 30 (Lower Case) CXCP.1 DR100
Ship To Address Ship-to address line one. IC140 IC141
Line 1 IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-SH-ADDR2 Alpha 30 (Lower Case) CXCP.1 DR100
Ship To Address Ship-to address line two. IC140 IC141
Line 2 IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-SH-ADDR3 Alpha 30 (Lower Case) CXCP.1 DR100
Ship To Address Ship-to address line three. IC140 IC141
Line 3 IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-SH-ADDR4 Alpha 30 (Lower Case) CXCP.1 DR100
Ship To Address Ship-to address line four. IC140 IC141
Line 4 IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-SH-CITY-ADDR5 Alpha 18 (Lower Case) CXCP.1 DR100
Ship To City or This is the ship-to city or the ship-to IC140 IC141
Address Line 5 address line five. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-SH-STATE-PROV Alpha 2 CXCP.1 DR100
Ship To State or This is the ship-to state or the IC140 IC141
Province ship-to province. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-SH-POST-CODE Alpha 10 (Lower Case) CXCP.1 DR100
Ship To Postal Code This is the ship-to mailing code. IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-SH-COUNTRY Alpha 30 (Lower Case) CXCP.1 DR100
Ship To Country This is the ship-to country. IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-SH-COUNTY Alpha 25 (Lower Case) CXCP.1 DR100
Sh County IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-SH-PHONE-PREF Alpha 6 CXCP.1 DR100
Ship To Telephone This is the ship-to telephone number IC140 IC141
Country Code prefix. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-SH-PHONE Alpha 15 CXCP.1 DR100
Ship To Telephone This is the ship-to telephone number. IC140 IC141
Number IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-SH-PHONE-EXT Alpha 5 CXCP.1 DR100
Ship To Telephone IC140 IC141
Extension IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-SH-CONTACT Alpha 30 (Lower Case) CXCP.1 DR100
Ship To Contact This is the ship-to contact. IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-REQ-DEL-DATE Numeric 8 (yyyymmdd) CXCP.1 DR100
Requested Delivery This is the date that the originator IC140 IC141
Date would like to receive the goods. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-LATE-DL-DATE Numeric 8 (yyyymmdd) CXCP.1 DR100
Late Delivery Date This field contains the late delivery IC140 IC141
date. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-PROCESS-LEVEL Alpha 5 CXCP.1 DR100
Process Level This field contains the process level, IC140 IC141
which is the reporting hierarchy below IC142 IC531
company. IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-PURCH-MAJCL Alpha 4 CXCP.1 DR100
Major Purchasing The user defined Major Purchasing Class IC140 IC141
Class identifier. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-PURCH-MINCL Alpha 4 CXCP.1 DR100
Minor Purchasing The user defined Minor purchasing Class IC140 IC141
Class identifier. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-MANUF-CODE Alpha 4 CXCP.1 DR100
Manufacturer's Code This field contains a user defined code IC140 IC141
that indicates the manufacturer of an IC142 IC531
item. IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-MANUF-DIVISION Alpha 4 CXCP.1 DR100
Manufacturer's This is a user defined code that IC140 IC141
Division indicates which division of a IC142 IC531
manufacturer is tied to an item. IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-MANUF-NBR Alpha 15 CXCP.1 DR100
Manufacturer's Item This is the identifier that the IC140 IC141
Number manufacturer has assigned to an item. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-MSDS-FLAG Alpha 1 CXCP.1 DR100
Material Safety This flag indicates if this item IC140 IC141
DataSheet Flag requires a Material Safety Data Sheet. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-USER-DATE-3 Numeric 8 (yyyymmdd) CXCP.1 DR100
User Date 3 This field contains the third IC140 IC141
user-definable date. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-USER-DATE-4 Numeric 8 (yyyymmdd) CXCP.1 DR100
User Date 4 This field contains the fourth IC140 IC141
user-definable date. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-PO-USER-FLD-2 Alpha 2 CXCP.1 DR100
Purchase Order User Purchase order line user defined field. IC140 IC141
Field 2 IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-PO-USER-FLD-4 Alpha 30 (Lower Case) CXCP.1 DR100
Purchase Order User Purchase order line user defined field. IC140 IC141
Field 4 IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-PO-USER-FLD-6 Alpha 15 (Lower Case) CXCP.1 DR100
Purchase Order User Purchase order line user defined field. IC140 IC141
Field 6 IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-USER-DATE-1 Numeric 8 (yyyymmdd) CXCP.1 DR100
User Date 1 IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-USER-DATE-2 Numeric 8 (yyyymmdd) CXCP.1 DR100
User Date 2 IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-PO-USER-FLD-1 Alpha 1 CXCP.1 DR100
Purchase Order User Purchase Order header user field one. IC140 IC141
Field 1 IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-PO-USER-FLD-3 Alpha 10 (Lower Case) CXCP.1 DR100
Purchase Order User Purchase Order header user field two. IC140 IC141
Field 3 IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-PO-USER-FLD-5 Alpha 30 (Lower Case) CXCP.1 DR100
Purchase Order User Purchase Order header user field three. IC140 IC141
Field 5 IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-INSP-REQ-FL Alpha 1 CXCP.1 DR100
Inspection Required This flag indicates whether this item IC140 IC141
Flag has to be inspected when received via IC142 IC531
purchase order. IC83.1 POCP.1
N = No POIJ.1 RQ11.1
Y = Yes RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-CERT-REQ-FL Alpha 1 CXCP.1 DR100
Certification This flag indicates whether a IC140 IC141
Required Flag certification is required for this line IC142 IC531
when it is purchased. This field value IC83.1 POCP.1
is passed to the purchase order when the POIJ.1 RQ11.1
purchase order line is created. Valid RQ12.1 RQ13.1
values are: RQ140 RQ300
"N" = Certification not required. RQ40.1 RQ41.1
"Y" = Certification required. RQ42.1 RQ44.1
N = No RQ44.2 WH130
Y = Yes WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-COST-OPTION Alpha 1 CXCP.1 DR100
Cost Option 1 = Cost Required IC140 IC141
2 = No Charge IC142 IC531
3 = Vendor Determined IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-REQ-LOCATION Alpha 5 CXCP.1 DR100
To Location The location requisitioning items. This IC140 IC141
location can be an inventory or nonstock IC142 IC531
location. IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-REQUESTER Alpha 10 (Lower Case) CXCP.1 DR100
Requester This is the person who requested this IC140 IC141
requisition. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-DELIVER-TO Alpha 30 (Lower Case) CXCP.1 DR100
Deliver To Name This field can be used to specify where IC140 IC141
to deliver the items. This field prints IC142 IC531
on the delivery ticket when you run IC83.1 POCP.1
Delivery Ticket Print program. POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-COST-CD Alpha 1 CXCP.1 DR100
Unit Cost Origin Unit cost origin code IC140 IC141
Code E = Entered IC142 IC531
L = Last Cost IC83.1 POCP.1
C = Contract POIJ.1 RQ11.1
T = Catalog/Quote RQ12.1 RQ13.1
B = Blanket RQ140 RQ300
P = Last PO Created RQ40.1 RQ41.1
I = Inventory Issue Cost RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIF-ALLOC-PRI Numeric 2 CXCP.1 DR100
Alloc Pri This is the allocation priority for IC140 IC141
this requisition. Valid values are from IC142 IC531
0 to 99, with 99 being the highest. This IC83.1 POCP.1
field defaults to 50. This field is POIJ.1 RQ11.1
used in the Warehouse module to RQ12.1 RQ13.1
determine the order in which inventory RQ140 RQ300
demand gets allocated. RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
POINTERFAC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PIFSET1 PROCURE-GROUP CXCP.1 DR100
COMPANY IC140 IC141
VENDOR IC142 IC531
PURCH-FR-LOC IC83.1 POCP.1
ORIGIN-CD POIF.1 POIJ.1
SOURCE-DOC-N RQ11.1 RQ12.1
SOURCE-DOC-A RQ13.1 RQ140
OPER-COMPANY RQ300 RQ40.1
REQ-LOCATION RQ41.1 RQ42.1
LINE-NBR RQ44.1 RQ44.2
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
...
PIFSET2 COMPANY Subset
VENDOR Where VENDOR != Spaces
PURCH-FR-LOC And (ENT-UNIT-CST != Zeroes
BUYER-CODE Or COST-OPTION = "2"
PO-CODE Or COST-OPTION = "3" )
PROCESS-LEVEL
ITEM
ORIGIN-CD
SOURCE-DOC-A
SOURCE-DOC-N
OPER-COMPANY
REQ-LOCATION
LINE-NBR
PIFSET3 PROCURE-GROUP CXCP.1 DR100
COMPANY IC140 IC141
ITEM IC142 IC531
VENDOR IC83.1 POCP.1
PURCH-FR-LOC POIJ.1 RQ11.1
ORIGIN-CD RQ12.1 RQ13.1
SOURCE-DOC-N RQ140 RQ300
SOURCE-DOC-A RQ40.1 RQ41.1
OPER-COMPANY RQ42.1 RQ44.1
REQ-LOCATION RQ44.2 WH130
LINE-NBR WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
...
PIFSET4 PROCURE-GROUP
COMPANY
DESCRIPTION
VENDOR
PURCH-FR-LOC
ORIGIN-CD
SOURCE-DOC-N
SOURCE-DOC-A
OPER-COMPANY
REQ-LOCATION
LINE-NBR
PIFSET5 PROCURE-GROUP
COMPANY
ALLOC-PRI
VENDOR
PURCH-FR-LOC
ORIGIN-CD
SOURCE-DOC-N
SOURCE-DOC-A
OPER-COMPANY
REQ-LOCATION
LINE-NBR
PIFSET6 PROCURE-GROUP
COMPANY
REQ-DEL-DATE
VENDOR
PURCH-FR-LOC
ORIGIN-CD
SOURCE-DOC-N
SOURCE-DOC-A
OPER-COMPANY
REQ-LOCATION
LINE-NBR
PIFSET7 COMPANY Subset
AGREEMENT-REF Where COST-CD = "B"
ORIGIN-CD And (ENT-UNIT-CST != Zeroes
SOURCE-DOC-A Or COST-OPTION = "2"
SOURCE-DOC-N Or COST-OPTION = "3" )
OPER-COMPANY
REQ-LOCATION
LINE-NBR
PIFSET8 PROCURE-GROUP Subset
COMPANY Where ORIGIN-CD = "OE"
ORIGIN-CD
SOURCE-DOC-N
SOURCE-DOC-A
LINE-NBR
VENDOR
PURCH-FR-LOC
OPER-COMPANY
REQ-LOCATION
POINTERFAC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
PIF-COMPANY -> CPY-COMPANY (CPYSET1)
Coline COLINE Required
PIF-COMPANY -> COL-COMPANY
PIF-SOURCE-DOC-N -> COL-ORDER-NBR
PIF-LINE-NBR -> COL-LINE-NBR
Cxprefitem CXPREFITEM Required
When PIF-ORIGIN-CD = "CX"
PIF-OPER-COMPANY -> CPI-COMPANY
PIF-SOURCE-DOC-N -> CPI-IF-REF-NBR
Iccompany ICCOMPANY Required
PIF-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
PIF-COMPANY -> ICL-COMPANY
PIF-LOCATION -> ICL-LOCATION
Itemloc ITEMLOC Required
When PIF-ITEM-TYPE = "I"
PIF-COMPANY -> ITL-COMPANY
PIF-LOCATION -> ITL-LOCATION
PIF-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
When PIF-ITEM-TYPE = "I"
Or PIF-ITEM-TYPE = "N"
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
PIF-ITEM -> ITE-ITEM
Pocompany POCOMPANY Required
PIF-COMPANY -> PCY-COMPANY
Reqline REQLINE Required
PIF-OPER-COMPANY -> RLN-COMPANY
PIF-SOURCE-DOC-N -> RLN-REQ-NUMBER
PIF-LINE-NBR -> RLN-LINE-NBR
Vendor APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
PIF-VENDOR -> VEN-VENDOR
POINTERFAC FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Mmdist MMDIST
Valid When PIF-ITEM-TYPE != "I"
PIF-COMPANY -> MMD-COMPANY
PIF-ORIGIN-CD -> MMD-SYSTEM-CD
PIF-SOURCE-DOC-A -> MMD-DOC-NUMBER
PIF-SOURCE-DOC-N -> MMD-DOC-NBR-NUM
PIF-REQ-LOCATION -> MMD-REQ-LOCATION
PIF-LINE-NBR -> MMD-LINE-NBR
MMD-LINE-SEQ
Pointaoc POINTAOC
PIF-COMPANY -> PIA-COMPANY
PIF-SOURCE-DOC-N -> PIA-SOURCE-DOC-N
PIF-LINE-NBR -> PIA-LINE-NBR
PIA-AOC-CODE
|