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
AC10.1 AC10.3 AC56.1 AC560 AC71.1 AM05.1
AM08.1 AM08.2 AM09.1 AM118 AM120 AM16.1
AM17.1 AM185 AM205 AM206 AM211 AM212
AM220 AM221 AM222 AM223 AM224 AM225
AM235 AM240 AM245 AM25.1 AM25.3 AM250
AM255 AM258 AM260 AM265 AM267 AM278
AM280 AM281 AM285 AM287 AM290 AM292
AM295 AM35.1 AM45.1 AM55.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 AP22.2 AM214


UPDATED BY
AC160 AM06.1 AM06.2 AM06.3 AM06.5 AM115
AM117 AM12.1 AM12.2 AM125 AM135 AM145
AM15.1 AM15.2 AM15.3 AM15.4 AM154 AM155
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 AM22.2 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 AP510
API1.1 API2.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC12.1 IC140 IC141 IC142 IC145
IC243 IC330 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC83.1 MA126 MA180 MA278 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
MA53.1 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 PD570 PO04.1 PO04.2 PO10.1
PO10.2 PO100 PO101 PO115 PO120 PO122
PO131 PO132 PO136 PO15.1 PO15.2 PO15.4
PO150 PO17.1 PO190 PO20.1 PO20.6 PO20.9
PO204 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO220 PO222 PO224
PO225 PO229 PO23.1 PO230 PO234 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO26.3
PO26.7 PO26.9 PO27.2 PO27.3 PO27.4 PO275
PO276 PO277 PO28.2 PO280 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 RQ01.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1
RQIF.1 RQII.1 RQIJ.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

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
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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 AM22.2
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
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
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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 AM22.2
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
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
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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 AM22.2
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
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
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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 AM22.2
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
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
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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 AM22.2
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
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
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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 AM22.2
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
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
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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 AM22.2
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
ATP-REVALUE-FLAG
Element: All Flag
Alpha 1
...
AC160 AM06.1
AM06.2 AM06.3
AM06.5 AM115
AM117 AM12.1
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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 AM22.2
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
ATP-REVALUE-METHOD
Element: All Flag
Alpha 1
...
AC160 AM06.1
AM06.2 AM06.3
AM06.5 AM115
AM117 AM12.1
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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 AM22.2
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


AMASTTYPE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATPSET1 COMPANY
ASSET-TYPE
SUB-TYPE
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM05.1 AM06.1
AM06.2 AM06.3
AM06.5 AM06.6
AM08.1 AM08.2
AM09.1 AM115
AM117 AM118
AM12.1 AM12.2
AM120 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
ATPSET2 ASSET-TYPE
SUB-TYPE
COMPANY
KeyChange
...
AC160 AM06.4
AM06.5 AM115
AM117 AM12.1
AM12.2 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


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
Amasttypau AMASTTYPAU
ATP-COMPANY->ASW-COMPANY
ATP-ASSET-TYPE->ASW-ASSET-TYPE
ATP-SUB-TYPE->ASW-SUB-TYPE
  ASW-ACTION
  ASW-DATE
  ASW-TIME
  ASW-UNIQUE-I-D
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 02:05:14 2016

Home
Contact Us



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