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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#TGL-OBJ-ID PKOBJ_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-BASERATETO_BASERATE | Signed 14.7 | — | AC131, AC190, AC197, AC198, AC40.4, AC41.4, AC45.4, AC540 +1 more |
#TGL-TO-BASE-AMTTO_BASE_AMT | Signed 18.2 | — | AC131, AC190, AC197, AC198, AC40.4, AC41.4, AC45.4, AC540 +1 more |
#TGL-TO-BASE-NDTO_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-BASERATEBASERATE | 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-AMTBASE_AMT | Signed 18.2 | — | AC131, AC190, AC197, AC198, AC40.4, AC41.4, AC45.4, AC540 +1 more |
#TGL-BASE-NDBASE_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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
TGLSET1 |
| 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)