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 AC210 AC217 AC218
AC41.1 AC41.4 AC42.1 AC46.1 AC460 AC52.1
AC520 AC54.1 AC540 AC69.2 AC92.2 AC92.4
AC92.6 ACAC.1 AM01.1 AM01.2 AM01.3 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 AM258 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 AP520 BR40.3
BR43.1 BR46.1 ET530 ET540 IC130 MX500
MA310 MA540 PO135 PO136 PO190 PO26.1
RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500
RQIB.1 RQID.1 RQIF.1 RQIJ.1 WH130 WH132
WH190 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 MX202
MX223 AM213 AM05.1 AM09.1 AM12.1 AM17.1
AM180 AM185 AM266 AM282 AM60.1 AC56.1
AC560 AC71.1 AM07.1 AM07.2 AM07.3 AM08.1
AM08.2 AM195
UPDATED BY
AC160 AM115 AM117 AM118 AM125 AM135
AM145 AM15.1 AM15.2 AM15.3 AM15.4 AM154
AM170 AM18.1 AM18.2 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 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 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 AM330
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AST-ASSET Numeric 10 AC160 AM115
Element: Asset The asset number contains up to ten AM117 AM135
numeric characters that uniquely AM15.1 AM15.2
identify an asset. Assets are AM15.3 AM15.4
automatically numbered system-wide. AM154 AM170
AM19.1 AM19.2
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
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
...
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) AC160 AM115
Element: Description A description of the asset. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM170
AM19.1 AM19.2
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 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
...
AST-CLASSIFICATION Alpha 1 AC160 AM115
Element: ClassificationThis field contains the asset's AM117 AM125
classification. Capital and Operating AM135 AM15.1
refer to leased assets; Purchased refers AM15.2 AM15.3
to non-leased assets. Valid values are: AM15.4 AM154
P = Purchased AM170 AM19.1
C = Capital AM19.2 AM20.1
O = Operating AM20.2 AM20.3
AM20.4 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 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
...
AST-LEASE-COMPANY Numeric 4 AC160 AM115
Element: Company The lessor company for the leased asset. AM117 AM135
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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
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
...
AST-LEASE Alpha 19 AC160 AM115
Element: Lease The lease number associated with a AM117 AM135
leased asset. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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
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
...
AST-TAG-NBR Alpha 12 AC160 AM115
Element: Tag Number The tag is a user definable identifier AM117 AM125
assigned to an asset. AM135 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM19.1
AM19.2 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 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
...
AST-ASSET-GROUP Alpha 10 AC160 AM115
Element: Asset Group The asset group assigned to the asset. AM117 AM125
Represents a parent asset number used AM135 AM15.1
for report grouping. AM15.2 AM15.3
AM15.4 AM154
AM170 AM19.1
AM19.2 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 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
...
AST-OBJ-ID Numeric 12 AC160 AM115
Element: Object ID The object identifier is a unique key AM117 AM135
used to attach a list of user-defined AM15.1 AM15.2
attributes for the asset. AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 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
...
AST-STATUS Numeric 1 AC160 AM115
Element: Status This field identifies the transaction AM117 AM125
status of the asset record. Valid values AM135 AM145
are: AM15.1 AM15.2
AM15.3 AM15.4
1 = Entered. AM154 AM170
2 = Active (updated). AM19.1 AM19.2
3 = Post Active Process. AM192 AM20.1
9 = Disposed. 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 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
...
AST-ASSET-PROCESS Alpha 3 AC160 AM115
Element: Asset Process This field identifies whether the asset AM117 AM125
record is in the process of being AM135 AM145
adjusted, disposed of, or transferred. AM15.1 AM15.2
Valid values are: AM15.3 AM15.4
AM154 AM170
ADJ = Adjustment AM19.1 AM19.2
DSP = Disposal AM192 AM20.1
TRF = Transfer AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
Blank = The asset is not being adjusted, AM21.4 AM21.5
disposed of, or transferred. AM21.6 AM30.1
RIN = Reinstate AM30.2 AM40.1
ADD AM41.1 AM500
AM551 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
...
AST-PROCESS-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Process Date The last date an adjustment, disposal, AM117 AM125
or transfer was processed for the asset AM135 AM145
record. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 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
...
AST-ASSET-CATEGORY Alpha 1 AC160 AM115
Element: Asset CategoryThis field identifies whether the asset AM117 AM15.1
is depreciable. Valid values are: AM15.2 AM15.3
AM15.4 AM170
D = Depreciable. AM19.1 AM19.2
N = Non-Depreciable. 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 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
...
AST-SIMULATED Alpha 1 AC160 AM115
Element: Simulated This field identifies whether the asset AM117 AM125
is simulated, which means the asset is a AM15.1 AM15.2
representation, not a real asset. AM15.3 AM15.4
Simulated assets can be used to AM170 AM19.1
experiment and test strategies. Valid AM19.2 AM20.1
values are: AM20.2 AM20.3
Y = Yes AM20.4 AM20.5
N = No AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM500 AM551
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
...
AST-WORK-IN-PROC Alpha 1 AC160 AM115
Element: Work-in-ProcesThis field identifies whether the asset AM117 AM125
is considered work in process, which AM15.1 AM15.2
means the asset is real, but not yet AM15.3 AM15.4
complete. If this field is Yes, the AM170 AM19.1
asset is on hold and cannot be released. AM19.2 AM20.1
Valid values are: AM20.2 AM20.3
AM20.4 AM20.5
N = No. AM20.6 AM21.1
Y = Yes. AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM500 AM551
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
...
AST-TAX-EXEMPT Alpha 1 AC160 AM115
Element: Tax Exempt This field identifies whether the asset AM117 AM125
is exempt from taxation. Valid values AM15.1 AM15.2
are: AM15.3 AM15.4
Y = Yes AM170 AM19.1
N = No AM19.2 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
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
...
AST-USED Alpha 1 AC160 AM115
Element: Used This field identifies whether the asset AM117 AM125
has already been used at the time it was AM15.1 AM15.2
purchased. Valid values are: AM15.3 AM15.4
AM170 AM19.1
N = No. AM19.2 AM20.1
Y = Yes. 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
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
...
AST-ITEM-TOT-QTY Numeric 10 AC160 AM115
Element: Item Total QuaThe total number of items that make up AM117 AM135
this asset record. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 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
...
AST-IT-TOT-CSTBASE Signed 18.2 AC160 AM115
Element: Item Total CosThe total cost of the asset items in AM117 AM135
company base currency. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 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
...
AST-IT-TOT-TAXBASE Signed 18.2 AC160 AM115
Element: Item Total TaxThe total tax amount associated with AM117 AM135
the asset items in the company base AM15.1 AM15.2
currency. AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 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
...
AST-IT-TOT-CSTTRAN Signed 18.2 AC160 AM115
Element: Item Total CosThe total cost of the asset items in AM117 AM135
the currency of the transaction. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 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
...
AST-IT-TOT-TAXTRAN Signed 18.2 AC160 AM115
Element: Item Total TaxThe total tax amount associated with AM117 AM135
the asset items in the currency of the AM15.1 AM15.2
transaction. AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 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
...
AST-BASE-ND Numeric 1 AC160 AM115
Base Number of The number of decimal positions defined AM117 AM135
Decimals for the company base currency. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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
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
...
AST-TRAN-ND Numeric 1 AC160 AM115
Tran Number of The number of decimals assigned to a AM117 AM135
Decimals particular account as determined by the AM15.1 AM15.2
account currency. AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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
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
...
AST-CURRENCY-CODE Alpha 5 AC160 AM115
Element: Currency Code The transaction currency code assigned AM117 AM135
to the asset. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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
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
...
AST-ITEM-LAST-DATE Numeric 8 (yyyymmdd) AC160 AM115
Item Last Purchase The highest (latest) purchase date of AM117 AM135
Date all of the items that make up the asset. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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
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
...
AST-ITEM-LAST-SEQ Numeric 6 AC160 AM115
Item Last Sequence The last sequence number assigned to an AM117 AM135
Number asset item for this asset record. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM19.1
AM19.2 AM192
AM20.1 AM20.3
AM21.1 AM21.3
AM30.1 AM30.2
AM500 AM51.1
AM551 AM97.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
...
AST-COMPANY Numeric 4 AC160 AM115
Element: Company The general ledger company number AM117 AM125
associated with the asset record. Used AM135 AM15.1
for posting associated asset transaction AM15.2 AM15.3
entries to the general ledger. AM15.4 AM154
AM170 AM19.1
AM19.2 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 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
...
AST-LOCATION-NAME Alpha 15 AC160 AM115
Element: Location Name The location assigned to the asset. AM117 AM125
AM135 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM19.1
AM19.2 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 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
...
AST-DIVISION Alpha 15 AC160 AM115
Element: Division The division assigned to the asset. AM117 AM125
AM135 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM19.1
AM19.2 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 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
...
AST-ASSET-TYPE Alpha 10 AC160 AM06.4
Element: Asset Type This field identifies the asset type. AM06.5 AM115
Asset types are user-defined and AM117 AM125
represent a grouping of like assets. AM135 AM15.1
Asset types are used to group assets AM15.2 AM15.3
into reporting classes and to default AM15.4 AM154
common asset definition data. AM170 AM19.1
AM19.2 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 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
...
AST-SUB-TYPE Alpha 10 AC160 AM06.4
Element: Asset Subtype This field identifies the asset AM06.5 AM115
subtype. An asset subtype represents a AM117 AM125
more detailed grouping of assets within AM135 AM15.1
an asset type. Asset subtypes are used AM15.2 AM15.3
to group assets into reporting classes AM15.4 AM154
and allow common asset definition data AM170 AM19.1
to default. AM19.2 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 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
...
AST-ACCT-GRP Alpha 10 AC160 AM115
Element: Account Group This is the account group assigned to AM117 AM125
the asset. Account groups are AM135 AM15.1
user-defined and are used to identify AM15.2 AM15.3
the general ledger accounts used to AM15.4 AM154
create journal entries when assets are AM170 AM19.1
processed (added, adjusted, transferred, AM19.2 AM20.1
or disposed of). 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 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
...
AST-ACCT-UNIT Alpha 15 AC160 AM115
Element: Accounting UniThe default accounting unit that will AM117 AM125
be used, if necessary, to piece together AM135 AM15.1
with accounts from the Type, Subtype, AM15.2 AM15.3
and Account Group fields to make valid AM15.4 AM154
general ledger accounts. AM170 AM19.1
AM19.2 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 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
...
AST-AU-GROUP Alpha 10 AC160 AM115
Accounting Unit Accounting unit groups group and AM117 AM125
Group identify the accounting units to use AM135 AM15.1
when you create journal entries for AM15.2 AM15.3
adding, adjusting, transferring, or AM15.4 AM154
disposing of assets. Changes to AM170 AM19.1
accounting unit groups are dynamic, AM19.2 AM20.1
affecting all assets using the AM20.2 AM20.3
accounting unit group. Accounting unit AM20.4 AM20.5
group names are user-definable, and AM20.6 AM21.1
accounting unit groups are set up by AM21.2 AM21.3
company. AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM500
AM551 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
...
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 AC160 AM115
Depreciation Activities are the processes or AM117 AM125
Expense Activity procedures that produce work. Cost AM15.1 AM15.2
objects (products, services, customers, AM15.3 AM15.4
and so on) are the reasons for AM170 AM19.1
performing the activity. AM19.2 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 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
...
AST-DEP-ACCT-CAT Alpha 5 AC160 AM115
Depr Expense Account categories are groupings of AM117 AM125
Account Category costs, revenues, or a combination of AM15.1 AM15.2
both used for reporting and inquiries AM15.3 AM15.4
for activities in the Activity AM170 AM19.1
Management system. All transactions are AM19.2 AM20.1
posted to an account category within an AM20.2 AM20.3
activity. You can assign a specific AM20.4 AM20.5
General Ledger account or range of AM20.6 AM21.1
accounts (company, accounting unit, AM21.2 AM21.3
account, and subaccount) that make up AM21.4 AM21.5
the transactions posted to an account AM21.6 AM500
category using AC07.1 (Account AM551 AM96.1
Assignment). AM98.1 AP115
AP125 AP126
Period-to-date, year-to-date, and AP131 AP20.1
life-to-date balances are maintained by AP20.2 AP20.3
account category for activities. Account AP20.4 AP20.5
categories must be assigned to AP20.7 AP21.1
activities before you do any budgeting AP220 AP23.1
or transaction processing. AP25.1 AP25.2
AP26.1 AP27.1
Valid account category types are: AP30.2 AP30.4
cost AP305 API1.1
revenue API2.1 BL120
accrual BL122 BL130
pass thru BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
AST-ORIG-CO Numeric 4 AC160 AM115
Element: Original CompaIdentifies the AP company if the AM117 AM15.1
resource type = V. Identifies the HR AM15.2 AM15.3
company if the resource type = E. It is AM15.4 AM170
blank for type A, P or Q resources. AM19.1 AM19.2
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 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
...
AST-ASSET-LAST-SEQ Numeric 6 AC160 AM115
Last Process The last sequence number assigned to AM117 AM118
Sequence Number the last process created for the asset. AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM18.1
AM18.2 AM19.1
AM19.2 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
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
...
AST-TRAN-LAST-SEQ Numeric 6
Last Transaction The sequence number assigned to the
Sequence Nbr last transaction created for the asset.
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) AC160 AM115
Element: Creation Date The date the asset record was created. AM117 AM135
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 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
...
AST-CREATION-TIME Numeric 6 (hhmmss) AC160 AM115
Element: Creation Time The time the asset record was created. AM117 AM135
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 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
...
AST-CREATOR-ID Alpha 10 AC160 AM115
Element: Creator ID This field identifies the operator who AM117 AM135
created the asset record. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 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
...
AST-INV-FLAG Alpha 1 AC160 AM115
Element: Inv Flag **Field purpose AM117 AM15.1
You can indicate whether the asset AM15.2 AM15.3
should be included as part of the AM15.4 AM170
physical inventory. This value defaults AM19.1 AM19.2
from the asset type and can be AM20.1 AM20.2
overridden when the asset is created. If AM20.3 AM20.4
the asset is not part of the physical AM20.5 AM20.6
inventory, it will be ignored in the AM21.1 AM21.2
inventory reports. AM21.3 AM21.4
AM21.5 AM21.6
Valid values are: AM500 AM551
Y = Yes AM96.1 AM98.1
N = No 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
...
AST-ASSET-OWNER Alpha 10 AC160 AM115
Element: Asset Owner This field contains the name of the AM117 AM15.1
person responsible for keeping track of AM15.2 AM15.3
the asset in invnetory. AM15.4 AM170
AM19.1 AM19.2
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
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
...
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
AC160 AC17.5
AC18.4 AC191
AC203 AC210
AC217 AC218
AC41.1 AC41.4
AC42.1 AC46.1
AC460 AC52.1
AC520 AC54.1
AC540 AC69.2
AC92.2 AC92.4
AC92.6 ACAC.1
AM01.1 AM01.2
AM01.3 AM06.4
...
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 KeyChange 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 AC160 AM01.1
ASSET AM01.2 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
AM17.1 AM170
AM180 AM185
AM19.1 AM19.2
AM190 AM192
...
ASTSET3 STATUS KeyChange AC10.1 AC10.3
LOCATION-NAME AC160 AC56.1
DSP-ASSET AC560 AC71.1
ASSET AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM15.1 AM15.2
AM15.3 AM15.4
AM17.1 AM170
AM19.1 AM19.2
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
...
ASTSET4 STATUS KeyChange AC10.1 AC10.3
DIVISION AC160 AC56.1
DSP-ASSET AC560 AC71.1
ASSET AM08.1 AM08.2
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
...
ASTSET5 STATUS KeyChange AC160 AM05.1
COMPANY AM06.1 AM06.2
ASSET-TYPE AM06.3 AM06.5
SUB-TYPE AM09.1 AM115
DSP-ASSET AM117 AM12.1
ASSET AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
...
ASTSET6 STATUS KeyChange, Subset AM145 AM25.3
COMPANY Where ASSET-GROUP != Spaces AM45.3 AM60.1
ASSET-GROUP AM70.1 AM70.2
DSP-ASSET AM90.1 AM90.2
ASSET 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.3 AM60.1
ASSET-TYPE AM70.2 AM90.1
SUB-TYPE AM90.2 AM90.4
DSP-ASSET AM90.5 AM91.1
ASSET 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 AC160 AM05.1
COMPANY AM115 AM117
DSP-ASSET AM12.1 AM125
ASSET AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM19.1
AM19.2 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
...
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
|