AMSELECT – Asset Processing Selection

System: Asset Management (AM)
Prefix: AMS
Primary key: SELECT-NAME, SELECT-TYPE
Fields: 36
Updated by: 9 programs
Referenced by: 0 programs

AMSELECT is the Asset Processing Selection table in Lawson Asset Management (prefix AMS). It is indexed by SELECT-NAME, SELECT-TYPE (AMSSET1); alternate indexes: AMSSET2. It is related 1:M to AMSELBKDTL and AMSELDTL. It is updated by AM125, AM135, AM145, AM155, AM170, AM25.1, AM35.1, AM45.1 and 1 more. The table has 36 fields, 2 indexes and 2 documented relations.

About AMSELECT

No description in the Lawson data dictionary.

Fields (36)

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

Field / column	Type	Description & values	Updated by
`AMS-SELECT-NAME` PK SELECT_NAME	Alpha 15	This is the name of the transfer or disposal selection used to make a mass transfer or mass disposal.	AM25.1, AM35.1, AM45.1, AM55.1
`AMS-SELECT-TYPE` PK SELECT_TYPE	Alpha 1	This is the type of the selection: disposal or transfer. `D` Disposal `T` Transfer `A` Adjustment `M` Multicurrency Transfer `P` Purge `R` Revalue	AM25.1, AM35.1, AM45.1, AM55.1
`AMS-SELECT-ALL` SELECT_ALL	Alpha 1	This field indicates whether you want to select all assets in the listing for transfer or disposal. `N` No `Y` Yes	AM25.1, AM35.1, AM45.1, AM55.1
`AMS-RELEASED` RELEASED	Alpha 1	This field indicates whether the transfer or disposal is released. Valid values are `Y` Released `N` Unreleased	AM125, AM135, AM145, AM155
`AMS-COMPANY` COMPANY	Numeric 4	Identifies 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.	AM25.1, AM35.1, AM45.1, AM55.1
`AMS-TO-COMPANY` TO_COMPANY	Numeric 4	This is the company number for the transfer-to asset.	AM35.1
`AMS-LOCATION-NAME` LOCATION_NAME	Alpha 15	A user-defined location name that represents where an asset is physically located. Locations are used to report asset information.	AM25.1, AM35.1, AM45.1, AM55.1
`AMS-TO-LOCATION` TO_LOCATION	Alpha 15	This is the location for the transfer-to asset.	AM35.1
`AMS-DIVISION` DIVISION	Alpha 15	This is the user-defined division.	AM25.1, AM35.1, AM45.1, AM55.1
`AMS-TO-DIVISION` TO_DIVISION	Alpha 15	This is the division for the transfer-to asset.	AM35.1
`AMS-ASSET-TYPE` ASSET_TYPE	Alpha 10	An asset type represents a grouping of like assets. Asset types are used to group assets into reporting classes and to default common asset definition data.	AM25.1, AM35.1, AM45.1, AM55.1
`AMS-TO-ASSET-TYPE` TO_ASSET_TYPE	Alpha 10	This is the asset type for the transfer-to asset.	AM35.1
`AMS-SUB-TYPE` SUB_TYPE	Alpha 10	An asset subtype represents a more detailed grouping of assets within an asset type grouping. Asset subtypes are used to group assets into reporting classes and allow common asset definition data to default. Subtypes must be unique within an asset type.	AM25.1, AM35.1, AM45.1, AM55.1
`AMS-TO-SUB-TYPE` TO_SUB_TYPE	Alpha 10	This is the subtype for the transfer-to asset.	AM35.1
`AMS-ACCT-GRP` ACCT_GRP	Alpha 10	This is the user-defined account group identifying the general ledger accounts used to create journal entries when assets are processed (added, adjusted, transferred, or disposed of).	AM25.1, AM35.1, AM45.1, AM55.1
`AMS-TO-ACCT-GRP` TO_ACCT_GRP	Alpha 10	This is the account group for the transfer-to asset.	AM35.1
`AMS-ACCT-UNIT` ACCT_UNIT	Alpha 15	The accounting unit is a shorthand notation representing the variable level number. The accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	AM25.1, AM35.1, AM45.1, AM55.1
`AMS-TO-ACCT-UNIT` TO_ACCT_UNIT	Alpha 15	This is the accounting unit for the transfer-to asset. An accounting unit is a shorthand notation representing the variable level number. The accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	AM35.1
`AMS-AU-GROUP` AU_GROUP	Alpha 10	Accounting 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.	AM25.1, AM35.1, AM45.1, AM55.1
`AMS-TO-AU-GROUP` TO_AU_GROUP	Alpha 10	Accounting 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.	AM35.1
`AMS-ASSET-GROUP` ASSET_GROUP	Alpha 10	An asset group allows you to group related assets that need to depreciate separately; for example, a new roof on a factory building. The building is depreciated over 30 years, but the new roof is depreciated over 15 years. The building and roof would be defined as separate assets, but could be grouped for reporting purposes by assigning an asset group to them.	AM25.1, AM35.1, AM45.1, AM55.1
`AMS-TO-ASSET-GROUP` TO_ASSET_GROUP	Alpha 10	This is the asset group for the transfer-to asset. An asset group allows you to group related assets that need to depreciate separately; for example, a new roof on a factory building. The building is depreciated over 30 years, but the new roof is depreciated over 15 years. The building and roof would be defined as separate assets, but could be grouped for reporting purposes by assigning an asset group to them.	AM35.1
`AMS-LEASE-COMPANY` LEASE_COMPANY	Numeric 4	Identifies 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.	AM25.1, AM45.1, AM55.1
`AMS-LEASE` LEASE	Alpha 19	—	AM25.1, AM45.1, AM55.1
`AMS-DEBIT-TOTAL` DEBIT_TOTAL	Signed 18.2	This is the total debit amount for the selected assets. The debit amount must equal the credit amount.	—
`AMS-CREDIT-TOTAL` CREDIT_TOTAL	Signed 18.2	This is the total credit amount for the selected assets. The credit amount must equal the debit amount.	—
`AMS-LOC-DTL` LOC_DTL	Alpha 14	This field contains the location detail of the selected asset items.	AM25.1, AM35.1, AM45.1, AM55.1
`AMS-ENABLE-FLAG` ENABLE_FLAG	Alpha 1	This field contains the value of the Filter flag, which controls additional selection criteria. Y means that the filter is enabled; N means that the filter is not in effect. `Y` Enabled `N` Disabled	AM25.1, AM35.1, AM45.1, AM55.1
`AMS-PROPERTY` PROPERTY	Alpha 1	This value classifies the kind of property that is represented by this asset type. `P` Personal `S` Stock `L` Land `R` Real `O` Other	AM25.1, AM55.1
`AMS-ASSET-CATEGORY` ASSET_CATEGORY	Alpha 1	— `N` Non Depreciable `D` Depreciable	AM25.1, AM55.1
`AMS-MATRIX-LIST` MATRIX_LIST	Alpha 12	Attribute categories are selection parameters used to build a list of objects (accounting units). Attribute categories and values are the basis of the selection and sorting. A attribute list can then be used for reporting on and processing objects.	AM25.1, AM35.1, AM45.1, AM55.1
`AMS-SIMULATED` SIMULATED	Alpha 1	— `Y` Yes `N` No `O` Only	AM25.1, AM35.1, AM45.1, AM55.1
`AMS-ACTIVITY` ACTIVITY	Alpha 15	—	—
`AMS-TO-ACTIVITY` TO_ACTIVITY	Alpha 15	—	—
`AMS-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	—	—
`AMS-TO-ACCT-CAT` TO_ACCT_CAT	Alpha 5	—	—

Indexes (2)

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

Index	Keys	Flags	Condition	Used in
`AMSSET1`	`SELECT-NAME`, `SELECT-TYPE`	Primary		AM125, AM135, AM145, AM155, AM25.1, AM25.3, AM35.1, AM35.3 +3 more
`AMSSET2`	`COMPANY`, `SELECT-TYPE`, `SELECT-NAME`	Subset	Where RELEASED = "Y"	AM170

Relations

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Amselbkdtl	AMSELBKDTL			`AMS-SELECT-NAME` → `AMK-SELECT-NAME`, `AMS-SELECT-TYPE` → `AMK-SELECT-TYPE`, → `AMK-BOOK`, → `AMK-TO-BOOK`
Amseldtl	AMSELDTL			`AMS-SELECT-NAME` → `SLD-SELECT-NAME`, `AMS-SELECT-TYPE` → `SLD-SELECT-TYPE`, → `SLD-ASSET`

Programs

Updated by (9)

AM125 Mass Adjustments
AM135 Mass Transfers
AM145 Mass Disposals
AM155 Mass Revalue
AM170 Processing Release
AM25.1 Mass Adjustment Selection
AM35.1 Mass Transfer Selection
AM45.1 Mass Disposal Selection
AM55.1 Mass Revalue Selection