Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ACTRANSERR FILE

REFERENCED BY

BR12.1    BR00.1    BR00.2    BR00.3    BR10.1    BR10.2

UPDATED BY

AC300     BR41.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

TER-OBJ-ID           Numeric 12
Object               This is the object identifier. It is
Identification       used to relate commitments or posted
                     transactions back to the originating
                     subsystems. Each subsystem record that
                     is updated as a commitment or posted
                     transaction is assigned an object
                     identifier. The object identifier is
                     maintained in the subsystem files and in
                     the Activity Commitments Detail and
                     Activity Transaction files. The object
                     identifier is a unique key used to drill
                     back from Activity Management to the
                     subsystems.

TER-ACTIVITY         Alpha 15
Activity             Activities are the processes or
                     procedures that produce work. Cost
                     objects (products, services, customers,
                     and so on) are the reasons for
                     performing the activity.


TER-ACCT-CATEGORY    Alpha 5
Account Category     Account categories are groupings of
                     costs, revenues, or a combination of
                     both used for reporting and inquiries
                     for activities in the Activity
                     Management system. All transactions are
                     posted to an account category within an
                     activity. You can assign a specific
                     General Ledger account or range of
                     accounts (company, accounting unit,
                     account, and subaccount) that make up
                     the transactions posted to an account
                     category using AC07.1 (Account
                     Assignment).

                     Period-to-date, year-to-date, and
                     life-to-date balances are maintained by
                     account category for activities. Account
                     categories must be assigned to
                     activities before you do any budgeting
                     or transaction processing.

TER-JOURNAL-CODE     Alpha 4                                     BR41.1
Journal Code

TER-STATUS           Numeric 1                                   BR41.1
Status               This field displays the status of the
                     transaction.
                     1 = Open
                     2 = Reviewed

TER-BRDN-ORG-OBJID   Numeric 12
Brdn Org Objid

TER-AUTO-JRL-CD      Alpha 4
Auto Jrl Cd

TER-REVENUE-AMT      Signed 15.2
Revenue Amt

TER-APPLY-TOL-AMT    Signed 15.2
Apply Tol Amt

                         ACTRANSERR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TERSET1   OBJ-ID

TERSET2   JOURNAL-CODE                                           BR12.1
          OBJ-ID

TERSET3   STATUS        KeyChange                                AC300   BR00.1
          ACTIVITY                                               BR00.2  BR00.3
          ACCT-CATEGORY                                          BR10.1  BR10.2
          OBJ-ID                                                 BR41.1

TERSET4   STATUS                                                 BR41.1
          OBJ-ID

TERSET5   BRDN-ORG-OBJID
          OBJ-ID

                         ACTRANSERR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Actrans        ACTRANS      Required

                            TER-ACCT-CATEGORY    -> ATN-ACCT-CATEGORY  (ATNSET11)
                            TER-OBJ-ID           -> ATN-OBJ-ID

                         ACTRANSERR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acclgtrans     ACCLGTRANS

                            TER-OBJ-ID           -> CGT-OBJ-ID
                                                    CGT-CONT-ACTIVITY
                                                    CGT-BILL-ACTIVITY
                                                    CGT-ACCT-CATEGORY
                                                    CGT-ACCT-CAT-CLASS
                                                    CGT-MATRIX-CAT
                                                    CGT-MX-VALUE