AMPOASTHDR – PO Asset Header

System
Asset Management (AM)
Prefix
AOH
Primary key
COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR
Fields
17
Updated by
235 programs
Referenced by
1 program

AMPOASTHDR is the PO Asset Header table in Lawson Asset Management (prefix AOH). It is indexed by COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR (AOHSET1). It is related 1:1 to AMPODFLTS and 1:M to AMPOASTDTL. It is updated by AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 and 227 more and referenced by AM219. The table has 17 fields, 1 index and 2 documented relations.

About AMPOASTHDR

No description in the Lawson data dictionary.

Fields (17)

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

Field / columnTypeDescription & valuesUpdated by
AOH-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.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOH-PO-NUMBER PK
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOH-PO-RELEASE PK
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOH-PO-CODE PK
PO_CODE		Alpha 4This is the purchase order code.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOH-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOH-STATUS
STATUS		Numeric 1This field displays the status of the transaction.
  • 0 Unreleased
  • 1 Released
AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOH-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOH-DROPSHIP-FL
DROPSHIP_FL		Alpha 1This flag indicates whether goods being shipped by the vendor directly to a non standard location need to have the receiving process performed.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOH-PO-LINE-QTY
PO_LINE_QTY		Numeric 8The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOH-RCVD-QTY
RCVD_QTY		Numeric 8The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOH-RJCT-QTY
RJCT_QTY		Numeric 8The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOH-RTRN-QTY
RTRN_QTY		Numeric 8The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOH-INVC-QTY
INVC_QTY		Numeric 8The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOH-CHBK-QTY
CHBK_QTY		Numeric 8The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOH-AM-CREATE-QTY
AM_CREATE_QTY		Numeric 8The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOH-AM-DIST-QTY
AM_DIST_QTY		Numeric 8The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOH-CNCL-QTY
CNCL_QTY		Numeric 8The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)

Indexes (1)

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

IndexKeysFlagsConditionUsed in
AOHSET1COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBRPrimaryAM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131, AP20.1 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AmpodfltsAMPODFLTSNot Required, Delete CascadesAOH-COMPANY → AOT-COMPANY, AOH-PO-NUMBER → AOT-PO-NUMBER, AOH-PO-RELEASE → AOT-PO-RELEASE, AOH-PO-CODE → AOT-PO-CODE, AOH-LINE-NBR → AOT-LINE-NBR

One to many (1) — child tables

RelationTableRulesConditionField map
AmpoastdtlAMPOASTDTLAOH-COMPANY → AOD-COMPANY, AOH-PO-NUMBER → AOD-PO-NUMBER, AOH-PO-RELEASE → AOD-PO-RELEASE, AOH-PO-CODE → AOD-PO-CODE, AOH-LINE-NBR → AOD-LINE-NBR, → AOD-DTL-SEQ-NBR

Programs

Updated by (235)

Referenced by (1)