|
|
AMSELECT FILE
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 AM170 AM25.1 AM35.1
AM45.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AMS-SELECT-NAME Alpha 15 AM25.1 AM35.1
Element: Selection NameThis is the name of the transfer or AM45.1
disposal selection used to make a mass
transfer or mass disposal.
AMS-SELECT-TYPE Alpha 1 AM25.1 AM35.1
Element: Selection TypeThis is the type of the selection: AM45.1
disposal or transfer.
D = Disposal
T = Transfer
A = Adjustment
M = Multicurrency Transfer
P = Purge
AMS-SELECT-ALL Alpha 1 AM25.1 AM35.1
Element: Select All This field indicates whether you want AM45.1
to select all assets in the listing for
transfer or disposal.
N = No
Y = Yes
AMS-RELEASED Alpha 1 AM125 AM135
Element: Released This field indicates whether the AM145
transfer or disposal is released.
Valid values are
Y = Released
N = Unreleased
AMS-COMPANY Numeric 4 AM25.1 AM35.1
Element: Company Identifies the AP company if the AM45.1
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
AMS-TO-COMPANY Numeric 4 AM35.1
Element: To Company This is the company number for the
transfer-to asset.
AMS-LOCATION-NAME Alpha 15 AM25.1 AM35.1
Element: Location Name A user-defined location name that AM45.1
represents where an asset is physically
located. Locations are used to report
asset information.
AMS-TO-LOCATION Alpha 15 AM35.1
Element: To Location This is the location for the
transfer-to asset.
AMS-DIVISION Alpha 15 AM25.1 AM35.1
Element: Division This is the user-defined division. AM45.1
AMS-TO-DIVISION Alpha 15 AM35.1
Element: To Division This is the division for the
transfer-to asset.
AMS-ASSET-TYPE Alpha 10 AM25.1 AM35.1
Element: Asset Type An asset type represents a grouping of AM45.1
like assets. Asset types are used to
group assets into reporting classes and
to default common asset definition data.
AMS-TO-ASSET-TYPE Alpha 10 AM35.1
Element: To Asset Type This is the asset type for the
transfer-to asset.
AMS-SUB-TYPE Alpha 10 AM25.1 AM35.1
Element: Subtype An asset subtype represents a more AM45.1
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.
AMS-TO-SUB-TYPE Alpha 10 AM35.1
Element: To Subtype This is the subtype for the transfer-to
asset.
AMS-ACCT-GRP Alpha 10 AM25.1 AM35.1
Element: Account Group This is the user-defined account group AM45.1
identifying the general ledger accounts
used to create journal entries when
assets are processed (added, adjusted,
transferred, or disposed of).
AMS-TO-ACCT-GRP Alpha 10 AM35.1
Element: To Account GroThis is the account group for the
transfer-to asset.
AMS-ACCT-UNIT Alpha 15 AM25.1 AM35.1
Element: Accounting UniThe accounting unit is a shorthand AM45.1
notation representing the variable level
number. The accounting unit must be
defined in the General Ledger Names file
as a posting accounting unit.
AMS-TO-ACCT-UNIT Alpha 15 AM35.1
Element: To Accounting 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.
AMS-AU-GROUP Alpha 10 AM25.1 AM35.1
Accounting Unit Accounting unit groups group and AM45.1
Group 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.
AMS-TO-AU-GROUP Alpha 10 AM35.1
To Accounting Unit Accounting unit groups group and
Group 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.
AMS-ASSET-GROUP Alpha 10 AM25.1 AM35.1
Element: Asset Group An asset group allows you to group AM45.1
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.
AMS-TO-ASSET-GROUP Alpha 10 AM35.1
Element: To Asset GroupThis 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.
AMS-LEASE-COMPANY Numeric 4 AM25.1 AM45.1
Element: Company 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.
AMS-LEASE Alpha 19 AM25.1 AM45.1
Element: Lease
AMS-DEBIT-TOTAL Signed 18.2
Element: Debit Total This is the total debit amount for the
selected assets. The debit amount must
equal the credit amount.
AMS-CREDIT-TOTAL Signed 18.2
Element: Credit Total This is the total credit amount for the
selected assets. The credit amount must
equal the debit amount.
AMS-LOC-DTL Alpha 14 AM25.1 AM35.1
Element: Loc Dtl This field contains the location detail AM45.1
of the selected asset items.
AMS-ENABLE-FLAG Alpha 1 AM25.1 AM35.1
Element: Enable Flag This field contains the value of the AM45.1
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
AMS-PROPERTY Alpha 1 AM25.1
Element: Property This value classifies the kind of
property that is represented by this
asset type.
P = Personal
S = Stock
L = Land
R = Real
O = Other
AMS-ASSET-CATEGORY Alpha 1 AM25.1
Element: Asset CategoryN = Non Depreciable
D = Depreciable
AMS-MATRIX-LIST Alpha 12 AM25.1 AM35.1
Element: Matrix List Attribute categories are selection AM45.1
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.
AMS-SIMULATED Alpha 1 AM25.1 AM35.1
Element: All Flag Y = Yes AM45.1
N = No
O = Only
AMSELECT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AMSSET1 SELECT-NAME AM125 AM135
SELECT-TYPE AM145 AM25.1
AM25.3 AM35.1
AM35.3 AM45.1
AM45.3
AMSSET2 COMPANY Subset AM170
SELECT-TYPE Where RELEASED = "Y"
SELECT-NAME
AMSELECT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|
