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

AM115     AM117     AM125     AM135     AM145     AM15.1
AM15.2    AM15.3    AM15.4    AM154     AM170     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     AM551     AM92.1    AM96.1    AM98.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

ABK-BOOK               Alpha 10                                  AM115   AM117
Element: Book          The book associated with the asset        AM125   AM135
                       transaction. Books are used by assets     AM145   AM15.1
                       for calculating depreciation,             AM15.2  AM15.3
                       replacement cost, and insurance values,   AM15.4  AM154
                       and for reporting.                        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

ABK-COMPANY            Numeric 4                                 AM115   AM117
Element: Company       The general ledger company number         AM125   AM135
                       associated with the book and asset.       AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 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

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

ABK-SEQ-NUMBER         Numeric 6                                 AM115   AM117
Record Sequence        A unique number assigned to the asset     AM125   AM135
Number                 transaction to keep records unique.       AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   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

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

ABK-TRAN-ND            Numeric 1                                 AM115   AM117
Account Currency       The number of decimal positions defined   AM125   AM135
Code                   for the book currency.                    AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 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

ABK-TRANS-DATE         Numeric 8  (yyyymmdd)                     AM115   AM117
Element: Transaction DaThe date of the transaction.              AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 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

ABK-PROCESS-DATE       Numeric 8  (yyyymmdd)                     AM115   AM117
Element: Date                                                    AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   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

ABK-REFERENCE          Alpha 10  (Lower Case)                    AM115   AM117
Element: Reference     The program number that created the       AM125   AM135
                       transaction.                              AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 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

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

ABK-ACCT-UNIT          Alpha 15                                  AM115   AM117
Element: Accounting UniThe accounting unit used to post the      AM125   AM135
                       transaction to the general ledger.        AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 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

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

ABK-SUB-ACCT           Numeric 4                                 AM115   AM117
Element: Subaccount    The subaccount used to post the           AM125   AM135
                       transaction to the general ledger.        AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 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

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

ABK-ATN-OBJ-ID         Numeric 12
Object                 The object ID used for Driall Around
Identification         operations.

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

ABK-ACCT-CATEGORY      Alpha 5                                   AM115   AM117
Element: Account CategoThe account category assigned to the      AM125   AM135
                       asset transaction.                        AM145   AM15.1
                                                                 AM15.2  AM15.3
                       Account categories are groupings of       AM15.4  AM154
                       costs, revenues, or a combination of      AM190   AM192
                       both used for reporting and inquiries     AM20.1  AM20.2
                       for activities in the Lawson Activity     AM20.4  AM21.1
                       Management system. All transactions are   AM21.2  AM21.4
                       posted to an account category within an   AM30.1  AM30.2
                       activity.                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM502   AM551
                                                                 AM92.1  AM98.1

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

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

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

                         AMBKTRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

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

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

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

ABKSET5   ASSET         KeyChange
          BOOK
          COMPANY
          SEQ-NUMBER*
          TRANS-STATUS

ABKSET6   TRANS-STATUS                                           AM135
          ASSET-PROCESS
          ASSET
          BOOK
          SEQ-NUMBER

                         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