Lawson Insight Technical Documentation |
|
AMASSET
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 AC131 AC17.5 AC18.4
AC191 AC203 AC217 AC218 AC41.1 AC41.4
AC42.1 AC52.1 AC520 AC54.1 AC540 AC92.2
AC92.4 AC92.6 ACAC.1 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 AM267 AM270 AM275 AM277 AM278
AM280 AM281 AM285 AM287 AM290 AM292
AM295 AM310 AM320 AM35.1 AM35.3 AM45.1
AM45.3 AM501 AM52.1 AM520 AM580 AM70.1
AM70.4 AM70.2 AM75.1 AM75.3 AM75.2 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 AP125 AP126 AP131 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP220
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.4 AP305 AP520 API1.1 API2.1 BR40.3
BR43.1 DR100 IC130 IC141 IC142 IC28.1
IC83.1 MX500 MA180 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.5
MA43.7 MA43.8 MA43.9 MA530 MA531 MA540
MA60.2 MA60.3 MA60.5 MA61.1 MA63.1 MA65.1
MA66.2 MA66.3 MA67.1 MA67.2 MA68.1 MA70.1
MA75.1 MA80.1 MAI1.1 PO100 PO101 PO122
PO131 PO135 PO136 PO20.1 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO23.1 PO25.1
PO25.5 PO25.6 PO25.7 PO26.1 PO27.2 PO29.1
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.1 PO32.2 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 POII.1 POIJ.1
RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1
RQ35.1 RQ500 RQIB.1 RQID.1 RQIE.1 RQIF.1
RQIJ.1 WH130 WH132 WH190 WH20.2 WH20.7
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 WO140 MX202
MX223 AM213 AM01.1 AM01.2 AM01.3 AM05.1
AM09.1 AM12.1 AM180 AM185 AM266 AM282
AM60.1 AM07.1 AM07.2 AM07.3 AM08.1 AM08.2
AM195
UPDATED BY
AM115 AM118 AM125 AM135 AM145 AM15.1
AM15.2 AM15.3 AM15.4 AM154 AM170 AM18.1
AM18.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 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 AM330
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AST-ASSET Numeric 10 AM115 AM135
Element: 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
Element: Disposal AssetIf the asset is partially disposed of, AM170 AM192
this field contains the original asset AM40.1 AM41.1
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
Element: 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
Element: ClassificationThis 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 AM240
AM281 AM30.1
AM30.2 AM500
AM551 AM96.1
AM98.1
AST-LEASE-COMPANY Numeric 4 AM115 AM135
Element: 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
Element: 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 AM125
Element: Tag Number The tag is a user definable identifier AM135 AM15.1
assigned to an asset. 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-GROUP Alpha 10 AM115 AM125
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Asset CategoryThis 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
Element: 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
Element: Work-in-ProcesThis 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
Element: 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
Element: 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
Element: Item Total QuaThe 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
Element: Item Total CosThe 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
Element: Item Total TaxThe 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
Element: Item Total CosThe 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
Element: Item Total TaxThe 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 AM15.1 AM15.2
Decimals 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 AM15.1 AM15.2
Decimals 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
Element: 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
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
AM500 AM51.1
AM551 AM97.1
AST-COMPANY Numeric 4 AM115 AM125
Element: Company The general ledger company number AM135 AM15.1
associated with the asset record. Used AM15.2 AM15.3
for posting associated asset transaction AM15.4 AM154
entries to the general ledger. 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-LOCATION-NAME Alpha 15 AM115 AM125
Element: Location Name The location assigned to the asset. AM135 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 AM125
Element: Division The division assigned to the asset. AM135 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
Element: 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
Element: 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
Element: 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
Element: Accounting UniThe 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
Element: 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 AM15.1 AM15.2
Expense Activity 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 AM500
AM551 AM96.1
AM98.1
AST-DEP-ACCT-CAT Alpha 5 AM115 AM125
Depr Expense AM15.1 AM15.2
Account Category 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 AM500
AM551 AM96.1
AM98.1
AST-ORIG-CO Numeric 4 AM115 AM15.1
Element: Original Company 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-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
AM170 AM18.1
AM18.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 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM551
AM96.1 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Company The name of the general ledger company
associated with the asset record.
AST-GL-CURR-CODE Derived
Element: Currency Code The base currency defined for the
posting company associated with the
asset.
AST-GL-CHART Derived
Element: 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
Element: Location DescrA description of the location
associated with the asset.
AST-DIV-DESC Derived
Element: Division DescrA description of the division
associated with the asset.
AST-TYPE-DESC Derived
Element: Type DescriptiA description of the asset type.
AST-ASD-DSP-METHOD Derived
Element: Disposal MethoIf 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
Element: Full or PartiaIf the asset is disposed of, this field
identifies whether the asset is
partially or fully disposed of.
AST-ASD-DSP-DATE Derived
Element: 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
Element: Disposal PropeIf the asset is disposed of, this field
identifies the disposal property code
assigned to the asset.
AST-ASD-DSP-QTY Derived
Element: Disposal QuantIf the asset is partially or fully
disposed of, this field identifies the
number of units disposed of.
AST-ASD-PROC-CURR Derived
Element: Proceeds CurreIf the asset is sold (disposed of),
this field identifies the currency of
the proceeds from the sale.
AST-ASD-PROCEEDS Derived
Element: 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
Element: Disposal ExpenIf the asset is sold (disposed of),
this field identifies the amount
received for the sale of the asset.
AST-BLANKAM Derived
Element: Blank This field consists of blank spaces. It
is used to provide column headings on
Drill Arounds.
AST-CLEARING-AU Derived
Element: Clearing Au
AST-ASSET-AU Derived
Element: Asset Au
AST-ACCUM-AU Derived
Element: Accum Au
AST-DEPR-EXP-AU Derived
Element: Depr Exp Au
AST-COST-AU Derived
Element: Cost Au
AST-PROCEEDS-AU Derived
Element: Proceeds Au
AST-GAIN-AU Derived
Element: Gain Au
AST-LOSS-AU Derived
Element: Loss Au
AST-DEF-GAIN-AU Derived
Element: Def Gain Au
AST-DEF-LOSS-AU Derived
Element: Def Loss Au
AST-REINSTATE-DATE Numeric 8 (yyyymmdd) AM41.1
Element: Reinstate DateThe date of the last disposal
reinstatement.
AST-REINSTATE-FLAG Alpha 1 AM41.1
Element: Reinstate FlagThis 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
AC131 AC17.5
AC18.4 AC191
AC203 AC217
AC218 AC41.1
AC41.4 AC42.1
AC52.1 AC520
AC54.1 AC540
AC92.2 AC92.4
AC92.6 ACAC.1
AM06.4 AM06.5
AM115 AM118
AM120 AM125
AM13.1 AM13.2
AM135 AM145
...
ASTSET10 OBJ-ID AM120 AM145
AM220 AM221
AM222 AM223
AM224 AM225
AM23.3 AM23.4
AM230 AM235
AM240 AM245
AM25.2 AM250
AM255 AM260
AM265 AM267
AM275 AM277
AM278 AM280
AM281 AM285
AM287 AM290
AM292 AM295
...
ASTSET11 CLASSIFICATION
ASSET
ASTSET12 ASSET-GROUP AM213 AM75.1
ASSET AM75.2 AM80.1
AM80.2 AM85.1
AM85.2
ASTSET13 LEASE-COMPANY AM145 AM21.2
LEASE AM21.4 AM25.1
ASSET AM25.3 AM330
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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM35.1 AM45.1
AM45.3 AM500
AM52.1 AM551
...
ASTSET4 STATUS KeyChange AC10.1 AC10.3
DIVISION AM08.1 AM08.2
DSP-ASSET AM115 AM12.1
ASSET AM15.1 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 AM45.1
AM45.3 AM500
AM551 AM60.1
AM88.7 AM96.1
...
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 AM21.1
AM21.2 AM21.3
...
ASTSET6 STATUS KeyChange, Subset AM145 AM25.3
COMPANY Where ASSET-GROUP != Spaces AM45.1 AM45.3
ASSET-GROUP AM60.1 AM70.1
DSP-ASSET AM70.2 AM90.1
ASSET AM90.2 AM90.4
AM90.5 AM91.1
AM91.2 AM91.4
AM91.5 AM95.2
ASTSET7 STATUS KeyChange AM145 AM25.3
COMPANY AM255 AM295
LOCATION-NAME AM330 AM35.3
DIVISION AM45.1 AM45.3
ASSET-TYPE AM60.1 AM70.2
SUB-TYPE AM90.1 AM90.2
DSP-ASSET AM90.4 AM90.5
ASSET AM91.1 AM91.2
AM91.4 AM91.5
AM95.2
ASTSET8 ASSET KeyChange, Subset AM245 AM40.1
DSP-ASSET Where STATUS = 3
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-LEASE-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
Amtypalloc AMTYPALLOC
AST-COMPANY -> ALL-COMPANY
AST-ASSET-TYPE -> ALL-ASSET-TYPE
AST-SUB-TYPE -> ALL-SUB-TYPE
ALL-START-DATE
ALL-SEQUENCE-NBR
|