|
AMIAASTDIM FILE
The Asset Dimension file contains the fields which define the asset dimension
of the AM data mart.
REFERENCED BY
AMAS.1 AMDL.1 AMDM.1
UPDATED BY
AM88.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IDA-AST-DIMENSION Alpha 50 (Lower Case) AM88.1
Element: Ast Dimension
IDA-MEMBER-PREFIX Alpha 5 (Lower Case) AM88.1
Element: Member Prefix 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.
IDA-ALIAS-OPTION Alpha 1 AM88.1
Element: Account Flag D = Description
A = Asset Desc
T = Tag Desc
IDA-ASSET Numeric 10 AM88.1
Element: Asset The asset number contains up to ten
numeric characters that uniquely
identify an asset. Assets are
automatically numbered system-wide.
IDA-LAST-ASSET Numeric 10 AM88.1
Element: Last Asset
IDA-MATRIX-LIST Alpha 12 AM88.1
Element: Matrix List Matrix List provides is a list of
assets, selected via the matrix system,
for output to the data mart.
IDA-DETAIL-LEVEL Alpha 1 AM88.1
Element: Detail Level This 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
IDA-DISPOSAL-FLAG Alpha 1 AM88.1
Element: Disposal Flag I = Include
N = Do not include
O = Only
IDA-FULL-DEPR-FLAG Alpha 1 AM88.1
Element: Full Depr FlagI = Include
N = Do not include
O = Only
IDA-FILTER-FLAG Alpha 1 AM88.1
Element: Filter Flag N = No
Y = Yes
IDA-COMPANY Numeric 4 AM88.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.
IDA-COMPANY-GROUP Alpha 12 AM88.1
Element: Company Group You 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.
IDA-CLASSIFICATION Alpha 1 AM88.1
Element: ClassificationP = Purchased
A = All
L = Leased
D = Depreciable
C = Capital Lease
O = Operating Lease
IDA-LOCATION-NAME Alpha 15 AM88.1
Element: Location Name A user-defined location name which
represents where an asset is physically
located. Locations are used to report
asset information.
IDA-DIVISION Alpha 15 AM88.1
Element: Division A user-defined division which is used
for reporting assets.
IDA-ASSET-TYPE Alpha 10 AM88.1
Element: Asset Type 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.
IDA-SUB-TYPE Alpha 10 AM88.1
Element: Sub Type 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.
IDA-PROPERTY Alpha 1 AM88.1
Element: Property This value classifies the kind of
property that is represented by this
asset type.
IDA-ASSET-CATEGORY Alpha 1 AM88.1
Element: Asset Category
IDA-SIMULATED Alpha 1 AM88.1
Element: All Flag
IDA-TAX-EXEMPT Alpha 1 AM88.1
Element: All Flag
IDA-USED Alpha 1 AM88.1
Element: All Flag
IDA-LEASE-COMPANY Numeric 4 AM88.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.
IDA-LEASE Alpha 19 AM88.1
Element: Lease
IDA-TAG-NBR Alpha 12 AM88.1
Element: Tag Nbr The tag is a user definable identifier
assigned to an asset.
IDA-ASSET-GROUP Alpha 10 AM88.1
Element: Asset Group
AMIAASTDIM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IDASET1 AST-DIMENSION AM88.1 AM88.8
AMAS.1 AMDL.1
AMDM.1
|