Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACTRANSREL


                            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

AC310     AC54.1    AC540

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TRR-RUN-GROUP          Alpha 15                                  AC54.1
Element: 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
Element: Sequence NumbeRequired. 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
Element: 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-OLD-ACCT-CAT       Alpha 35                                  AC54.1
Element: Old Acct Cat

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

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

TRR-SYSTEM             Alpha 2                                   AC54.1
Element: 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
Element: Company       This is the company number for the
                       transaction.

TRR-ACCT-UNIT          Alpha 15                                  AC54.1
Element: Accounting UniThis is the accounting unit for the
                       transaction.

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

TRR-SUB-ACCOUNT        Numeric 4                                 AC54.1
Element: 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
Element: Reference     This is the reference number associated
                       with the transaction.

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

TRR-TRAN-CURRENCY      Alpha 5                                   AC54.1
Element: Transaction CuThis is the currency for the
                       transaction.

TRR-TRAN-AMOUNT        Signed 18.2                               AC54.1
Element: Transaction AmThis is the amount in transaction
                       currency.

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

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

TRR-SOURCE-CODE        Alpha 2                                   AC54.1
Element: 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
Element: 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
Element: 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
Element: 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
Element: Attribute ValuThis 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
Element: Attribute ValuThis 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
Element: Attribute ValuThis 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
Element: Resource Type This is the type of resource associated
                       with the transaction.

TRR-FROM-COMPANY       Numeric 4                                 AC54.1
Element: Company       This is the from company used for the GL
                       transaction.  This is also the resource
                       company if the resource is type V or E.

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

TRR-RESOURCE-DESC      Alpha 30  (Lower Case)                    AC54.1
Element: Description   This field displays the description.

TRR-UNIT-MEASURE       Alpha 12                                  AC54.1
Element: Unit of MeasurThis is the unit of measure for the
                       transaction.

TRR-STD-COST-FLAG      Alpha 1                                   AC54.1
Element: Standard Cost 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 18.2                               AC54.1
Element: Intl Amt      This field indicates the billable
                       amount for the transaction.

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

TRR-SEGMENT-BLOCK      Alpha 103                                 AC54.1
Element: Segment Block 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 18.2                               AC54.1
Element: Intl Amt

TRR-AP-PAID            Alpha 1                                   AC54.1
Element: Ap Paid       " " = Eligible for Billing
                       H = Hold for Billing

TRR-COMMENTS-FLAG      Alpha 1
Element: Flag          Y = Yes
                       N = No

                         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  AC310
          RUN-GROUP                                              AC540
          SEQ-NUMBER