 |
Lawson Insight Technical Documentation |
|
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 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
PIA-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
...
PIA-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
...
PIA-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
...
PIA-AOC-CODE Alpha 2 AP125 AP126
Add On Cost Code This field contains the identifier for AP131 AP25.1
the add-on cost associated with this AP25.2 AP26.1
line 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
...
PIA-AOC-RATE Percent 7.3 (Percent) AP125 AP126
Add On Cost Rate Add-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 CXCP.1
cost for the purchase order line. 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
...
PIA-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
...
PIA-QUANTITY Signed 13.4 AP125 AP126
Quantity This field contains the desired AP131 AP25.1
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
...
PIA-ENTRY Alpha 1 AP125 AP126
Entry Amount entry method. 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
...
PIA-TOTAL-AOC Signed 15.2 AP125 AP126
Total Add On Cost 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 CXCP.1
cost or add-on cost percent is entered. 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
...
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 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
...
PIA-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
...
PIA-OE-AOC-TYPE Alpha 2 AP125 AP126
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 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
...
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 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
...
PIASET2 COMPANY Subset AP125 AP126
SOURCE-DOC-N Where OE-AOC-TYPE = "HA" AP131 AP25.1
AOC-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
...
|