POAOCDTL

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.
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 AP30.2 API1.1
API2.1 MA08.1 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MA540 MAI1.1 PO136 PO190 PO300 PO520
POCP.1 POI3.1 POI7.1 POIF.1 POIG.1 POII.1
POIJ.1 POIM.1 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 AP150 AP210 AP220
AP305 AP510 AP90.1 AP91.1 API3.1 API4.1
MX123 MX500 PO10.1 PO64.1 PR05.1 PR05.3
PR226 PR247 PR26.1 PR47.1 PR514 UK47.1
POED.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAO-PROCURE-GROUP
Element: Procure Group
Alpha 4
This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-COMPANY
Element: Company
Numeric 4
The company number.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-VEN-AGRMT-REF
Element: Agreement Ref
Alpha 30
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-PO-NUMBER
Element: Po Number
Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-PO-RELEASE
Element: Po Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-AOC-CODE
Element: Aoc Code
Alpha 2
This field contains the identifier for the add-on cost associated with this line item.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-PURCH-FR-LOC
Element: Purch Fr Loc
Alpha 4
The vendor's purchase from location.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-LOCATION
Element: Location
Alpha 5
This field contains a valid stock location within the company inventory.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-AOC-RATE
Element: Aoc Rate
Percent 7.3 (Percent)
Add-on cost percentage rate. If add-on cost is spread by rate, this value multiplied by the line unit cost is the unit add-on cost for the purchase order line.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-ENTRY
Element: Entry
Alpha 1
Amount entry method.
U = Unit Cost Entry
R = Rate Percentage Entry
T = Total Amount Entry
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-QUANTITY
Element: Quantity
Signed 13.4
The order quantity.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-ENT-UNIT-CST
Element: Intl Cost
Signed 18.5
The entered unit cost in the vendor price unit of measure terms.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-TOTAL-AOC
Element: Intl Amt
Signed 18.2
The total add-on cost amount can be an entered amount if entered at this level, or a calculated amount if a unit add-on cost or add-on cost percent is entered.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-REC-QTY
Element: Rec Qty
Signed 13.4
The quantity received against the purchase order line the add-on cost is associated with.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-MATCHED-QTY
Element: Rec Qty
Signed 13.4
This is the total quantity to date received for this ordered item.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-MISC-MA-AMT
Element: Intl Amt
Signed 18.2
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-RECQTY-TO-MA
Element: Rec Qty
Signed 13.4
This is the qty on the receipt that remains available to match. The qty in this field would be the whole qty of the receipt until a match is completed and then the qty would decreas by the qty matched. RECQTY-TO-MA - MATCHED-QTY =new RECQTY-TO-MA
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-TAXABLE-FLAG
Element: Taxable Flag
Alpha 1
Defines if taxable.
Y = Yes
N = No
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-ORIGIN-CD
Element: Origin Code
Alpha 2
System origin code
PO = Purchase Order
MA = Matching
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-AOC-ON-PO
Element: Aoc On Po
Alpha 1
Indicates if the add-on cost is to appear on the Purchase Order document that is issued to the vendor.
Y = Yes
N = No
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-SUMMARY-FLAG
Element: Summary Only
Alpha 1
Defines if the add-on cost is printed in summary or at a detail level on the purchase order.
Y = Yes
N = No
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-ZERO-COST-FLG
Element: Zero Cost Flg
Alpha 1
Defines if this tax record is allowed to have a zero unit cost.
N = No
Y = Yes
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-CANCELLED-FL
Element: All Flag
Alpha 1

N = No
Y = Yes
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-CLOSED-FL
Element: Closed Fl
Alpha 1
The closed flag.
N = No
Y = Yes
H = History
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-INV-SPRD-CRET
Element: Inv Sprd Cret
Numeric 1
Defines if record was created during purchase order invoice spread.
1 = Invoice Spread Difference
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-MATCH-DTL-KEY
Element: Match Dtl Key
Alpha 85
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-ISSUED-FLAG
Element: All Flag
Alpha 1
This is the issue status of the add on cost detail record. If the PO has been issued at least once since the add on cost detail record was created, this flag will be set to a value of "Y". Once set to "Y", it never changes.
Y = Issued
N = Not Issued
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-INVC-TAX-AMT
Element: Intl Amt
Signed 18.2
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-ACCR-TAX-AMT
Element: Intl Amt
Signed 18.2
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-EXT-TAXBL-AMT
Element: Intl Amt
Signed 18.2
The amount of the add on cost that is taxable. This is zero if the taxable flag is "N", otherwise it will equal the total AOC amount.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-LAND-UNIT-CST
Element: Intl Cost
Signed 18.5
The unit cost of the add on costs if it is landed in addition to the unit cost of taxes that are landed.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-BL-INVC-AMT
Element: Intl Amt
Signed 18.2
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-LANDED-FLAG
Element: Landed Flag
Numeric 1

0 = No
1 = Landed
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-FREIGHT-TERMS
Element: Freight Terms
Alpha 1
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
Element: Fob Code
Alpha 3
The user defined Free On Board Code.
PAO-TERM-CODE
Element: Term Code
Alpha 5
A user-defined code representing a method of determining invoice due and discount dates.
PAO-XREF-VENDOR
Element: Xref Vendor
Alpha 9 (Right Justified)
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.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-ENT-CNV-RATE
Element: Ent Cnv Rate
Signed 14.7
Currency conversion rate at Purchase Order entry time.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-REC-CNV-RATE
Element: Ent Cnv Rate
Signed 14.7
Currency conversion rate at Purchase Order entry time.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-TOTAL-AOC-PO
Element: Intl Amt
Signed 18.2
The total add-on cost amount in the Purchase Order currency.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-OPEN-PO-AMT
Element: Intl Amt
Signed 18.2
PAO-CHARGEBACK-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-ITAX-AMT-PO
Element: Intl Amt
Signed 18.2
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-ATAX-AMT-PO
Element: Intl Amt
Signed 18.2
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-EX-TXBL-AMT-PO
Element: Intl Amt
Signed 18.2
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POIF.1 POIG.1
POII.1 POIJ.1
POIM.1
PAO-MNR-QTY
Element: Quantity
Signed 13.4
PAO-WRITE-OFF-QTY
Element: Quantity
Signed 13.4
PAO-ARCHIVE-QTY
Element: Quantity
Signed 13.4
PAO-MEMO-QTY
Element: Quantity
Signed 13.4
PAO-MEMO-AMT
Element: Intl Amt
Signed 18.2


POAOCDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAOSET1 COMPANY
PROCURE-GROUP
VEN-AGRMT-REF
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
AOC-CODE
...
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 AP125
AP126 AP131
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
PAOSET10 COMPANY
PROCURE-GROUP
VEN-AGRMT-REF
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
AOC-CODE
VENDOR
KeyChange
...
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PAOSET2 COMPANY
AOC-CODE
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
Subset
WhereVEN-AGRMT-REF =Spaces
...
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
PAOSET3 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
AOC-CODE
Subset
WhereLINE-NBR !=Zeroes
AndVEN-AGRMT-REF =Spaces
...
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
PAOSET4 COMPANY
VENDOR
PO-NUMBER
PO-RELEASE
PO-CODE
AOC-CODE
LINE-NBR
KeyChange, Subset
WhereCLOSED-FL ="N"
AndCANCELLED-FL ="N"
AndVEN-AGRMT-REF =Spaces
...
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
PAOSET5 COMPANY
AOC-CODE
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
Subset
WhereCLOSED-FL ="N"
AndCANCELLED-FL ="N"
AndVEN-AGRMT-REF =Spaces
...
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
PAOSET6 PROCURE-GROUP
VEN-AGRMT-REF
LINE-NBR
AOC-CODE
Subset
WhereVEN-AGRMT-REF !=Spaces
...
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
PAOSET8 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
LOCATION
MATCH-DTL-KEY
LINE-NBR
AOC-CODE
KeyChange, Subset
WhereVEN-AGRMT-REF =Spaces
...
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
PAOSET9 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
AOC-ON-PO
VENDOR
LINE-NBR
AOC-CODE
KeyChange, Subset
WhereCANCELLED-FL !="Y"
AndVEN-AGRMT-REF =Spaces
...
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 API2.1
MA08.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540


POAOCDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
AndPAO-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
NAME
RELATED 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


File created: Wed Jun 08 20:50:43 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.