ACCATRANS – AC Allocation Transaction
- System
- Activity Management (AC)
- Prefix
TRN- Primary key
ALLOC-GROUP,STEP,ALLOC-NAME,LINE-NBR,ACTIVITY,ACCT-CATEGORY,FISCAL-YEAR,PERIOD,SEQ-NUMBER- Fields
- 45
- Updated by
- 8 programs
- Referenced by
- 1 program
ACCATRANS is the AC Allocation Transaction table in Lawson Activity Management (prefix TRN). It is indexed by ALLOC-GROUP, STEP, ALLOC-NAME, LINE-NBR, ACTIVITY, ACCT-CATEGORY, FISCAL-YEAR, PERIOD, SEQ-NUMBER (TRNSET1); alternate indexes: TRNSET2 and TRNSET3. It is related 1:1 to ACACCTCAT, ACACTGRP, ACACTIVITY, ACALLOC, ACALLOCGP and GLSYSTEM and 1:M to ACALPRDAMT. It is updated by AC120, AC130, AC131, AC30.1, AC30.2, AC30.3, AC300 and AC32.1 and referenced by AC10.1. The table has 45 fields, 3 indexes and 7 documented relations.
About ACCATRANS
This file contains a set of intermediate results produced by AC130 (Allocation Calculation). These transactions are moved to the Activity Transaction file for posting by AC131 (Allocation Update) and posted by AC190 (Activity Posting).
Fields (45)
Column = COBOL field name without the TRN- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
TRN-ALLOC-NAME PKALLOC_NAME | Alpha 12 | The allocation name represents an allocation as defined in AC30.1 (Allocation) or AC30.2 (Multiple Pool Allocation). | AC130 |
TRN-LINE-NBR PKLINE_NBR | Numeric 6 | You can assign a line number to each detail line of an allocation for sequencing. | AC130 |
TRN-SEQ-NUMBER PKSEQ_NUMBER | Numeric 6 | A unique number assigned to each allocation line. | AC130 |
TRN-ALLOC-GROUP PKALLOC_GROUP | Alpha 12 | This is the allocation group, which is defined in AC37.1 (Allocation Group). | AC130 |
TRN-STEP PKSTEP | Numeric 3 | This field determines when an allocation detail line will get processed. All lower steps are processed before processing higher steps. | AC130 |
TRN-FISCAL-YEAR PKFISCAL_YEAR | Numeric 4 | Contains the fiscal year for the data stored on this record. | AC130 |
TRN-PERIOD PKPERIOD | Numeric 2 | This is the period in the activity group calendar to which the transaction is posted. | AC130 |
TRN-TRANS-TYPETRANS_TYPE | Alpha 1 | This field identifies the type of value for the transaction: amount or units.
| AC130 |
TRN-UNIT-MEASUREUNIT_MEASURE | Alpha 12 | — | AC130 |
TRN-ALLOC-TYPEALLOC_TYPE | Alpha 1 | This field defines where the allocation will take place.
| AC130 |
TRN-ACTIVITY-GRPACTIVITY_GRP | Alpha 15 | This is the activity group of the activity to which the transaction is posted. | AC120, AC130 |
TRN-ACTIVITY PKACTIVITY | Alpha 15 | This is the activity to which the transaction is posted. | AC130 |
TRN-VAR-LEVELSVAR_LEVELS | Alpha 30 | Levels define an addressing system that organizes activities into a reporting hierarchy. Level names are defined for an activity group and should be able to be used across all activities in an activity group. Levels facilitate rollup or consolidation of budgets, costs, and revenues from activities at lower levels to macro activities at a higher level within the hierarchy. | AC130 |
TRN-ACCT-CATEGORY PKACCT_CATEGORY | Alpha 5 | This is the account category to which the transaction is posted. | AC130 |
TRN-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This is the description of the transaction. | AC130 |
TRN-REFERENCEREFERENCE | Alpha 10 (Lower Case) | This is a user-defined field used for tracing the transaction to its origin. Allocation transaction Reference fields contain the name of the allocation. | AC130 |
TRN-COMPANYCOMPANY | Numeric 4 | This is the company to which the allocation is posted. | AC130 |
TRN-FROM-COMPANYFROM_COMPANY | Numeric 4 | This is the company that is the source of the allocation. | AC130 |
TRN-ACCT-UNITACCT_UNIT | Alpha 15 | This is the accounting unit to which the allocation transaction is posted. | AC130 |
TRN-ACCOUNTACCOUNT | Numeric 6 | This is the account to which the allocation transaction is posted. If you select the Pool (P) posting option, and the pool consists of General Ledger balances, a separate transaction is created for each account/subaccount combination and posted to the post-to activity and account category. | AC130, AC131 |
TRN-SUB-ACCOUNTSUB_ACCOUNT | Numeric 4 | This is the subaccount to which the allocation transaction is posted. If you select the Pool (P) posting option, and the pool consists of General Ledger balances, a separate transaction is created for each account/subaccount combination and posted to the post-to activity and account category. | AC130, AC131 |
TRN-TRAN-DATETRAN_DATE | Numeric 8 (yyyymmdd) | This is a user-defined date specifying when the transaction was entered. | AC130 |
TRN-POST-DATEPOST_DATE | Numeric 8 (yyyymmdd) | This is the date the allocation transaction was posted. | AC130 |
TRN-AUTO-REVAUTO_REV | Alpha 1 | When you set the Auto Reversal field to Yes (Y), reversing entries are created (R) by AC131 (Allocation Update) in the run following the run that produced the original entry.
| AC130, AC131 |
TRN-CONTROL-GROUPCONTROL_GROUP | Numeric 8 | This is the control group number assigned to the transactions created by the allocation. | AC130 |
TRN-TRAN-CURRENCYTRAN_CURRENCY | Alpha 5 | This is the transaction currency. | AC130 |
TRN-TRAN-BASERATETRAN_BASERATE | Signed 14.7 | This is the rate that converts the transaction amount. | — |
TRN-TRAN-AMOUNTTRAN_AMOUNT | Signed 18.2 | This is the amount in transaction currency. | AC130 |
TRN-UNITS-AMOUNTUNITS_AMOUNT | Signed 15.2 | This is the number of units for the transaction. | AC130 |
TRN-TRAN-NDTRAN_ND | Numeric 1 | This is the defined number of decimal positions used for the transaction. | AC130 |
TRN-ACT-CURRENCYACT_CURRENCY | Alpha 5 | This is the activity currency. | AC130 |
TRN-ACT-BASERATEACT_BASERATE | Signed 14.7 | This is the rate that converts the transaction amount to the activity amount. | AC130 |
TRN-ACT-AMOUNTACT_AMOUNT | Signed 18.2 | This is the amount in activity currency. | AC130 |
TRN-ACT-NDACT_ND | Numeric 1 | This is the defined number of decimal positions used for the transaction. | AC130 |
TRN-AG-CURRENCYAG_CURRENCY | Alpha 5 | This is the activity group currency. | AC130 |
TRN-AG-BASERATEAG_BASERATE | Signed 14.7 | This is the rate that converts the transaction amount to the activity group amount. | AC130 |
TRN-AG-AMOUNTAG_AMOUNT | Signed 18.2 | This is the amount in activity group currency. | AC130 |
TRN-AG-NDAG_ND | Numeric 1 | This is the defined number of decimal positions for the activity group. | AC130 |
TRN-RPT-AMOUNT-1RPT_AMOUNT_1 | Signed 18.2 | — | AC130 |
TRN-RPT-RATE-1RPT_RATE_1 | Signed 14.7 | The exchange rate to convert the transaction amount to Report Currency 1. The exchange rate is defined in CU10.1 (Exchange Rate). | AC130 |
TRN-RPT-ND-1RPT_ND_1 | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | AC130 |
TRN-RPT-AMOUNT-2RPT_AMOUNT_2 | Signed 18.2 | — | AC130 |
TRN-RPT-RATE-2RPT_RATE_2 | Signed 14.7 | The exchange rate to convert the transaction amount to Report Currency 1. The exchange rate is defined in CU10.1 (Exchange Rate). | AC130 |
TRN-RPT-ND-2RPT_ND_2 | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | AC130 |
TRN-ORIG-ACCT-CATORIG_ACCT_CAT | Alpha 5 | — | — |
Indexes (3)
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 |
|---|---|---|---|---|
TRNSET1 | ALLOC-GROUP, STEP, ALLOC-NAME, LINE-NBR, ACTIVITY, ACCT-CATEGORY, FISCAL-YEAR, PERIOD, SEQ-NUMBER | Primary | AC130, AC131 | |
TRNSET2 | ALLOC-NAME, LINE-NBR, STEP*, SEQ-NUMBER, ALLOC-GROUP | KeyChange | AC130, AC30.1, AC30.2, AC30.3, AC32.1 | |
TRNSET3 | ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, CONTROL-GROUP, LINE-NBR, SEQ-NUMBER, ALLOC-GROUP, STEP, ALLOC-NAME | KeyChange | AC10.1, AC120, AC131, AC300 |
Relations
One to one (6) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acacctcat | ACACCTCAT | Required | TRN-ACCT-CATEGORY → AAX-ACCT-CATEGORY | |
| Acactgrp | ACACTGRP | Required | TRN-ACTIVITY-GRP → AGP-ACTIVITY-GRP | |
| Acactivity | ACACTIVITY | Required | TRN-ACTIVITY → ACV-ACTIVITY | |
| Acalloc | ACALLOC | Required | TRN-ALLOC-NAME → AOC-ALLOC-NAME | |
| Acallocgp | ACALLOCGP | Required | TRN-ALLOC-GROUP → ALG-ALLOC-GROUP | |
| Glsystem | GLSYSTEM | Required | TRN-COMPANY → GLS-COMPANY |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acalprdamt | ACALPRDAMT | TRN-ALLOC-NAME → ALA-ALLOC-NAME, ALA-LINE-NBR, ALA-ACTIVITY, ALA-ACCT-CATEGORY, ALA-ORIG-ACCT-CAT |
Programs
Updated by (8)
- AC120 Level Reorganization
- AC130 Allocation Calculation
- AC131 Allocation Update
- AC30.1 Allocation
- AC30.2 Multiple Pool Allocation
- AC30.3 List Allocation
- AC300 Activity Group Purge
- AC32.1 Allocation Pool
Referenced by (1)
- AC10.1 Activity