POINTAOC FILE
Interface Add On Cost
This file contains additional costs associated with an Interface File record.
These additional costs are created by the system that creates the Interface
File record and become part of the Purchase Order line created from that
Interface File record.
UPDATED BY
AP125 AP126 AP225 AP226 AP25.1 AP25.2
AP26.1 BL92.1 MA190 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 OE510
OE810 OE90.1 OE90.2 OE920 PO100 PO21.5
PO21.6 PO31.1 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PIA-COMPANY Numeric 4 BL92.1 OE10.1
Company The company number. 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
OE510 OE810
OE920 WH20.2
WH20.7
PIA-ORIGIN-CD Alpha 2 BL92.1 OE10.1
Origin Code This field identifies the system that OE10.2 OE10.3
created this record. 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
OE510 OE810
OE920 WH20.2
WH20.7
PIA-IF-REF-NBR Numeric 9 BL92.1 OE10.1
Reference Number This field contains an internally OE10.2 OE10.3
generated reference number used by the OE10.4 OE10.5
Requisition system. 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
OE510 OE810
OE920 WH20.2
WH20.7
PIA-ORDER-NBR Numeric 8 BL92.1 OE10.1
Order Number This field contains the order number. 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
OE510 OE810
OE920 WH20.2
WH20.7
PIA-LINE-NBR Numeric 6 BL92.1 OE10.1
Line Number This field contains the line number. 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
OE510 OE810
OE920 WH20.2
WH20.7
PIA-AOC-CODE Alpha 2 BL92.1 OE10.1
Add On Cost Code This field contains the identifier for OE10.2 OE10.3
the add-on cost associated with this OE10.4 OE10.5
line item. 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
OE510 OE810
OE920 WH20.2
WH20.7
PIA-PO-NUMBER Alpha 7 (Right Justified) BL92.1 OE10.1
PO Number This field contains the number OE10.2 OE10.3
representing the purchase order. 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
OE510 OE810
OE920 PO100
WH20.2 WH20.7
PIA-PO-RELEASE Numeric 6
PO Release Number Used to identify a purchase order
release (created from a Blanket or
Standing order).
PIA-PO-LINE-NBR Numeric 6 BL92.1 OE10.1
PO Line Number The purchase order line number this OE10.2 OE10.3
record is associated with. 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
OE510 OE810
OE920 PO100
WH20.2 WH20.7
PIA-VENDOR Alpha 9 BL92.1 OE10.1
Vendor ID The vendor's identification code. 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
OE510 OE810
OE920 PO21.5
PO21.6 WH20.2
WH20.7
PIA-PURCH-FR-LOC Alpha 4 BL92.1 OE10.1
Purchase From The vendor's purchase from location. OE10.2 OE10.3
Location Code 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
OE510 OE810
OE920 PO21.5
PO21.6 WH20.2
WH20.7
PIA-APPV-VENDOR Alpha 9
Appv Vendor Approval vendor.
PIA-APPV-PURCH-FR Alpha 4
Appv Purch Fr Approval vendor purchase from location.
PIA-AOC-RATE Percent 7.3 (Percent) BL92.1 OE10.1
Add On Cost Rate Add-on cost percentage rate. If add-on OE10.2 OE10.3
cost is spread by rate, this value times OE10.4 OE10.5
the line unit cost is the unit add-on OE10.6 OE10.7
cost for the purchase order line. 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
OE510 OE810
OE920 PO100
PO21.5 PO21.6
WH20.2 WH20.7
PIA-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
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 OE510
OE810 OE920
PO100 PO21.5
PO21.6 PO31.1
WH20.2 WH20.7
PIA-QUANTITY Signed 13.4 BL92.1 OE10.1
Quantity This field contains the requested OE10.2 OE10.3
quantity. 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
OE510 OE810
OE920 PO100
PO21.5 PO21.6
WH20.2 WH20.7
PIA-ENTRY Alpha 1 BL92.1 OE10.1
Entry Amount entry method. 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
OE510 OE810
OE920 PO100
PO21.5 PO21.6
WH20.2 WH20.7
PIA-REC-QTY Signed 13.4 PO21.5 PO21.6
Receiving Quantity This is the total quantity to date
received for this ordered item.
PIA-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 MA530
MA540 PO21.5
PO21.6 PO31.1
PIA-MISC-APPV-AMT Signed 15.2 AP25.1 AP25.2
Miscellaneous This is the miscellaneous add-on cost PO21.5 PO21.6
Approved Amount amount that has been approved for this
add-on cost.
PIA-BILLED-AMOUNT Signed 15.2 BL92.1 OE10.1
Billed Amount The order entry customer billed amount. 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
OE510 OE810
OE920 WH20.2
WH20.7
PIA-TOTAL-AOC Signed 15.2 BL92.1 OE10.1
Total Add On Cost The total add-on cost amount can be an OE10.2 OE10.3
entered amount if entered at this level, OE10.4 OE10.5
or a calculated amount if a unit add-on OE10.6 OE10.7
cost or add-on cost percent is entered. 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
OE510 OE810
OE920 PO100
PO21.5 PO21.6
WH20.2 WH20.7
PIA-DST-COMPANY Numeric 4 BL92.1 OE10.1
Distribution Company Distribution company used for OE10.2 OE10.3
intercompany account distribution. 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
OE510 OE810
OE920 PO100
WH20.2 WH20.7
PIA-DST-ACCT-UNIT Alpha 15 BL92.1 OE10.1
Distribution Contains the General Ledger accounting OE10.2 OE10.3
Accounting Unit unit to which the amount is posted. 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
OE510 OE810
OE920 PO100
WH20.2 WH20.7
PIA-DST-ACCOUNT Numeric 6 BL92.1 OE10.1
Distribution Contains the General Ledger account to OE10.2 OE10.3
Account Number which the amount is posted. 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
OE510 OE810
OE920 PO100
WH20.2 WH20.7
PIA-DST-SUB-ACCT Numeric 4 BL92.1 OE10.1
Distribution Contains the General Ledger subaccount OE10.2 OE10.3
Subaccount Number to which the amount is posted. 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
OE510 OE810
OE920 PO100
WH20.2 WH20.7
PIA-TAXABLE-FLAG Alpha 1 BL92.1 OE10.1
Taxable or Defines if taxable. OE10.2 OE10.3
Non-Taxable Flag Y = Yes item is taxable OE10.4 OE10.5
N = No item is not taxable 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
OE510 OE810
OE920 PO21.5
PO21.6 WH20.2
WH20.7
PIA-PRINT-FLAG Alpha 1 BL92.1 OE10.1
Print Flag Indicates if the system prints the OE10.2 OE10.3
add-on cost on the purchase order. OE10.4 OE10.5
Y = Yes print on document OE10.6 OE10.7
N = No do not print on document 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
OE510 OE810
OE920 PO100
PO21.5 PO21.6
WH20.2 WH20.7
PIA-SUMMARY-FLAG Alpha 1 BL92.1 OE10.1
Summary Flag Defines if the add-on cost is printed OE10.2 OE10.3
in summary or at a detail level on the OE10.4 OE10.5
purchase order. OE10.6 OE10.7
Y = Yes will print in summary only OE10.8 OE11.1
N = No will also print in detail OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 PO21.5
PO21.6 WH20.2
WH20.7
PIA-ZERO-COST-FLG Alpha 1 BL92.1 OE10.1
Zero Cost Flag Defines if this tax record is allowed OE10.2 OE10.3
to have a zero unit cost. OE10.4 OE10.5
Y = Yes will allow a zero cost OE10.6 OE10.7
N = No will not allow a zero cost 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
OE510 OE810
OE920 PO21.5
PO21.6 WH20.2
WH20.7
PIA-TAX-CODE Alpha 10 BL92.1 OE10.1
Tax Code This field contains a code representing OE10.2 OE10.3
specific tax information. This must be OE10.4 OE10.5
valid tax code in the Tax system. 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
OE510 OE810
OE920 PO21.5
PO21.6 WH20.2
WH20.7
PIA-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
AP26.1 BL92.1
MA190 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
OE510 OE810
OE920 PO100
PO31.1 WH20.2
WH20.7
PIA-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 MA190 MA530
9 = Purge MA540 OE10.1
5 = Hold 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
OE510 OE810
OE90.1 OE90.2
OE920 PO100
PO31.1 WH20.2
WH20.7
POINTAOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PIASET1 COMPANY BL92.1 MA300
ORIGIN-CD OE10.1 OE10.2
IF-REF-NBR OE10.3 OE10.4
ORDER-NBR OE10.5 OE10.6
LINE-NBR OE10.7 OE10.8
AOC-CODE 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 OE510
OE810 OE90.1
OE90.2 OE920
...
PIASET3 COMPANY Subset AP125 AP126
PO-NUMBER Where PO-NUMBER != Spaces AP225 AP226
PO-RELEASE And ORIGIN-CD = "OE" AP25.1 AP25.2
PO-LINE-NBR AP26.1 BL92.1
AOC-CODE MA190 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
...
POINTAOC FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pointerfac POINTERFAC Required
PIA-COMPANY -> PIF-COMPANY
PIA-ORIGIN-CD -> PIF-ORIGIN-CD
PIA-IF-REF-NBR -> PIF-IF-REF-NBR
PIA-ORDER-NBR -> PIF-ORDER-NBR
PIA-LINE-NBR -> PIF-LINE-NBR
PIF-SEQ
|