AMPOASTDTL – PO Asset Detail

System
Asset Management (AM)
Prefix
AOD
Primary key
COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, DTL-SEQ-NBR
Fields
41
Updated by
237 programs
Referenced by
4 programs

AMPOASTDTL is the PO Asset Detail table in Lawson Asset Management (prefix AOD). It is indexed by COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, DTL-SEQ-NBR (AODSET1); alternate indexes: AODSET2 and AODSET3. It is related 1:1 to AMASTITEM, AMPOASTHDR and POLINE. It is updated by AM17.1, AM19.1, AM19.2, AM19.3, AP115, AP125, AP126, AP131 and 229 more and referenced by AM219, IC130, MA26.1 and PO135. The table has 41 fields, 3 indexes and 3 documented relations.

About AMPOASTDTL

No description in the Lawson data dictionary.

Fields (41)

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

Field / columnTypeDescription & valuesUpdated by
AOD-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)
AOD-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)
AOD-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)
AOD-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)
AOD-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)
AOD-DTL-SEQ-NBR PK
DTL_SEQ_NBR		Numeric 6A unique number assigned to each transaction to be interfaced into the Lawson system.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOD-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOD-TRAN-ND
TRAN_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOD-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOD-BAR-CODE
BAR_CODE		Alpha 30—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOD-SERIAL-NUMBER
SERIAL_NUMBER		Alpha 30This optional field is used for the serial number of the asset.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOD-DIST-COMPANY
DIST_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)
AOD-ASSET-TEMPLATE
ASSET_TEMPLATE		Alpha 10A user-defined asset template identifies general asset creation parameters that you can use to quickly add assets with minimal keying. Using a template lets you default many data items associated with a new asset. You can use an asset template to process quick asset additions in AM20.1 (Quick Addition) and to create assets and asset books from Accounts Payable and Activity Management interface information. Asset templates are required if you define new assets as a result of transactions interfaced from the Lawson Purchase Order or Accounts Payable systems.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOD-ASSET-DESC
ASSET_DESC		Alpha 30 (Lower Case)This field displays the description.AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOD-TAG-NBR
TAG_NBR		Alpha 12The tag is a user definable identifier assigned to an asset.AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOD-ASSET-GROUP
ASSET_GROUP		Alpha 10—AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOD-AU-GROUP
AU_GROUP		Alpha 10Accounting unit groups group and identify the accounting units to use when you create journal entries for adding, adjusting, transferring, or disposing of assets. Changes to accounting unit groups are dynamic, affecting all assets using the accounting unit group. Accounting unit group names are user-definable, and accounting unit groups are set up by company.AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOD-COMBINE
COMBINE		Alpha 10—AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOD-HOLD-AM
HOLD_AM		Alpha 1—AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOD-ACTIVITY
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOD-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruAM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOD-ITEM-NBR
ITEM_NBR		Alpha 32This field contains the item identifier.AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOD-ITEM-DESC
ITEM_DESC		Alpha 30 (Lower Case)This field displays the description.AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOD-MODEL-NUMBER
MODEL_NUMBER		Alpha 30—AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOD-PURCHASE-DATE
PURCHASE_DATE		Numeric 8 (yyyymmdd)The date the asset was purchased. This purchased date can be different from the in-service dates for the depreciation books used.AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOD-INSRV-DATE
INSRV_DATE		Numeric 8 (yyyymmdd)The book in-service date for the asset. Note: The in-service date can be different for each depreciation book used.AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOD-ITEM-TAX-TRAN
ITEM_TAX_TRAN		Signed 18.2—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOD-ITEM-TAX-BASE
ITEM_TAX_BASE		Signed 18.2—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOD-INVOICE
INVOICE		Alpha 22Used to identify the invoice.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOD-SUFFIX
SUFFIX		Numeric 3This is the suffix for the invoice.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOD-ACCT-UNIT
ACCT_UNIT		Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOD-LOCATION-NAME
LOCATION_NAME		Alpha 15A user-defined location name which represents where an asset is physically located. Locations are used to report asset information.AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOD-DIVISION
DIVISION		Alpha 15A user-defined division which is used for reporting assets.AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOD-ITEM-LOC-DTL
ITEM_LOC_DTL		Alpha 14—AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOD-PO-AST-OBJ-ID
PO_AST_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOD-RECEIVED
RECEIVED		Numeric 10
  • 1 X
AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOD-REJECTED
REJECTED		Numeric 10
  • 1 X
AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOD-RETURNED
RETURNED		Numeric 10
  • 1 X
AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOD-INVOICED
INVOICED		Numeric 10
  • 1 X
AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOD-ASSET-CREATED
ASSET_CREATED		Numeric 10
  • 1 X
AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
AOD-CANCELLED
CANCELLED		Numeric 10
  • 1 X
AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)

Indexes (3)

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

IndexKeysFlagsConditionUsed in
AODSET1COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, DTL-SEQ-NBRPrimaryAM17.1, AM19.1, AM19.2, AM19.3, AM219, AP115, AP125, AP126 +22 more (list truncated in source)
AODSET2COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, DTL-SEQ-NBR*KeyChangeAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)
AODSET3COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, BAR-CODE, SERIAL-NUMBER, DTL-SEQ-NBRKeyChangeAM19.1

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AmastitemAMASTITEMNot RequiredAOD-PO-AST-OBJ-ID → ASI-PO-AST-OBJ-ID
AmpoasthdrAMPOASTHDRRequiredAOD-COMPANY → AOH-COMPANY, AOD-PO-NUMBER → AOH-PO-NUMBER, AOD-PO-RELEASE → AOH-PO-RELEASE, AOD-PO-CODE → AOH-PO-CODE, AOD-LINE-NBR → AOH-LINE-NBR
PolinePOLINERequiredAOD-COMPANY → PLI-COMPANY, AOD-PO-NUMBER → PLI-PO-NUMBER, AOD-PO-RELEASE → PLI-PO-RELEASE, AOD-PO-CODE → PLI-PO-CODE, AOD-LINE-NBR → PLI-LINE-NBR

Programs

Updated by (237)

Referenced by (4)