Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCATRANS


                             ACCATRANS FILE

                       AC Allocation Transaction

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).

REFERENCED BY

AC10.1

UPDATED BY

AC120     AC130     AC131     AC30.1    AC30.2    AC30.3
AC300     AC32.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TRN-ALLOC-NAME         Alpha 12                                  AC130
Element: Alloc Name    The allocation name represents an
                       allocation as defined in AC30.1
                       (Allocation) or AC30.2 (Multiple Pool
                       Allocation).

TRN-LINE-NBR           Numeric 6                                 AC130
Element: Line Nbr      You can assign a line number to each
                       detail line of an allocation for
                       sequencing.

TRN-SEQ-NUMBER         Numeric 6                                 AC130
Element: Seq Number    A unique number assigned to each
                       allocation line.

TRN-ALLOC-GROUP        Alpha 12                                  AC130
Element: Allocation GroThis is the allocation group, which is
                       defined in AC37.1 (Allocation Group).

TRN-STEP               Numeric 3                                 AC130
Element: Step          This field determines when an
                       allocation detail line will get
                       processed.  All lower steps are
                       processed before processing higher
                       steps.

TRN-FISCAL-YEAR        Numeric 4                                 AC130
Element: Year          Contains the fiscal year for the data
                       stored on this record.


TRN-PERIOD             Numeric 2                                 AC130
Element: Period        This is the period in the activity
                       group calendar to which the transaction
                       is posted.

TRN-TRANS-TYPE         Alpha 1                                   AC130
Element: Trans Type    This field identifies the type of value
                       for the transaction: amount or units.
                       A = Amount
                       U = Unit

TRN-UNIT-MEASURE       Alpha 12                                  AC130
Element: Unit Measure

TRN-ALLOC-TYPE         Alpha 1                                   AC130
Element: Alloc Type    This field defines where the allocation
                       will take place.

                       A = AC Only
                       B = Both AC and GL

TRN-ACTIVITY-GRP       Alpha 15                                  AC120   AC130
Element: Activity GroupThis is the activity group of the
                       activity to which the transaction is
                       posted.

TRN-ACTIVITY           Alpha 15                                  AC130
Element: Activity      This is the activity to which the
                       transaction is posted.

TRN-VAR-LEVELS         Alpha 30                                  AC130
Element: Variable LevelLevels 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.

TRN-ACCT-CATEGORY      Alpha 5                                   AC130
Element: Acct Category This is the account category to which
                       the transaction is posted.

TRN-DESCRIPTION        Alpha 30  (Lower Case)                    AC130
Transaction            This is the description of the
Description            transaction.

TRN-REFERENCE          Alpha 10  (Lower Case)                    AC130
Element: Reference     This is a user-defined field used for
                       tracing the transaction to its origin.
                       Allocation transaction Reference fields
                       contain the name of the allocation.

TRN-COMPANY            Numeric 4                                 AC130
Element: Company       This is the company to which the
                       allocation is posted.

TRN-FROM-COMPANY       Numeric 4                                 AC130
Element: From Company  This is the company that is the source
                       of the allocation.

TRN-ACCT-UNIT          Alpha 15                                  AC130
Element: Acct Unit     This is the accounting unit to which
                       the allocation transaction is posted.

TRN-ACCOUNT            Numeric 6                                 AC130
Element: Account       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.

TRN-SUB-ACCOUNT        Numeric 4                                 AC130
Element: Sub Acct      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.

TRN-TRAN-DATE          Numeric 8  (yyyymmdd)                     AC130
Element: Tran Date     This is a user-defined date specifying
                       when the transaction was entered.

TRN-POST-DATE          Numeric 8  (yyyymmdd)                     AC130
Element: Posting Date  This is the date the allocation
                       transaction was posted.

TRN-AUTO-REV           Alpha 1                                   AC130   AC131
Element: Auto Reverse  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.
                       Y = Yes
                       N = No

TRN-CONTROL-GROUP      Numeric 8                                 AC130
Element: Control Group This is the control group number
                       assigned to the transactions created by
                       the allocation.

TRN-TRAN-CURRENCY      Alpha 5                                   AC130
Element: Transaction CuThis is the transaction currency.

TRN-TRAN-BASERATE      Signed 14.7
Transaction Base       This is the rate that converts the
Rate                   transaction amount.

TRN-TRAN-AMOUNT        Signed 18.2                               AC130
Element: Transaction AmThis is the amount in transaction
                       currency.

TRN-UNITS-AMOUNT       Signed 15.2                               AC130
Element: Units Amount  This is the number of units for the
                       transaction.

TRN-TRAN-ND            Numeric 1                                 AC130
Transaction Number     This is the defined number of decimal
of Decimals            positions used for the transaction.

TRN-ACT-CURRENCY       Alpha 5                                   AC130
Element: Activity CurreThis is the activity currency.

TRN-ACT-BASERATE       Signed 14.7                               AC130
Element: Activity Base This is the rate that converts the
                       transaction amount to the activity
                       amount.

TRN-ACT-AMOUNT         Signed 18.2                               AC130
Element: Activity AmounThis is the amount in activity
                       currency.

TRN-ACT-ND             Numeric 1                                 AC130
Activity Number of     This is the defined number of decimal
Decimals               positions used for the transaction.

TRN-AG-CURRENCY        Alpha 5                                   AC130
Activity Group         This is the activity group currency.
Currency

TRN-AG-BASERATE        Signed 14.7                               AC130
Activity Group Base    This is the rate that converts the
Rate                   transaction amount to the activity group
                       amount.

TRN-AG-AMOUNT          Signed 18.2                               AC130
Activity Group         This is the amount in activity group
Amount                 currency.

TRN-AG-ND              Numeric 1                                 AC130
Activity Grp Nbr of    This is the defined number of decimal
Decimals               positions for the activity group.

TRN-RPT-AMOUNT-1       Signed 18.2                               AC130
Element: Intl Amt

TRN-RPT-RATE-1         Signed 14.7                               AC130
Element: Rpt Rate 1    The exchange rate to convert the
                       transaction amount to Report Currency 1.
                       The exchange rate is defined in CU10.1
                       (Exchange Rate).

TRN-RPT-ND-1           Numeric 1                                 AC130
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


TRN-RPT-AMOUNT-2       Signed 18.2                               AC130
Element: Intl Amt

TRN-RPT-RATE-2         Signed 14.7                               AC130
Element: Rpt Rate 1    The exchange rate to convert the
                       transaction amount to Report Currency 1.
                       The exchange rate is defined in CU10.1
                       (Exchange Rate).

TRN-RPT-ND-2           Numeric 1                                 AC130
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


                         ACCATRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TRNSET1   ALLOC-GROUP                                            AC130   AC131
          STEP
          ALLOC-NAME
          LINE-NBR
          ACTIVITY
          ACCT-CATEGORY
          FISCAL-YEAR
          PERIOD
          SEQ-NUMBER

TRNSET2   ALLOC-NAME    KeyChange                                AC130   AC30.1
          LINE-NBR                                               AC30.2  AC30.3
          STEP*                                                  AC32.1
          SEQ-NUMBER
          ALLOC-GROUP

TRNSET3   ACTIVITY-GRP  KeyChange                                AC10.1  AC120
          ACTIVITY                                               AC131   AC300
          ACCT-CATEGORY
          CONTROL-GROUP
          LINE-NBR
          SEQ-NUMBER
          ALLOC-GROUP
          STEP
          ALLOC-NAME

                         ACCATRANS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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