 |
Lawson Insight Technical Documentation |
|
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
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP23.1 API2.1 PO135 PO220 PO225 PO26.1
PO54.4 PO64.1 POIM.1 PO67.1
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 API1.1 IC28.1 MA08.1 MA180 MA41.1
MA41.4 MA43.9 MA530 MA531 MA540 MA60.2
MA60.3 MA60.5 MA61.1 MA66.3 MA67.1 MA67.2
MA70.1 MAI1.1 PO100 PO101 PO122 PO131
PO150 PO190 PO20.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO25.2 PO25.6 PO25.7
PO25.8 PO27.2 PO27.3 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 POI3.1 POI7.1 POIE.1
POIF.1 POIG.1 POII.1 POIJ.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
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 API1.1
services together. IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-COMPANY Numeric 4 AP125 AP126
Company The company number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-VEN-AGRMT-REF Alpha 30 AP125 AP126
Ven Agrmt Ref AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
PO Number This field contains the number AP131 AP25.1
representing the purchase order. AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-PO-RELEASE Numeric 4 AP125 AP126
PO Release Number Used to identify a purchase order AP131 AP25.1
release (created from a Blanket or AP25.2 AP26.1
Standing order). AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-PO-CODE Alpha 4 AP125 AP126
Po Code This is the purchase order code. AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-LINE-NBR Numeric 6 AP125 AP126
Line Number This field contains the line number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-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 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-VENDOR Alpha 9 (Right Justified) AP125 AP126
Vendor ID The vendor's identification code. AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO150 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.2
PO27.3 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
...
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 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO150 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.2
PO27.3 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
...
PAO-LOCATION Alpha 5 AP125 AP126
Location Code This field contains a valid stock AP131 AP25.1
location within the company inventory. AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-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 AP25.2 AP26.1
multiplied by the line unit cost is the AP27.1 API1.1
unit add-on cost for the purchase order IC28.1 MA08.1
line. MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-ENTRY Alpha 1 AP125 AP126
Entry Amount entry method. AP131 AP25.1
U = Unit Cost Entry AP25.2 AP26.1
R = Rate Percentage Entry AP27.1 API1.1
T = Total Amount Entry IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-QUANTITY Signed 13.4 AP125 AP126
Quantity The order quantity. AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-ENT-UNIT-CST Signed 13.5 AP125 AP126
Entered Unit Cost The entered unit cost. AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-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 API1.1
cost or add-on cost percent is entered. IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-REC-QTY Signed 13.4 AP125 AP126
Receiving Quantity The quantity received against the AP131 AP25.1
purchase order line the add-on cost is AP25.2 AP26.1
associated with. AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-MATCHED-QTY Signed 13.4 AP125 AP126
Matched Qty AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-MISC-MA-AMT Signed 15.2 AP125 AP126
Misc Ma Amt AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-RECQTY-TO-MA Signed 13.4 AP125 AP126
Recqty To Ma AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-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. AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
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 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-ORIGIN-CD Alpha 2 AP125 AP126
Origin Code This field identifies the system that AP131 AP25.1
created this record. AP25.2 AP26.1
PO = Purchase Order AP27.1 API1.1
MA = Matching IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-AOC-ON-PO Alpha 1 AP125 AP126
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 API1.1
Y = Yes IC28.1 MA08.1
N = No MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-SUMMARY-FLAG Alpha 1 AP125 AP126
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 API1.1
Y = Yes IC28.1 MA08.1
N = No MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-ZERO-COST-FLG Alpha 1 AP125 AP126
Zero Cost Flag Defines if this tax record is allowed AP131 AP25.1
to have a zero unit cost. AP25.2 AP26.1
N = No AP27.1 API1.1
Y = Yes IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-CANCELLED-FL Alpha 1 AP125 AP126
Canceled Flag The canceled flag. AP131 AP25.1
N = No AP25.2 AP26.1
Y = Yes AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-CLOSED-FL Alpha 1 AP125 AP126
Closed Flag The closed flag. AP131 AP25.1
N = No AP25.2 AP26.1
Y = Yes AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-INV-SPRD-CRET Numeric 1 AP125 AP126
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 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-MATCH-DTL-KEY Alpha 55 AP125 AP126
Match Dtl Key AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-ISSUED-FLAG Alpha 1 AP125 AP126
Issued 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 API1.1
cost detail record was created, this IC28.1 MA08.1
flag will be set to a value of "Y". MA180 MA41.1
Once set to "Y", it never changes. MA41.4 MA43.9
Y = Issued MA530 MA531
N = Not Issued MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-INVC-TAX-AMT Signed 15.2 AP125 AP126
Invc Tax Amt The tax amount that is to be invoiced. AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-ACCR-TAX-AMT Signed 15.2 AP125 AP126
Accr Tax Amt The tax amount that is to be accrued. AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-EXT-TAXBL-AMT Signed 15.2 AP125 AP126
Ext Taxbl 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 API1.1
total AOC amount. IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-LAND-UNIT-CST Signed 13.5 AP125 AP126
Landed Unit Costs 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 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
PAO-BL-INVC-AMT Signed 15.2 AP125 AP126
Bl Invc Amt AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO190 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO27.3 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
...
POAOCDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAOSET1 COMPANY AP125 AP126
PROCURE-GROUP AP131 AP20.1
VEN-AGRMT-REF AP20.2 AP20.3
PO-NUMBER AP20.4 AP20.5
PO-RELEASE AP20.7 AP23.1
PO-CODE AP25.1 AP25.2
LINE-NBR AP26.1 AP27.1
AOC-CODE API1.1 API2.1
IC28.1 MA08.1
MA180 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.9
MA530 MA531
...
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 IC28.1
PO-RELEASE MA180 MA43.9
PO-CODE MA530 MA531
LINE-NBR MA60.2 MA60.3
AOC-CODE MA60.5 MA61.1
VENDOR MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO190
PO20.1 PO21.2
PO21.3 PO21.4
...
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 API1.1
PO-CODE IC28.1 MA08.1
LINE-NBR MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
...
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 API1.1
LINE-NBR IC28.1 MA08.1
AOC-CODE MA180 MA41.1
MA41.4 MA43.1
MA43.3 MA43.4
MA43.5 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
...
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 API1.1
PO-CODE IC28.1 MA08.1
AOC-CODE MA180 MA41.1
LINE-NBR MA41.2 MA41.4
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
...
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 API1.1
PO-CODE IC28.1 MA08.1
LINE-NBR MA180 MA41.1
MA41.2 MA41.4
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
...
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 API1.1
IC28.1 MA08.1
MA180 MA41.1
MA41.4 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
...
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 API1.1
LOCATION IC28.1 MA08.1
MATCH-DTL-KEY MA180 MA41.1
LINE-NBR MA41.4 MA43.9
AOC-CODE MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
...
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 API1.1
AOC-ON-PO IC28.1 MA08.1
VENDOR MA180 MA41.1
LINE-NBR MA41.4 MA43.9
AOC-CODE MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
...
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
|