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 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
PR514 UK47.1 PO67.1 PO229 API5.1
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 IC28.1 MA08.1
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.9 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
PO100 PO101 PO122 PO131 PO150 PO190
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 POD0.1 POI3.1
POI7.1 POIF.1 POIG.1 POII.1 POIJ.1 POIM.1
POIT.1 RQ10.1 RQ10.2 RQ10.3 RQIE.1 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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-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
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-VEN-AGRMT-REF Alpha 30 AP125 AP126
Element: Agreement Ref 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
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-PO-RELEASE Numeric 4 AP125 AP126
Element: PO Release NumUsed 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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-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
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-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
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-VENDOR Alpha 9 (Right Justified) AP125 AP126
Element: Vendor ID The vendor's identification code. 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
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO150 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
...
PAO-PURCH-FR-LOC Alpha 4 AP125 AP126
Purchase From The vendor's purchase from location. AP131 AP20.1
Location 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
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO150 PO190
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
...
PAO-LOCATION Alpha 5 AP125 AP126
Element: Location Code This field contains a valid stock AP131 AP20.1
location within the company inventory. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-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 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 AP23.1
line. AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-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
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-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
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-REC-QTY Signed 13.4 AP125 AP126
Element: Quantity 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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-MATCHED-QTY Signed 13.4 AP125 AP126
Element: Quantity 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
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-MISC-MA-AMT Signed 15.2 AP125 AP126
Element: Adj Amt 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
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-RECQTY-TO-MA Signed 13.4 AP125 AP126
Element: Quantity 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
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-TAXABLE-FLAG Alpha 1 AP125 AP126
Taxable or Defines if taxable. AP131 AP20.1
Non-Taxable Flag Y = Yes AP20.2 AP20.3
N = No AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-ORIGIN-CD Alpha 2 AP125 AP126
Element: Add On Cost CoPO = Purchase Order AP131 AP20.1
MA = Matching AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-AOC-ON-PO Alpha 1 AP125 AP126
Element: All Flag Y = Yes AP131 AP20.1
N = No AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
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 AP23.1
N = No AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-ZERO-COST-FLG Alpha 1 AP125 AP126
Element: Zero Cost FlagDefines 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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-CLOSED-FL Alpha 1 AP125 AP126
Element: All Flag The closed flag. AP131 AP20.1
N = No AP20.2 AP20.3
Y = Yes AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
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 AP23.1
flag will be set to a value of "Y". AP25.1 AP25.2
Once set to "Y", it never changes. AP26.1 AP27.1
Y = Issued AP30.4 API1.1
N = Not Issued IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-INVC-TAX-AMT Signed 15.2 AP125 AP126
Element: Adj Amt 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
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-ACCR-TAX-AMT Signed 15.2 AP125 AP126
Element: Adj Amt 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
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-EXT-TAXBL-AMT Signed 15.2 AP125 AP126
Element: Adj 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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-LAND-UNIT-CST Signed 13.5 AP125 AP126
Element: Base 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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
PAO-BL-INVC-AMT Signed 15.2 AP125 AP126
Element: Bl Invc Amt 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
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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
PO100 PO101
PO122 PO131
PO190 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
...
POAOCDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAOSET1 COMPANY AM115 AM15.1
PROCURE-GROUP AM15.2 AM15.3
VEN-AGRMT-REF AM15.4 AM20.1
PO-NUMBER AM20.3 AM21.1
PO-RELEASE AM21.3 AM500
PO-CODE AM51.1 AM551
LINE-NBR AM97.1 AP125
AOC-CODE 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 API2.1
...
PAOSET10 COMPANY This key was added to allow alternate AP125 AP126
PROCURE-GROUP file access for correcting DBAPIERROR AP131 AP20.1
VEN-AGRMT-REF problems. AP20.2 AP20.3
PO-NUMBER KeyChange AP20.4 AP20.5
PO-RELEASE AP20.7 AP23.1
PO-CODE AP25.1 AP25.2
LINE-NBR AP26.1 AP27.1
AOC-CODE AP30.4 API1.1
VENDOR IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
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 AP23.1
LINE-NBR AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA540
...
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 AP23.1
AOC-CODE AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.9 MA530
...
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 AP23.1
AOC-CODE AP25.1 AP25.2
LINE-NBR AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA540
...
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 AP23.1
LINE-NBR AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA540
...
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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA540
...
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 AP23.1
MATCH-DTL-KEY AP25.1 AP25.2
LINE-NBR AP26.1 AP27.1
AOC-CODE AP30.4 API1.1
API5.1 IC28.1
MA08.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
...
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 AP23.1
VENDOR AP25.1 AP25.2
LINE-NBR AP26.1 AP27.1
AOC-CODE AP30.4 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA540
...
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
Mainvdtl MAINVDTL Delete Restricted
PAO-COMPANY -> MAD-COMPANY
PAO-PO-NUMBER -> MAD-PO-NUMBER
PAO-PO-RELEASE -> MAD-PO-RELEASE
PAO-PO-CODE -> MAD-PO-CODE
PAO-LINE-NBR -> MAD-LINE-NBR
PAO-VENDOR -> MAD-VENDOR
PAO-AOC-CODE -> MAD-AOC-CODE
MAD-INVOICE
MAD-SUFFIX
MAD-SEQ-NBR
Mapoinv MAPOINV Delete Restricted
PAO-COMPANY -> AOI-COMPANY
PAO-PO-NUMBER -> AOI-PO-NUMBER
PAO-PO-RELEASE -> AOI-PO-RELEASE
PAO-PO-CODE -> AOI-PO-CODE
AOI-VENDOR
AOI-INVOICE
AOI-SUFFIX
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
|