|
|
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 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 CXCP.1 DR100 IC140 IC28.1
IC531 IC83.1 MA180 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.2 MA66.3 MA67.1
MA67.2 MA70.1 MA75.1 MA80.1 MAI1.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
OE111 OE113 OE114 OE116 OE129 OE13.2
OE13.3 OE13.5 OE13.6 OE14.4 OE30.1 OE30.2
OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9
OE510 OE530 OE81.1 OE810 OE830 OE90.1
OE90.2 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 POID.1 POIE.1 POII.1 POIJ.1
RQ10.1 RQ10.2 RQ12.1 RQ13.1 RQ13.2 RQ140
RQ300 RQ35.1 RQ40.1 RQ41.1 RQ42.1 RQ44.1
RQ44.2 RQ500 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 WO132 WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PIA-COMPANY Numeric 4 AP125 AP126
Element: Company The company number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.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
OE111 OE113
OE114 OE116
OE129 OE13.2
...
PIA-SOURCE-DOC-N Numeric 8 AP125 AP126
Element: 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 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.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
OE111 OE113
OE114 OE116
OE129 OE13.2
...
PIA-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This field contains the line number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.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
OE111 OE113
OE114 OE116
OE129 OE13.2
...
PIA-AOC-CODE Alpha 2 AP125 AP126
Element: Add On Cost CoThis field contains the identifier for AP131 AP25.1
the add-on cost associated with this AP25.2 AP26.1
line item. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.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
OE111 OE113
OE114 OE116
OE129 OE13.2
...
PIA-AOC-RATE Percent 7.3 (Percent) AP125 AP126
Element: Add On Cost RaAdd-on cost percentage rate. If add-on AP131 AP25.1
cost is spread by rate, this value times AP25.2 AP26.1
the line unit cost is the unit add-on AP27.1 AP30.4
cost for the purchase order line. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.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
OE111 OE113
OE114 OE116
OE129 OE13.2
...
PIA-ENT-UNIT-CST Signed 18.5 AP125 AP126
Element: Intl Cost The entered unit cost. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.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
OE111 OE113
OE114 OE116
OE129 OE13.2
...
PIA-QUANTITY Signed 13.4 AP125 AP126
Element: Quantity This field contains the desired AP131 AP25.1
quantity. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.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
OE111 OE113
OE114 OE116
OE129 OE13.2
...
PIA-ENTRY Alpha 1 AP125 AP126
Element: Entry Amount entry method. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.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
OE111 OE113
OE114 OE116
OE129 OE13.2
...
PIA-TOTAL-AOC Signed 18.2 AP125 AP126
Element: Intl Amt The total add-on cost amount can be an AP131 AP25.1
entered amount if entered at this level, AP25.2 AP26.1
or a calculated amount if a unit add-on AP27.1 AP30.4
cost or add-on cost percent is entered. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.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
OE111 OE113
OE114 OE116
OE129 OE13.2
...
PIA-TAXABLE-FLAG Alpha 1 AP125 AP126
Taxable or Defines if taxable. AP131 AP25.1
Non-Taxable Flag Y = Yes item is taxable AP25.2 AP26.1
N = No item is not taxable AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.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
OE111 OE113
OE114 OE116
OE129 OE13.2
...
PIA-TAX-CODE Alpha 10 AP125 AP126
Element: 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 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.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
OE111 OE113
OE114 OE116
OE129 OE13.2
...
PIA-OE-AOC-TYPE Alpha 2 AP125 AP126
Element: Oe Aoc Type HA = Header Add On Charge AP131 AP25.1
HF = Header Freight Charge AP25.2 AP26.1
LA = Line Add On Charge AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.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
OE111 OE113
OE114 OE116
OE129 OE13.2
...
POINTAOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PIASET1 COMPANY AP125 AP126
SOURCE-DOC-N AP131 AP25.1
LINE-NBR AP25.2 AP26.1
AOC-CODE AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA530
MA531 MA60.2
...
PIASET2 COMPANY Subset AP125 AP126
SOURCE-DOC-N Where OE-AOC-TYPE = "HA" AP131 AP25.1
AOC-CODE AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA530
MA531 MA60.2
...
|
