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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 30—AP125, 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 SET10 SET4 SET9
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 SET8
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.2—AP125, 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 SET9
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 SET8
MATCH_DTL_KEY		Alpha 85—AP125, 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.2—AP125, 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.2—AP125, 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.2—AP125, 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.2—AP125, 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.2—AP125, 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.2—AP125, 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PAOSET1
  1. COMPANY
  2. PROCURE-GROUP
  3. VEN-AGRMT-REF
  4. PO-NUMBER
  5. PO-RELEASE
  6. PO-CODE
  7. LINE-NBR
  8. AOC-CODE
PrimaryAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
PAOSET10
  1. COMPANY
  2. PROCURE-GROUP
  3. VEN-AGRMT-REF
  4. PO-NUMBER
  5. PO-RELEASE
  6. PO-CODE
  7. LINE-NBR
  8. AOC-CODE
  9. VENDOR
KeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PAOSET2
  1. COMPANY
  2. AOC-CODE
  3. PO-NUMBER
  4. PO-RELEASE
  5. PO-CODE
  6. LINE-NBR
SubsetWhere VEN-AGRMT-REF = SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PAOSET3
  1. COMPANY
  2. PO-NUMBER
  3. PO-RELEASE
  4. PO-CODE
  5. LINE-NBR
  6. AOC-CODE
SubsetWhere 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)
PAOSET4
  1. COMPANY
  2. VENDOR
  3. PO-NUMBER
  4. PO-RELEASE
  5. PO-CODE
  6. AOC-CODE
  7. LINE-NBR
KeyChange, 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)
PAOSET5
  1. COMPANY
  2. AOC-CODE
  3. PO-NUMBER
  4. PO-RELEASE
  5. PO-CODE
  6. LINE-NBR
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)
PAOSET6
  1. PROCURE-GROUP
  2. VEN-AGRMT-REF
  3. LINE-NBR
  4. AOC-CODE
SubsetWhere VEN-AGRMT-REF != SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PAOSET8
  1. COMPANY
  2. PO-NUMBER
  3. PO-RELEASE
  4. PO-CODE
  5. LOCATION
  6. MATCH-DTL-KEY
  7. LINE-NBR
  8. AOC-CODE
KeyChange, SubsetWhere VEN-AGRMT-REF = SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PAOSET9
  1. COMPANY
  2. PO-NUMBER
  3. PO-RELEASE
  4. PO-CODE
  5. AOC-ON-PO
  6. VENDOR
  7. LINE-NBR
  8. AOC-CODE
KeyChange, 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

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APCOMPANYICLOCATIONPOAOCMASTPOCOMPANYPOLINEPURCHORDERTXTAXCODEAPVENLOCAPVENMASTMAAOCDTLMMDISTPOAGMAUDITPOAUDITPOLINEPOAOCDTL

One to one (9) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequired
PAO-COMPANY→CPY-COMPANY
IclocationICLOCATIONNot Required
PAO-COMPANY→ICL-COMPANY
PAO-LOCATION→ICL-LOCATION
PoaocmastPOAOCMASTRequired
PAO-COMPANY→PAM-COMPANY
PAO-AOC-CODE→PAM-AOC-CODE
PocompanyPOCOMPANYRequired
PAO-COMPANY→PCY-COMPANY
PolinedtlPOLINENot RequiredValid 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
PurchorderPURCHORDERRequiredWhen 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
TxtaxcodeTXTAXCODERequired
PAO-COMPANY→TAC-COMPANY
PAO-TAX-CODE→TAC-TAX-CODE
VendlocAPVENLOCNot Required
CPY-VENDOR-GROUP→VLO-VENDOR-GROUP
PAO-VENDOR→VLO-VENDOR
PAO-PURCH-FR-LOC→VLO-LOCATION-CODE
VendorAPVENMASTNot Required
CPY-VENDOR-GROUP→VEN-VENDOR-GROUP
PAO-VENDOR→VEN-VENDOR

One to many (5) — child tables

RelationTableRulesConditionField map
MaaocdtlMAAOCDTL
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
MmdistMMDIST
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
PoagmauditPOAGMAUDIT
PAO-PROCURE-GROUP→PVB-PROCURE-GROUP
PAO-VEN-AGRMT-REF→PVB-VEN-AGRMT-REF
PAO-LINE-NBR→PVB-LINE-NBR
PAO-AOC-CODE→PVB-AOC-CODE
—→PVB-SYSTEM
—→PVB-LINE-SEQ
—→PVB-COMMIT-DATE
—→PVB-UPDATE-DATE
—→PVB-UPDATE-TIME
—→PVB-FLD-NBR
—→PVB-AUDIT-TYPE
PoauditPOAUDIT
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-LINE-SEQ
—→PAU-PO-REVISION
—→PAU-UPDATE-DATE
—→PAU-UPDATE-TIME
—→PAU-FLD-NBR
—→PAU-AUDIT-TYPE
—→PAU-AUDIT-ACTION
Poline Dlv DtePOLINE
PAO-COMPANY→PLI-COMPANY
PAO-LOCATION→PLI-LOCATION
—→PLI-EARLY-DL-DATE
—→PLI-PO-NUMBER
—→PLI-PO-RELEASE
—→PLI-PO-CODE
—→PLI-LINE-NBR

Programs

Updated by (235)

Referenced by (66)