|
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 AM206 AM211
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.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 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
AM21.1 AM21.2 AM21.3 AM21.4 AM21.5 AM21.6
AM230 AM282 AM30.1 AM30.2 AM40.1 AM40.2
AM40.3 AM500 AM551 AM700 AM88.7 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 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM230 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
Element: 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM230 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
Element: 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM230 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
Element: 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM230 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
Element: Property This value classifies the kind of AM06.3 AM06.5
property that is represented by this AM115 AM12.1
asset type. AM125 AM135
P = Personal AM145 AM15.1
R = Real AM15.2 AM15.3
L = Land AM15.4 AM154
S = Stock AM170 AM180
O = Other 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
AM40.1 AM40.2
AM40.3 AM500
AM551 AM88.7
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 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM230 AM282
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM551 AM88.7
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 AM12.1
allocated to multiple accounting units. AM125 AM135
Valid values are: AM145 AM15.1
N = No (the default) AM15.2 AM15.3
Y = Yes AM15.4 AM154
AM170 AM180
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
AM40.1 AM40.2
AM40.3 AM500
AM551 AM700
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 AM06.6 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
...
ATPSET2 ASSET-TYPE KeyChange AM06.4 AM06.5
SUB-TYPE AM115 AM12.1
COMPANY AM15.1 AM15.2
AM15.3 AM15.4
AM206 AM211
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
|