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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#TRN-ALLOC-NAME PK
ALLOC_NAME		Alpha 12The allocation name represents an allocation as defined in AC30.1 (Allocation) or AC30.2 (Multiple Pool Allocation).AC130
#TRN-LINE-NBR PK
LINE_NBR		Numeric 6You can assign a line number to each detail line of an allocation for sequencing.AC130
#TRN-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6A unique number assigned to each allocation line.AC130
#TRN-ALLOC-GROUP PK
ALLOC_GROUP		Alpha 12This is the allocation group, which is defined in AC37.1 (Allocation Group).AC130
#TRN-STEP PK
STEP		Numeric 3This field determines when an allocation detail line will get processed. All lower steps are processed before processing higher steps.AC130
#TRN-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4Contains the fiscal year for the data stored on this record.AC130
#TRN-PERIOD PK
PERIOD		Numeric 2This is the period in the activity group calendar to which the transaction is posted.AC130
#TRN-TRANS-TYPE
TRANS_TYPE		Alpha 1This field identifies the type of value for the transaction: amount or units.
  • A Amount
  • U Unit
AC130
#TRN-UNIT-MEASURE
UNIT_MEASURE		Alpha 12—AC130
#TRN-ALLOC-TYPE
ALLOC_TYPE		Alpha 1This field defines where the allocation will take place.
  • A AC Only
  • B Both AC and GL
AC130
#TRN-ACTIVITY-GRP SET3
ACTIVITY_GRP		Alpha 15This is the activity group of the activity to which the transaction is posted.AC120, AC130
#TRN-ACTIVITY PK
ACTIVITY		Alpha 15This is the activity to which the transaction is posted.AC130
#TRN-VAR-LEVELS
VAR_LEVELS		Alpha 30Levels 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 PK
ACCT_CATEGORY		Alpha 5This is the account category to which the transaction is posted.AC130
#TRN-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This is the description of the transaction.AC130
#TRN-REFERENCE
REFERENCE		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-COMPANY
COMPANY		Numeric 4This is the company to which the allocation is posted.AC130
#TRN-FROM-COMPANY
FROM_COMPANY		Numeric 4This is the company that is the source of the allocation.AC130
#TRN-ACCT-UNIT
ACCT_UNIT		Alpha 15This is the accounting unit to which the allocation transaction is posted.AC130
#TRN-ACCOUNT
ACCOUNT		Numeric 6This 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-ACCOUNT
SUB_ACCOUNT		Numeric 4This 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-DATE
TRAN_DATE		Numeric 8 (yyyymmdd)This is a user-defined date specifying when the transaction was entered.AC130
#TRN-POST-DATE
POST_DATE		Numeric 8 (yyyymmdd)This is the date the allocation transaction was posted.AC130
#TRN-AUTO-REV
AUTO_REV		Alpha 1When 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.
  • Y Yes
  • N No
AC130, AC131
#TRN-CONTROL-GROUP SET3
CONTROL_GROUP		Numeric 8This is the control group number assigned to the transactions created by the allocation.AC130
#TRN-TRAN-CURRENCY
TRAN_CURRENCY		Alpha 5This is the transaction currency.AC130
#TRN-TRAN-BASERATE
TRAN_BASERATE		Signed 14.7This is the rate that converts the transaction amount.—
#TRN-TRAN-AMOUNT
TRAN_AMOUNT		Signed 18.2This is the amount in transaction currency.AC130
#TRN-UNITS-AMOUNT
UNITS_AMOUNT		Signed 15.2This is the number of units for the transaction.AC130
#TRN-TRAN-ND
TRAN_ND		Numeric 1This is the defined number of decimal positions used for the transaction.AC130
#TRN-ACT-CURRENCY
ACT_CURRENCY		Alpha 5This is the activity currency.AC130
#TRN-ACT-BASERATE
ACT_BASERATE		Signed 14.7This is the rate that converts the transaction amount to the activity amount.AC130
#TRN-ACT-AMOUNT
ACT_AMOUNT		Signed 18.2This is the amount in activity currency.AC130
#TRN-ACT-ND
ACT_ND		Numeric 1This is the defined number of decimal positions used for the transaction.AC130
#TRN-AG-CURRENCY
AG_CURRENCY		Alpha 5This is the activity group currency.AC130
#TRN-AG-BASERATE
AG_BASERATE		Signed 14.7This is the rate that converts the transaction amount to the activity group amount.AC130
#TRN-AG-AMOUNT
AG_AMOUNT		Signed 18.2This is the amount in activity group currency.AC130
#TRN-AG-ND
AG_ND		Numeric 1This is the defined number of decimal positions for the activity group.AC130
#TRN-RPT-AMOUNT-1
RPT_AMOUNT_1		Signed 18.2—AC130
#TRN-RPT-RATE-1
RPT_RATE_1		Signed 14.7The 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-1
RPT_ND_1		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.AC130
#TRN-RPT-AMOUNT-2
RPT_AMOUNT_2		Signed 18.2—AC130
#TRN-RPT-RATE-2
RPT_RATE_2		Signed 14.7The 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-2
RPT_ND_2		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.AC130
#TRN-ORIG-ACCT-CAT
ORIG_ACCT_CAT		Alpha 5——

Indexes (3)

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.

IndexKeysFlagsConditionUsed in
TRNSET1
  1. ALLOC-GROUP
  2. STEP
  3. ALLOC-NAME
  4. LINE-NBR
  5. ACTIVITY
  6. ACCT-CATEGORY
  7. FISCAL-YEAR
  8. PERIOD
  9. SEQ-NUMBER
PrimaryAC130, AC131
TRNSET2
  1. ALLOC-NAME
  2. LINE-NBR
  3. STEP ↓
  4. SEQ-NUMBER
  5. ALLOC-GROUP
KeyChangeAC130, AC30.1, AC30.2, AC30.3, AC32.1
TRNSET3
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. ACCT-CATEGORY
  4. CONTROL-GROUP
  5. LINE-NBR
  6. SEQ-NUMBER
  7. ALLOC-GROUP
  8. STEP
  9. ALLOC-NAME
KeyChangeAC10.1, AC120, AC131, AC300

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACCTCATACACTGRPACACTIVITYACALLOCACALLOCGPGLSYSTEMACALPRDAMTACCATRANS

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequired
TRN-ACCT-CATEGORY→AAX-ACCT-CATEGORY
AcactgrpACACTGRPRequired
TRN-ACTIVITY-GRP→AGP-ACTIVITY-GRP
AcactivityACACTIVITYRequired
TRN-ACTIVITY→ACV-ACTIVITY
AcallocACALLOCRequired
TRN-ALLOC-NAME→AOC-ALLOC-NAME
AcallocgpACALLOCGPRequired
TRN-ALLOC-GROUP→ALG-ALLOC-GROUP
GlsystemGLSYSTEMRequired
TRN-COMPANY→GLS-COMPANY

One to many (1) — child tables

RelationTableRulesConditionField map
AcalprdamtACALPRDAMT
TRN-ALLOC-NAME→ALA-ALLOC-NAME
—→ALA-LINE-NBR
—→ALA-ACTIVITY
—→ALA-ACCT-CATEGORY
—→ALA-ORIG-ACCT-CAT

Programs

Updated by (8)

Referenced by (1)