 |
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
CXCP.1 DR100 IC140 IC141 IC142 IC531
IC83.1 POCP.1 POIJ.1 RQ11.1 RQ12.1 RQ13.1
RQ140 RQ300 RQ40.1 RQ41.1 RQ42.1 RQ44.1
RQ44.2 WH130 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PIA-COMPANY Numeric 4 CXCP.1 DR100
Company The company number. IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIA-SOURCE-DOC-N Numeric 8 CXCP.1 DR100
Source Doc N This is the source document number if IC140 IC141
the document number in the source system IC142 IC531
is numeric. IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIA-LINE-NBR Numeric 6 CXCP.1 DR100
Line Number This field contains the line number. IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIA-AOC-CODE Alpha 2 CXCP.1 DR100
Add On Cost Code This field contains the identifier for IC140 IC141
the add-on cost associated with this IC142 IC531
line item. IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIA-AOC-RATE Percent 7.3 (Percent) CXCP.1 DR100
Add On Cost Rate Add-on cost percentage rate. If add-on IC140 IC141
cost is spread by rate, this value times IC142 IC531
the line unit cost is the unit add-on IC83.1 POCP.1
cost for the purchase order line. POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIA-ENT-UNIT-CST Signed 13.5 CXCP.1 DR100
Entered Unit Cost The entered unit cost. IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIA-QUANTITY Signed 13.4 CXCP.1 DR100
Quantity This field contains the desired IC140 IC141
quantity. IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIA-ENTRY Alpha 1 CXCP.1 DR100
Entry Amount entry method. IC140 IC141
IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIA-TOTAL-AOC Signed 15.2 CXCP.1 DR100
Total Add On Cost The total add-on cost amount can be an IC140 IC141
entered amount if entered at this level, IC142 IC531
or a calculated amount if a unit add-on IC83.1 POCP.1
cost or add-on cost percent is entered. POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIA-TAXABLE-FLAG Alpha 1 CXCP.1 DR100
Taxable or Defines if taxable. IC140 IC141
Non-Taxable Flag Y = Yes item is taxable IC142 IC531
N = No item is not taxable IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIA-TAX-CODE Alpha 10 CXCP.1 DR100
Tax Code This field contains a code representing IC140 IC141
specific tax information. This must be IC142 IC531
valid tax code in the Tax system. IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
PIA-OE-AOC-TYPE Alpha 2 CXCP.1 DR100
Oe Aoc Type HA = Header Add On Charge IC140 IC141
HF = Header Freight Charge IC142 IC531
LA = Line Add On Charge IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
POINTAOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PIASET1 COMPANY CXCP.1 DR100
SOURCE-DOC-N IC140 IC141
LINE-NBR IC142 IC531
AOC-CODE IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
...
PIASET2 COMPANY Subset CXCP.1 DR100
SOURCE-DOC-N Where OE-AOC-TYPE = "HA" IC140 IC141
AOC-CODE IC142 IC531
IC83.1 POCP.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
RQ140 RQ300
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
...
|