AMPODFLTS – PO Defaults

System
Asset Management (AM)
Prefix
AOT
Primary key
COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR
Fields
22
Updated by
236 programs
Referenced by
3 programs

AMPODFLTS is the PO Defaults table in Lawson Asset Management (prefix AOT). It is indexed by COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR (AOTSET1). It is related 1:1 to AMPOASTHDR. It is updated by AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 and 228 more and referenced by IC130, MA26.1 and PO135. The table has 22 fields, 1 index and 1 documented relation.

About AMPODFLTS

No description in the Lawson data dictionary.

Fields (22)

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

Field / columnTypeDescription & valuesUpdated by
AOT-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.AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOT-PO-NUMBER PK
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOT-PO-RELEASE PK
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOT-PO-CODE PK
PO_CODE		Alpha 4This is the purchase order code.AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOT-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOT-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)
AOT-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)
AOT-ASSET-GROUP
ASSET_GROUP		Alpha 10—AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOT-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)
AOT-COMBINE
COMBINE		Alpha 10—AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOT-HOLD-AM
HOLD_AM		Alpha 1—
  • N No
  • Y Yes
AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOT-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)
AOT-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)
AOT-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)
AOT-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)
AOT-MODEL-NUMBER
MODEL_NUMBER		Alpha 30—AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOT-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)
AOT-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)
AOT-ITEM-TAX-TRAN
ITEM_TAX_TRAN		Signed 18.2—AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1 +52 more (list truncated in source)
AOT-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)
AOT-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)
AOT-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)

Indexes (1)

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

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

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AmpoasthdrAMPOASTHDRNot RequiredAOT-COMPANY → AOH-COMPANY, AOT-PO-NUMBER → AOH-PO-NUMBER, AOT-PO-RELEASE → AOH-PO-RELEASE, AOT-PO-CODE → AOH-PO-CODE, AOT-LINE-NBR → AOH-LINE-NBR

Programs

Updated by (236)

Referenced by (3)