AMASTTYPE

Asset Type

The Asset Type file stores asset types and subtypes, which represent groupings of like assets that can be used for reporting and defaulting common asset definition data. You must define at least one asset type. Asset types must be unique within a general ledger company, and asset subtypes must be unique within an asset type. Each Asset Type record has one or more Account records, which identify the general ledger accounts used to create journal entries when you process (add, adjust, transfer, and dispose of) assets.

REFERENCED BY
AM118 AM120 AM185 AM220 AM221 AM222
AM223 AM224 AM225 AM235 AM240 AM245
AM25.1 AM25.3 AM250 AM255 AM258 AM260
AM267 AM278 AM280 AM281 AM285 AM287
AM290 AM292 AM295 AM35.1 AM45.1 AM580
AM60.1 AM70.1 AM70.2 AM75.3 AM80.3 AM85.3
AM90.1 AM90.2 AM90.4 AM90.5 AM90.6 AM91.1
AM91.2 AM91.4 AM91.5 AM93.1 AM95.1 AM95.2
AM95.4 AM95.5 AM95.6 AMAS.1 AMDL.1


UPDATED BY
AM06.1 AM06.2 AM06.3 AM06.5 AM06.6 AM06.4
AM115 AM117 AM12.1 AM125 AM135 AM145
AM15.1 AM15.2 AM15.3 AM15.4 AM154 AM170
AM180 AM19.1 AM19.2 AM190 AM192 AM20.1
AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM21.1
AM21.2 AM21.3 AM21.4 AM21.5 AM21.6 AM230
AM282 AM30.1 AM30.2 AM30.3 AM40.1 AM40.2
AM40.3 AM40.4 AM41.1 AM41.2 AM500 AM502
AM551 AM700 AM88.7 AM92.1 AM96.1 AM98.1
AP115 AP125 AP126 AP131 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP220
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.4 AP305 API1.1 API2.1 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MAI1.1 PO136 PO190 PO300
PO520 POCP.1 POI3.1 POII.1 POIJ.1 AM205
AM206 AM211 AM212 AM265 AM214

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATP-COMPANY
Element: Company
Numeric 4
The general ledger company number associated with the asset type record.
...
AM06.1 AM06.2
AM06.3 AM06.5
AM115 AM117
AM12.1 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
ATP-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.
...
AM06.1 AM06.2
AM06.3 AM06.5
AM115 AM117
AM12.1 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
ATP-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 to default common asset definition data. Subtypes must be unique within an asset type.
...
AM06.1 AM06.2
AM06.3 AM06.5
AM115 AM117
AM12.1 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
ATP-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The asset type description.
...
AM06.1 AM06.2
AM06.3 AM06.5
AM115 AM117
AM12.1 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
ATP-PROPERTY
Element: Property
Alpha 1
This value classifies the kind of property that is represented by this asset type.
P = Personal
R = Real
L = Land
S = Stock
O = Other
...
AM06.1 AM06.2
AM06.3 AM06.5
AM115 AM117
AM12.1 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
ATP-INV-FLAG
Element: Inv Flag
Alpha 1
This flag indicates whether an asset should be included as part of the physical inventory. If it is not, the asset is ignored in inventories. Valid values are: Y = Yes N = No
...
AM06.1 AM06.2
AM06.3 AM06.5
AM115 AM117
AM12.1 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
ATP-DEP-EXP-ALLOC
Element: Dep Exp Alloc
Alpha 1
This field indicates whether the asset type allows depreciation expense to ve allocated to multiple accounting units. Valid values are: N = No (the default) Y = Yes
...
AM06.1 AM06.2
AM06.3 AM06.5
AM115 AM117
AM12.1 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM700
AM88.7 AM92.1
AM96.1 AM98.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4


AMASTTYPE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATPSET1 COMPANY
ASSET-TYPE
SUB-TYPE
...
AM06.1 AM06.2
AM06.3 AM06.5
AM06.6 AM115
AM117 AM118
AM12.1 AM120
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM180
AM185 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
ATPSET2 ASSET-TYPE
SUB-TYPE
COMPANY
KeyChange
...
AM06.4 AM06.5
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM206
AM211 AM212
AM214 AM265
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1


AMASTTYPE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amcontrol AMCONTROL Not Required
ATP-COMPANY->CTL-COMPANY
Glsystem GLSYSTEM Required
ATP-COMPANY->GLS-COMPANY


AMASTTYPE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amaccount AMACCOUNT Delete Cascades
ATP-COMPANY->AAC-COMPANY
Spaces->AAC-ACCT-GRP
ATP-ASSET-TYPE->AAC-ASSET-TYPE
ATP-SUB-TYPE->AAC-SUB-TYPE
  AAC-ACCT-TYPE
  AAC-ASSET-EVENT
Amasset1 AMASSET
1->AST-STATUS
ATP-COMPANY->AST-COMPANY
ATP-ASSET-TYPE->AST-ASSET-TYPE
ATP-SUB-TYPE->AST-SUB-TYPE
  AST-DSP-ASSET
  AST-ASSET
Amasset2 AMASSET
2->AST-STATUS
ATP-COMPANY->AST-COMPANY
ATP-ASSET-TYPE->AST-ASSET-TYPE
ATP-SUB-TYPE->AST-SUB-TYPE
  AST-DSP-ASSET
  AST-ASSET
Amasset3 AMASSET
3->AST-STATUS
ATP-COMPANY->AST-COMPANY
ATP-ASSET-TYPE->AST-ASSET-TYPE
ATP-SUB-TYPE->AST-SUB-TYPE
  AST-DSP-ASSET
  AST-ASSET
Amassetadj AMASSETADJ
ATP-COMPANY->ASA-COMPANY
ATP-ASSET-TYPE->ASA-ASSET-TYPE
ATP-SUB-TYPE->ASA-SUB-TYPE
  ASA-ASSET
  ASA-PROCESS-SEQ
Amassetdsp AMASSET
9->AST-STATUS
ATP-COMPANY->AST-COMPANY
ATP-ASSET-TYPE->AST-ASSET-TYPE
ATP-SUB-TYPE->AST-SUB-TYPE
  AST-DSP-ASSET
  AST-ASSET
Amassettrf AMASSETTRF
ATP-COMPANY->ATF-COMPANY
ATP-ASSET-TYPE->ATF-ASSET-TYPE
ATP-SUB-TYPE->ATF-SUB-TYPE
  ATF-ASSET
  ATF-PROCESS-SEQ
Ambooktype AMBOOKTYPE
ATP-ASSET-TYPE->ADR-ASSET-TYPE
  ADR-SUB-TYPE
  ADR-BOOK
Amclassdep AMCLASSDEP
ATP-ASSET-TYPE->CLD-ASSET-TYPE
ATP-SUB-TYPE->CLD-SUB-TYPE
  CLD-BOOK
  CLD-COMPANY
  CLD-AST-ACCT-UNIT
  CLD-EXP-ACCT-UNIT
  CLD-ACM-ACCT-UNIT
  CLD-YR-END-DATE
  CLD-PERIOD
Amtypalloc AMTYPALLOC
ATP-COMPANY->ALL-COMPANY
ATP-ASSET-TYPE->ALL-ASSET-TYPE
ATP-SUB-TYPE->ALL-SUB-TYPE
  ALL-START-DATE
  ALL-SEQUENCE-NBR


File created: Wed Jun 08 20:47:07 2016

Home
Contact Us



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