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
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 AM500 AM51.1 AM551 AM97.1 AP03.3
AP110 AP115 AP210 AP220 AP305 AP510
AP90.1 AP91.1 API2.1 API3.1 API4.1 MX123
MX500 MA279 MA63.1 MA65.1 MA90.2 MA90.3
MA90.5 MA90.1 PD235 PO10.1 PO120 PO135
PO220 PO223 PO225 PO233 PO253 PO254
PO26.1 PO278 PO54.1 PO54.2 PO54.3 PO54.4
PO63.1 PO64.1 PR05.1 PR05.3 PR226 PR247
PR26.1 PR47.1 PR514 UK47.1 PO67.1 POED.1
PO229
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 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 MA08.1
MA180 MA278 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.7 MA43.4 MA530
MA531 MA540 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA66.3 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PO100
PO101 PO122 PO131 PO136 PO150 PO190
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO24.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 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
POD0.1 POI3.1 POI7.1 POID.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 AP20.1
group of companies that share a common AP20.2 AP20.3
procurement effort. They buy items and AP20.4 AP20.5
services together. AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-COMPANY Numeric 4 AP125 AP126
Element: Company The company number. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-VEN-AGRMT-REF Alpha 30 AP125 AP126
Element: Agreement Ref AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
Element: Po Number This field contains the number AP131 AP20.1
representing the purchase order. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-PO-RELEASE Numeric 4 AP125 AP126
Element: Po Release Used to identify a purchase order AP131 AP20.1
release (created from a Blanket or AP20.2 AP20.3
Standing order). AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-PO-CODE Alpha 4 AP125 AP126
Element: Po Code This is the purchase order code. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-LINE-NBR Numeric 6 AP125 AP126
Element: Line Nbr This field contains the line number. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-AOC-CODE Alpha 2 AP125 AP126
Element: Aoc Code This 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 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-VENDOR Alpha 9 (Right Justified) AP125 AP126
Element: Vendor The vendor's identification code. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-PURCH-FR-LOC Alpha 4 AP125 AP126
Element: Purch Fr Loc The vendor's purchase from location. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-LOCATION Alpha 5 AP125 AP126
Element: Location This field contains a valid stock AP131 AP20.1
location within the company inventory. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-AOC-RATE Percent 7.3 (Percent) AP125 AP126
Element: Aoc Rate Add-on cost percentage rate. If add-on AP131 AP20.1
cost is spread by rate, this value AP20.2 AP20.3
multiplied by the line unit cost is the AP20.4 AP20.5
unit add-on cost for the purchase order AP20.7 AP21.1
line. AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-ENTRY Alpha 1 AP125 AP126
Element: Entry Amount entry method. AP131 AP20.1
U = Unit Cost Entry AP20.2 AP20.3
R = Rate Percentage Entry AP20.4 AP20.5
T = Total Amount Entry AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-QUANTITY Signed 13.4 AP125 AP126
Element: Quantity The order quantity. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-ENT-UNIT-CST Signed 18.5 AP125 AP126
Element: Intl Cost The entered unit cost in the vendor AP131 AP20.1
price unit of measure terms. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-TOTAL-AOC Signed 18.2 AP125 AP126
Element: Intl Amt The 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 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-REC-QTY Signed 13.4 AP125 AP126
Element: Rec Qty The quantity received against the AP131 AP20.1
purchase order line the add-on cost is AP20.2 AP20.3
associated with. AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-MATCHED-QTY Signed 13.4 AP125 AP126
Element: Rec Qty This is the total quantity to date AP131 AP20.1
received for this ordered item. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-MISC-MA-AMT Signed 18.2 AP125 AP126
Element: Intl Amt AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-RECQTY-TO-MA Signed 13.4 AP125 AP126
Element: Rec Qty This is the qty on the receipt that AP131 AP20.1
remains available to match. The qty in AP20.2 AP20.3
this field would be the whole qty of the AP20.4 AP20.5
receipt until a match is completed and AP20.7 AP21.1
then the qty would decreas by the qty AP23.1 AP25.1
matched. RECQTY-TO-MA - MATCHED-QTY AP25.2 AP26.1
=new RECQTY-TO-MA 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-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. AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-TAXABLE-FLAG Alpha 1 AP125 AP126
Element: Taxable Flag Defines if taxable. AP131 AP20.1
Y = Yes AP20.2 AP20.3
N = No AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-ORIGIN-CD Alpha 2 AP125 AP126
Element: Origin Code System origin code AP131 AP20.1
PO = Purchase Order AP20.2 AP20.3
MA = Matching AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-AOC-ON-PO Alpha 1 AP125 AP126
Element: Aoc On Po Indicates if the add-on cost is to AP131 AP20.1
appear on the Purchase Order document AP20.2 AP20.3
that is issued to the vendor. AP20.4 AP20.5
Y = Yes AP20.7 AP21.1
N = No AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-SUMMARY-FLAG Alpha 1 AP125 AP126
Element: Summary Only Defines if the add-on cost is printed AP131 AP20.1
in summary or at a detail level on the AP20.2 AP20.3
purchase order. AP20.4 AP20.5
Y = Yes AP20.7 AP21.1
N = No AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-ZERO-COST-FLG Alpha 1 AP125 AP126
Element: Zero Cost Flg Defines if this tax record is allowed AP131 AP20.1
to have a zero unit cost. AP20.2 AP20.3
N = No AP20.4 AP20.5
Y = Yes AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-CANCELLED-FL Alpha 1 AP125 AP126
Element: All Flag N = No AP131 AP20.1
Y = Yes AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-CLOSED-FL Alpha 1 AP125 AP126
Element: Closed Fl The closed flag. AP131 AP20.1
N = No AP20.2 AP20.3
Y = Yes AP20.4 AP20.5
H = History AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-INV-SPRD-CRET Numeric 1 AP125 AP126
Element: Inv Sprd Cret Defines if record was created during AP131 AP20.1
purchase order invoice spread. AP20.2 AP20.3
1 = Invoice Spread Difference AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-MATCH-DTL-KEY Alpha 85 AP125 AP126
Element: Match Dtl Key AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-ISSUED-FLAG Alpha 1 AP125 AP126
Element: All Flag This is the issue status of the add on AP131 AP20.1
cost detail record. If the PO has been AP20.2 AP20.3
issued at least once since the add on AP20.4 AP20.5
cost detail record was created, this AP20.7 AP21.1
flag will be set to a value of "Y". AP23.1 AP25.1
Once set to "Y", it never changes. AP25.2 AP26.1
Y = Issued AP27.1 AP30.4
N = Not Issued API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-INVC-TAX-AMT Signed 18.2 AP125 AP126
Element: Intl Amt AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-ACCR-TAX-AMT Signed 18.2 AP125 AP126
Element: Intl Amt AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-EXT-TAXBL-AMT Signed 18.2 AP125 AP126
Element: Intl Amt The amount of the add on cost that is AP131 AP20.1
taxable. This is zero if the taxable AP20.2 AP20.3
flag is "N", otherwise it will equal the AP20.4 AP20.5
total AOC amount. AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-LAND-UNIT-CST Signed 18.5 AP125 AP126
Element: Intl Cost The unit cost of the add on costs if it AP131 AP20.1
is landed in addition to the unit cost AP20.2 AP20.3
of taxes that are landed. AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-BL-INVC-AMT Signed 18.2 AP125 AP126
Element: Intl Amt AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-LANDED-FLAG Numeric 1 AP125 AP126
Element: Landed Flag 0 = No AP131 AP20.1
1 = Landed AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
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: Fob Code The user defined Free On Board Code.
PAO-TERM-CODE Alpha 5
Element: Term Code A user-defined code representing a
method of determining invoice due and
discount dates.
PAO-XREF-VENDOR Alpha 9 (Right Justified) AP125 AP126
Element: Xref Vendor This is a vendor that is supported on a AP131 AP20.1
system outside Lawson. When records are AP20.2 AP20.3
interfaces we will maintain this vendor AP20.4 AP20.5
on the file but we will use the Lawson AP20.7 AP21.1
vendor while in the lawson application. AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-CURRENCY-CODE Alpha 5 AP125 AP126
Element: Currency Code This field contains the company base AP131 AP20.1
currency code established in Company AP20.2 AP20.3
(GL10.1 ). AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-ENT-CNV-RATE Signed 14.7 AP125 AP126
Element: Ent Cnv Rate Currency conversion rate at Purchase AP131 AP20.1
Order entry time. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-REC-CNV-RATE Signed 14.7 AP125 AP126
Element: Ent Cnv Rate Currency conversion rate at Purchase AP131 AP20.1
Order entry time. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-TOTAL-AOC-PO Signed 18.2 AP125 AP126
Element: Intl Amt The total add-on cost amount in the AP131 AP20.1
Purchase Order currency. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-OPEN-PO-AMT Signed 18.2
Element: Intl Amt
PAO-CHARGEBACK-QTY Signed 13.4
Element: Quantity This field contains the desired
quantity.
PAO-ITAX-AMT-PO Signed 18.2 AP125 AP126
Element: Intl Amt AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-ATAX-AMT-PO Signed 18.2 AP125 AP126
Element: Intl Amt AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
PAO-EX-TXBL-AMT-PO Signed 18.2 AP125 AP126
Element: Intl Amt AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
...
POAOCDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAOSET1 COMPANY AC160 AM115
PROCURE-GROUP AM117 AM15.1
VEN-AGRMT-REF AM15.2 AM15.3
PO-NUMBER AM15.4 AM19.1
PO-RELEASE AM19.2 AM20.1
PO-CODE AM20.3 AM21.1
LINE-NBR AM21.3 AM500
AOC-CODE AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
...
PAOSET10 COMPANY KeyChange AP125 AP126
PROCURE-GROUP AP131 AP20.1
VEN-AGRMT-REF AP20.2 AP20.3
PO-NUMBER AP20.4 AP20.5
PO-RELEASE AP20.7 AP21.1
PO-CODE AP23.1 AP25.1
LINE-NBR AP25.2 AP26.1
AOC-CODE AP27.1 AP30.4
VENDOR API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
PAOSET2 COMPANY Subset AP125 AP126
AOC-CODE Where VEN-AGRMT-REF = Spaces AP131 AP20.1
PO-NUMBER AP20.2 AP20.3
PO-RELEASE AP20.4 AP20.5
PO-CODE AP20.7 AP21.1
LINE-NBR AP23.1 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 MA08.1
...
PAOSET3 COMPANY Subset AP125 AP126
PO-NUMBER Where LINE-NBR != Zeroes AP131 AP20.1
PO-RELEASE And VEN-AGRMT-REF = Spaces AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
LINE-NBR AP20.7 AP21.1
AOC-CODE AP23.1 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 MA08.1
...
PAOSET4 COMPANY KeyChange, Subset AP125 AP126
VENDOR Where CLOSED-FL = "N" AP131 AP20.1
PO-NUMBER And CANCELLED-FL = "N" AP20.2 AP20.3
PO-RELEASE And VEN-AGRMT-REF = Spaces AP20.4 AP20.5
PO-CODE AP20.7 AP21.1
AOC-CODE AP23.1 AP25.1
LINE-NBR AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
PAOSET5 COMPANY Subset AP125 AP126
AOC-CODE Where CLOSED-FL = "N" AP131 AP20.1
PO-NUMBER And CANCELLED-FL = "N" AP20.2 AP20.3
PO-RELEASE And VEN-AGRMT-REF = Spaces AP20.4 AP20.5
PO-CODE AP20.7 AP21.1
LINE-NBR AP23.1 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 MA08.1
...
PAOSET6 PROCURE-GROUP Subset AP125 AP126
VEN-AGRMT-REF Where VEN-AGRMT-REF != Spaces AP131 AP20.1
LINE-NBR AP20.2 AP20.3
AOC-CODE AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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 MA08.1
...
PAOSET8 COMPANY KeyChange, Subset AP125 AP126
PO-NUMBER Where VEN-AGRMT-REF = Spaces AP131 AP20.1
PO-RELEASE AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
LOCATION AP20.7 AP21.1
MATCH-DTL-KEY AP23.1 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 MA08.1
...
PAOSET9 COMPANY KeyChange, Subset AP125 AP126
PO-NUMBER Where CANCELLED-FL != "Y" AP131 AP20.1
PO-RELEASE And VEN-AGRMT-REF = Spaces AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
AOC-ON-PO AP20.7 AP21.1
VENDOR AP23.1 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 MA08.1
...
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 Not Required
Valid 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
Mmdist MMDIST
PAO-COMPANY -> MMD-COMPANY
PAO-PO-NUMBER -> MMD-DOC-NUMBER
PAO-PO-RELEASE -> MMD-DOC-NBR-NUM
PAO-PO-CODE -> MMD-PO-CODE
PAO-LINE-NBR -> MMD-LINE-NBR
PAO-AOC-CODE -> MMD-AOC-CODE
MMD-LINE-SEQ
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
|