|
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 AM235
AM240 AM245 AM25.1 AM25.3 AM250 AM255
AM260 AM265 AM267 AM278 AM280 AM281
AM285 AM287 AM290 AM292 AM295 AM35.1
AM41.2 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 AM214
UPDATED BY
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 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 AM230 AM282 AM30.1
AM30.2 AM40.1 AM40.2 AM40.3 AM500 AM502
AM551 AM700 AM88.7 AM92.1 AM96.1 AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATP-COMPANY Numeric 4 AM06.1 AM06.2
Element: Company The general ledger company number AM06.3 AM06.5
associated with the asset type record. AM115 AM117
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 AM230
AM282 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1
ATP-ASSET-TYPE Alpha 10 AM06.1 AM06.2
Element: Asset Type An asset type represents a grouping of AM06.3 AM06.5
like assets. Asset types are used to AM115 AM117
group assets into reporting classes and AM12.1 AM125
to default common asset definition data. 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 AM230
AM282 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1
ATP-SUB-TYPE Alpha 10 AM06.1 AM06.2
Element: Subtype An asset subtype represents a more AM06.3 AM06.5
detailed grouping of assets within an AM115 AM117
asset type grouping. Asset subtypes are AM12.1 AM125
used to group assets into reporting AM135 AM145
classes and to default common asset AM15.1 AM15.2
definition data. Subtypes must be unique AM15.3 AM15.4
within an asset type. 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 AM230
AM282 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1
ATP-DESCRIPTION Alpha 30 (Lower Case) AM06.1 AM06.2
Element: Description The asset type description. AM06.3 AM06.5
AM115 AM117
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 AM230
AM282 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1
ATP-PROPERTY Alpha 1 AM06.1 AM06.2
Element: Property This value classifies the kind of AM06.3 AM06.5
property that is represented by this AM115 AM117
asset type. AM12.1 AM125
P = Personal AM135 AM145
R = Real AM15.1 AM15.2
L = Land AM15.3 AM15.4
S = Stock AM154 AM170
O = Other 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 AM230
AM282 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1
ATP-INV-FLAG Alpha 1 AM06.1 AM06.2
Element: Inv Flag This flag indicates whether an asset AM06.3 AM06.5
should be included as part of the AM115 AM117
physical inventory. If it is not, the AM12.1 AM125
asset is ignored in inventories. Valid AM135 AM145
values are: AM15.1 AM15.2
Y = Yes AM15.3 AM15.4
N = No 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 AM230
AM282 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1
ATP-DEP-EXP-ALLOC Alpha 1 AM06.1 AM06.2
Element: Dep Exp Alloc This field indicates whether the asset AM06.3 AM06.5
type allows depreciation expense to ve AM115 AM117
allocated to multiple accounting units. AM12.1 AM125
Valid values are: AM135 AM145
N = No (the default) AM15.1 AM15.2
Y = Yes 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 AM230
AM282 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM500 AM502
AM551 AM700
AM88.7 AM92.1
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 AM06.6 AM115
AM117 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
...
ATPSET2 ASSET-TYPE KeyChange AM06.4 AM06.5
SUB-TYPE AM115 AM117
COMPANY AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM212
AM214
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
Amtypalloc AMTYPALLOC
ATP-COMPANY -> ALL-COMPANY
ATP-ASSET-TYPE -> ALL-ASSET-TYPE
ATP-SUB-TYPE -> ALL-SUB-TYPE
ALL-START-DATE
ALL-SEQUENCE-NBR
|