Lawson Insight Technical Documentation |
|
POAOCDTL
POAOCDTL FILE
Add On Cost Detail
Purchase Order Add On Cost Detail file. This file contains all Add On Costs
in relation to a Purchase Order. This relation can be at Purchase Order level
and/or at Purchase Order Item level.
REFERENCED BY
AM115 AM117 AM15.1 AM15.2 AM15.3 AM15.4
AM20.1 AM20.3 AM21.1 AM21.3 AM500 AM51.1
AM551 AM97.1 API2.1 API3.1 API4.1 IC840
PO135 PO220 PO225 PO26.1 PO54.4 PO63.1
PO64.1 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 UK47.1 PO67.1 PO229 API5.1
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 API1.1 BL120 BL122 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 IC28.1 MA08.1 MA180
MA530 MA531 MA540 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 PO150 PO190 PO20.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 POI3.1 POI7.1 POIE.1 POIF.1
POIG.1 POII.1 POIJ.1 POIM.1 POIT.1 RQ10.1
RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAO-PROCURE-GROUP Alpha 4 AP125 AP126
Element: Procure Group This field contains the identifier for a AP131 AP25.1
group of companies that share a common AP25.2 AP26.1
procurement effort. They buy items and AP27.1 AP30.4
services together. API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-COMPANY Numeric 4 AP125 AP126
Element: Company The company number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-VEN-AGRMT-REF Alpha 30 AP125 AP126
Element: Agreement Ref AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
Element: PO Number This field contains the number AP131 AP25.1
representing the purchase order. AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-PO-RELEASE Numeric 4 AP125 AP126
Element: PO Release NumUsed to identify a purchase order AP131 AP25.1
release (created from a Blanket or AP25.2 AP26.1
Standing order). AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-PO-CODE Alpha 4 AP125 AP126
Element: Po Code This is the purchase order code. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-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
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-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
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-VENDOR Alpha 9 (Right Justified) AP125 AP126
Element: Vendor ID The vendor's identification code. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-PURCH-FR-LOC Alpha 4 AP125 AP126
Purchase From The vendor's purchase from location. AP131 AP25.1
Location Code AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-LOCATION Alpha 5 AP125 AP126
Element: Location Code This field contains a valid stock AP131 AP25.1
location within the company inventory. AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-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 AP25.2 AP26.1
multiplied by the line unit cost is the AP27.1 AP30.4
unit add-on cost for the purchase order API1.1 BL120
line. BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-ENTRY Alpha 1 AP125 AP126
Element: Entry Amount entry method. AP131 AP25.1
U = Unit Cost Entry AP25.2 AP26.1
R = Rate Percentage Entry AP27.1 AP30.4
T = Total Amount Entry API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-QUANTITY Signed 13.4 AP125 AP126
Element: Quantity The order quantity. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-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
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-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. API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-REC-QTY Signed 13.4 AP125 AP126
Element: Receiving QuanThe quantity received against the AP131 AP25.1
purchase order line the add-on cost is AP25.2 AP26.1
associated with. AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-MATCHED-QTY Signed 13.4 AP125 AP126
Element: Receiving Quantity AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-MISC-MA-AMT Signed 18.2 AP125 AP126
Element: Intl Amt AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-RECQTY-TO-MA Signed 13.4 AP125 AP126
Element: Receiving Quantity AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-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. AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-TAXABLE-FLAG Alpha 1 AP125 AP126
Taxable or Defines if taxable. AP131 AP25.1
Non-Taxable Flag Y = Yes AP25.2 AP26.1
N = No AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-ORIGIN-CD Alpha 2 AP125 AP126
Element: Origin Code This field identifies the system that AP131 AP25.1
created this record. AP25.2 AP26.1
PO = Purchase Order AP27.1 AP30.4
MA = Matching API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-AOC-ON-PO Alpha 1 AP125 AP126
Element: Aoc On Po Indicates if the add-on cost is to AP131 AP25.1
appear on the Purchase Order document AP25.2 AP26.1
that is issued to the vendor. AP27.1 AP30.4
Y = Yes API1.1 BL120
N = No BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-SUMMARY-FLAG Alpha 1 AP125 AP126
Element: Summary Only Defines if the add-on cost is printed AP131 AP25.1
in summary or at a detail level on the AP25.2 AP26.1
purchase order. AP27.1 AP30.4
Y = Yes API1.1 BL120
N = No BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-ZERO-COST-FLG Alpha 1 AP125 AP126
Element: Zero Cost FlagDefines if this tax record is allowed AP131 AP25.1
to have a zero unit cost. AP25.2 AP26.1
N = No AP27.1 AP30.4
Y = Yes API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-CANCELLED-FL Alpha 1 AP125 AP126
Element: All Flag The canceled flag. AP131 AP25.1
N = No AP25.2 AP26.1
Y = Yes AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-CLOSED-FL Alpha 1 AP125 AP126
Element: Closed Flag The closed flag. AP131 AP25.1
N = No AP25.2 AP26.1
Y = Yes AP27.1 AP30.4
H = History API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-INV-SPRD-CRET Numeric 1 AP125 AP126
Element: Inv Sprd Cret Defines if record was created during AP131 AP25.1
purchase order invoice spread. AP25.2 AP26.1
1 = Invoice Spread Difference AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-MATCH-DTL-KEY Alpha 85 AP125 AP126
Element: Match Dtl Key AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-ISSUED-FLAG Alpha 1 AP125 AP126
Element: All Flag This is the issue status of the add on AP131 AP25.1
cost detail record. If the PO has been AP25.2 AP26.1
issued at least once since the add on AP27.1 AP30.4
cost detail record was created, this API1.1 BL120
flag will be set to a value of "Y". BL122 BL130
Once set to "Y", it never changes. BL20.1 BL20.3
Y = Issued BL21.2 BL21.5
N = Not Issued BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-INVC-TAX-AMT Signed 18.2 AP125 AP126
Element: Intl Amt The tax amount that is to be invoiced. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-ACCR-TAX-AMT Signed 18.2 AP125 AP126
Element: Intl Amt The tax amount that is to be accrued. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-EXT-TAXBL-AMT Signed 18.2 AP125 AP126
Element: Intl Amt The amount of the add on cost that is AP131 AP25.1
taxable. This is zero if the taxable AP25.2 AP26.1
flag is "N", otherwise it will equal the AP27.1 AP30.4
total AOC amount. API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-LAND-UNIT-CST Signed 18.5 AP125 AP126
Element: Intl Cost The unit cost of the add on costs if it AP131 AP25.1
is landed in addition to the unit cost AP25.2 AP26.1
of taxes that are landed. AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-BL-INVC-AMT Signed 18.2 AP125 AP126
Element: Intl Amt AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 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
...
PAO-LANDED-FLAG Numeric 1 AP125 AP126
Element: Landed Flag 0 = No AP131 AP25.1
1 = Landed 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
IC28.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
...
PAO-FREIGHT-TERMS Alpha 1
Element: Freight Terms Freight terms are used to define who
pays for freight costs incurred when
goods are shipped. Prepaid, for
instance, would normally mean that the
vendor would pay for freight. Collect
would mean the customer would pay for
freight.
A freight terms code can be entered on
a purchase order, or defaulted by vendor
or company.
PAO-FOB-CODE Alpha 3
Element: Shipping Term The user defined Free On Board Code.
PAO-TERM-CODE Alpha 5
Element: Terms Code A user-defined code representing a
method of determining invoice due and
discount dates.
PAO-XREF-VENDOR Alpha 9 (Right Justified)
Element: Xref Vendor This is a vendor that is supported on a
system outside Lawson. When records are
interfaces we will maintain this vendor
on the file but we will use the Lawson
vendor while in the lawson application.
PAO-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PAO-ENT-CNV-RATE Signed 14.7
Entered Conversion Currency conversion rate at Purchase
Rate Order entry time.
PAO-REC-CNV-RATE Signed 14.7
Entered Conversion Currency conversion rate for the
Rate Purchase Order at receiving time.
PAO-TOTAL-AOC-PO Signed 18.2
Element: Intl Amt The total add-on cost amount in the
Purchase Order currency.
PAO-OPEN-PO-AMT Signed 18.2
Element: Intl Amt The portion of the total or extended
ordered amount that is still open --
that is, it has not been cancelled or
paid. This is always expressed in the
company base currency, and includes only
product costs (add on costs and taxes
are not included).
POAOCDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAOSET1 COMPANY AM115 AM117
PROCURE-GROUP AM15.1 AM15.2
VEN-AGRMT-REF AM15.3 AM15.4
PO-NUMBER AM20.1 AM20.3
PO-RELEASE AM21.1 AM21.3
PO-CODE AM500 AM51.1
LINE-NBR AM551 AM97.1
AOC-CODE AP125 AP126
AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
...
PAOSET10 COMPANY This key was added to allow alternate AP125 AP126
PROCURE-GROUP file access for correcting DBAPIERROR AP131 AP25.1
VEN-AGRMT-REF problems. AP25.2 AP26.1
PO-NUMBER KeyChange AP27.1 AP30.4
PO-RELEASE BL120 BL122
PO-CODE BL130 BL20.1
LINE-NBR BL20.3 BL21.2
AOC-CODE BL21.5 BL29.1
VENDOR BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
...
PAOSET2 COMPANY Subset AP125 AP126
AOC-CODE Where VEN-AGRMT-REF = Spaces AP131 AP25.1
PO-NUMBER AP25.2 AP26.1
PO-RELEASE AP27.1 AP30.4
PO-CODE API1.1 BL120
LINE-NBR BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
...
PAOSET3 COMPANY Subset AP125 AP126
PO-NUMBER Where LINE-NBR != Zeroes AP131 AP25.1
PO-RELEASE And VEN-AGRMT-REF = Spaces AP25.2 AP26.1
PO-CODE AP27.1 AP30.4
LINE-NBR API1.1 BL120
AOC-CODE BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
...
PAOSET4 COMPANY KeyChange, Subset AP125 AP126
VENDOR Where CLOSED-FL = "N" AP131 AP25.1
PO-NUMBER And CANCELLED-FL = "N" AP25.2 AP26.1
PO-RELEASE And VEN-AGRMT-REF = Spaces AP27.1 AP30.4
PO-CODE API1.1 BL120
AOC-CODE BL122 BL130
LINE-NBR BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
...
PAOSET5 COMPANY Subset AP125 AP126
AOC-CODE Where CLOSED-FL = "N" AP131 AP25.1
PO-NUMBER And CANCELLED-FL = "N" AP25.2 AP26.1
PO-RELEASE And VEN-AGRMT-REF = Spaces AP27.1 AP30.4
PO-CODE API1.1 BL120
LINE-NBR BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
...
PAOSET6 PROCURE-GROUP Subset AP125 AP126
VEN-AGRMT-REF Where VEN-AGRMT-REF != Spaces AP131 AP25.1
LINE-NBR AP25.2 AP26.1
AOC-CODE AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
...
PAOSET8 COMPANY KeyChange, Subset AP125 AP126
PO-NUMBER Where VEN-AGRMT-REF = Spaces AP131 AP25.1
PO-RELEASE AP25.2 AP26.1
PO-CODE AP27.1 AP30.4
LOCATION API1.1 API5.1
MATCH-DTL-KEY BL120 BL122
LINE-NBR BL130 BL20.1
AOC-CODE BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA08.1
MA180 MA530
MA531 MA540
MA60.2 MA60.3
...
PAOSET9 COMPANY KeyChange, Subset AP125 AP126
PO-NUMBER Where CANCELLED-FL != "Y" AP131 AP25.1
PO-RELEASE And VEN-AGRMT-REF = Spaces AP25.2 AP26.1
PO-CODE AP27.1 AP30.4
AOC-ON-PO API1.1 BL120
VENDOR BL122 BL130
LINE-NBR BL20.1 BL20.3
AOC-CODE BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
...
POAOCDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
PAO-COMPANY -> CPY-COMPANY
Iclocation ICLOCATION Not Required
PAO-COMPANY -> ICL-COMPANY
PAO-LOCATION -> ICL-LOCATION
Poaocmast POAOCMAST Required
PAO-COMPANY -> PAM-COMPANY
PAO-AOC-CODE -> PAM-AOC-CODE
Pocompany POCOMPANY Required
PAO-COMPANY -> PCY-COMPANY
Polinedtl POLINE Required
When PAO-LINE-NBR != Zeroes
And PAO-VEN-AGRMT-REF = Spaces
PAO-COMPANY -> PLI-COMPANY
PAO-PO-NUMBER -> PLI-PO-NUMBER
PAO-PO-RELEASE -> PLI-PO-RELEASE
PAO-PO-CODE -> PLI-PO-CODE
PAO-LINE-NBR -> PLI-LINE-NBR
Purchorder PURCHORDER Required
When PAO-VEN-AGRMT-REF = Spaces
PAO-COMPANY -> PCR-COMPANY
PAO-PO-CODE -> PCR-PO-CODE
PAO-PO-NUMBER -> PCR-PO-NUMBER
PAO-PO-RELEASE -> PCR-PO-RELEASE
Txtaxcode TXTAXCODE Required
PAO-COMPANY -> TAC-COMPANY
PAO-TAX-CODE -> TAC-TAX-CODE
Vendloc APVENLOC Not Required
CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP
PAO-VENDOR -> VLO-VENDOR
PAO-PURCH-FR-LOC -> VLO-LOCATION-CODE
Vendor APVENMAST Not Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
PAO-VENDOR -> VEN-VENDOR
POAOCDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Maaocdtl MAAOCDTL
PAO-COMPANY -> MAA-COMPANY
PAO-PO-NUMBER -> MAA-PO-NUMBER
PAO-PO-RELEASE -> MAA-PO-RELEASE
PAO-PO-CODE -> MAA-PO-CODE
PAO-LINE-NBR -> MAA-LINE-NBR
PAO-VENDOR -> MAA-VENDOR
PAO-AOC-CODE -> MAA-AOC-CODE
MAA-INVOICE
MAA-SUFFIX
MAA-SEQ-NBR
Poaudit POAUDIT
PAO-COMPANY -> PAU-COMPANY
PAO-PO-NUMBER -> PAU-PO-NUMBER
PAO-PO-RELEASE -> PAU-PO-RELEASE
PAO-PO-CODE -> PAU-PO-CODE
PAO-LINE-NBR -> PAU-PO-LINE-NBR
PAO-AOC-CODE -> PAU-AOC-CODE
PAU-PO-REVISION
PAU-UPDATE-DATE
PAU-UPDATE-TIME
PAU-FLD-NBR
PAU-AUDIT-TYPE
PAU-AUDIT-ACTION
Poline Dlv Dte POLINE
PAO-COMPANY -> PLI-COMPANY
PAO-LOCATION -> PLI-LOCATION
PLI-EARLY-DL-DATE
PLI-PO-NUMBER
PLI-PO-RELEASE
PLI-PO-CODE
PLI-LINE-NBR
|