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