Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACTRANSGL


                             ACTRANSGL FILE

UPDATED BY

AC131     AC145     AC190     AC197     AC198     AC300
AC310     AC40.4    AC41.4    AC45.1    AC540     BR41.1
BR41.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TGL-OBJ-ID             Numeric 12                                AC131   AC190
Element: Obj Id        This is the object identifier. It is      AC197   AC198
                       used to relate commitments or posted      AC40.4  AC41.4
                       transactions back to the originating      AC540   BR41.4
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

TGL-TO-BASERATE        Signed 14.7                               AC131   AC190
Element: Acct Rate                                               AC197   AC198
                                                                 AC40.4  AC41.4
                                                                 AC540   BR41.4

TGL-TO-BASE-AMT        Signed 18.2                               AC131   AC190
Element: Intl Amt                                                AC197   AC198
                                                                 AC40.4  AC41.4
                                                                 AC540   BR41.4

TGL-TO-BASE-ND         Numeric 1                                 AC131   AC190
Element: Acct Nd       The number of decimals assigned to a      AC197   AC198
                       particular account as determined by the   AC40.4  AC41.4
                       account currency.                         AC540   BR41.4


TGL-BASERATE           Signed 14.7                               AC131   AC190
Element: Baserate      Enter the exchange rate at the time the   AC197   AC198
                       journal entry was made.  If left blank,   AC40.4  AC41.4
                       the current exchange rate will default.   AC540   BR41.4

TGL-BASE-AMT           Signed 18.2                               AC131   AC190
Element: Intl Amt                                                AC197   AC198
                                                                 AC40.4  AC41.4
                                                                 AC540   BR41.4

TGL-BASE-ND            Numeric 1                                 AC131   AC190
Element: Base Nd       The number of decimal positions defined   AC197   AC198
                       for the company base currency.            AC40.4  AC41.4
                                                                 AC540   BR41.4

                         ACTRANSGL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TGLSET1   OBJ-ID                                                 AC145   AC197
                                                                 AC198   AC300
                                                                 AC310   AC40.4
                                                                 AC41.4  AC45.1
                                                                 AC45.4  BR41.1
                                                                 BR41.4