POCAOCDTL – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
CAO
Primary key
PROCURE-GROUP, COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, REC-TYP
Fields
25
Updated by
4 programs
Referenced by
0 programs

POCAOCDTL is a Lawson Purchase Order table (prefix CAO); no description in the lawson data dictionary. It is indexed by PROCURE-GROUP, COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, REC-TYP (CAOSET1). It is updated by PO520, PO53.1, PO53.4 and PO53.8. The table has 25 fields, 1 index and 0 documented relations.

About POCAOCDTL

No description in the Lawson data dictionary.

Fields (25)

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

Field / columnTypeDescription & valuesUpdated by
CAO-PROCURE-GROUP PK
PROCURE_GROUP		Alpha 4Type or select a procurement group. A procurement group is a group of companies that share a common procurement effort. They buy items and services together.PO520, PO53.4, PO53.8
CAO-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.PO520, PO53.4, PO53.8
CAO-PO-NUMBER PK
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.PO520, PO53.4, PO53.8
CAO-PO-RELEASE PK
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).PO520, PO53.4, PO53.8
CAO-PO-CODE PK
PO_CODE		Alpha 4This is the purchase order code.PO520, PO53.4, PO53.8
CAO-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.PO520, PO53.4, PO53.8
CAO-AOC-CODE PK
AOC_CODE		Alpha 2This field contains the identifier for the add on cost associated with this line item.PO520, PO53.4, PO53.8
CAO-REC-TYP PK
REC_TYP		Numeric 2—PO520, PO53.4, PO53.8
CAO-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.PO520, PO53.4, PO53.8
CAO-PURCH-FR-LOC
PURCH_FR_LOC		Alpha 4The vendor's purchase from location.PO520, PO53.4, PO53.8
CAO-AOC-RATE
AOC_RATE		Percent 7.3 (Percent)Add On Cost Percentage Rate. If add on cost is spread by rate, this value times the line unit cost is the unit add on cost for the PO line.PO520, PO53.4, PO53.8
CAO-ENTRY
ENTRY		Alpha 1Amount Entry Method.
  • U Unit Cost Entry
  • R Rate Percentage Entry
  • T Total Amount Entry
PO520, PO53.4, PO53.8
CAO-QUANTITY
QUANTITY		Signed 13.4This field contains the desired quantity.PO520, PO53.4, PO53.8
CAO-ENT-UNIT-CST
ENT_UNIT_CST		Signed 18.5—PO520, PO53.4, PO53.8
CAO-TOTAL-AOC
TOTAL_AOC		Signed 18.2—PO520, PO53.4, PO53.8
CAO-TAX-CODE
TAX_CODE		Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.PO520, PO53.4, PO53.8
CAO-TAXABLE-FLAG
TAXABLE_FLAG		Alpha 1Defines if Taxable.
  • Y Yes
  • N No
PO520, PO53.4, PO53.8
CAO-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
PO520, PO53.4, PO53.8
CAO-SUMMARY-FLAG
SUMMARY_FLAG		Alpha 1Defines if add on cost is printed in summary or at a detail level on the Lawson Purchase Order document.
  • Y Yes
  • N No
PO520, PO53.4, PO53.8
CAO-ZERO-COST-FLG
ZERO_COST_FLG		Alpha 1Defines if this tax record is allowed to have a zero unit cost.
  • N No
  • Y Yes
PO520, PO53.4, PO53.8
CAO-CLOSED-FL
CLOSED_FL		Alpha 1The Closed Flag.
  • N No
  • Y Yes
PO520, PO53.4, PO53.8
CAO-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.PO520, PO53.4, PO53.8
CAO-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).PO520, PO53.4
CAO-ENT-CNV-RATE
ENT_CNV_RATE		Signed 14.7Currency conversion rate at Purchase Order entry time.PO53.4
CAO-RUN-GROUP
RUN_GROUP		Alpha 15—PO520, PO53.4, PO53.8

Indexes (1)

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

IndexKeysFlagsConditionUsed in
CAOSET1PROCURE-GROUP, COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, REC-TYPPrimaryPO520, PO53.1, PO53.4, PO53.8

Programs

Updated by (4)