POAOCDTL – Add On Cost Detail

System
Purchase Order (PO)
Prefix
PAO
Primary key
COMPANY, PROCURE-GROUP, VEN-AGRMT-REF, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE
Fields
58
Updated by
235 programs
Referenced by
66 programs

POAOCDTL is the Add On Cost Detail table in Lawson Purchase Order (prefix PAO). It is indexed by COMPANY, PROCURE-GROUP, VEN-AGRMT-REF, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE (PAOSET1); alternate indexes: PAOSET10, PAOSET2, PAOSET3, PAOSET4, PAOSET5, PAOSET6, PAOSET8 and PAOSET9. It is related 1:1 to APCOMPANY, ICLOCATION, POAOCMAST, POCOMPANY, POLINE, PURCHORDER, TXTAXCODE, APVENLOC and 1 more and 1:M to MAAOCDTL, MMDIST, POAGMAUDIT, POAUDIT and POLINE. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 227 more and referenced by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 58 more. The table has 58 fields, 9 indexes and 14 documented relations.

About POAOCDTL

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.

Fields (58)

Column = COBOL field name without the PAO- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PAO-PROCURE-GROUP PK
PROCURE_GROUP
Alpha 4This 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 +52 more (list truncated in source)
PAO-COMPANY PK
COMPANY
Numeric 4The company number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-VEN-AGRMT-REF PK
VEN_AGRMT_REF
Alpha 30AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-PO-NUMBER PK
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 +52 more (list truncated in source)
PAO-PO-RELEASE PK
PO_RELEASE
Numeric 4Used 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 +52 more (list truncated in source)
PAO-PO-CODE PK
PO_CODE
Alpha 4This is the purchase order code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-LINE-NBR PK
LINE_NBR
Numeric 6This field contains the line number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-AOC-CODE PK
AOC_CODE
Alpha 2This is 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 +52 more (list truncated in source)
PAO-VENDOR
VENDOR
Alpha 9 (Right Justified)The vendor's identification code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-PURCH-FR-LOC
PURCH_FR_LOC
Alpha 4The vendor's purchase from location.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-LOCATION
LOCATION
Alpha 5This field contains a valid stock location within the company inventory.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-AOC-RATE
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 +52 more (list truncated in source)
PAO-ENTRY
ENTRY
Alpha 1Amount 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 +52 more (list truncated in source)
PAO-QUANTITY
QUANTITY
Signed 13.4The order quantity.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-ENT-UNIT-CST
ENT_UNIT_CST
Signed 18.5The entered unit cost in the vendor price unit of measure terms.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-TOTAL-AOC
TOTAL_AOC
Signed 18.2The 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 +52 more (list truncated in source)
PAO-REC-QTY
REC_QTY
Signed 13.4The 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 +52 more (list truncated in source)
PAO-MATCHED-QTY
MATCHED_QTY
Signed 13.4This is the total quantity to date received for this ordered item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-MISC-MA-AMT
MISC_MA_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-RECQTY-TO-MA
RECQTY_TO_MA
Signed 13.4This 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-MAAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-TAX-CODE
TAX_CODE
Alpha 10This 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 +52 more (list truncated in source)
PAO-TAXABLE-FLAG
TAXABLE_FLAG
Alpha 1Defines if taxable.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-ORIGIN-CD
ORIGIN_CD
Alpha 2System origin code
  • PO Purchase Order
  • MA Matching
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-AOC-ON-PO
AOC_ON_PO
Alpha 1Indicates 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 +52 more (list truncated in source)
PAO-SUMMARY-FLAG
SUMMARY_FLAG
Alpha 1Defines 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 +52 more (list truncated in source)
PAO-ZERO-COST-FLG
ZERO_COST_FLG
Alpha 1Defines whether or not 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 +52 more (list truncated in source)
PAO-CANCELLED-FL
CANCELLED_FL
Alpha 1
  • N No
  • Y Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-CLOSED-FL
CLOSED_FL
Alpha 1The closed flag.
  • N No
  • Y Yes
  • H History
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-INV-SPRD-CRET
INV_SPRD_CRET
Numeric 1Defines 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 +52 more (list truncated in source)
PAO-MATCH-DTL-KEY
MATCH_DTL_KEY
Alpha 85AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-ISSUED-FLAG
ISSUED_FLAG
Alpha 1This 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 +52 more (list truncated in source)
PAO-INVC-TAX-AMT
INVC_TAX_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-ACCR-TAX-AMT
ACCR_TAX_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-EXT-TAXBL-AMT
EXT_TAXBL_AMT
Signed 18.2The 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 +52 more (list truncated in source)
PAO-LAND-UNIT-CST
LAND_UNIT_CST
Signed 18.5The 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 +52 more (list truncated in source)
PAO-BL-INVC-AMT
BL_INVC_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-LANDED-FLAG
LANDED_FLAG
Numeric 1
  • 0 No
  • 1 Landed
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-FREIGHT-TERMS
FREIGHT_TERMS
Alpha 1Freight 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
FOB_CODE
Alpha 3The user defined Free On Board Code.
PAO-TERM-CODE
TERM_CODE
Alpha 5A user-defined code representing a method of determining invoice due and discount dates.
PAO-XREF-VENDOR
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 +52 more (list truncated in source)
PAO-CURRENCY-CODE
CURRENCY_CODE
Alpha 5This 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 +52 more (list truncated in source)
PAO-ENT-CNV-RATE
ENT_CNV_RATE
Signed 14.7Currency conversion rate at Purchase Order entry time.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-REC-CNV-RATE
REC_CNV_RATE
Signed 14.7Currency conversion rate at Purchase Order entry time.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-TOTAL-AOC-PO
TOTAL_AOC_PO
Signed 18.2The total add-on cost amount in the Purchase Order currency.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-OPEN-PO-AMT
OPEN_PO_AMT
Signed 18.2
PAO-CHARGEBACK-QTY
CHARGEBACK_QTY
Signed 13.4This field contains the desired quantity.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-ITAX-AMT-PO
ITAX_AMT_PO
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-ATAX-AMT-PO
ATAX_AMT_PO
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-EX-TXBL-AMT-PO
EX_TXBL_AMT_PO
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-MNR-QTY
MNR_QTY
Signed 13.4
PAO-WRITE-OFF-QTY
WRITE_OFF_QTY
Signed 13.4
PAO-ARCHIVE-QTY
ARCHIVE_QTY
Signed 13.4
PAO-MEMO-QTY
MEMO_QTY
Signed 13.4
PAO-MEMO-AMT
MEMO_AMT
Signed 18.2
PAO-TRACK-TYPE
TRACK_TYPE
Alpha 1" " = Other AOC
  • I Insurance
  • F Freight
  • C Customs Charges
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAO-GLBL-DOC-TYPE
GLBL_DOC_TYPE
Alpha 10
PAO-GLBL-LINE-TYPE
GLBL_LINE_TYPE
Alpha 15

Indexes (9)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PAOSET1COMPANY, PROCURE-GROUP, VEN-AGRMT-REF, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODEPrimaryAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
PAOSET10COMPANY, PROCURE-GROUP, VEN-AGRMT-REF, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, VENDORKeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PAOSET2COMPANY, AOC-CODE, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBRSubsetWhere VEN-AGRMT-REF = SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PAOSET3COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODESubsetWhere LINE-NBR != Zeroes And VEN-AGRMT-REF = SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PAOSET4COMPANY, VENDOR, PO-NUMBER, PO-RELEASE, PO-CODE, AOC-CODE, LINE-NBRKeyChange, SubsetWhere CLOSED-FL = "N" And CANCELLED-FL = "N" And VEN-AGRMT-REF = SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PAOSET5COMPANY, AOC-CODE, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBRSubsetWhere CLOSED-FL = "N" And CANCELLED-FL = "N" And VEN-AGRMT-REF = SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PAOSET6PROCURE-GROUP, VEN-AGRMT-REF, LINE-NBR, AOC-CODESubsetWhere VEN-AGRMT-REF != SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PAOSET8COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LOCATION, MATCH-DTL-KEY, LINE-NBR, AOC-CODEKeyChange, SubsetWhere VEN-AGRMT-REF = SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PAOSET9COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, AOC-ON-PO, VENDOR, LINE-NBR, AOC-CODEKeyChange, SubsetWhere CANCELLED-FL != "Y" And VEN-AGRMT-REF = SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

One to one (9) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequiredPAO-COMPANYCPY-COMPANY
IclocationICLOCATIONNot RequiredPAO-COMPANYICL-COMPANY, PAO-LOCATIONICL-LOCATION
PoaocmastPOAOCMASTRequiredPAO-COMPANYPAM-COMPANY, PAO-AOC-CODEPAM-AOC-CODE
PocompanyPOCOMPANYRequiredPAO-COMPANYPCY-COMPANY
PolinedtlPOLINENot RequiredValid When PAO-LINE-NBR != Zeroes And PAO-VEN-AGRMT-REF = SpacesPAO-COMPANYPLI-COMPANY, PAO-PO-NUMBERPLI-PO-NUMBER, PAO-PO-RELEASEPLI-PO-RELEASE, PAO-PO-CODEPLI-PO-CODE, PAO-LINE-NBRPLI-LINE-NBR
PurchorderPURCHORDERRequiredWhen PAO-VEN-AGRMT-REF = SpacesPAO-COMPANYPCR-COMPANY, PAO-PO-CODEPCR-PO-CODE, PAO-PO-NUMBERPCR-PO-NUMBER, PAO-PO-RELEASEPCR-PO-RELEASE
TxtaxcodeTXTAXCODERequiredPAO-COMPANYTAC-COMPANY, PAO-TAX-CODETAC-TAX-CODE
VendlocAPVENLOCNot RequiredCPY-VENDOR-GROUPVLO-VENDOR-GROUP, PAO-VENDORVLO-VENDOR, PAO-PURCH-FR-LOCVLO-LOCATION-CODE
VendorAPVENMASTNot RequiredCPY-VENDOR-GROUPVEN-VENDOR-GROUP, PAO-VENDORVEN-VENDOR

One to many (5) — child tables

RelationTableRulesConditionField map
MaaocdtlMAAOCDTLPAO-COMPANYMAA-COMPANY, PAO-PO-NUMBERMAA-PO-NUMBER, PAO-PO-RELEASEMAA-PO-RELEASE, PAO-PO-CODEMAA-PO-CODE, PAO-LINE-NBRMAA-LINE-NBR, PAO-VENDORMAA-VENDOR, PAO-AOC-CODEMAA-AOC-CODE, MAA-INVOICE, MAA-SUFFIX, MAA-SEQ-NBR
MmdistMMDISTPAO-COMPANYMMD-COMPANY, PAO-PO-NUMBERMMD-DOC-NUMBER, PAO-PO-RELEASEMMD-DOC-NBR-NUM, PAO-PO-CODEMMD-PO-CODE, PAO-LINE-NBRMMD-LINE-NBR, PAO-AOC-CODEMMD-AOC-CODE, MMD-LINE-SEQ
PoagmauditPOAGMAUDITPAO-PROCURE-GROUPPVB-PROCURE-GROUP, PAO-VEN-AGRMT-REFPVB-VEN-AGRMT-REF, PAO-LINE-NBRPVB-LINE-NBR, PAO-AOC-CODEPVB-AOC-CODE, PVB-SYSTEM, PVB-LINE-SEQ, PVB-COMMIT-DATE, PVB-UPDATE-DATE, PVB-UPDATE-TIME, PVB-FLD-NBR, PVB-AUDIT-TYPE
PoauditPOAUDITPAO-COMPANYPAU-COMPANY, PAO-PO-NUMBERPAU-PO-NUMBER, PAO-PO-RELEASEPAU-PO-RELEASE, PAO-PO-CODEPAU-PO-CODE, PAO-LINE-NBRPAU-PO-LINE-NBR, PAO-AOC-CODEPAU-AOC-CODE, PAU-LINE-SEQ, PAU-PO-REVISION, PAU-UPDATE-DATE, PAU-UPDATE-TIME, PAU-FLD-NBR, PAU-AUDIT-TYPE, PAU-AUDIT-ACTION
Poline Dlv DtePOLINEPAO-COMPANYPLI-COMPANY, PAO-LOCATIONPLI-LOCATION, PLI-EARLY-DL-DATE, PLI-PO-NUMBER, PLI-PO-RELEASE, PLI-PO-CODE, PLI-LINE-NBR

Programs

Updated by (235)

Referenced by (66)