Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACTRANSERR


                            ACTRANSERR FILE

REFERENCED BY

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

UPDATED BY

AC300     BR130     BR530

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TER-OBJ-ID             Numeric 12                                BR130   BR530
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                                  BR130   BR530
Element: 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                                   BR130   BR530
Element: Account CategoAccount 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                                   BR130   BR530
Element: Journal Code

TER-STATUS             Numeric 1                                 BR130   BR530
Element: Status        This field displays the status of the
                       transaction.
                       1 = Open
                       2 = Reviewed

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

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

TER-REVENUE-AMT        Signed 15.2
Element: Adj Amt

TER-APPLY-TOL-AMT      Signed 15.2                               BR130   BR530
Element: Apply Tol Amt

                         ACTRANSERR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TERSET1   OBJ-ID                                                 BR130   BR530

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

TERSET4   STATUS
          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