Lawson Insight Technical Documentation |
|
AMASTTYPE
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 AM258 AM260 AM265 AM267
AM278 AM280 AM281 AM285 AM287 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 AM214
UPDATED BY
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 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 API1.1 API2.1 BL120 BL122 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA66.3
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PO100 PO101 PO122
PO131 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 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 POI3.1 POID.1 POII.1 POIJ.1 RQ10.1
RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATP-COMPANY Numeric 4 AC160 AM06.1
Element: Company The general ledger company number AM06.2 AM06.3
associated with the asset type record. 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
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 AP20.4
...
ATP-ASSET-TYPE Alpha 10 AC160 AM06.1
Element: Asset Type An asset type represents a grouping of AM06.2 AM06.3
like assets. Asset types are used to AM06.5 AM115
group assets into reporting classes and AM117 AM12.1
to default common asset definition data. 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
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 AP20.4
...
ATP-SUB-TYPE Alpha 10 AC160 AM06.1
Element: Subtype An asset subtype represents a more AM06.2 AM06.3
detailed grouping of assets within an AM06.5 AM115
asset type grouping. Asset subtypes are AM117 AM12.1
used to group assets into reporting AM125 AM135
classes and to default common asset AM145 AM15.1
definition data. Subtypes must be unique AM15.2 AM15.3
within an asset type. 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
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 AP20.4
...
ATP-DESCRIPTION Alpha 30 (Lower Case) AC160 AM06.1
Element: Description The asset type description. 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
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 AP20.4
...
ATP-PROPERTY Alpha 1 AC160 AM06.1
Element: Property This value classifies the kind of AM06.2 AM06.3
property that is represented by this AM06.5 AM115
asset type. AM117 AM12.1
P = Personal AM125 AM135
R = Real AM145 AM15.1
L = Land AM15.2 AM15.3
S = Stock AM15.4 AM154
O = Other 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
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 AP20.4
...
ATP-INV-FLAG Alpha 1 AC160 AM06.1
Element: Inv Flag This flag indicates whether an asset AM06.2 AM06.3
should be included as part of the AM06.5 AM115
physical inventory. If it is not, the AM117 AM12.1
asset is ignored in inventories. Valid AM125 AM135
values are: AM145 AM15.1
Y = Yes AM15.2 AM15.3
N = No 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
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 AP20.4
...
ATP-DEP-EXP-ALLOC Alpha 1 AC160 AM06.1
Element: Dep Exp Alloc This field indicates whether the asset AM06.2 AM06.3
type allows depreciation expense to ve AM06.5 AM115
allocated to multiple accounting units. AM117 AM12.1
Valid values are: AM125 AM135
N = No (the default) AM145 AM15.1
Y = Yes 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
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
...
AMASTTYPE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATPSET1 COMPANY AC160 AM06.1
ASSET-TYPE AM06.2 AM06.3
SUB-TYPE 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 KeyChange AC160 AM06.4
SUB-TYPE AM06.5 AM115
COMPANY 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 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
|