Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACTRANSGL


                             ACTRANSGL FILE

REFERENCED BY

AC45.1    AC45.4

UPDATED BY

AC300     AC40.4    AC41.4    BR41.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TGL-OBJ-ID             Numeric 12                                AC40.4  AC41.4
Object                 This is the object identifier. It is      BR41.4
Identification         used to relate commitments or posted
                       transactions back to the originating
                       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                               AC40.4  AC41.4
Element: Account Rate                                            BR41.4

TGL-TO-BASE-AMT        Signed 18.2                               AC40.4  AC41.4
Element: Intl Amt                                                BR41.4

TGL-TO-BASE-ND         Numeric 1                                 AC40.4  AC41.4
Account Currency                                                 BR41.4
Code

TGL-BASERATE           Signed 14.7                               AC40.4  AC41.4
Element: Exchange Rate Enter the exchange rate at the time the   BR41.4
                       journal entry was made.  If left blank,
                       the current exchange rate will default.

TGL-BASE-AMT           Signed 18.2                               AC40.4  AC41.4
Element: Intl Amt      This is the amount of the transaction in  BR41.4
                       the company base amount.

TGL-BASE-ND            Numeric 1                                 AC40.4  AC41.4
Base Number Of         The number of decimal positions defined   BR41.4
Decimals               for the company base currency.

                         ACTRANSGL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TGLSET1   OBJ-ID                                                 AC300   AC40.4
                                                                 AC41.4  AC45.1
                                                                 AC45.4  BR41.4