ACTRANSGL – No description in the Lawson data dictionary

System: Activity Management (AC)
Prefix: TGL
Primary key: OBJ-ID
Fields: 7
Updated by: 15 programs
Referenced by: 0 programs

ACTRANSGL is a Lawson Activity Management table (prefix TGL); no description in the lawson data dictionary. It is indexed by OBJ-ID (TGLSET1). It is updated by AC131, AC145, AC190, AC197, AC198, AC300, AC310, AC311 and 7 more. The table has 7 fields, 1 index and 0 documented relations.

About ACTRANSGL

No description in the Lawson data dictionary.

Fields (7)

Column = COBOL field name without the TGL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`TGL-OBJ-ID` PK OBJ_ID	Numeric 12	This is the object identifier. It is 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.	AC131, AC190, AC197, AC198, AC40.4, AC41.4, AC45.4, AC540 +1 more
`TGL-TO-BASERATE` TO_BASERATE	Signed 14.7	—	AC131, AC190, AC197, AC198, AC40.4, AC41.4, AC45.4, AC540 +1 more
`TGL-TO-BASE-AMT` TO_BASE_AMT	Signed 18.2	—	AC131, AC190, AC197, AC198, AC40.4, AC41.4, AC45.4, AC540 +1 more
`TGL-TO-BASE-ND` TO_BASE_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	AC131, AC190, AC197, AC198, AC40.4, AC41.4, AC45.4, AC540 +1 more
`TGL-BASERATE` BASERATE	Signed 14.7	Enter the exchange rate at the time the journal entry was made. If left blank, the current exchange rate will default.	AC131, AC190, AC197, AC198, AC40.4, AC41.4, AC45.4, AC540 +1 more
`TGL-BASE-AMT` BASE_AMT	Signed 18.2	—	AC131, AC190, AC197, AC198, AC40.4, AC41.4, AC45.4, AC540 +1 more
`TGL-BASE-ND` BASE_ND	Numeric 1	The number of decimal positions defined for the company base currency.	AC131, AC190, AC197, AC198, AC40.4, AC41.4, AC45.4, AC540 +1 more

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`TGLSET1`	`OBJ-ID`	Primary		AC145, AC197, AC198, AC300, AC310, AC311, AC40.4, AC41.4 +4 more

Programs

Updated by (15)

AC131 Allocation Update
AC145 Mass Transaction Backout
AC190 Activity Posting
AC197 Burden Recalculation Based on Total Cost
AC198 Burden Rate Recalculation
AC300 Activity Group Purge
AC310 Transaction Consolidation
AC311 Purge and Archive
AC40.4 Journal Entry (AC and GL)
AC41.4 Resource Time Entry (AC and GL)
AC45.1 Transaction Edit
AC45.4 Control Group Release
AC540 Transaction Interface
BR41.1 Contract Adjustment (AC only)
BR41.4 Contract Adjustment (AC and GL)