Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ACTRANSREL FILE

                     Activity Transaction Relation

This file is used in conversion of non-Lawson activity transactions to the
Lawson Activity Management system. It includes the Run Group and Sequence
Number fields, which organize transaction records for conversion and
interfacing. The field Old Activity links the old system and its transactions
with the Lawson Activity Management system.

REFERENCED BY

AC29.1

UPDATED BY

AC300     AC310     AC54.1    AC540

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

TRR-RUN-GROUP        Alpha 15                                    AC54.1
Run Group            Required. Run Group and Sequence Number
                     are the keys to the file. They should be
                     used to group records together for
                     interfacing.

TRR-SEQ-NUMBER       Numeric 6                                   AC54.1
Sequence Number      Required. The Sequence number is a
                     unique number assigned to each
                     transaction to be transferred into the
                     Lawson system.

TRR-OLD-ACTIVITY     Alpha 35                                    AC54.1
Old Activity         Required. This is the old activity or
                     project, to be associated with a new
                     activity.

                     If you are not upgrading and want to
                     interface data on a regular basis, you
                     can enter a valid activity in this
                     field.

TRR-ACCT-CATEGORY    Alpha 5                                     AC54.1
Account Category     Required. This is the account category
                     for the transaction.

TRR-POSTING-DATE     Numeric 8  (yyyymmdd)                       AC54.1
Posting Date         Required. This is the posting date
                     assigned to the transaction.

TRR-TRANS-DATE       Numeric 8  (yyyymmdd)                       AC54.1
Transaction Date     The date of the transaction.

TRR-SYSTEM           Alpha 2                                     AC54.1
System Code          Required. This is the system code for
                     the transaction. The system code is a
                     two-character code representing an
                     application used within the Lawson
                     system. (i.e.: GL = General Ledger, AP =
                     Accounts Payable, etc.)

TRR-COMPANY          Numeric 4                                   AC54.1
Company              This is the company number for the
                     transaction.

TRR-ACCT-UNIT        Alpha 15                                    AC54.1
Accounting Unit      This is the accounting unit for the
                     transaction.

TRR-ACCOUNT          Numeric 6                                   AC54.1
Account              This is the account for the
                     transaction.

TRR-SUB-ACCOUNT      Numeric 4                                   AC54.1
Subaccount           This is the subaccount for the
                     transaction.

TRR-DESCRIPTION      Alpha 30  (Lower Case)                      AC54.1
Transaction          This is the transaction description.
Description

TRR-REFERENCE        Alpha 10  (Lower Case)                      AC54.1
Reference            This is the reference number associated
                     with the transaction.

TRR-UNITS-AMOUNT     Signed 15.2                                 AC54.1
Units Amount         This is the units amount for the
                     transaction.

TRR-TRAN-CURRENCY    Alpha 5                                     AC54.1
Transaction Currency This is the currency for the
                     transaction.

TRR-TRAN-AMOUNT      Signed 15.2                                 AC54.1
Transaction Amount   This is the amount in transaction
                     currency.

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

TRR-RUN-DATE         Numeric 8  (yyyymmdd)                       AC54.1
Run Date             This is the date the transaction was
                     posted to the general ledger.

TRR-RUN-TIME         Numeric 6  (hhmmss)                         AC54.1
Run Time             This is the time the transaction was
                     posted to the general ledger.

TRR-SOURCE-CODE      Alpha 2                                     AC54.1
Source Code          This is the source code for the
                     transaction. A source code is a
                     two-character code assigned to a
                     transaction to identify where the
                     transaction was created.

TRR-MATRIX-CAT-1     Alpha 12                                    AC54.1
Attribute 1          This is an attribute name assigned to a
                     transaction to track additional
                     information. Attribute values can then
                     be selected and sorted for reporting and
                     analysis.

                     Three attributes can be defined per
                     source code.

TRR-MATRIX-CAT-2     Alpha 12                                    AC54.1
Attribute 2          This is an attribute name assigned to a
                     transaction to track additional
                     information. Attribute values can then
                     be selected and sorted for reporting and
                     analysis.

                     Three attributes can be defined per
                     source code.

TRR-MATRIX-CAT-3     Alpha 12                                    AC54.1
Attribute 3          This is an attribute name assigned to a
                     transaction to track additional
                     information. Attribute values can then
                     be selected and sorted for reporting and
                     analysis.

                     Three attributes can be defined per
                     source code.

TRR-MX-VALUE-1       Alpha 32                                    AC54.1
Attribute Value 1    This is the value for attribute 1.
                     Attribute values can be used in
                     selection and sorting for reporting and
                     analysis.

TRR-MX-VALUE-2       Alpha 32                                    AC54.1
Attribute Value 2    This is the value for attribute 2.
                     Attribute values can be used in
                     selection and sorting for reporting and
                     analysis.

TRR-MX-VALUE-3       Alpha 32                                    AC54.1
Attribute Value 3    This is the value for attribute 3.
                     Attribute values can be used in
                     selection and sorting for reporting and
                     analysis.

TRR-RESOURCE-TYPE    Alpha 1                                     AC54.1
Resource Type        This is the type of resource associated
                     with the transaction.

TRR-RESOURCE-CODE    Alpha 10                                    AC54.1
Resource Code        This is the resource code associated
                     with the transaction.

TRR-RESOURCE-DESC    Alpha 30  (Lower Case)                      AC54.1
Resource Desc

TRR-UNIT-MEASURE     Alpha 12                                    AC54.1
Unit of Measure      This is the unit of measure for the
                     transaction.

TRR-STD-COST-FLAG    Alpha 1                                     AC54.1
Standard Cost Flag   This field indicates whether standard
                     cost is associated with the transaction.

                     Y = Yes
                     N = No

TRR-SHORT-OLD-ACT    Derived
Old Activity Short   This is the short description for the
Description          old activity.

TRR-BILLABLE-AMT     Signed 15.2                                 AC54.1
Billable Amt         This field indicates the billable
                     amount for the transaction.

TRR-BILLABLE-UNIT    Signed 15.2                                 AC54.1
Billable Unit        This field indicates the number of
                     billable units for the transaction.

TRR-SEGMENT-BLOCK    Alpha 103                                   AC54.1
User Analysis        This field identifies the user analysis
                     values included in the transaction.

                     You can either type up to four values
                     or use Define (F6) to open the User
                     Analysis Entry subform. Use this subform
                     to select the user analysis values you
                     want to include in the transaction. If
                     you choose to type values, use commas to
                     separate them. For example:
                     value1,value2,value3,value4

                     There are three conditions that affect
                     how you can select user analysis values.
                     See the User Analysis Entry form help or
                     the Strategic Ledger procedures manual
                     for additional information.

TRR-REVENUE-AMT      Signed 15.2                                 AC54.1
Revenue Amt

                         ACTRANSREL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TRRSET1   RUN-GROUP                                              AC54.1  AC540
          SEQ-NUMBER

TRRSET2   OLD-ACTIVITY  KeyChange                                AC29.1  AC300
          RUN-GROUP                                              AC310   AC540
          SEQ-NUMBER