 |
Lawson Insight Technical Documentation |
|
AMASSET FILE
Asset
The Asset file stores asset records. An asset record is a grouping of one or
more asset items that are grouped together, or "combined," for depreciation
purposes. The Asset file also contains many of the selection and sorting
fields that are used for reporting.
Each Asset file record has one or more related records in the Asset Item file
and may have related records in the Asset Book file.
REFERENCED BY
AC03.5 AC10.3 AC10.1 AC17.5 AC18.4 AC191
AC203 AC217 AC218 AC52.1 AC520 AC92.2
AC92.4 AC92.6 AM06.4 AM06.5 AM06.1 AM06.2
AM06.3 AM120 AM13.1 AM13.2 AM152 AM153
AM220 AM221 AM222 AM223 AM224 AM225
AM23.1 AM23.2 AM23.3 AM23.4 AM230 AM235
AM240 AM241 AM245 AM25.2 AM25.1 AM25.3
AM250 AM251 AM252 AM255 AM260 AM265
AM270 AM275 AM277 AM278 AM280 AM281
AM285 AM290 AM292 AM295 AM310 AM320
AM35.1 AM35.3 AM45.1 AM45.3 AM52.1 AM580
AM70.1 AM70.4 AM70.2 AM75.1 AM75.3 AM80.1
AM80.2 AM80.3 AM85.1 AM85.2 AM85.3 AM88.1
AM88.7 AM90.3 AM90.1 AM90.2 AM90.4 AM90.5
AM91.3 AM91.1 AM91.2 AM91.4 AM91.5 AM93.1
AM94.1 AM95.3 AM95.1 AM95.2 AM95.4 AM95.5
AM95.6 AMAS.1 AMBK.1 AMBL.1 AMCO.1 AMDL.1
AP05.3 AP115 AP220 AP30.2 AP30.4 AP305
AP520 API1.1 API2.1 BR40.3 DR100 IC130
IC141 IC142 IC83.1 MX500 MA126 MA63.1
MA65.1 MA68.1 PO135 PO136 PO26.1 POIJ.1
RQ11.1 RQ12.1 RQ13.1 WH130 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 MX202 MX223
AM213 AM01.1 AM01.2 AM01.3 AM05.1 AM09.1
AM12.1 AM180 AM185 AM206 AM211 AM266
AM282 AM60.1 AM07.1 AM07.2 AM07.3 AM207
UPDATED BY
AM115 AM118 AM125 AM135 AM145 AM15.1
AM15.2 AM15.3 AM15.4 AM154 AM170 AM18.1
AM18.2 AM190 AM192 AM195 AM20.1 AM20.2
AM20.3 AM20.4 AM20.5 AM20.6 AM21.1 AM21.2
AM21.3 AM21.4 AM21.5 AM21.6 AM30.1 AM30.2
AM30.3 AM300 AM40.1 AM40.2 AM40.3 AM40.4
AM41.1 AM41.2 AM500 AM51.1 AM551 AM96.1
AM97.1 AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AST-ASSET Numeric 10 AM115 AM135
Asset The asset number contains up to ten AM15.1 AM15.2
numeric characters that uniquely AM15.3 AM15.4
identify an asset. Assets are AM154 AM170
automatically numbered system-wide. AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM40.1 AM500
AM551 AM96.1
AM98.1 AMCO.1
AST-DSP-ASSET Numeric 10 AM145 AM154
Disposal Asset If the asset is partially disposed of, AM192 AM40.1
this field contains the original asset
number of a new asset record that is
created due to the partial disposal. If
the asset is fully disposed of, this
field contains the same value as the
Asset field on this record.
AST-DESCRIPTION Alpha 30 (Lower Case) AM115 AM15.1
Description A description of the asset. AM15.2 AM15.3
AM15.4 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM551 AM96.1
AM98.1
AST-CLASSIFICATION Alpha 1 AM115 AM125
Classification This field contains the asset's AM135 AM15.1
classification. Capital and Operating AM15.2 AM15.3
refer to leased assets; Purchased refers AM15.4 AM154
to non-leased assets. Valid values are: AM170 AM20.1
P = Purchased AM20.2 AM20.3
C = Capital AM20.4 AM20.5
O = Operating AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM500
AM551 AM96.1
AM98.1
AST-LEASE-COMPANY Numeric 4 AM115 AM135
Lease Company The lessor company for the leased asset. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM500 AM551
AM96.1 AM98.1
AST-LEASE Alpha 19 AM115 AM135
Lease The lease number associated with a AM15.1 AM15.2
leased asset. AM15.3 AM15.4
AM154 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM500 AM551
AM96.1 AM98.1
AST-TAG-NBR Alpha 12 AM115 AM135
Tag Number The tag is a user definable identifier AM15.1 AM15.2
assigned to an asset. AM15.3 AM15.4
AM154 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM500 AM551
AM96.1 AM98.1
AST-ASSET-GROUP Alpha 10 AM115 AM125
Asset Group The asset group assigned to the asset. AM135 AM15.1
Represents a parent asset number used AM15.2 AM15.3
for report grouping. AM15.4 AM154
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM500
AM551 AM96.1
AM98.1
AST-OBJ-ID Numeric 12 AM115 AM135
Object ID The object identifier is a unique key AM15.1 AM15.2
used to attach a list of user-defined AM15.3 AM15.4
attributes for the asset. AM154 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM40.1 AM500
AM551 AM96.1
AM98.1
AST-STATUS Numeric 1 AM115 AM125
Status This field identifies the transaction AM135 AM145
status of the asset record. Valid values AM15.1 AM15.2
are: AM15.3 AM15.4
AM154 AM170
1 = Entered. AM192 AM20.1
2 = Active (updated). AM20.2 AM20.3
3 = Post Active Process. AM20.4 AM20.5
9 = Disposed. AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM40.1
AM41.1 AM500
AM551 AM96.1
AM98.1
AST-ASSET-PROCESS Alpha 3 AM115 AM125
Asset Process This field identifies whether the asset AM135 AM145
record is in the process of being AM15.1 AM15.2
adjusted, disposed of, or transferred. AM15.3 AM15.4
Valid values are: AM154 AM170
AM192 AM20.1
ADJ = Adjustment AM20.2 AM20.3
DSP = Disposal AM20.4 AM20.5
TRF = Transfer AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
Blank = The asset is not being adjusted, AM30.2 AM40.1
disposed of, or transferred. AM41.1 AM500
RIN = Reinstate AM551 AM96.1
AM98.1
AST-PROCESS-DATE Numeric 8 (yyyymmdd) AM115 AM125
Process Date The last date an adjustment, disposal, AM135 AM145
or transfer was processed for the asset AM15.1 AM15.2
record. AM15.3 AM15.4
AM154 AM170
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 AM30.1
AM30.2 AM40.1
AM41.1 AM500
AM551 AM96.1
AM98.1
AST-ASSET-CATEGORY Alpha 1 AM115 AM15.1
Asset Category This field identifies whether the asset AM15.2 AM15.3
is depreciable. Valid values are: AM15.4 AM170
AM20.1 AM20.2
D = Depreciable. AM20.3 AM20.4
N = Non-Depreciable. AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM551 AM96.1
AM98.1
AST-SIMULATED Alpha 1 AM115 AM125
Simulated This field identifies whether the asset AM15.1 AM15.2
is simulated, which means the asset is a AM15.3 AM15.4
representation, not a real asset. AM170 AM20.1
Simulated assets can be used to AM20.2 AM20.3
experiment and test strategies. Valid AM20.4 AM20.5
values are: AM20.6 AM21.1
Y = Yes AM21.2 AM21.3
N = No AM21.4 AM21.5
AM21.6 AM30.1
AM500 AM551
AM96.1 AM98.1
AST-WORK-IN-PROC Alpha 1 AM115 AM125
Work-in-Process This field identifies whether the asset AM15.1 AM15.2
is considered work in process, which AM15.3 AM15.4
means the asset is real, but not yet AM170 AM20.1
complete. If this field is Yes, the AM20.2 AM20.3
asset is on hold and cannot be released. AM20.4 AM20.5
Valid values are: AM20.6 AM21.1
AM21.2 AM21.3
N = No. AM21.4 AM21.5
Y = Yes. AM21.6 AM30.1
AM500 AM551
AM96.1 AM98.1
AST-TAX-EXEMPT Alpha 1 AM115 AM125
Tax Exempt This field identifies whether the asset AM15.1 AM15.2
is exempt from taxation. Valid values AM15.3 AM15.4
are: AM170 AM20.1
Y = Yes AM20.2 AM20.3
N = No AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM500 AM551
AM96.1 AM98.1
AST-USED Alpha 1 AM115 AM125
Used This field identifies whether the asset AM15.1 AM15.2
has already been used at the time it was AM15.3 AM15.4
purchased. Valid values are: AM170 AM20.1
AM20.2 AM20.3
N = No. AM20.4 AM20.5
Y = Yes. AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM500 AM551
AM96.1 AM98.1
AST-ITEM-TOT-QTY Numeric 10 AM115 AM135
Item Total Quantity The total number of items that make up AM15.1 AM15.2
this asset record. AM15.3 AM15.4
AM154 AM170
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 AM30.1
AM30.2 AM40.1
AM40.2 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
AST-IT-TOT-CSTBASE Signed 15.2 AM115 AM135
Item Total Cost Base The total cost of the asset items in AM15.1 AM15.2
company base currency. AM15.3 AM15.4
AM154 AM170
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 AM30.1
AM30.2 AM40.1
AM40.2 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
AST-IT-TOT-TAXBASE Signed 15.2 AM115 AM135
Item Total Tax Base The total tax amount associated with AM15.1 AM15.2
the asset items in the company base AM15.3 AM15.4
currency. AM154 AM170
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 AM30.1
AM30.2 AM40.1
AM40.2 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
AST-IT-TOT-CSTTRAN Signed 15.2 AM115 AM135
Item Total Cost Tran The total cost of the asset items in AM15.1 AM15.2
the currency of the transaction. AM15.3 AM15.4
AM154 AM170
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 AM30.1
AM30.2 AM40.1
AM40.2 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
AST-IT-TOT-TAXTRAN Signed 15.2 AM115 AM135
Item Total Tax Tran The total tax amount associated with AM15.1 AM15.2
the asset items in the currency of the AM15.3 AM15.4
transaction. AM154 AM170
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 AM30.1
AM30.2 AM40.1
AM40.2 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
AST-BASE-ND Numeric 1 AM115 AM135
Base Number of The number of decimal positions defined AM15.1 AM15.2
Decimals for the company base currency. AM15.3 AM15.4
AM154 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM500 AM551
AM96.1 AM98.1
AST-TRAN-ND Numeric 1 AM115 AM135
Tran Number of The number of decimal positions defined AM15.1 AM15.2
Decimals for the transaction currency. AM15.3 AM15.4
AM154 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM500 AM551
AM96.1 AM98.1
AST-CURRENCY-CODE Alpha 5 AM115 AM135
Currency Code The transaction currency code assigned AM15.1 AM15.2
to the asset. AM15.3 AM15.4
AM154 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM500 AM551
AM96.1 AM98.1
AST-ITEM-LAST-DATE Numeric 8 (yyyymmdd) AM115 AM135
Item Last Purchase The highest (latest) purchase date of AM15.1 AM15.2
Date all of the items that make up the asset. AM15.3 AM15.4
AM154 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM40.1 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
AST-ITEM-LAST-SEQ Numeric 6 AM115 AM135
Item Last Sequence The last sequence number assigned to an AM15.1 AM15.2
Number asset item for this asset record. AM15.3 AM15.4
AM154 AM192
AM20.1 AM20.3
AM21.1 AM21.3
AM30.1 AM30.2
AM40.1 AM500
AM51.1 AM551
AM97.1
AST-COMPANY Numeric 4 AM115 AM135
Company The general ledger company number AM15.1 AM15.2
associated with the asset record. Used AM15.3 AM15.4
for posting associated asset transaction AM154 AM170
entries to the general ledger. AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM500 AM551
AM96.1 AM98.1
AST-LOCATION-NAME Alpha 15 AM115 AM135
Location Name The location assigned to the asset. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM500 AM551
AM96.1 AM98.1
AST-DIVISION Alpha 15 AM115 AM135
Division The division assigned to the asset. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM500 AM551
AM96.1 AM98.1
AST-ASSET-TYPE Alpha 10 AM06.4 AM06.5
Asset Type This field identifies the asset type. AM115 AM125
Asset types are user-defined and AM135 AM15.1
represent a grouping of like assets. AM15.2 AM15.3
Asset types are used to group assets AM15.4 AM154
into reporting classes and to default AM170 AM20.1
common asset definition data. AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM500
AM551 AM96.1
AM98.1
AST-SUB-TYPE Alpha 10 AM06.4 AM06.5
Asset Subtype This field identifies the asset AM115 AM125
subtype. An asset subtype represents a AM135 AM15.1
more detailed grouping of assets within AM15.2 AM15.3
an asset type. Asset subtypes are used AM15.4 AM154
to group assets into reporting classes AM170 AM20.1
and allow common asset definition data AM20.2 AM20.3
to default. AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM500
AM551 AM96.1
AM98.1
AST-ACCT-GRP Alpha 10 AM115 AM125
Account Group This is the account group assigned to AM135 AM15.1
the asset. Account groups are AM15.2 AM15.3
user-defined and are used to identify AM15.4 AM154
the general ledger accounts used to AM170 AM20.1
create journal entries when assets are AM20.2 AM20.3
processed (added, adjusted, transferred, AM20.4 AM20.5
or disposed of). AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM500
AM551 AM96.1
AM98.1
AST-ACCT-UNIT Alpha 15 AM115 AM125
Accounting Unit The default accounting unit that will AM135 AM15.1
be used, if necessary, to piece together AM15.2 AM15.3
with accounts from the Type, Subtype, AM15.4 AM154
and Account Group fields to make valid AM170 AM20.1
general ledger accounts. AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM500
AM551 AM96.1
AM98.1
AST-AU-GROUP Alpha 10 AM115 AM125
Accounting Unit Accounting unit groups group and AM135 AM15.1
Group identify the accounting units to use AM15.2 AM15.3
when you create journal entries for AM15.4 AM154
adding, adjusting, transferring, or AM170 AM20.1
disposing of assets. Changes to AM20.2 AM20.3
accounting unit groups are dynamic, AM20.4 AM20.5
affecting all assets using the AM20.6 AM21.1
accounting unit group. Accounting unit AM21.2 AM21.3
group names are user-definable, and AM21.4 AM21.5
accounting unit groups are set up by AM21.6 AM30.1
company. AM30.2 AM500
AM551 AM96.1
AM98.1
AST-ACTIVITY Alpha 15
Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
AST-DEP-EXP-ACTVTY Alpha 15 AM115 AM125
Depreciation This is the override depreciation AM15.1 AM15.2
Expense Activity expense activity, which overrides any AM15.3 AM15.4
depreciation expense activity set up on AM170 AM20.1
AM06.1 (Type). This is the depreciation AM20.2 AM20.3
expense activity used for posting. AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
AST-DEP-ACCT-CAT Alpha 5 AM115 AM125
Depr Expense This is the override depreciation AM15.1 AM15.2
Account Category expense account category, which AM15.3 AM15.4
overrides any depreciation expense AM170 AM20.1
account category set up on AM06.1 AM20.2 AM20.3
(Type). This is the depreciation AM20.4 AM20.5
expense account category used for AM20.6 AM21.1
posting. AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1
AST-ORIG-CO Numeric 4 AM115 AM15.1
Original Company This field contains the original AM15.2 AM15.3
company number when the asset record is AM15.4 AM170
added to this file. This field is never AM20.1 AM20.2
changed after being added. AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM551 AM96.1
AM98.1
AST-ASSET-LAST-SEQ Numeric 6 AM115 AM125
Last Process The last sequence number assigned to AM135 AM145
Sequence Number the last process created for the asset. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
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 AM30.1
AM40.1 AM500
AM551 AM96.1
AM98.1
AST-TRAN-LAST-SEQ Numeric 6 AM115 AM118
Last Transaction The sequence number assigned to the AM125 AM135
Sequence Nbr last transaction created for the asset. AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM18.1 AM18.2
AM190 AM192
AM20.1 AM20.2
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM551 AM98.1
AST-COMM-LAST-SEQ Numeric 6
Last Comment The sequence number of the last comment
Sequence Number defined for the asset.
AST-CREATION-DATE Numeric 8 (yyyymmdd) AM115 AM135
Creation Date The date the asset record was created. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM40.1 AM500
AM551 AM96.1
AM98.1
AST-CREATION-TIME Numeric 6 (hhmmss) AM115 AM135
Creation Time The time the asset record was created. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM40.1 AM500
AM551 AM96.1
AM98.1
AST-CREATOR-ID Alpha 10 AM115 AM135
Creator ID This field identifies the operator who AM15.1 AM15.2
created the asset record. AM15.3 AM15.4
AM154 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM40.1 AM500
AM551 AM96.1
AM98.1
AST-INV-FLAG Alpha 1 AM115 AM15.1
Inv Flag **Field purpose AM15.2 AM15.3
You can indicate whether the asset AM15.4 AM170
should be included as part of the AM20.1 AM20.2
physical inventory. This value defaults AM20.3 AM20.4
from the asset type and can be AM20.5 AM20.6
overridden when the asset is created. If AM21.1 AM21.2
the asset is not part of the physical AM21.3 AM21.4
inventory, it will be ignored in the AM21.5 AM21.6
inventory reports. AM500 AM551
AM96.1 AM98.1
Valid values are:
Y = Yes
N = No
AST-ASSET-OWNER Alpha 10 AM115 AM15.1
Asset Owner This field contains the name of the AM15.2 AM15.3
person responsible for keeping track of AM15.4 AM170
the asset in invnetory. AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM551
AM96.1 AM98.1
AST-ATP-PROPERTY Derived
Property Type This field identifies the kind of
property defined for the asset type,
such as personal, real, land, stock, or
other kinds of property.
AST-GL-NAME Derived
Company The name of the general ledger company
associated with the asset record.
AST-GL-CURR-CODE Derived
Currency Code The base currency defined for the
posting company associated with the
asset.
AST-GL-CHART Derived
Chart The chart name assigned to the posting
company associated with the asset.
AST-ACCT-UNIT-DESC Derived
Accounting Unit A description of the general ledger
Description accounting unit that is assigned to the
asset.
AST-ACCT-GRP-DESC Derived
Account Group A description of the account group
Description associated with the asset.
AST-LOC-DESC Derived
Location Description A description of the location
associated with the asset.
AST-DIV-DESC Derived
Division Description A description of the division
associated with the asset.
AST-TYPE-DESC Derived
Type Description A description of the asset type.
AST-ASD-DSP-METHOD Derived
Disposal Method If the asset is fully or partially
disposed of, this field identifies the
method by which the asset was disposed
of. Valid values are:
A = Abandoned.
D = Donated.
E = Exchanged.
P = Purged.
R = Retired.
S = Sold.
T = Traded.
O = Other.
AST-ASD-DSP-FL-PRT Derived
Full or Partial If the asset is disposed of, this field
identifies whether the asset is
partially or fully disposed of.
AST-ASD-DSP-DATE Derived
Disposal Date If the asset is disposed of, this field
identifies the date the asset was
partially or fully disposed of.
AST-ASD-DSP-PROP Derived
Disposal Property If the asset is disposed of, this field
identifies the disposal property code
assigned to the asset.
AST-ASD-DSP-QTY Derived
Disposal Quantity If the asset is partially or fully
disposed of, this field identifies the
number of units disposed of.
AST-ASD-PROC-CURR Derived
Proceeds Currency If the asset is sold (disposed of),
this field identifies the currency of
the proceeds from the sale.
AST-ASD-PROCEEDS Derived
Proceeds If the asset is sold (disposed of),
this field identifies the proceeds of
the sale in the proceeds currency.
AST-ASD-COS-CURR Derived
Disposal Expense If the asset is sold (disposed of),
Currency this field identifies the currency of
the expenses in selling it.
AST-ASD-COST-SALE Derived
Disposal Expense If the asset is sold (disposed of),
this field identifies the amount
received for the sale of the asset.
AST-BLANKAM Derived
Blank This field consists of blank spaces. It
is used to provide column headings on
Drill Arounds.
AST-CLEARING-AU Derived
Clearing Au
AST-ASSET-AU Derived
Asset Au
AST-ACCUM-AU Derived
Accum Au
AST-DEPR-EXP-AU Derived
Depr Exp Au
AST-COST-AU Derived
Cost Au
AST-PROCEEDS-AU Derived
Proceeds Au
AST-GAIN-AU Derived
Gain Au
AST-LOSS-AU Derived
Loss Au
AST-DEF-GAIN-AU Derived
Def Gain Au
AST-DEF-LOSS-AU Derived
Def Loss Au
AST-REINSTATE-DATE Numeric 8 (yyyymmdd) AM41.1
Reinstate Date The date of the last disposal
reinstatement.
AST-REINSTATE-FLAG Alpha 1 AM41.1
Reinstate Flag This field indicates that the disposal
has been reinstated.
N = No
Y = Yes
AMASSET FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASTSET1 ASSET AC03.5 AC10.3
AC17.5 AC18.4
AC191 AC203
AC217 AC218
AC52.1 AC520
AC92.2 AC92.4
AC92.6 AM06.4
AM06.5 AM115
AM118 AM120
AM125 AM13.1
AM13.2 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM152
AM153 AM154
...
ASTSET10 OBJ-ID AM120 AM220
AM221 AM222
AM223 AM224
AM225 AM23.3
AM23.4 AM230
AM235 AM240
AM245 AM25.2
AM250 AM255
AM260 AM265
AM275 AM277
AM278 AM280
AM281 AM285
AM290 AM292
AM295 AM320
AM35.1 AM45.1
...
ASTSET11 CLASSIFICATION
ASSET
ASTSET12 ASSET-GROUP AM213
ASSET
ASTSET13 LEASE-COMPANY AM21.2 AM21.4
LEASE AM25.1 AM25.3
ASSET AM35.1 AM40.1
AM45.1 AM45.3
ASTSET2 COMPANY KeyChange AM01.1 AM01.2
ASSET AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM09.1 AM115
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
...
ASTSET3 STATUS KeyChange AC10.1 AC10.3
LOCATION-NAME AM07.1 AM07.2
DSP-ASSET AM07.3 AM115
ASSET AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM207 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM52.1 AM551
AM60.1 AM88.7
...
ASTSET4 STATUS KeyChange AM60.1
DIVISION
DSP-ASSET
ASSET
ASTSET5 STATUS KeyChange AM05.1 AM06.1
COMPANY AM06.2 AM06.3
ASSET-TYPE AM06.5 AM09.1
SUB-TYPE AM115 AM12.1
DSP-ASSET AM125 AM135
ASSET AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM180
AM190 AM192
AM195 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM206
AM21.1 AM21.2
...
ASTSET6 STATUS KeyChange, Subset AM25.3 AM45.3
COMPANY Where ASSET-GROUP != Spaces AM60.1 AM90.1
ASSET-GROUP AM90.2 AM90.4
DSP-ASSET AM90.5 AM91.1
ASSET AM91.2 AM91.4
AM91.5 AM95.2
ASTSET7 STATUS KeyChange AM25.3 AM255
COMPANY AM295 AM45.3
LOCATION-NAME AM60.1 AM90.1
DIVISION AM90.2 AM90.4
ASSET-TYPE AM90.5 AM91.1
SUB-TYPE AM91.2 AM91.4
DSP-ASSET AM91.5 AM95.2
ASSET
ASTSET8 ASSET KeyChange, Subset AM170 AM245
DSP-ASSET Where STATUS = 3 AM40.1
And ASSET-PROCESS = "DSP"
And DSP-ASSET != Zeroes
ASTSET9 STATUS KeyChange AM05.1 AM115
COMPANY AM12.1 AM125
DSP-ASSET AM145 AM15.1
ASSET AM15.2 AM15.3
AM15.4 AM154
AM170 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
AM240 AM245
AM30.1 AM40.1
AM40.2 AM40.3
...
AMASSET FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amaccount Acm AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
Spaces -> AAC-ACCT-GRP
AST-ASSET-TYPE -> AAC-ASSET-TYPE
AST-SUB-TYPE -> AAC-SUB-TYPE
"ACM" -> AAC-ACCT-TYPE
Amaccount Ast AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
Spaces -> AAC-ACCT-GRP
AST-ASSET-TYPE -> AAC-ASSET-TYPE
AST-SUB-TYPE -> AAC-SUB-TYPE
"AST" -> AAC-ACCT-TYPE
Amaccount Clr AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
AST-ACCT-GRP -> AAC-ACCT-GRP
Spaces -> AAC-ASSET-TYPE
Spaces -> AAC-SUB-TYPE
"CLR" -> AAC-ACCT-TYPE
Amaccount Cos AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
AST-ACCT-GRP -> AAC-ACCT-GRP
Spaces -> AAC-ASSET-TYPE
Spaces -> AAC-SUB-TYPE
"COS" -> AAC-ACCT-TYPE
Amaccount Dgn AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
AST-ACCT-GRP -> AAC-ACCT-GRP
Spaces -> AAC-ASSET-TYPE
Spaces -> AAC-SUB-TYPE
"DGN" -> AAC-ACCT-TYPE
Amaccount Dls AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
AST-ACCT-GRP -> AAC-ACCT-GRP
Spaces -> AAC-ASSET-TYPE
Spaces -> AAC-SUB-TYPE
"DLS" -> AAC-ACCT-TYPE
Amaccount Exp AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
Spaces -> AAC-ACCT-GRP
AST-ASSET-TYPE -> AAC-ASSET-TYPE
AST-SUB-TYPE -> AAC-SUB-TYPE
"EXP" -> AAC-ACCT-TYPE
Amaccount Gan AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
AST-ACCT-GRP -> AAC-ACCT-GRP
Spaces -> AAC-ASSET-TYPE
Spaces -> AAC-SUB-TYPE
"GAN" -> AAC-ACCT-TYPE
Amaccount Los AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
AST-ACCT-GRP -> AAC-ACCT-GRP
Spaces -> AAC-ASSET-TYPE
Spaces -> AAC-SUB-TYPE
"LOS" -> AAC-ACCT-TYPE
Amaccount Pro AMACCOUNT Not Required
AST-COMPANY -> AAC-COMPANY
AST-ACCT-GRP -> AAC-ACCT-GRP
Spaces -> AAC-ASSET-TYPE
Spaces -> AAC-SUB-TYPE
"PRO" -> AAC-ACCT-TYPE
Amacctgrp AMACCTGRP Required
AST-COMPANY -> AAG-COMPANY
AST-ACCT-GRP -> AAG-ACCT-GRP
Amassetdsp AMASSETDSP Not Required
AST-ASSET -> ASD-ASSET
Amassetgrp AMASSETGRP Not Required
AST-ASSET-GROUP -> ATG-ASSET-GROUP
Amasttype AMASTTYPE Required
AST-COMPANY -> ATP-COMPANY
AST-ASSET-TYPE -> ATP-ASSET-TYPE
AST-SUB-TYPE -> ATP-SUB-TYPE
Amaugroup AMAUGROUP Not Required
AST-COMPANY -> AAU-COMPANY
AST-AU-GROUP -> AAU-AU-GROUP
Amcontrol AMCONTROL Not Required
AST-COMPANY -> CTL-COMPANY
Amdivision AMDIVISION Not Required
AST-DIVISION -> DIV-DIVISION
Amlocation AMLOCATION Not Required, Delete Restricted
AST-LOCATION-NAME -> LOC-LOCATION-NAME
Glnames GLNAMES Not Required
AST-COMPANY -> GLN-COMPANY
AST-ACCT-UNIT -> GLN-ACCT-UNIT
Glsystem GLSYSTEM Required
AST-COMPANY -> GLS-COMPANY
Lmlease LMLEASE Not Required
AST-COMPANY -> LSE-COMPANY
AST-LEASE -> LSE-LEASE
AMASSET FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amassetadj AMASSETADJ
AST-ASSET -> ASA-ASSET
ASA-PROCESS-SEQ
Amassetrin AMASSETRIN
AST-ASSET -> RIN-ASSET
RIN-CREATION-DATE
RIN-CREATION-TIME
Amassettrf AMASSETTRF
AST-ASSET -> ATF-ASSET
ATF-PROCESS-SEQ
Amastbkadj AMASTBKADJ
AST-ASSET -> ABA-ASSET
ABA-BOOK
ABA-PROCESS-SEQ
Amastbkdsp AMASTBKDSP
AST-ASSET -> ABD-ASSET
ABD-BOOK
Amastbktrf AMASTBKTRF
AST-ASSET -> ABT-ASSET
ABT-BOOK
ABT-PROCESS-SEQ
Amastbook AMASTBOOK Delete Restricted
AST-ASSET -> ASB-ASSET
ASB-BOOK
Amastitdsp AMASTITDSP
AST-ASSET -> ADS-ASSET
ADS-PROCESS-SEQ
ADS-SEQ-NUMBER
Amastitem AMASTITEM Delete Cascades
AST-ASSET -> ASI-ASSET
ASI-SEQ-NUMBER
Amastmxval AMASTMXVAL
AST-OBJ-ID -> MXT-OBJ-ID
MXT-MATRIX-CAT
Amastrpair AMASTRPAIR
AST-ASSET -> ASR-ASSET
ASR-REPAIR-DATE
ASR-SEQ-NUMBER
Amtrans AMTRANS
AST-ASSET -> AMT-ASSET
"R" -> AMT-TRANS-STATUS
AMT-COMPANY
AMT-BOOK
AMT-SEQ-NUMBER
|