AMIAASTDIM – The Asset Dimension file contains the fields which define the asset dimension of the AM data mart.

System
Asset Management (AM)
Prefix
IDA
Primary key
AST-DIMENSION
Fields
26
Updated by
1 program
Referenced by
3 programs

AMIAASTDIM is the The Asset Dimension file contains the fields which define the asset dimension of the AM data mart. table in Lawson Asset Management (prefix IDA). It is indexed by AST-DIMENSION (IDASET1). It is updated by AM88.1 and referenced by AMAS.1, AMDL.1 and AMDM.1. The table has 26 fields, 1 index and 0 documented relations.

About AMIAASTDIM

The Asset Dimension file contains the fields which define the asset dimension of the AM data mart.

Fields (26)

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

Field / columnTypeDescription & valuesUpdated by
IDA-AST-DIMENSION PK
AST_DIMENSION		Alpha 50 (Lower Case)—AM88.1
IDA-MEMBER-PREFIX
MEMBER_PREFIX		Alpha 5 (Lower Case)The Member Prefix field contains a unique prefix to differentiate the dimension name from other like-named dimensions. This user-defined name can contain up to five characters of any kind.AM88.1
IDA-ALIAS-OPTION
ALIAS_OPTION		Alpha 1—
  • D Description
  • A Asset Desc
  • T Tag Desc
AM88.1
IDA-ASSET
ASSET		Numeric 10The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.AM88.1
IDA-LAST-ASSET
LAST_ASSET		Numeric 10—AM88.1
IDA-MATRIX-LIST
MATRIX_LIST		Alpha 12Matrix List provides is a list of assets, selected via the matrix system, for output to the data mart.AM88.1
IDA-DETAIL-LEVEL
DETAIL_LEVEL		Alpha 1This field is used to indicate to the Budget Architect the level of detail associated to the summary account that must be imported to the Pillar budget.
  • A Asset
  • I Item
AM88.1
IDA-DISPOSAL-FLAG
DISPOSAL_FLAG		Alpha 1—
  • I Include
  • N Do not include
  • O Only
AM88.1
IDA-FULL-DEPR-FLAG
FULL_DEPR_FLAG		Alpha 1—
  • I Include
  • N Do not include
  • O Only
AM88.1
IDA-FILTER-FLAG
FILTER_FLAG		Alpha 1—
  • N No
  • Y Yes
AM88.1
IDA-COMPANY
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.AM88.1
IDA-COMPANY-GROUP
COMPANY_GROUP		Alpha 12You can type or select a company group. A company group represents one or more companies. If you select a company group, leave the Company field blank.AM88.1
IDA-CLASSIFICATION
CLASSIFICATION		Alpha 1—
  • P Purchased
  • A All
  • L Leased
  • D Depreciable
  • C Capital Lease
  • O Operating Lease
AM88.1
IDA-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.AM88.1
IDA-DIVISION
DIVISION		Alpha 15A user-defined division which is used for reporting assets.AM88.1
IDA-ASSET-TYPE
ASSET_TYPE		Alpha 10An 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.AM88.1
IDA-SUB-TYPE
SUB_TYPE		Alpha 10An 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.AM88.1
IDA-PROPERTY
PROPERTY		Alpha 1This value classifies the kind of property that is represented by this asset type.AM88.1
IDA-ASSET-CATEGORY
ASSET_CATEGORY		Alpha 1—AM88.1
IDA-SIMULATED
SIMULATED		Alpha 1—AM88.1
IDA-TAX-EXEMPT
TAX_EXEMPT		Alpha 1—AM88.1
IDA-USED
USED		Alpha 1—AM88.1
IDA-LEASE-COMPANY
LEASE_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.AM88.1
IDA-LEASE
LEASE		Alpha 19—AM88.1
IDA-TAG-NBR
TAG_NBR		Alpha 12The tag is a user definable identifier assigned to an asset.AM88.1
IDA-ASSET-GROUP
ASSET_GROUP		Alpha 10—AM88.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
IDASET1AST-DIMENSIONPrimaryAM88.1, AM88.8, AMAS.1, AMDL.1, AMDM.1

Programs

Updated by (1)

Referenced by (3)