POINTAOC – Interface Add On Cost

System
Purchase Order (PO)
Prefix
PIA
Primary key
COMPANY, ORIGIN-CD, SOURCE-DOC-N, LINE-NBR, AOC-CODE, VENDOR
Fields
23
Updated by
220 programs
Referenced by
0 programs

POINTAOC is the Interface Add On Cost table in Lawson Purchase Order (prefix PIA). It is indexed by COMPANY, ORIGIN-CD, SOURCE-DOC-N, LINE-NBR, AOC-CODE, VENDOR (PIASET1); alternate indexes: PIASET2. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 212 more. The table has 23 fields, 2 indexes and 0 documented relations.

About POINTAOC

No description in the Lawson data dictionary.

Fields (23)

Column = COBOL field name without the PIA- 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
#PIA-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)
#PIA-SOURCE-DOC-N PK
SOURCE_DOC_N		Numeric 8This is the source document number if the document number in the source system is numeric.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PIA-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)
#PIA-AOC-CODE PK
AOC_CODE		Alpha 2This 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 +52 more (list truncated in source)
#PIA-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 purchase order line.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PIA-ENT-UNIT-CST
ENT_UNIT_CST		Signed 18.5—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PIA-QUANTITY
QUANTITY		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)
#PIA-ENTRY
ENTRY		Alpha 1Amount entry method.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PIA-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)
#PIA-TAXABLE-FLAG
TAXABLE_FLAG		Alpha 1Defines if taxable.
  • Y Yes item is taxable
  • N No item is not taxable
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PIA-TAX-CODE
TAX_CODE		Alpha 10This field contains a code representing specific tax information. This must be valid tax code in the Tax system.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PIA-OE-AOC-TYPE
OE_AOC_TYPE		Alpha 2—
  • HA Header Add On Charge
  • HF Header Freight Charge
  • LA Line Add On Charge
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PIA-ORIGIN-CD PK
ORIGIN_CD		Alpha 2The system code where this transaction originated
  • OE Order Entry
  • SS Strategic Sourcing
  • RQ Requisitions
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PIA-VENDOR PK
VENDOR		Alpha 9 (Right Justified)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PIA-SUMMARY-FLAG
SUMMARY_FLAG		Alpha 1——
#PIA-ZERO-COST-FLG
ZERO_COST_FLG		Alpha 1—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PIA-PO-CODE
PO_CODE		Alpha 4——
#PIA-LANDED-FLAG
LANDED_FLAG		Numeric 1—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PIA-CURRENCY-CODE
CURRENCY_CODE		Alpha 5—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PIA-LOCATION
LOCATION		Alpha 5—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PIA-PURCH-FR-LOC
PURCH_FR_LOC		Alpha 4——
#PIA-GLBL-DOC-TYPE
GLBL_DOC_TYPE		Alpha 10—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PIA-GLBL-LINE-TYPE
GLBL_LINE_TYPE		Alpha 15—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (2)

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
PIASET1
  1. COMPANY
  2. ORIGIN-CD
  3. SOURCE-DOC-N
  4. LINE-NBR
  5. AOC-CODE
  6. VENDOR
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PIASET2
  1. COMPANY
  2. SOURCE-DOC-N
  3. AOC-CODE
SubsetWhere OE-AOC-TYPE = "HA"AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Programs

Updated by (220)