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
AM120 AM185 AM220 AM221 AM222 AM223
AM224 AM225 AM235 AM240 AM245 AM25.1
AM25.3 AM250 AM255 AM260 AM267 AM278
AM280 AM281 AM285 AM287 AM290 AM292
AM295 AM35.1 AM45.1 AM580 AM70.1 AM70.2
AM95.1 AM95.2 AM95.4 AM95.5 AM95.6 AM118
AM205 AM206 AM211 AM212 AM258 AM60.1
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 AMAS.1 AMDL.1 AM214


UPDATED BY
AC160 AM06.1 AM06.2 AM06.3 AM06.4 AM06.5
AM06.6 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
AM22.1 AM230 AM265 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 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC140 IC66.1 IC83.1 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA42.1 MA42.2 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA44.1 MA44.2
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA63.1 MA65.1 MA66.2 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA69.1 MA70.1 MA75.1 MA80.1
MAI1.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PO100 PO101 PO122 PO131 PO136
PO150 PO190 PO20.1 PO20.6 PO20.9 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.3
PO22.4 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO28.2 PO29.1 PO30.1 PO30.2
PO30.3 PO30.4 PO300 PO31.1 PO31.2 PO32.2
PO32.4 PO33.1 PO34.1 PO35.1 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 PO54.5 POCP.1 POI3.1 POID.1
POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.4 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ500 RQIF.1 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATP-COMPANY
Element: Company
Numeric 4
The general ledger company number associated with the asset type record.
...
AC160 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
AM22.1 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
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.
...
AC160 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
AM22.1 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
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.
...
AC160 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
AM22.1 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
ATP-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The asset type description.
...
AC160 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
AM22.1 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
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
...
AC160 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
AM22.1 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
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
...
AC160 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
AM22.1 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
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
...
AC160 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
AM22.1 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


AMASTTYPE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATPSET1 COMPANY
ASSET-TYPE
SUB-TYPE
...
AC160 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
ATPSET2 ASSET-TYPE
SUB-TYPE
COMPANY
KeyChange
...
AC160 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


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: Thu Jun 09 11:05:52 2016

Home
Contact Us



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