AMSELECT

Asset Processing Selection

This file contains the selection information from AM35.1 (Mass Transfer Selection) and AM45.1 (Mass Disposal) for mass transfers and mass disposals.
UPDATED BY
AM125 AM135 AM145 AM155 AM170 AM25.1
AM35.1 AM45.1 AM55.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AMS-SELECT-NAME
Element: Selection 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
Element: Selection 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
Element: 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
Element: 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
Element: 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
Element: To Company
Numeric 4
This is the company number for the transfer-to asset.
AM35.1
AMS-LOCATION-NAME
Element: 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
Element: To Location
Alpha 15
This is the location for the transfer-to asset.
AM35.1
AMS-DIVISION
Element: Division
Alpha 15
This is the user-defined division.
AM25.1 AM35.1
AM45.1 AM55.1
AMS-TO-DIVISION
Element: To Division
Alpha 15
This is the division for the transfer-to asset.
AM35.1
AMS-ASSET-TYPE
Element: 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
Element: To Asset Type
Alpha 10
This is the asset type for the transfer-to asset.
AM35.1
AMS-SUB-TYPE
Element: Subtype
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
Element: To Subtype
Alpha 10
This is the subtype for the transfer-to asset.
AM35.1
AMS-ACCT-GRP
Element: Account Group
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
Element: To Account Group
Alpha 10
This is the account group for the transfer-to asset.
AM35.1
AMS-ACCT-UNIT
Element: Accounting 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
Element: To Accounting 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
Accounting Unit
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 Accounting Unit
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
Element: 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
Element: 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
Element: 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
Element: Lease
Alpha 19
AM25.1 AM45.1
AM55.1
AMS-DEBIT-TOTAL
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Asset Category
Alpha 1

N = Non Depreciable
D = Depreciable
AM25.1 AM55.1
AMS-MATRIX-LIST
Element: 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
Element: All Flag
Alpha 1

Y = Yes
N = No
O = Only
AM25.1 AM35.1
AM45.1 AM55.1
AMS-ACTIVITY
Element: Activity
Alpha 15
AMS-TO-ACTIVITY
Element: Activity
Alpha 15
AMS-ACCT-CATEGORY
Element: Acct Category
Alpha 5
AMS-TO-ACCT-CAT
Element: Acct Category
Alpha 5


AMSELECT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AMSSET1 SELECT-NAME
SELECT-TYPE
AM125 AM135
AM145 AM155
AM25.1 AM25.3
AM35.1 AM35.3
AM45.1 AM45.3
AM55.1
AMSSET2 COMPANY
SELECT-TYPE
SELECT-NAME
Subset
WhereRELEASED ="Y"
AM170


AMSELECT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 02:05:45 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.