AMASTTYPE FILE
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 AM205 AM212 AM220
AM221 AM222 AM223 AM224 AM225 AM230
AM235 AM240 AM245 AM25.1 AM25.3 AM250
AM255 AM260 AM265 AM278 AM280 AM281
AM285 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 AM115 AM12.1
AM125 AM135 AM145 AM15.1 AM15.2 AM15.3
AM15.4 AM154 AM170 AM180 AM190 AM192
AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6
AM206 AM21.1 AM21.2 AM21.3 AM21.4 AM21.5
AM21.6 AM211 AM282 AM30.1 AM30.2 AM40.1
AM40.2 AM40.3 AM500 AM551 AM88.7 AM96.1
AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATP-COMPANY Numeric 4 AM06.1 AM06.2
Company The general ledger company number AM06.3 AM06.5
associated with the asset type record. AM115 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM180
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM206 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM211
AM282 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM500 AM551
AM88.7 AM96.1
AM98.1
ATP-ASSET-TYPE Alpha 10 AM06.1 AM06.2
Asset Type An asset type represents a grouping of AM06.3 AM06.5
like assets. Asset types are used to AM115 AM12.1
group assets into reporting classes and AM125 AM135
to default common asset definition data. AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM180
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM206 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM211
AM282 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM500 AM551
AM88.7 AM96.1
AM98.1
ATP-SUB-TYPE Alpha 10 AM06.1 AM06.2
Subtype An asset subtype represents a more AM06.3 AM06.5
detailed grouping of assets within an AM115 AM12.1
asset type grouping. Asset subtypes are AM125 AM135
used to group assets into reporting AM145 AM15.1
classes and to default common asset AM15.2 AM15.3
definition data. Subtypes must be unique AM15.4 AM154
within an asset type. AM170 AM180
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM206 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM211
AM282 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM500 AM551
AM88.7 AM96.1
AM98.1
ATP-DESCRIPTION Alpha 30 (Lower Case) AM06.1 AM06.2
Description The asset type description. AM06.3 AM06.5
AM115 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM180
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM206 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM211
AM282 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM500 AM551
AM88.7 AM96.1
AM98.1
ATP-PROPERTY Alpha 1 AM06.1 AM06.2
Property This value classifies the kind of AM06.3 AM06.5
property that is represented by this AM115 AM12.1
asset type. AM125 AM135
AM145 AM15.1
P = Personal AM15.2 AM15.3
R = Real AM15.4 AM154
L = Land AM170 AM180
S = Stock AM190 AM192
O = Other AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM206 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM211
AM282 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM500 AM551
AM88.7 AM96.1
AM98.1
ATP-INV-FLAG Alpha 1 AM06.1 AM06.2
Inv Flag This flag indicates whether an asset AM06.3 AM06.5
should be included as part of the AM115 AM12.1
physical inventory. If it is not, the AM125 AM135
asset is ignored in inventories. Valid AM145 AM15.1
values are: AM15.2 AM15.3
Y = Yes AM15.4 AM154
N = No AM170 AM180
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM206 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM211
AM282 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM500 AM551
AM88.7 AM96.1
AM98.1
AMASTTYPE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATPSET1 COMPANY AM06.1 AM06.2
ASSET-TYPE AM06.3 AM06.5
SUB-TYPE AM115 AM118
AM12.1 AM120
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM180
AM185 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM205
AM206 AM21.1
...
ATPSET2 ASSET-TYPE KeyChange AM06.4 AM06.5
SUB-TYPE AM115 AM12.1
COMPANY AM15.1 AM15.2
AM15.3 AM15.4
AMASTTYPE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
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
|