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
API1.1 API2.1 PO135 PO220 PO225 PO26.1
PO60.1 PO61.1 PO63.1 PO64.1 PO67.1
UPDATED BY
MA08.1 PO190 POI7.1 POIF.1 POIJ.1 POIT.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAO-PROCURE-GROUP Alpha 4 MA08.1 PO190
Procure Group This field contains the identifier for a POI7.1 POIF.1
group of companies that share a common POIJ.1 POIT.1
procurement effort. They buy items and
services together.
PAO-COMPANY Numeric 4 MA08.1 PO190
Company The company number. POI7.1 POIF.1
POIJ.1 POIT.1
PAO-VEN-AGRMT-REF Alpha 30 MA08.1 PO190
Ven Agrmt Ref POI7.1 POIF.1
POIJ.1 POIT.1
PAO-PO-NUMBER Alpha 14 (Right Justified) MA08.1 PO190
PO Number This field contains the number POI7.1 POIF.1
representing the purchase order. POIJ.1 POIT.1
PAO-PO-RELEASE Numeric 4 MA08.1 PO190
PO Release Number Used to identify a purchase order POI7.1 POIF.1
release (created from a Blanket or POIJ.1 POIT.1
Standing order).
PAO-PO-CODE Alpha 4 MA08.1 PO190
Po Code This is the purchase order code. POI7.1 POIF.1
POIJ.1 POIT.1
PAO-LINE-NBR Numeric 6 MA08.1 PO190
Line Number This field contains the line number. POI7.1 POIF.1
POIJ.1 POIT.1
PAO-AOC-CODE Alpha 2 MA08.1 PO190
Add On Cost Code This field contains the identifier for POI7.1 POIF.1
the add-on cost associated with this POIJ.1 POIT.1
line item.
PAO-VENDOR Alpha 9 (Right Justified) MA08.1 PO190
Vendor ID The vendor's identification code. POI7.1 POIF.1
POIJ.1 POIT.1
PAO-PURCH-FR-LOC Alpha 4 MA08.1 PO190
Purchase From The vendor's purchase from location. POI7.1 POIF.1
Location Code POIJ.1 POIT.1
PAO-LOCATION Alpha 5 MA08.1 PO190
Location Code This field contains a valid stock POI7.1 POIF.1
location within the company inventory. POIJ.1 POIT.1
PAO-AOC-RATE Percent 7.3 (Percent) MA08.1 PO190
Add On Cost Rate Add-on cost percentage rate. If add-on POI7.1 POIF.1
cost is spread by rate, this value POIJ.1 POIT.1
multiplied by the line unit cost is the
unit add-on cost for the purchase order
line.
PAO-ENTRY Alpha 1 MA08.1 PO190
Entry Amount entry method. POI7.1 POIF.1
U = Unit Cost Entry POIJ.1 POIT.1
R = Rate Percentage Entry
T = Total Amount Entry
PAO-QUANTITY Signed 13.4 MA08.1 PO190
Quantity The order quantity. POI7.1 POIF.1
POIJ.1 POIT.1
PAO-ENT-UNIT-CST Signed 13.5 MA08.1 PO190
Entered Unit Cost The entered unit cost. POI7.1 POIF.1
POIJ.1 POIT.1
PAO-TOTAL-AOC Signed 15.2 MA08.1 PO190
Total Add On Cost The total add-on cost amount can be an POI7.1 POIF.1
entered amount if entered at this level, POIJ.1 POIT.1
or a calculated amount if a unit add-on
cost or add-on cost percent is entered.
PAO-REC-QTY Signed 13.4 MA08.1 PO190
Receiving Quantity The quantity received against the POI7.1 POIF.1
purchase order line the add-on cost is POIJ.1 POIT.1
associated with.
PAO-MATCHED-QTY Signed 13.4 MA08.1 PO190
Matched Qty POI7.1 POIF.1
POIJ.1 POIT.1
PAO-MISC-MA-AMT Signed 15.2 MA08.1 PO190
Misc Ma Amt POI7.1 POIF.1
POIJ.1 POIT.1
PAO-RECQTY-TO-MA Signed 13.4 MA08.1 PO190
Recqty To Ma POI7.1 POIF.1
POIJ.1 POIT.1
PAO-TAX-CODE Alpha 10 MA08.1 PO190
Tax Code This field contains a code representing POI7.1 POIF.1
specific tax information. This must be POIJ.1 POIT.1
valid Tax Code.
PAO-TAXABLE-FLAG Alpha 1 MA08.1 PO190
Taxable or Defines if taxable. POI7.1 POIF.1
Non-Taxable Flag Y = Yes POIJ.1 POIT.1
N = No
PAO-ORIGIN-CD Alpha 2 MA08.1 PO190
Origin Code This field identifies the system that POI7.1 POIF.1
created this record. POIJ.1 POIT.1
PO = Purchase Order
MA = Matching
PAO-AOC-ON-PO Alpha 1 MA08.1 PO190
Aoc On Po Indicates if the add-on cost is to POI7.1 POIF.1
appear on the Purchase Order document POIJ.1 POIT.1
that is issued to the vendor.
Y = Yes
N = No
PAO-SUMMARY-FLAG Alpha 1 MA08.1 PO190
Summary Only Defines if the add-on cost is printed POI7.1 POIF.1
in summary or at a detail level on the POIJ.1 POIT.1
purchase order.
Y = Yes
N = No
PAO-ZERO-COST-FLG Alpha 1 MA08.1 PO190
Zero Cost Flag Defines if this tax record is allowed POI7.1 POIF.1
to have a zero unit cost. POIJ.1 POIT.1
N = No
Y = Yes
PAO-CANCELLED-FL Alpha 1 MA08.1 PO190
Canceled Flag The canceled flag. POI7.1 POIF.1
N = No POIJ.1 POIT.1
Y = Yes
PAO-CLOSED-FL Alpha 1 MA08.1 PO190
Closed Flag The closed flag. POI7.1 POIF.1
N = No POIJ.1 POIT.1
Y = Yes
PAO-INV-SPRD-CRET Numeric 1 MA08.1 PO190
Inv Sprd Cret Defines if record was created during POI7.1 POIF.1
purchase order invoice spread. POIJ.1 POIT.1
1 = Invoice Spread Difference
PAO-MATCH-DTL-KEY Alpha 55 MA08.1 PO190
Match Dtl Key POI7.1 POIF.1
POIJ.1 POIT.1
PAO-ISSUED-FLAG Alpha 1 MA08.1 PO190
Issued Flag This is the issue status of the add on POI7.1 POIF.1
cost detail record. If the PO has been POIJ.1 POIT.1
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
PAO-INVC-TAX-AMT Signed 15.2 MA08.1 PO190
Invc Tax Amt The tax amount that is to be invoiced. POI7.1 POIF.1
POIJ.1 POIT.1
PAO-ACCR-TAX-AMT Signed 15.2 MA08.1 PO190
Accr Tax Amt The tax amount that is to be accrued. POI7.1 POIF.1
POIJ.1 POIT.1
PAO-EXT-TAXBL-AMT Signed 15.2 MA08.1 PO190
Ext Taxbl Amt The amount of the add on cost that is POI7.1 POIF.1
taxable. This is zero if the taxable POIJ.1 POIT.1
flag is "N", otherwise it will equal the
total AOC amount.
PAO-LAND-UNIT-CST Signed 13.5 MA08.1 PO190
Landed Unit Costs The unit cost of the add on costs if it POI7.1 POIF.1
is landed in addition to the unit cost POIJ.1 POIT.1
of taxes that are landed.
PAO-BL-INVC-AMT Signed 15.2 MA08.1 PO190
Bl Invc Amt POI7.1 POIF.1
POIJ.1 POIT.1
POAOCDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAOSET1 COMPANY API1.1 API2.1
PROCURE-GROUP MA08.1 PO135
VEN-AGRMT-REF PO190 PO220
PO-NUMBER PO225 PO26.1
PO-RELEASE PO60.1 PO61.1
PO-CODE PO63.1 PO64.1
LINE-NBR POI7.1 POIF.1
AOC-CODE POIJ.1 POIT.1
PAOSET2 COMPANY Subset MA08.1 PO190
AOC-CODE Where VEN-AGRMT-REF = Spaces PO67.1 POIF.1
PO-NUMBER POIJ.1 POIT.1
PO-RELEASE
PO-CODE
LINE-NBR
PAOSET3 COMPANY Subset MA08.1 PO190
PO-NUMBER Where LINE-NBR != Zeroes PO26.1 PO60.1
PO-RELEASE And VEN-AGRMT-REF = Spaces PO61.1 PO63.1
PO-CODE PO64.1 POIF.1
LINE-NBR POIJ.1 POIT.1
AOC-CODE
PAOSET4 COMPANY KeyChange, Subset MA08.1 PO190
VENDOR Where CLOSED-FL = "N" POIF.1 POIJ.1
PO-NUMBER And CANCELLED-FL = "N" POIT.1
PO-RELEASE And VEN-AGRMT-REF = Spaces
PO-CODE
AOC-CODE
LINE-NBR
PAOSET5 COMPANY Subset MA08.1 PO190
AOC-CODE Where CLOSED-FL = "N" POIF.1 POIJ.1
PO-NUMBER And CANCELLED-FL = "N" POIT.1
PO-RELEASE And VEN-AGRMT-REF = Spaces
PO-CODE
LINE-NBR
PAOSET6 PROCURE-GROUP Subset MA08.1 PO190
VEN-AGRMT-REF Where VEN-AGRMT-REF != Spaces POIF.1 POIJ.1
LINE-NBR POIT.1
AOC-CODE
PAOSET8 COMPANY KeyChange, Subset MA08.1 PO190
PO-NUMBER Where VEN-AGRMT-REF = Spaces POIF.1 POIJ.1
PO-RELEASE POIT.1
PO-CODE
LOCATION
MATCH-DTL-KEY
LINE-NBR
AOC-CODE
PAOSET9 COMPANY KeyChange, Subset MA08.1 PO190
PO-NUMBER Where CANCELLED-FL != "Y" POIF.1 POIJ.1
PO-RELEASE And VEN-AGRMT-REF = Spaces POIT.1
PO-CODE
AOC-ON-PO
VENDOR
LINE-NBR
AOC-CODE
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
|
