 |
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 POIG.1
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 CXCP.1 DR100 IC140 IC141 IC142
IC28.1 IC531 IC83.1 MA180 MA43.9 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.3
MA67.1 MA67.2 MA70.1 MAI1.1 PO100 PO101
PO122 PO131 PO20.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO33.1
PO34.1 PO35.1 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 POCP.1 POI3.1 POIE.1
POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1
RQ12.1 RQ13.1 RQ140 RQ300 RQ35.1 RQ40.1
RQ41.1 RQ42.1 RQ44.1 RQ44.2 RQ500 RQIB.1
RQIF.1 WH130 WH132 WH190 WH20.2 WH20.7
WH222 WH25.1 WH25.2 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PIF-PROCURE-GROUP Alpha 4 AP125 AP126
Procure Group This field contains the identifier for a AP131 AP25.1
group of companies that share a common AP25.2 AP26.1
procurement effort. They buy items and AP27.1 CXCP.1
services together. DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-COMPANY Numeric 4 AP125 AP126
Company The company number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-ORIGIN-CD Alpha 2 AP125 AP126
Origin Code This field identifies the system that AP131 AP25.1
created this record. AP25.2 AP26.1
RQ = Requisitions AP27.1 CXCP.1
IC = Inventory Control DR100 IC140
OE = Order Entry IC141 IC142
CX = Case Carts IC28.1 IC531
PH = Pharmacy IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-SOURCE-DOC-A Alpha 10 (Right Justified) AP125 AP126
Source Doc A This is the source document number if AP131 AP25.1
the document number in the source system AP25.2 AP26.1
is alphanumeric. AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-SOURCE-DOC-N Numeric 8 AP125 AP126
Source Doc N This is the source document number if AP131 AP25.1
the document number in the source system AP25.2 AP26.1
is numeric. AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-OPER-COMPANY Numeric 4 AP125 AP126
Oper Company AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-LINE-NBR Numeric 6 AP125 AP126
Line Number This field contains the line number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-PO-CODE Alpha 4 AP125 AP126
Po Code This is the purchase order code. AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-BUYER-CODE Alpha 3 AP125 AP126
Buyer Code The user-defined buyer identifier. AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-VENDOR Alpha 9 (Right Justified) AP125 AP126
Vendor ID The vendor's identification code. AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-PURCH-FR-LOC Alpha 4 AP125 AP126
Purchase From The vendor's purchase from location. AP131 AP25.1
Location Code AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-VENDOR-NAME Alpha 30 AP125 AP126
Vendor Name The requester can enter the recommended AP131 AP25.1
vendor's name for the requested items. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-VEN-ITEM Alpha 32 AP125 AP126
Vendor Item The vendor's item identifer. AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-AGREEMENT-REF Alpha 30 AP125 AP126
Agreement Ref AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-ITEM-TYPE Alpha 1 AP125 AP126
Item Type This field identifies the line item AP131 AP25.1
type. AP25.2 AP26.1
I = Inventoried AP27.1 CXCP.1
N = Non-stock DR100 IC140
S = Service IC141 IC142
X = Special IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-SERVICE-CODE Alpha 1 AP125 AP126
Service Code A = Amount AP131 AP25.1
Q = Quantity AP25.2 AP26.1
" " = Not Service Item AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-ITEM Alpha 32 AP125 AP126
Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-DESCRIPTION Alpha 30 (Lower Case) AP125 AP126
Description This field displays the description. AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-TAX-CODE Alpha 10 AP125 AP126
Tax Code This field contains a code representing AP131 AP25.1
specific tax information. This must be AP25.2 AP26.1
valid tax code in the Tax system. AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-TAXABLE-FLAG Alpha 1 AP125 AP126
Taxable or Defines if taxable. AP131 AP25.1
Non-Taxable Flag N = No AP25.2 AP26.1
Y = Yes AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-DROPSHIP-FL Alpha 1 AP125 AP126
Dropship Flag This field defines whether or not the AP131 AP25.1
items ordered from this line are to be AP25.2 AP26.1
dropshipped. If this flag is set to Yes, AP27.1 CXCP.1
then the drop-ship flag on the purchase DR100 IC140
order created for this line item is also IC141 IC142
Yes. IC28.1 IC531
N = No IC83.1 MA180
Y = Yes MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-ENTERED-UOM Alpha 4 AP125 AP126
Entered Unit of This is the valid Unit Of Measure of AP131 AP25.1
Measure the entered quantity. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-ENT-UOM-MULT Signed 13.7 AP125 AP126
Entered UOM This is the multiplier that relates the AP131 AP25.1
Multiplier entered UOM to stock UOM. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-VPRI-UOM Alpha 4 AP125 AP126
Vendor Price Unit This is the vendor pricing unit of AP131 AP25.1
of Measure measure. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-VPRI-UOM-MULT Signed 13.7 AP125 AP126
Vendor Price UOM This is the vendor pricing unit of AP131 AP25.1
Multiplier measure multiplier. It is used to AP25.2 AP26.1
convert unit cost to stock unit of AP27.1 CXCP.1
measure terms. DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-QUANTITY Signed 13.4 AP125 AP126
Quantity The quantity to be ordered for this AP131 AP25.1
item. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-ENT-UNIT-CST Signed 13.5 AP125 AP126
Entered Unit Cost The entered unit cost. AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-OVERIDE-CST-FL Alpha 1 AP125 AP126
Overide Cst Fl Y = Yes AP131 AP25.1
N = No AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-LOCATION Alpha 5 AP125 AP126
Location Code This field contains a valid stock AP131 AP25.1
location within the company inventory. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-SH-NAME Alpha 30 (Lower Case) AP125 AP126
Ship To Name This is the ship-to name for a AP131 AP25.1
non-standard ship-to address. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-SH-ADDR1 Alpha 30 (Lower Case) AP125 AP126
Ship To Address Ship-to address line one. AP131 AP25.1
Line 1 AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-SH-ADDR2 Alpha 30 (Lower Case) AP125 AP126
Ship To Address Ship-to address line two. AP131 AP25.1
Line 2 AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-SH-ADDR3 Alpha 30 (Lower Case) AP125 AP126
Ship To Address Ship-to address line three. AP131 AP25.1
Line 3 AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-SH-ADDR4 Alpha 30 (Lower Case) AP125 AP126
Ship To Address Ship-to address line four. AP131 AP25.1
Line 4 AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-SH-CITY-ADDR5 Alpha 18 (Lower Case) AP125 AP126
Ship To City or This is the ship-to city or the ship-to AP131 AP25.1
Address Line 5 address line five. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-SH-STATE-PROV Alpha 2 AP125 AP126
Ship To State or This is the ship-to state or the AP131 AP25.1
Province ship-to province. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-SH-POST-CODE Alpha 10 (Lower Case) AP125 AP126
Ship To Postal Code This is the ship-to mailing code. AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-SH-COUNTRY Alpha 30 (Lower Case) AP125 AP126
Ship To Country This is the ship-to country. AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-SH-COUNTY Alpha 25 (Lower Case) AP125 AP126
Sh County AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-SH-PHONE-PREF Alpha 6 AP125 AP126
Ship To Telephone This is the ship-to telephone number AP131 AP25.1
Country Code prefix. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-SH-PHONE Alpha 15 AP125 AP126
Ship To Telephone This is the ship-to telephone number. AP131 AP25.1
Number AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-SH-PHONE-EXT Alpha 5 AP125 AP126
Ship To Telephone AP131 AP25.1
Extension AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-SH-CONTACT Alpha 30 (Lower Case) AP125 AP126
Ship To Contact This is the ship-to contact. AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-REQ-DEL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Requested Delivery This is the date that the originator AP131 AP25.1
Date would like to receive the goods. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-LATE-DL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Late Delivery Date This field contains the late delivery AP131 AP25.1
date. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-PROCESS-LEVEL Alpha 5 AP125 AP126
Process Level This field contains the process level, AP131 AP25.1
which is the reporting hierarchy below AP25.2 AP26.1
company. AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-PURCH-MAJCL Alpha 4 AP125 AP126
Major Purchasing The user defined Major Purchasing Class AP131 AP25.1
Class identifier. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-PURCH-MINCL Alpha 4 AP125 AP126
Minor Purchasing The user defined Minor purchasing Class AP131 AP25.1
Class identifier. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-MANUF-CODE Alpha 4 AP125 AP126
Manufacturer's Code This field contains a user defined code AP131 AP25.1
that indicates the manufacturer of an AP25.2 AP26.1
item. AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-MANUF-DIVISION Alpha 4 AP125 AP126
Manufacturer's This is a user defined code that AP131 AP25.1
Division indicates which division of a AP25.2 AP26.1
manufacturer is tied to an item. AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-MANUF-NBR Alpha 15 AP125 AP126
Manufacturer's Item This is the identifier that the AP131 AP25.1
Number manufacturer has assigned to an item. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-MSDS-FLAG Alpha 1 AP125 AP126
Material Safety This flag indicates if this item AP131 AP25.1
DataSheet Flag requires a Material Safety Data Sheet. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-USER-DATE-3 Numeric 8 (yyyymmdd) AP125 AP126
User Date 3 This field contains the third AP131 AP25.1
user-definable date. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-USER-DATE-4 Numeric 8 (yyyymmdd) AP125 AP126
User Date 4 This field contains the fourth AP131 AP25.1
user-definable date. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-PO-USER-FLD-2 Alpha 2 AP125 AP126
Purchase Order User Purchase order line user defined field. AP131 AP25.1
Field 2 AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-PO-USER-FLD-4 Alpha 30 (Lower Case) AP125 AP126
Purchase Order User Purchase order line user defined field. AP131 AP25.1
Field 4 AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-PO-USER-FLD-6 Alpha 15 (Lower Case) AP125 AP126
Purchase Order User Purchase order line user defined field. AP131 AP25.1
Field 6 AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-USER-DATE-1 Numeric 8 (yyyymmdd) AP125 AP126
User Date 1 AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-USER-DATE-2 Numeric 8 (yyyymmdd) AP125 AP126
User Date 2 AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-PO-USER-FLD-1 Alpha 1 AP125 AP126
Purchase Order User Purchase Order header user field one. AP131 AP25.1
Field 1 AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-PO-USER-FLD-3 Alpha 10 (Lower Case) AP125 AP126
Purchase Order User Purchase Order header user field two. AP131 AP25.1
Field 3 AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-PO-USER-FLD-5 Alpha 30 (Lower Case) AP125 AP126
Purchase Order User Purchase Order header user field three. AP131 AP25.1
Field 5 AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-INSP-REQ-FL Alpha 1 AP125 AP126
Inspection Required This flag indicates whether this item AP131 AP25.1
Flag has to be inspected when received via AP25.2 AP26.1
purchase order. AP27.1 CXCP.1
N = No DR100 IC140
Y = Yes IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-CERT-REQ-FL Alpha 1 AP125 AP126
Certification This flag indicates whether a AP131 AP25.1
Required Flag certification is required for this line AP25.2 AP26.1
when it is purchased. This field value AP27.1 CXCP.1
is passed to the purchase order when the DR100 IC140
purchase order line is created. Valid IC141 IC142
values are: IC28.1 IC531
"N" = Certification not required. IC83.1 MA180
"Y" = Certification required. MA43.9 MA530
N = No MA531 MA60.2
Y = Yes MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-COST-OPTION Alpha 1 AP125 AP126
Cost Option 1 = Cost Required AP131 AP25.1
2 = No Charge AP25.2 AP26.1
3 = Vendor Determined AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-REQ-LOCATION Alpha 5 AP125 AP126
To Location The location requisitioning items. This AP131 AP25.1
location can be an inventory or nonstock AP25.2 AP26.1
location. AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-REQUESTER Alpha 10 (Lower Case) AP125 AP126
Requester This is the person who requested this AP131 AP25.1
requisition. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-DELIVER-TO Alpha 30 (Lower Case) AP125 AP126
Deliver To Name This field can be used to specify where AP131 AP25.1
to deliver the items. This field prints AP25.2 AP26.1
on the delivery ticket when you run AP27.1 CXCP.1
Delivery Ticket Print program. DR100 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-COST-CD Alpha 1 AP125 AP126
Unit Cost Origin Unit cost origin code AP131 AP25.1
Code E = Entered AP25.2 AP26.1
L = Last Cost AP27.1 CXCP.1
C = Contract DR100 IC140
T = Catalog/Quote IC141 IC142
B = Blanket IC28.1 IC531
P = Last PO Created IC83.1 MA180
I = Inventory Issue Cost MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-ALLOC-PRI Numeric 2 AP125 AP126
Alloc Pri This is the allocation priority for AP131 AP25.1
this requisition. Valid values are from AP25.2 AP26.1
0 to 99, with 99 being the highest. This AP27.1 CXCP.1
field defaults to 50. This field is DR100 IC140
used in the Warehouse module to IC141 IC142
determine the order in which inventory IC28.1 IC531
demand gets allocated. IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POCP.1
POI3.1 POIE.1
...
PIF-RQSRC-MACHINE Alpha 6
Rqsrc Machine
PIF-PAR-ORDER-ID Alpha 20
Par Order Id
POINTERFAC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PIFSET1 PROCURE-GROUP AP125 AP126
COMPANY AP131 AP25.1
VENDOR AP25.2 AP26.1
PURCH-FR-LOC AP27.1 CXCP.1
ORIGIN-CD DR100 IC140
SOURCE-DOC-N IC141 IC142
SOURCE-DOC-A IC28.1 IC531
OPER-COMPANY IC83.1 MA180
REQ-LOCATION MA43.9 MA530
LINE-NBR MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
...
PIFSET2 COMPANY Subset PO100
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 AP125 AP126
COMPANY AP131 AP25.1
ITEM AP25.2 AP26.1
VENDOR AP27.1 CXCP.1
PURCH-FR-LOC DR100 IC140
ORIGIN-CD IC141 IC142
SOURCE-DOC-N IC28.1 IC531
SOURCE-DOC-A IC83.1 MA180
OPER-COMPANY MA43.9 MA530
REQ-LOCATION MA531 MA60.2
LINE-NBR MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
...
PIFSET4 PROCURE-GROUP PO23.1
COMPANY
DESCRIPTION
VENDOR
PURCH-FR-LOC
ORIGIN-CD
SOURCE-DOC-N
SOURCE-DOC-A
OPER-COMPANY
REQ-LOCATION
LINE-NBR
PIFSET5 PROCURE-GROUP PO23.1
COMPANY
ALLOC-PRI
VENDOR
PURCH-FR-LOC
ORIGIN-CD
SOURCE-DOC-N
SOURCE-DOC-A
OPER-COMPANY
REQ-LOCATION
LINE-NBR
PIFSET6 PROCURE-GROUP PO23.1
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 PO100
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 PO100 PO23.1
COMPANY Where ORIGIN-CD = "OE" WH20.2 WH20.7
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
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
|