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
RQ240 RQ42.1 RQ44.1 RQ44.2 PO25.1 WH120
UPDATED BY
AP125 AP126 AP225 AP226 AP25.1 AP25.2
AP26.1 BL92.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC140 IN20.1 MA300 MA530 MA540
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE113 OE114 OE129 OE14.4 OE15.1
OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE810 OE830 OE90.1 OE90.2
OE920 OE950 PO100 PO20.1 PO21.4 PO21.6
PO22.1 PO22.2 PO22.3 PO30.1 PO31.1 PO33.1
PO34.1 PO35.1 PO530 PO960 RQ120 RQ125
RQ20.1 RQ20.2 RQ20.3 RQ20.4 RQ300 RQ35.1
WH110 WH130 WH132 WH190 WH20.2 WH20.7
WH222 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2
WH31.3 WH32.1 WH32.2 WH32.3 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 WO132 WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PIF-COMPANY Numeric 4 BL92.1 CX100
Company The company number. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO31.1
PO960 RQ125
RQ20.1 RQ20.2
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
...
PIF-ORIGIN-CD Alpha 2 BL92.1 CX100
Origin Code This field identifies the system that CX20.1 CX20.2
created this record. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO31.1
PO960 RQ125
RQ20.1 RQ20.2
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
...
PIF-IF-REF-NBR Numeric 9 BL92.1 CX100
Reference Number This is an internally generated CX20.1 CX20.2
reference number used by the Requisition CX20.4 CX20.5
system. CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO31.1
PO960 RQ125
RQ20.1 RQ20.2
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
...
PIF-ORDER-NBR Numeric 8 BL92.1 CX100
Order Number This is the order number in Order Entry CX20.1 CX20.2
from which this record was created. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO31.1
PO960 RQ125
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
WH222 WH30.1
WH30.2 WH30.3
...
PIF-LINE-NBR Numeric 6 BL92.1 CX100
Line Number This field contains the line number. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO31.1
PO960 RQ125
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
WH222 WH30.1
...
PIF-SEQ Numeric 3 BL92.1 CX100
Sequence Number This field contains the record sequence CX20.1 CX20.2
number. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO30.1 PO31.1
PO35.1 PO530
PO960 RQ125
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
...
PIF-PO-NUMBER Alpha 7 (Right Justified) BL92.1 CX100
PO Number This field contains the number CX20.1 CX20.2
representing the purchase order. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO100
PO22.3 PO30.1
PO31.1 PO35.1
PO530 PO960
RQ125 RQ20.1
RQ20.2 RQ20.4
RQ35.1 WH130
...
PIF-PO-RELEASE Numeric 6 BL92.1 CX100
PO Release Number Used to identify a purchase order CX20.1 CX20.2
release (created from a Blanket or CX20.4 CX20.5
Standing order). CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO100 PO22.3
PO31.1 PO960
RQ125 RQ20.1
RQ20.2 RQ20.4
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
...
PIF-PO-LINE-NBR Numeric 6 BL92.1 CX100
PO Line Number The purchase order line number this CX20.1 CX20.2
record is associated with. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO100
PO20.1 PO22.2
PO22.3 PO30.1
PO31.1 PO35.1
PO530 PO960
RQ125 RQ20.1
RQ20.2 RQ20.4
...
PIF-SOURCE-DOC Alpha 10 (Right Justified) BL92.1 CX100
Source Document The document number of the source from CX20.1 CX20.2
which this record was created. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO20.1
PO21.6 PO31.1
PO960 RQ125
RQ20.1 RQ20.2
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
...
PIF-PO-STATUS Numeric 1 AP125 AP126
Purchase Order This field identifies the status of the AP225 AP226
Status purchase order created from this record. AP25.1 AP25.2
0 = PO Not Created AP26.1 BL92.1
1 = PO Created CX100 CX20.1
2 = PO Deleted CX20.2 CX20.4
6 = Unreleased Model PO CX20.5 CX220
7 = Released Model PO CX30.1 CX300
8 = PO Canceled CX506 CXCP.1
9 = PO Closed IN20.1 MA530
5 = Backorder Cancel MA540 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO100
PO20.1 PO21.6
...
PIF-COMBINE-FL Alpha 1 BL92.1 CX100
PO Interface This flag defines whether or not this CX20.1 CX20.2
Combine Flag record will be combined on the same CX20.4 CX20.5
purchase order with other records that CX220 CX30.1
have the same vendor and purchase from CX300 CX506
location. All other records combined CXCP.1 DR100
must also have the combine flag set to IC140 OE10.1
Yes. OE10.2 OE10.3
Y = Yes OE10.4 OE10.5
N = No OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO31.1
PO960 RQ125
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
WH222 WH30.1
...
PIF-CREATE-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
Creation Date The creation date. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO31.1
PO960 RQ125
RQ20.1 RQ20.2
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
...
PIF-BUYER-CODE Alpha 3 BL92.1 CX100
Buyer Code The user-defined buyer identifier. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO20.1
PO21.4 PO22.1
PO22.3 PO31.1
PO960 RQ125
RQ20.1 RQ20.3
...
PIF-VENDOR Alpha 9 BL92.1 CX100
Vendor ID The vendor's identification code. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO20.1
PO21.4 PO22.1
PO22.3 PO31.1
PO960 RQ125
RQ20.1 RQ20.2
...
PIF-PURCH-FR-LOC Alpha 4 BL92.1 CX100
Purchase From The vendor's purchase from location. CX20.1 CX20.2
Location Code CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO20.1
PO21.4 PO22.1
PO22.3 PO31.1
PO960 RQ125
RQ20.1 RQ20.2
...
PIF-CONTRACT-NBR Alpha 14 BL92.1 CX100
Contract Number The contract number to be entered on CX20.1 CX20.2
the purchase order created from this CX20.4 CX20.5
record. CX220 CX30.1
CX300 CX506
CXCP.1 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO20.1 PO21.4
PO31.1 PO960
RQ125 RQ20.1
RQ20.2 RQ35.1
WH130 WH132
WH190 WH20.2
...
PIF-ITEM-TYPE Alpha 1 BL92.1 CX100
Item Type This field identifies the line item CX20.1 CX20.2
type. CX20.4 CX20.5
I = Inventory CX220 CX30.1
N = Non-Stock CX300 CX506
S = Service CXCP.1 DR100
X = Special IC140 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO100
PO20.1 PO21.6
PO31.1 PO960
RQ125 RQ20.1
RQ20.2 RQ35.1
WH130 WH132
...
PIF-ITEM Alpha 32 BL92.1 CX100
Item Number This field contains the item CX20.1 CX20.2
identifier. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO20.1
PO21.6 PO30.1
PO31.1 PO35.1
PO530 PO960
RQ125 RQ20.1
RQ20.2 RQ35.1
...
PIF-DESCRIPTION Alpha 30 (Lower Case) BL92.1 CX100
Description This field contains the description. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO20.1
PO21.6 PO30.1
PO31.1 PO35.1
PO530 PO960
RQ125 RQ20.1
RQ20.2 RQ35.1
...
PIF-TAX-CODE Alpha 10 BL92.1 CX100
Tax Code This field contains a code representing CX20.1 CX20.2
specific tax information. This must be CX20.4 CX20.5
valid tax code in the Tax system. CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO20.1
PO21.6 PO31.1
PO960 RQ125
RQ20.1 RQ20.2
RQ35.1 WH130
WH132 WH190
...
PIF-TAXABLE-FLAG Alpha 1 BL92.1 CX100
Taxable or Defines if taxable. CX20.1 CX20.2
Non-Taxable Flag CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO20.1
PO21.6 PO31.1
PO960 RQ125
RQ20.1 RQ20.2
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
...
PIF-CURRENCY-CODE Alpha 5 BL92.1 CX100
Currency Code The base currency defined for the CX20.1 CX20.2
company in the General Ledger system. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO100
PO20.1 PO21.4
PO31.1 PO960
RQ125 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
...
PIF-CURRENCY-FLAG Alpha 1 BL92.1 CX100
Currency Flag Conversion method for currency - CX20.1 CX20.2
multiply/divide. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO100
PO20.1 PO21.4
PO31.1 PO960
RQ125 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
...
PIF-TRAN-ND Numeric 1 BL92.1 CX100
Transaction Number The number of decimal positions defined CX20.1 CX20.2
of Decimals for the transaction currency. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO100
PO20.1 PO21.4
PO31.1 PO960
RQ125 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
...
PIF-ENT-CNV-RATE Signed 12.6 BL92.1 CX100
Entered Conversion Currency conversion rate at purchase CX20.1 CX20.2
Rate order entry time. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO100
PO20.1 PO21.4
PO31.1 PO960
RQ125 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
...
PIF-CURR-SET-FLAG Alpha 1 BL92.1 CX100
Currency Set Flag Flag defines when the currency rate has CX20.1 CX20.2
been set for the purchase order. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO100 PO20.1
PO21.4 PO31.1
PO960 RQ125
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
...
PIF-DROPSHIP-FL Alpha 1 BL92.1 CX100
Dropship Flag This field defines whether or not the CX20.1 CX20.2
items ordered from this line are to be CX20.4 CX20.5
dropshipped. If this flag is set to Yes, CX220 CX30.1
then the drop-ship flag on the purchase CX300 CX506
order created for this line item is also CXCP.1 DR100
Yes. IC140 IN20.1
N = No OE10.1 OE10.2
Y = Yes OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO20.1 PO21.4
PO31.1 PO960
RQ125 RQ20.1
RQ20.2 RQ35.1
WH130 WH132
...
PIF-SUB-EXISTS-FL Alpha 1 BL92.1 CX100
Substitute Exists This flag is part of the feed back CX20.1 CX20.2
Flag information from purchase order to order CX20.4 CX20.5
entry. If this flag is set to Yes, then CX220 CX30.1
order entry knows that the items CX300 CX506
received for this line item have CXCP.1 OE10.1
received at least one substitute item. OE10.2 OE10.3
Y = Yes OE10.4 OE10.5
N = No OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO20.1
PO21.6 PO30.1
PO31.1 PO33.1
PO34.1 PO35.1
PO530 PO960
RQ125 RQ20.1
RQ20.2 RQ35.1
...
PIF-SHIPMENT-NBR Numeric 10 BL92.1 CX100
Shipment Number This field contains the shipment CX20.1 CX20.2
number. One order can have several CX20.4 CX20.5
shipment numbers if the items of the CX220 CX30.1
order were not shipped at the same time. CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 PO960
RQ125 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
WO132 WO140
PIF-ENT-BUY-UOM Alpha 4 BL92.1 CX100
Entered Buy Unit Of Entered Buy Unit Of Measure. CX20.1 CX20.2
Measure CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO20.1
PO21.6 PO22.1
PO22.3 PO30.1
PO31.1 PO35.1
PO530 PO960
...
PIF-EBUY-UOM-MULT Signed 13.7 BL92.1 CX100
Entered Buy UOM Entered buy unit of measure conversion CX20.1 CX20.2
Multiplier multiplier. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO100
PO20.1 PO21.6
PO31.1 PO960
RQ125 RQ20.1
RQ20.2 RQ35.1
WH130 WH132
...
PIF-VPRI-UOM Alpha 4 BL92.1 CX100
Vendor Price Unit This is the vendor pricing unit of CX20.1 CX20.2
of Measure measure. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO20.1
PO21.6 PO22.1
PO22.3 PO31.1
PO960 RQ125
RQ20.1 RQ20.3
RQ20.4 RQ35.1
...
PIF-VPRI-UOM-MULT Signed 13.7 BL92.1 CX100
Vendor Price UOM This is the vendor pricing unit of CX20.1 CX20.2
Multiplier measure multiplier. It is used to CX20.4 CX20.5
convert unit cost to stock unit of CX220 CX30.1
measure terms. CX300 CX506
CXCP.1 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO20.1
PO21.6 PO22.1
PO22.3 PO31.1
PO960 RQ125
RQ20.1 RQ20.3
RQ20.4 RQ35.1
...
PIF-QUANTITY Signed 13.4 BL92.1 CX100
Quantity The quantity to be ordered for this CX20.1 CX20.2
item. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO20.1
PO21.6 PO22.1
PO22.3 PO30.1
PO31.1 PO33.1
PO34.1 PO35.1
...
PIF-ASN-QTY Signed 13.4 BL92.1 CX100
Asn Qty Advanced shipping notice quantity. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 PO960
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
PIF-ENT-UNIT-CST Signed 13.5 AP125 AP126
Entered Unit Cost The entered unit cost. AP225 AP226
AP25.1 AP25.2
AP26.1 BL92.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
IN20.1 MA530
MA540 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO100
PO20.1 PO21.6
...
PIF-PO-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
Purchase Order Date The date assigned to the purchase order CX20.1 CX20.2
created for this line item. CX20.4 CX20.5
CX220 CX30.1
Note: The creation date can be CX300 CX506
different from the purchase order date. CXCP.1 IN20.1
A purchase order can be assigned a date OE10.1 OE10.2
other than the current date. The OE10.3 OE10.4
creation date is the actual date the OE10.5 OE10.6
purchase order was created. OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO100 PO20.1
PO21.4 PO31.1
PO960 RQ125
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
...
PIF-REC-QTY Signed 13.4 BL92.1 CX100
Receiving Quantity This the total quantity to date CX20.1 CX20.2
received for this ordered item. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO20.1 PO21.6
PO30.1 PO31.1
PO33.1 PO34.1
PO35.1 PO530
PO960 RQ125
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
...
PIF-LAST-REC-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
Last Received Date This is the last receiving activity CX20.1 CX20.2
date for this item. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO30.1 PO31.1
PO33.1 PO34.1
PO35.1 PO530
PO960 RQ125
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
...
PIF-APPROVE-QTY Signed 13.4 AP125 AP126
Approved Quantity The total approved quantity for this AP225 AP226
line item. AP25.1 AP25.2
AP26.1 BL92.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
MA530 MA540
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO20.1
PO21.6 PO31.1
PO960 RQ125
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
...
PIF-LAST-APP-DATE Numeric 8 (yyyymmdd) AP125 AP126
Last Approval Date This is the last approval activity date AP225 AP226
for this item. AP25.1 AP25.2
AP26.1 BL92.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
MA530 MA540
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
PO960 RQ125
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
...
PIF-LOCATION Alpha 5 BL92.1 CX100
Location Code This field contains a valid stock CX20.1 CX20.2
location within the company inventory. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO20.1
PO21.6 PO31.1
PO960 RQ125
RQ20.1 RQ20.2
RQ35.1 WH130
WH132 WH190
...
PIF-SH-NAME Alpha 30 (Lower Case) BL92.1 CX100
Ship To Name This is the ship-to name for a CX20.1 CX20.2
non-standard ship-to address. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO20.1 PO21.4
PO31.1 PO960
RQ125 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
...
PIF-SH-ADDR1 Alpha 30 (Lower Case) BL92.1 CX100
Ship To Address Ship-to address line one. CX20.1 CX20.2
Line 1 CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO20.1 PO21.4
PO31.1 PO960
RQ125 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
...
PIF-SH-ADDR2 Alpha 30 (Lower Case) BL92.1 CX100
Ship To Address Ship-to address line two. CX20.1 CX20.2
Line 2 CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO20.1 PO21.4
PO31.1 PO960
RQ125 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
...
PIF-SH-ADDR3 Alpha 30 (Lower Case) BL92.1 CX100
Ship To Address Ship-to address line three. CX20.1 CX20.2
Line 3 CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO20.1 PO21.4
PO31.1 PO960
RQ125 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
...
PIF-SH-ADDR4 Alpha 30 (Lower Case) BL92.1 CX100
Ship To Address Ship-to address line four. CX20.1 CX20.2
Line 4 CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO20.1 PO21.4
PO31.1 PO960
RQ125 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
...
PIF-SH-CITY-ADDR5 Alpha 18 (Lower Case) BL92.1 CX100
Ship To City or This is the ship-to city or the ship-to CX20.1 CX20.2
Address Line 5 address line five. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO20.1 PO21.4
PO31.1 PO960
RQ125 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
...
PIF-SH-STATE-PROV Alpha 2 BL92.1 CX100
Ship To State or This is the ship-to state or the CX20.1 CX20.2
Province ship-to province. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO20.1 PO21.4
PO31.1 PO960
RQ125 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
...
PIF-SH-POST-CODE Alpha 10 (Lower Case) BL92.1 CX100
Ship To Postal Code This is the ship-to mailing code. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO20.1 PO21.4
PO31.1 PO960
RQ125 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
...
PIF-SH-COUNTRY Alpha 30 (Lower Case) BL92.1 CX100
Ship To Country This is the ship-to country. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO20.1 PO21.4
PO31.1 PO960
RQ125 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
...
PIF-SH-PHONE-PREF Alpha 6 BL92.1 CX100
Ship To Telephone This is the ship-to telephone number CX20.1 CX20.2
Country Code prefix. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO20.1 PO21.4
PO31.1 PO960
RQ125 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
...
PIF-SH-PHONE Alpha 15 BL92.1 CX100
Ship To Telephone This is the ship-to telephone number. CX20.1 CX20.2
Number CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO20.1 PO21.4
PO31.1 PO960
RQ125 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
...
PIF-SH-CONTACT Alpha 30 (Lower Case) BL92.1 CX100
Ship To Contact This is the ship-to contact. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO20.1 PO21.4
PO31.1 PO960
RQ125 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
...
PIF-EARLY-DL-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
Early Delivery Date This field contains the early delivery CX20.1 CX20.2
(Rqst DT) date. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO20.1 PO21.6
PO31.1 PO960
RQ125 RQ20.1
RQ20.2 RQ35.1
WH130 WH132
WH190 WH20.2
...
PIF-LATE-DL-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
Late Delivery Date This field contains the late delivery CX20.1 CX20.2
date. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO20.1 PO21.6
PO31.1 PO960
RQ125 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
...
PIF-ACTIVITY Alpha 15 BL92.1 CX100
Activity Activities are the processes or CX20.1 CX20.2
procedures that produce work. Cost CX20.4 CX20.5
objects (products, services, customers, CX220 CX30.1
and so on) are the reasons for CX300 CX506
performing the activity. Activities and CXCP.1 OE10.1
cost object activities are used OE10.2 OE10.3
synonymously in the Activity Management OE10.4 OE10.5
system. Direct costs are posted to OE10.6 OE10.7
activities, and indirect costs are OE10.8 OE11.1
allocated to activities based on OE11.4 OE11.8
activity drivers. OE11.9 OE110
OE113 OE114
Activities are grouped or organized by OE129 OE14.4
activity levels. There are two types of OE15.1 OE15.2
activities: "posting allowed" and OE15.3 OE15.4
"summary only." Use posting level OE15.5 OE15.7
activities to budget and maintain all OE30.1 OE30.2
posted transactions. Summary activities OE30.3 OE30.4
or macro activities combine information OE30.5 OE30.6
and balances from lower level activities OE30.7 OE30.9
for reporting and inquiries. OE510 OE810
OE830 OE920
OE950 PO20.1
PO21.6 PO31.1
PO960 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
WH30.1 WH30.2
...
PIF-ACCT-CATEGORY Alpha 5 BL92.1 CX100
Account Category Account categories are groupings of CX20.1 CX20.2
costs, revenues, or a combination of CX20.4 CX20.5
both used for reporting and inquiries CX220 CX30.1
for activities in the Activity CX300 CX506
Management system. All transactions are CXCP.1 OE10.1
posted to an account category within an OE10.2 OE10.3
activity. You can assign a specific OE10.4 OE10.5
general ledger account or range of OE10.6 OE10.7
accounts (company, accounting unit, OE10.8 OE11.1
account, and subaccount) that make up OE11.4 OE11.8
the transactions posted to an account OE11.9 OE110
category using AC07.1 (Account OE113 OE114
Assignment). OE129 OE14.4
OE15.1 OE15.2
Period-to-date, year-to-date, and OE15.3 OE15.4
life-to-date balances are maintained by OE15.5 OE15.7
account category for activities. Account OE30.1 OE30.2
categories must be assigned to OE30.3 OE30.4
activities before you do any budgeting OE30.5 OE30.6
or transaction processing. OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO20.1
PO21.6 PO31.1
PO960 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
WH30.1 WH30.2
...
PIF-DST-ACCT-UNIT Alpha 15 BL92.1 CX100
Distribution Contains the General Ledger accounting CX20.1 CX20.2
Accounting Unit unit to which the amount is posted. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO20.1
PO21.6 PO31.1
PO960 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
WH30.1 WH30.2
...
PIF-DST-ACCOUNT Numeric 6 BL92.1 CX100
Distribution Contains the General Ledger account to CX20.1 CX20.2
Account Number which the amount is posted. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO20.1
PO21.6 PO31.1
PO960 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
WH30.1 WH30.2
...
PIF-DST-SUB-ACCT Numeric 4 BL92.1 CX100
Distribution The general ledger subaccount to which CX20.1 CX20.2
Subaccount Number the amount is posted. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO20.1
PO21.6 PO31.1
PO960 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
WH30.1 WH30.2
...
PIF-DST-COMPANY Numeric 4 BL92.1 CX100
Distribution Company Distribution company used for CX20.1 CX20.2
intercompany account distribution. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO20.1
PO21.6 PO31.1
PO960 RQ125
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
WH222 WH30.1
...
PIF-VAR-ACCT-UNIT Alpha 15 BL92.1 CX100
Cost Variance The variance account accounting unit. CX20.1 CX20.2
Accounting Unit CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO31.1
PO960 RQ125
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
WH222 WH30.1
WH30.2 WH30.3
...
PIF-VAR-ACCOUNT Numeric 6 BL92.1 CX100
Cost Variance The variance account account number. CX20.1 CX20.2
Account Number CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO31.1
PO960 RQ125
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
WH222 WH30.1
WH30.2 WH30.3
...
PIF-VAR-SUB-ACCT Numeric 4 BL92.1 CX100
Cost Variance The variance account subaccount number. CX20.1 CX20.2
Subaccount CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO31.1
PO960 RQ125
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
WH222 WH30.1
WH30.2 WH30.3
...
PIF-PROCESS-LEVEL Alpha 5 BL92.1 CX100
Process Level This field contains the process level, CX20.1 CX20.2
which is the reporting hierarchy below CX20.4 CX20.5
company. CX220 CX30.1
CX300 CX506
CXCP.1 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
PO20.1 PO21.4
PO31.1 PO960
RQ125 RQ35.1
WH130 WH132
WH190 WH20.2
WH20.7 WH222
...
PIF-HOLD-QTY Signed 13.4 BL92.1 CX100
Hold Quantity This is the quantity put on hold at CX20.1 CX20.2
receiving time if the item is an CX20.4 CX20.5
inspection item. CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO30.1 PO31.1
PO33.1 PO34.1
PO35.1 PO530
PO960 RQ125
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
...
PIF-SHIPPED-QTY Signed 13.4 BL92.1 CX100
Shipped Quantity This is the quantity which was shipped CX20.1 CX20.2
in the Order Entry system. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO31.1
PO960 RQ120
RQ125 RQ35.1
WH110 WH130
WH132 WH190
WH20.2 WH20.7
WH222 WH30.1
...
PIF-REC-SEQ Numeric 3 BL92.1 CX100
Rec Seq Not in use. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 PO960
RQ120 RQ125
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
PIF-MSDS-FLAG Alpha 1 BL92.1 CX100
Material Safety This flag indicates if this item CX20.1 CX20.2
DataSheet Flag requires a Material Safety Data Sheet. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO20.1
PO21.6 PO31.1
PO960 RQ125
RQ20.1 RQ20.2
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
...
PIF-USER-DATE-3 Numeric 8 (yyyymmdd) BL92.1 CX100
User Date 3 This field contains the third CX20.1 CX20.2
user-definable date. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO20.1
PO21.6 PO31.1
PO960 RQ125
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
WH222 WH30.1
...
PIF-USER-DATE-4 Numeric 8 (yyyymmdd) BL92.1 CX100
User Date 4 This field contains the fourth CX20.1 CX20.2
user-definable date. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO20.1
PO21.6 PO31.1
PO960 RQ125
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
WH222 WH30.1
...
PIF-PO-USER-FLD-2 Alpha 2 BL92.1 CX100
Purchase Order User Purchase order line user defined field. CX20.1 CX20.2
Field 2 CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO20.1
PO21.6 PO31.1
PO960 RQ125
RQ20.1 RQ20.2
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
...
PIF-PO-USER-FLD-4 Alpha 30 (Lower Case) BL92.1 CX100
Purchase Order User Purchase order line user defined field. CX20.1 CX20.2
Field 4 CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO20.1
PO21.6 PO31.1
PO960 RQ125
RQ20.1 RQ20.2
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
...
PIF-PO-USER-FLD-6 Alpha 15 (Lower Case) BL92.1 CX100
Purchase Order User Purchase order line user defined field. CX20.1 CX20.2
Field 6 CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 PO20.1
PO21.6 PO31.1
PO960 RQ125
RQ20.1 RQ20.2
RQ35.1 WH130
WH132 WH190
WH20.2 WH20.7
...
PIF-INTF-STATUS Numeric 1 AP125 AP126
Intf Status This defines the status of the AP225 AP226
interface record. AP25.1 AP25.2
1 = Open AP26.1 BL92.1
8 = Not In Use CX100 CX20.1
9 = Purge CX20.2 CX20.4
5 = Hold CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
IN20.1 MA530
MA540 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO100
...
PIF-INSP-REQ-FL Alpha 1 BL92.1 CX100
Inspection Required This flag indicates whether this item CX20.1 CX20.2
Flag has to be inspected when received via CX20.4 CX20.5
purchase order. CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ125
RQ20.1 RQ20.2
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
PIF-CERT-REQ-FL Alpha 1 BL92.1 CX100
Certification This flag indicates whether a CX20.1 CX20.2
Required Flag certification is required for this line CX20.4 CX20.5
when it is purchased. This field value CX220 CX30.1
is passed to the purchase order when the CX300 CX506
purchase order line is created. Valid CXCP.1 OE114
values are: OE30.1 OE30.2
"N" = Certification not required. OE30.3 OE30.4
"Y" = Certification required. OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ20.1
RQ20.2 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
WO132 WO140
PIF-NO-CHARGE-FL Alpha 1 BL92.1 CX100
No Charge Flag This field indicates the item's price CX20.1 CX20.2
is zero. This defaults to No. If Yes, CX20.4 CX20.5
this field prevents the system from CX220 CX30.1
pricing the item. No charge invoices are CX300 CX506
to be passed to the Accounts Receivable CXCP.1 OE114
system for collection. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO100 PO31.1
RQ125 RQ20.1
RQ20.2 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
WO132 WO140
PIF-ZERO-COST-FL Alpha 1 BL92.1 CX100
Zero Cost Flag Zero unit cost line tolerance flag. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ125
RQ20.1 RQ20.2
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
PIF-REQ-LOCATION Alpha 5 BL92.1 CX100
To Location The location requisitioning items. This CX20.1 CX20.2
location can be an inventory or nonstock CX20.4 CX20.5
location. CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ125
RQ20.1 RQ20.2
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
PIF-COST-CD Alpha 1 BL92.1 CX100
Unit Cost Origin Unit cost origin code CX20.1 CX20.2
Code E = Entered CX20.4 CX20.5
L = Last Cost CX220 CX30.1
Q = Quote CX300 CX506
S = Standard Order CXCP.1 OE114
O = Order Entry OE30.1 OE30.2
C = Contract OE30.3 OE30.4
N = Last PO Created OE30.5 OE30.6
Y = Copied From PO OE30.7 OE30.9
P = Override Contract OE830 OE950
D = Standard Cost PO31.1 RQ125
A = Average Cost RQ20.1 RQ20.2
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
PIF-INTRASTAT-FL Alpha 1
Intrastat Fl Specifies whether the transaction is
subject to Intrastat reporting. (Yes or
No).
PIF-SH-CNTRY-CODE Alpha 2
Sh Cntry Code The Ship To country code.
PIF-SH-REGION Alpha 2
Sh Region The Ship To region code.
PIF-UNLOADING-PORT Alpha 5
Unloading Port The port where the goods are unloaded
if required. Must be defined in
IN04.1 (Port Maintenance).
PIF-NOTC Alpha 2
Notc The Nature Of Transaction Code. This
code must be defined in IN07.1 (NOTC
Maintenance).
PIF-DLVRY-TRMS Alpha 1
Dlvry Trms The terms of delivery
1 = EXW 4 = DDU 9 = XXX
2 = FDB 5 = CFR
3 = CIF 6 = CIP
PIF-TRANSPORT-MODE Alpha 1
Transport Mode The mode of transportation at the border
crossing. Code 7 is used for the
Channel Tunnel.
1 Sea 4 Air 8 Inland Waterway
2 Rail 5 Post 9 Own Propulsion
3 Road 7 Fixed Installation
PIF-COMMODITY Alpha 8
Commodity The Intrastat commodity code.
Represents a category of goods. Must be
defined in IN03.1 (Commodity
Maintenance).
PIF-WEIGHT Signed 9.3 PO960
Unit Weight This field contains the unit weight of
the item based on the stocking UOM (the
kilogram for the European Community).
PIF-SECONDARY-QTY Signed 13.4 PO960
Secondary Quantity This field contains the secondary
quantity, which is tracked if the
Intrastat commodity code requires it.
This quantity is a memo quantity only.
It is not used for valuation.
PIF-SEC-UOM Alpha 4
Secondary Unit of This field contains the secondary
Measure quantity unit of measure.
PIF-DROP-SHIP-IND Alpha 1
Drop Ship Ind Specifies whether the shipment is a
drop (triangulated) shipment, that is a
shipment where goods are shipped from
one EC country to another, but a
principal in the transaction is based
elsewhere.
PIF-STAT-PROC Alpha 6
Stat Proc The statistical procedure code
applicable to the data. The code must
be defined in IN06.1 (Statistical
Procedure Maintenance).
PIF-BOE-CODE Alpha 2
Boe Code An Intrastat code referring to energy,
required in some countries.
PIF-AFFILIATION-CD Alpha 1
Affiliation Code Specifies whether there is a
affiliation between the declarnt and
vendor or customer. No is the default.
PIF-CSA-CODE Alpha 1
Csa Code Required in some countries for energy
transactions. Select Yes if the
transactions is under contractual
agreement. No is the default.
POINTERFAC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PIFSET1 COMPANY BL92.1 CX100
ORIGIN-CD CX20.1 CX20.2
IF-REF-NBR CX20.4 CX20.5
ORDER-NBR CX220 CX30.1
LINE-NBR CX300 CX506
SEQ CXCP.1 DR100
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
...
PIFSET2 COMPANY KeyChange, Subset AP125 AP126
PO-NUMBER Where PO-NUMBER != Spaces AP225 AP226
PO-RELEASE AP25.1 AP25.2
PO-LINE-NBR AP26.1 BL92.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
IN20.1 MA300
MA530 MA540
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
...
PIFSET3 COMPANY Subset BL92.1 CX100
LOCATION Where ORIGIN-CD = "IC" CX20.1 CX20.2
ITEM CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 IC140
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
...
PIFSET4 COMPANY Subset RQ20.4
ORIGIN-CD Where PO-STATUS = 7
VENDOR
PURCH-FR-LOC
LOCATION
ITEM
IF-REF-NBR
PIFSET5 COMPANY Subset RQ20.1 RQ20.2
LOCATION Where ORIGIN-CD = "RQ"
ITEM And PO-STATUS = 6
EARLY-DL-DATE
PIFSET6 COMPANY Subset BL92.1 CX100
ORDER-NBR Where (ORIGIN-CD = "OE" ) CX20.1 CX20.2
IF-REF-NBR And (INTF-STATUS = 1 ) CX20.4 CX20.5
LINE-NBR And ((REC-QTY > SHIPPED-QTY) CX220 CX30.1
Or (APPROVE-QTY > SHIPPED-QTY)) CX300 CX506
CXCP.1 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH110
WH120 WH130
WH132 WH190
...
POINTERFAC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
PIF-COMPANY -> CPY-COMPANY
Blanket Order STPURCHORD Required
When PIF-PO-RELEASE != Zeroes
PIF-COMPANY -> SPO-COMPANY
PIF-PO-NUMBER -> SPO-PO-NUMBER
Buyer BUYER Required
When PIF-BUYER-CODE != Spaces
PIF-COMPANY -> BUY-COMPANY
PIF-BUYER-CODE -> BUY-BUYER-CODE
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
Poline POLINE Required
When PIF-PO-NUMBER != Spaces
PIF-COMPANY -> PLI-COMPANY
PIF-PO-NUMBER -> PLI-PO-NUMBER
PIF-PO-RELEASE -> PLI-PO-RELEASE
PIF-PO-LINE-NBR -> PLI-LINE-NBR
Purchorder PURCHORDER Required
When PIF-PO-NUMBER != Spaces
PIF-COMPANY -> PCR-COMPANY
PIF-PO-NUMBER -> PCR-PO-NUMBER
PIF-PO-RELEASE -> PCR-PO-RELEASE
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
Comments POINTCMTS
PIF-COMPANY -> PIC-COMPANY
PIF-ORIGIN-CD -> PIC-ORIGIN-CD
PIF-IF-REF-NBR -> PIC-IF-REF-NBR
PIF-ORDER-NBR -> PIC-ORDER-NBR
PIF-LINE-NBR -> PIC-LINE-NBR
PIC-SEQ
Pointaoc POINTAOC
PIF-COMPANY -> PIA-COMPANY
PIF-ORIGIN-CD -> PIA-ORIGIN-CD
PIF-IF-REF-NBR -> PIA-IF-REF-NBR
PIF-ORDER-NBR -> PIA-ORDER-NBR
PIF-LINE-NBR -> PIA-LINE-NBR
PIA-AOC-CODE
Req Line REQLINE
PIF-COMPANY -> RLN-COMPANY
PIF-IF-REF-NBR -> RLN-IF-REF-NBR
RLN-REQ-DEL-DATE
RLN-REQ-NUMBER
RLN-LINE-NBR
|