Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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