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 AC03.7 AC10.3 AC10.1 AC145 AC17.5
AC18.4 AC191 AC203 AC217 AC218 AC41.1
AC41.4 AC42.1 AC46.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.2
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 AP125 AP126
AP131 AP220 AP25.1 AP25.2 AP26.1 AP27.1
AP30.2 AP30.4 AP305 AP520 API1.1 API2.1
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
BR40.3 BR43.1 BR46.1 DR100 IC130 IC141
IC142 IC28.1 IC83.1 MX500 MA126 MA180
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
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE111 OE113 OE114 OE116 OE129
OE13.2 OE13.3 OE13.5 OE13.6 OE14.4 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE530 OE81.1 OE810 OE830
OE90.1 OE90.2 PO100 PO101 PO122 PO131
PO135 PO136 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO25.5 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 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 POI3.1 POIE.1 POII.1 POIJ.1
RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ500 RQIB.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 AM206 AM211 AM266
AM282 AM60.1 AM07.1 AM07.2 AM07.3 AM207
AM195
UPDATED BY
AM115 AM117 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 AM502 AM51.1 AM551
AM92.1 AM96.1 AM97.1 AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AST-ASSET Numeric 10 AM115 AM117
Element: Asset The asset number contains up to ten AM135 AM15.1
numeric characters that uniquely AM15.2 AM15.3
identify an asset. Assets are AM15.4 AM154
automatically numbered system-wide. 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
AMCO.1
AST-DSP-ASSET Numeric 10 AM145 AM154
Element: Disposal AssetIf 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 AM117
Element: Description A description of the 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 AM30.1
AM500 AM551
AM96.1 AM98.1
AST-CLASSIFICATION Alpha 1 AM115 AM117
Element: ClassificationThis field contains the asset's AM125 AM135
classification. Capital and Operating AM15.1 AM15.2
refer to leased assets; Purchased refers AM15.3 AM15.4
to non-leased assets. Valid values are: AM154 AM170
P = Purchased AM20.1 AM20.2
C = Capital AM20.3 AM20.4
O = Operating AM20.5 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 AM117
Element: Company The lessor company for the leased 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-LEASE Alpha 19 AM115 AM117
Element: Lease The lease number associated with a AM135 AM15.1
leased 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-TAG-NBR Alpha 12 AM115 AM117
Element: Tag Number The tag is a user definable identifier AM125 AM135
assigned to an 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-GROUP Alpha 10 AM115 AM117
Element: Asset Group The asset group assigned to the asset. AM125 AM135
Represents a parent asset number used AM15.1 AM15.2
for report grouping. 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-OBJ-ID Numeric 12 AM115 AM117
Element: Object ID The object identifier is a unique key AM135 AM15.1
used to attach a list of user-defined AM15.2 AM15.3
attributes for the asset. 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-STATUS Numeric 1 AM115 AM117
Element: Status This field identifies the transaction AM125 AM135
status of the asset record. Valid values AM145 AM15.1
are: AM15.2 AM15.3
AM15.4 AM154
1 = Entered. AM170 AM192
2 = Active (updated). AM20.1 AM20.2
3 = Post Active Process. AM20.3 AM20.4
9 = Disposed. 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-PROCESS Alpha 3 AM115 AM117
Element: Asset Process This field identifies whether the asset AM125 AM135
record is in the process of being AM145 AM15.1
adjusted, disposed of, or transferred. AM15.2 AM15.3
Valid values are: AM15.4 AM154
AM170 AM192
ADJ = Adjustment AM20.1 AM20.2
DSP = Disposal AM20.3 AM20.4
TRF = Transfer AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
Blank = The asset is not being adjusted, AM30.1 AM30.2
disposed of, or transferred. AM40.1 AM41.1
RIN = Reinstate AM500 AM551
ADD AM96.1 AM98.1
AST-PROCESS-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: Process Date The last date an adjustment, disposal, AM125 AM135
or transfer was processed for the asset AM145 AM15.1
record. 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 AM30.2
AM40.1 AM41.1
AM500 AM551
AM96.1 AM98.1
AST-ASSET-CATEGORY Alpha 1 AM115 AM117
Element: Asset CategoryThis field identifies whether the asset AM15.1 AM15.2
is depreciable. Valid values are: AM15.3 AM15.4
AM170 AM20.1
D = Depreciable. AM20.2 AM20.3
N = Non-Depreciable. 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-SIMULATED Alpha 1 AM115 AM117
Element: Simulated This field identifies whether the asset AM125 AM15.1
is simulated, which means the asset is a AM15.2 AM15.3
representation, not a real asset. AM15.4 AM170
Simulated assets can be used to AM20.1 AM20.2
experiment and test strategies. Valid AM20.3 AM20.4
values are: AM20.5 AM20.6
Y = Yes AM21.1 AM21.2
N = No AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM551 AM96.1
AM98.1
AST-WORK-IN-PROC Alpha 1 AM115 AM117
Element: Work-in-ProcesThis field identifies whether the asset AM125 AM15.1
is considered work in process, which AM15.2 AM15.3
means the asset is real, but not yet AM15.4 AM170
complete. If this field is Yes, the AM20.1 AM20.2
asset is on hold and cannot be released. AM20.3 AM20.4
Valid values are: AM20.5 AM20.6
AM21.1 AM21.2
N = No. AM21.3 AM21.4
Y = Yes. AM21.5 AM21.6
AM30.1 AM500
AM551 AM96.1
AM98.1
AST-TAX-EXEMPT Alpha 1 AM115 AM117
Element: Tax Exempt This field identifies whether the asset AM125 AM15.1
is exempt from taxation. Valid values AM15.2 AM15.3
are: AM15.4 AM170
Y = Yes AM20.1 AM20.2
N = No 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-USED Alpha 1 AM115 AM117
Element: Used This field identifies whether the asset AM125 AM15.1
has already been used at the time it was AM15.2 AM15.3
purchased. Valid values are: AM15.4 AM170
AM20.1 AM20.2
N = No. AM20.3 AM20.4
Y = Yes. 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-ITEM-TOT-QTY Numeric 10 AM115 AM117
Element: Item Total QuaThe total number of items that make up AM135 AM15.1
this asset record. 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 AM30.2
AM40.1 AM40.2
AM500 AM51.1
AM551 AM96.1
AM97.1 AM98.1
AST-IT-TOT-CSTBASE Signed 18.2 AM115 AM117
Element: Item Total CosThe total cost of the asset items in AM135 AM15.1
company base currency. 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 AM30.2
AM40.1 AM40.2
AM500 AM51.1
AM551 AM96.1
AM97.1 AM98.1
AST-IT-TOT-TAXBASE Signed 18.2 AM115 AM117
Element: Item Total TaxThe total tax amount associated with AM135 AM15.1
the asset items in the company base AM15.2 AM15.3
currency. 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-CSTTRAN Signed 18.2 AM115 AM117
Element: Item Total CosThe total cost of the asset items in AM135 AM15.1
the currency of the transaction. 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 AM30.2
AM40.1 AM40.2
AM500 AM51.1
AM551 AM96.1
AM97.1 AM98.1
AST-IT-TOT-TAXTRAN Signed 18.2 AM115 AM117
Element: Item Total TaxThe total tax amount associated with AM135 AM15.1
the asset items in the currency of the AM15.2 AM15.3
transaction. 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-BASE-ND Numeric 1 AM115 AM117
Base Number of The number of decimal positions defined AM135 AM15.1
Decimals for the company base currency. 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-TRAN-ND Numeric 1 AM115 AM117
Tran Number of The number of decimal positions defined AM135 AM15.1
Decimals for the transaction currency. 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-CURRENCY-CODE Alpha 5 AM115 AM117
Element: Currency Code The transaction currency code assigned AM135 AM15.1
to the 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-ITEM-LAST-DATE Numeric 8 (yyyymmdd) AM115 AM117
Item Last Purchase The highest (latest) purchase date of AM135 AM15.1
Date all of the items that make up the 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
AM51.1 AM551
AM96.1 AM97.1
AM98.1
AST-ITEM-LAST-SEQ Numeric 6 AM115 AM117
Item Last Sequence The last sequence number assigned to an AM135 AM15.1
Number asset item for this asset record. AM15.2 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 AM117
Element: Company The general ledger company number AM125 AM135
associated with the asset record. Used AM15.1 AM15.2
for posting associated asset transaction AM15.3 AM15.4
entries to the general ledger. 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-LOCATION-NAME Alpha 15 AM115 AM117
Element: Location Name The location assigned to the asset. AM125 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 AM117
Element: Division The division assigned to the asset. AM125 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 AM117
Asset types are user-defined and AM125 AM135
represent a grouping of like assets. AM15.1 AM15.2
Asset types are used to group assets AM15.3 AM15.4
into reporting classes and to default AM154 AM170
common asset definition data. 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-SUB-TYPE Alpha 10 AM06.4 AM06.5
Element: Asset Subtype This field identifies the asset AM115 AM117
subtype. An asset subtype represents a AM125 AM135
more detailed grouping of assets within AM15.1 AM15.2
an asset type. Asset subtypes are used AM15.3 AM15.4
to group assets into reporting classes AM154 AM170
and allow common asset definition data AM20.1 AM20.2
to default. 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-ACCT-GRP Alpha 10 AM115 AM117
Element: Account Group This is the account group assigned to AM125 AM135
the asset. Account groups are AM15.1 AM15.2
user-defined and are used to identify AM15.3 AM15.4
the general ledger accounts used to AM154 AM170
create journal entries when assets are AM20.1 AM20.2
processed (added, adjusted, transferred, AM20.3 AM20.4
or disposed of). 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-UNIT Alpha 15 AM115 AM117
Element: Accounting UniThe default accounting unit that will AM125 AM135
be used, if necessary, to piece together AM15.1 AM15.2
with accounts from the Type, Subtype, AM15.3 AM15.4
and Account Group fields to make valid AM154 AM170
general ledger accounts. 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-AU-GROUP Alpha 10 AM115 AM117
Accounting Unit Accounting unit groups group and AM125 AM135
Group identify the accounting units to use AM15.1 AM15.2
when you create journal entries for AM15.3 AM15.4
adding, adjusting, transferring, or AM154 AM170
disposing of assets. Changes to AM20.1 AM20.2
accounting unit groups are dynamic, AM20.3 AM20.4
affecting all assets using the AM20.5 AM20.6
accounting unit group. Accounting unit AM21.1 AM21.2
group names are user-definable, and AM21.3 AM21.4
accounting unit groups are set up by AM21.5 AM21.6
company. AM30.1 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 AM117
Depreciation This is the override depreciation AM125 AM15.1
Expense Activity expense activity, which overrides any AM15.2 AM15.3
depreciation expense activity set up on AM15.4 AM170
AM06.1 (Type). This is the depreciation AM20.1 AM20.2
expense activity used for posting. 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 AM117
Depr Expense This is the override depreciation AM125 AM15.1
Account Category expense account category, which AM15.2 AM15.3
overrides any depreciation expense AM15.4 AM170
account category set up on AM06.1 AM20.1 AM20.2
(Type). This is the depreciation AM20.3 AM20.4
expense account category used for AM20.5 AM20.6
posting. AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM551
AM96.1 AM98.1
AST-ORIG-CO Numeric 4 AM115 AM117
Element: Original CompaThis field contains the original AM15.1 AM15.2
company number when the asset record is AM15.3 AM15.4
added to this file. This field is never AM170 AM20.1
changed after being added. 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 AM117
Last Process The last sequence number assigned to AM125 AM135
Sequence Number the last process created for the asset. AM145 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 AM117
Last Transaction The sequence number assigned to the AM118 AM125
Sequence Nbr last transaction created for the asset. 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 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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 AM117
Element: Creation Date The date the asset record was created. 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 AM40.1
AM500 AM551
AM96.1 AM98.1
AST-CREATION-TIME Numeric 6 (hhmmss) AM115 AM117
Element: Creation Time The time the asset record was created. 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 AM40.1
AM500 AM551
AM96.1 AM98.1
AST-CREATOR-ID Alpha 10 AM115 AM117
Element: Creator ID This field identifies the operator who AM135 AM15.1
created the asset record. 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-INV-FLAG Alpha 1 AM115 AM117
Element: Inv Flag **Field purpose AM15.1 AM15.2
You can indicate whether the asset AM15.3 AM15.4
should be included as part of the AM170 AM20.1
physical inventory. This value defaults AM20.2 AM20.3
from the asset type and can be AM20.4 AM20.5
overridden when the asset is created. If AM20.6 AM21.1
the asset is not part of the physical AM21.2 AM21.3
inventory, it will be ignored in the AM21.4 AM21.5
inventory reports. AM21.6 AM500
AM551 AM96.1
Valid values are: AM98.1
Y = Yes
N = No
AST-ASSET-OWNER Alpha 10 AM115 AM117
Element: Asset Owner This field contains the name of the AM15.1 AM15.2
person responsible for keeping track of AM15.3 AM15.4
the asset in invnetory. 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-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 AC03.7
AC10.3 AC145
AC17.5 AC18.4
AC191 AC203
AC217 AC218
AC41.1 AC41.4
AC42.1 AC46.1
AC52.1 AC520
AC54.1 AC540
AC92.2 AC92.4
AC92.6 ACAC.1
AM06.4 AM06.5
AM115 AM117
AM118 AM120
AM125 AM13.1
...
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
...
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 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
AM117 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
...
ASTSET3 STATUS KeyChange AC10.1 AC10.3
LOCATION-NAME AM07.1 AM07.2
DSP-ASSET AM07.3 AM115
ASSET AM117 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
AM35.1 AM45.1
AM500 AM52.1
...
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 AM117
DSP-ASSET AM12.1 AM125
ASSET AM135 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
...
ASTSET6 STATUS KeyChange, Subset AM145 AM25.3
COMPANY Where ASSET-GROUP != Spaces AM45.3 AM60.1
ASSET-GROUP AM90.1 AM90.2
DSP-ASSET AM90.4 AM90.5
ASSET AM91.1 AM91.2
AM91.4 AM91.5
AM95.2
ASTSET7 STATUS KeyChange AM145 AM25.3
COMPANY AM255 AM295
LOCATION-NAME AM35.3 AM45.3
DIVISION AM60.1 AM90.1
ASSET-TYPE AM90.2 AM90.4
SUB-TYPE AM90.5 AM91.1
DSP-ASSET AM91.2 AM91.4
ASSET 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 AM117 AM12.1
DSP-ASSET AM125 AM145
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 AM240
AM245 AM30.1
AM40.1 AM40.2
...
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
|