Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMBKTRANS


                             AMBKTRANS FILE

                        Asset Book Transactions

The Asset Book Transaction file stores a copy of each transaction
transactions for each asset and each book.

REFERENCED BY

AM320     AM80.1    AM80.2    AM85.1    AM85.2    AM270
AM75.1    AM75.2    AM275     AM277

UPDATED BY

AC160     AM115     AM117     AM125     AM135     AM145
AM15.1    AM15.2    AM15.3    AM15.4    AM154     AM170
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     AM330     AM40.1    AM40.2    AM40.3
AM40.4    AM41.1    AM41.2    AM500     AM502     AM520
AM551     AM92.1    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    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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ABK-ASSET              Numeric 10                                AC160   AM115
Element: Asset         The asset number associated with the      AM117   AM125
                       asset transaction.                        AM135   AM145
                                                                 AM15.1  AM15.2
                       The asset number contains up to ten       AM15.3  AM15.4
                       numeric characters that uniquely          AM154   AM19.1
                       identify an asset. Assets are             AM19.2  AM190
                       automatically numbered system-wide.       AM192   AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM21.1  AM21.2
                                                                 AM21.4  AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM92.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
                                                                 ...

ABK-BOOK               Alpha 10                                  AC160   AM115
Element: Book          The book associated with the asset        AM117   AM125
                       transaction. Books are used by assets     AM135   AM145
                       for calculating depreciation,             AM15.1  AM15.2
                       replacement cost, and insurance values,   AM15.3  AM15.4
                       and for reporting.                        AM154   AM19.1
                                                                 AM19.2  AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM21.1  AM21.2
                                                                 AM21.4  AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM520   AM551
                                                                 AM92.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
                                                                 ...

ABK-COMPANY            Numeric 4                                 AC160   AM115
Element: Company       The general ledger company number         AM117   AM125
                       associated with the book and asset.       AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM19.1
                                                                 AM19.2  AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM21.1  AM21.2
                                                                 AM21.4  AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM92.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
                                                                 ...

ABK-TRANS-STATUS       Alpha 1                                   AC160   AM115
Element: Trans Status  This field identifies the status of the   AM117   AM125
                       asset transaction. The status can be:     AM135   AM145
                       U = Unreleased                            AM15.1  AM15.2
                       R = Released                              AM15.3  AM15.4
                       H = Historical                            AM154   AM170
                                                                 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  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM502   AM551
                                                                 AM92.1  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
                                                                 ...

ABK-SEQ-NUMBER         Numeric 6                                 AC160   AM115
Element: Seq Number    A unique number assigned to the asset     AM117   AM125
                       transaction to keep records unique.       AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 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  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM502   AM551
                                                                 AM92.1  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
                                                                 ...

ABK-TRAN-AMOUNT        Signed 18.2                               AC160   AM115
Element: Intl Amt      The amount of the asset transaction in    AM117   AM125
                       book currency.                            AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 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  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM502   AM551
                                                                 AM92.1  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
                                                                 ...

ABK-TRAN-ND            Numeric 1                                 AC160   AM115
Element: Acct Nd       The number of decimal positions defined   AM117   AM125
                       for the book currency.                    AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM19.1
                                                                 AM19.2  AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM21.1  AM21.2
                                                                 AM21.4  AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM92.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
                                                                 ...

ABK-TRANS-DATE         Numeric 8  (yyyymmdd)                     AC160   AM115
Element: Trans Date    The date of the transaction.              AM117   AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM19.1
                                                                 AM19.2  AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM21.1  AM21.2
                                                                 AM21.4  AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM41.1  AM500
                                                                 AM502   AM551
                                                                 AM92.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
                                                                 ...

ABK-PROCESS-DATE       Numeric 8  (yyyymmdd)                     AC160   AM115
Element: Date          This field displays the system date       AM117   AM125
                       when this was created.                    AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 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  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM502   AM551
                                                                 AM92.1  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
                                                                 ...

ABK-REFERENCE          Alpha 10  (Lower Case)                    AC160   AM115
Element: Reference     The program number that created the       AM117   AM125
                       transaction.                              AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM19.1
                                                                 AM19.2  AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM21.1  AM21.2
                                                                 AM21.4  AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM41.1  AM500
                                                                 AM502   AM551
                                                                 AM92.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
                                                                 ...

ABK-ACC-TYPE           Alpha 3                                   AC160   AM115
Element: Acc Type      For posting books, this field contains    AM117   AM125
                       the type of account to which the          AM135   AM145
                       transaction will be posted. Values are:   AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                       AST = Asset                               AM154   AM170
                       ACM = Accumulated Depreciation            AM19.1  AM19.2
                       EXP = Depreciation Expense                AM190   AM192
                       PRO = Proceeds                            AM20.1  AM20.2
                       GAN = Gain                                AM20.3  AM20.4
                       LOS = Loss                                AM20.5  AM20.6
                       CLR = Clearing                            AM21.1  AM21.2
                       COS = Disposal Expense                    AM21.3  AM21.4
                       DGN = Deferred Gain                       AM21.5  AM21.6
                       DLS = Deferred Loss                       AM30.1  AM30.2
                                                                 AM30.3  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM502   AM551
                                                                 AM92.1  AM96.1
                                                                 AM98.1  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
                                                                 ...

ABK-ACCT-UNIT          Alpha 15                                  AC160   AM115
Element: Acct Unit     The accounting unit used to post the      AM117   AM125
                       transaction to the general ledger.        AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 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  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM502   AM551
                                                                 AM92.1  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
                                                                 ...

ABK-ACCOUNT            Numeric 6                                 AC160   AM115
Element: Account       The account used to post the transaction  AM117   AM125
                       to the general ledger.                    AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 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  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM502   AM551
                                                                 AM92.1  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
                                                                 ...

ABK-SUB-ACCT           Numeric 4                                 AC160   AM115
Element: Sub Acct      The subaccount used to post the           AM117   AM125
                       transaction to the general ledger.        AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 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  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM502   AM551
                                                                 AM92.1  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
                                                                 ...

ABK-ASSET-PROCESS      Alpha 3                                   AC160   AM115
Element: Asset Process This field identifies the Asset           AM117   AM125
                       Management process that caused this       AM135   AM145
                       record to be created. Valid values are:   AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                       ADD = Addition                            AM154   AM19.1
                       ADJ = Adjustment                          AM19.2  AM190
                       DPR = Depreciation                        AM192   AM20.1
                       DSP = Disposal                            AM20.2  AM20.4
                       TRF = Transfer                            AM21.1  AM21.2
                       RIN = Reinstate                           AM21.4  AM30.1
                       RAD = Readd                               AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM41.1  AM500
                                                                 AM502   AM551
                                                                 AM92.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
                                                                 ...

ABK-ATN-OBJ-ID         Numeric 12
Element: Obj Id        The object ID used for Driall Around
                       operations.

ABK-ACTIVITY           Alpha 15                                  AC160   AM115
Element: Activity      The activity assigned to the asset        AM117   AM125
                       transaction.                              AM135   AM145
                                                                 AM15.1  AM15.2
                       Activities are the processes or           AM15.3  AM15.4
                       procedures that produce work. Cost        AM154   AM170
                       objects (products, services, customers,   AM19.1  AM19.2
                       and so on) are the reasons for            AM190   AM192
                       performing the activity. Activities and   AM20.1  AM20.2
                       cost object activities are used           AM20.3  AM20.4
                       synonymously in the Lawson Activity       AM20.5  AM20.6
                       Management system.                        AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM30.1  AM30.2
                                                                 AM30.3  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM502   AM551
                                                                 AM92.1  AM96.1
                                                                 AM98.1  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
                                                                 ...

ABK-ACCT-CATEGORY      Alpha 5                                   AC160   AM115
Element: Acct Category The account category assigned to the      AM117   AM125
                       asset transaction.                        AM135   AM145
                                                                 AM15.1  AM15.2
                       Account categories are groupings of       AM15.3  AM15.4
                       costs, revenues, or a combination of      AM154   AM170
                       both used for reporting and inquiries     AM19.1  AM19.2
                       for activities in the Lawson Activity     AM190   AM192
                       Management system. All transactions are   AM20.1  AM20.2
                       posted to an account category within an   AM20.3  AM20.4
                       activity.                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM30.1  AM30.2
                                                                 AM30.3  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM502   AM551
                                                                 AM92.1  AM96.1
                                                                 AM98.1  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
                                                                 ...

ABK-CREATION-DATE      Numeric 8  (yyyymmdd)                     AC160   AM115
Element: Creation Date The record's creation date.               AM117   AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 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  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM502   AM551
                                                                 AM92.1  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
                                                                 ...

ABK-CREATION-TIME      Numeric 6  (hhmmss)                       AC160   AM115
Element: Creation Time The record's creation time.               AM117   AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 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  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM502   AM551
                                                                 AM92.1  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
                                                                 ...

ABK-CREATOR-ID         Alpha 10                                  AC160   AM115
Element: Operator      The user that created the record.         AM117   AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 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  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM502   AM551
                                                                 AM92.1  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
                                                                 ...

                         AMBKTRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ABKSET1   ASSET                                                  AC160   AM115
          BOOK                                                   AM117   AM125
          COMPANY                                                AM135   AM145
          TRANS-STATUS                                           AM15.1  AM15.2
          SEQ-NUMBER                                             AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 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
                                                                 ...

ABKSET2   COMPANY       KeyChange                                AM270   AM300
          ACCT-UNIT                                              AM75.1  AM75.2
          ACCOUNT
          SUB-ACCT
          TRANS-DATE
          BOOK
          ASSET
          SEQ-NUMBER

ABKSET3   COMPANY       KeyChange                                AC160   AM115
          TRANS-STATUS                                           AM117   AM125
          ASSET-PROCESS                                          AM135   AM145
          BOOK                                                   AM15.1  AM15.2
          ASSET                                                  AM15.3  AM15.4
          SEQ-NUMBER                                             AM154   AM170
                                                                 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
                                                                 AM275   AM277
                                                                 ...

ABKSET4   COMPANY       KeyChange                                AM85.1  AM85.2
          TRANS-STATUS
          ACTIVITY
          ACCT-CATEGORY
          BOOK
          ASSET
          SEQ-NUMBER

ABKSET5   ASSET         KeyChange                                AC160   AM115
          SEQ-NUMBER*                                            AM117   AM125
          COMPANY                                                AM135   AM145
          BOOK                                                   AM15.1  AM15.2
          TRANS-STATUS                                           AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 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
                                                                 ...

ABKSET6   TRANS-STATUS                                           AC160   AM115
          ASSET-PROCESS                                          AM117   AM135
          ASSET                                                  AM15.1  AM15.2
          BOOK                                                   AM15.3  AM15.4
          SEQ-NUMBER                                             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
                                                                 ...

                         AMBKTRANS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amasset        AMASSET      Required

                            ABK-ASSET      -> AST-ASSET

Ambook         AMBOOK       Required

                            ABK-BOOK       -> AMB-BOOK

                         AMBKTRANS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ambkhistx      AMBKHISTX

                            ABK-ASSET      -> ABX-ASSET
                            ABK-BOOK       -> ABX-BOOK
                            ABK-COMPANY    -> ABX-COMPANY
                                              ABX-YR-END-DATE
                                              ABX-PERIOD