Lawson Insight Technical Documentation |
|
POINTAOC
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 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 CXCP.1 DR100
IC140 IC28.1 IC531 IC83.1 MA180 MA41.2
MA41.7 MA43.1 MA43.2 MA43.3 MA43.9 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 PO100 PO101 PO122 PO131 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO25.1 PO25.5 PO25.6 PO25.7 PO27.2
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 POCP.1 POI3.1 POID.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 RQIE.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 WO132 WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PIA-COMPANY Numeric 4 AP125 AP126
Element: Company The company number. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
...
PIA-SOURCE-DOC-N Numeric 8 AP125 AP126
Element: Source Doc N This is the source document number if AP131 AP20.1
the document number in the source system AP20.2 AP20.3
is numeric. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
...
PIA-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This field contains the line number. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
...
PIA-AOC-CODE Alpha 2 AP125 AP126
Element: Add On Cost CoThis field contains the identifier for AP131 AP20.1
the add-on cost associated with this AP20.2 AP20.3
line item. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
...
PIA-AOC-RATE Percent 7.3 (Percent) AP125 AP126
Element: Add On Cost RaAdd-on cost percentage rate. If add-on AP131 AP20.1
cost is spread by rate, this value times AP20.2 AP20.3
the line unit cost is the unit add-on AP20.4 AP20.5
cost for the purchase order line. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
...
PIA-ENT-UNIT-CST Signed 13.5 AP125 AP126
Element: Base Cost AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
...
PIA-QUANTITY Signed 13.4 AP125 AP126
Element: Quantity This field contains the desired AP131 AP20.1
quantity. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
...
PIA-ENTRY Alpha 1 AP125 AP126
Element: Entry Amount entry method. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
...
PIA-TOTAL-AOC Signed 15.2 AP125 AP126
Element: Total Add On CThe total add-on cost amount can be an AP131 AP20.1
entered amount if entered at this level, AP20.2 AP20.3
or a calculated amount if a unit add-on AP20.4 AP20.5
cost or add-on cost percent is entered. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
...
PIA-TAXABLE-FLAG Alpha 1 AP125 AP126
Taxable or Defines if taxable. AP131 AP20.1
Non-Taxable Flag Y = Yes item is taxable AP20.2 AP20.3
N = No item is not taxable AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
...
PIA-TAX-CODE Alpha 10 AP125 AP126
Element: Tax Code This field contains a code representing AP131 AP20.1
specific tax information. This must be AP20.2 AP20.3
valid tax code in the Tax system. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
...
PIA-OE-AOC-TYPE Alpha 2 AP125 AP126
Element: Oe Aoc Type HA = Header Add On Charge AP131 AP20.1
HF = Header Freight Charge AP20.2 AP20.3
LA = Line Add On Charge AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
...
POINTAOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PIASET1 COMPANY AP125 AP126
SOURCE-DOC-N AP131 AP20.1
LINE-NBR AP20.2 AP20.3
AOC-CODE AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
...
PIASET2 COMPANY Subset AP125 AP126
SOURCE-DOC-N Where OE-AOC-TYPE = "HA" AP131 AP20.1
AOC-CODE AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
...
|