Lawson Insight Technical Documentation

                            ACCNTRACTX FILE

The ACCNTRACTX file maintains all the posting level activities under a
contract and their contract amount.

REFERENCED BY

BR130     BR131     BR140     BR210     BR430     BR515
BR516     BR530     BR65.2    BR65.1    BRCC.1    BRIP.1
AC473     AC493     AC50.1    AC93.4    AC93.5    BR02.2
BR05.1    BR05.2    BR05.3    BR05.4    BR05.5    BR43.1
BR44.1

UPDATED BY

AC10.1    AC110     AC120     AC300     AC310     AC500
BR10.1    BR10.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CNX-CONTRACT           Alpha 10                                  AC10.1  AC110
Element: Contract      Activity Management contract.             AC120   AC500
                                                                 BR10.1

CNX-ACTIVITY           Alpha 15                                  AC10.1  AC110
Element: Activity      Activities are the processes or           AC500   BR10.1
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


CNX-CONTRACT-AMT       Signed 18.2                               AC10.1  AC110
Element: Intl Amt                                                AC500   BR10.1
                                                                 BR10.2

CNX-CONTRACT-FLAG      Alpha 1                                   AC10.1  AC110
Element: Contract Flag                                           AC500   BR10.1
                                                                 BR10.2

                         ACCNTRACTX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CNXSET1   CONTRACT                                               AC10.1  AC10.5
          ACTIVITY                                               AC300   AC310
                                                                 BR10.1  BR10.2
                                                                 BR130   BR131
                                                                 BR140   BR210
                                                                 BR430   BR515
                                                                 BR516   BR530
                                                                 BR65.2  BRCC.1
                                                                 BRIP.1

CNXSET2   ACTIVITY                                               AC10.1  AC120
          CONTRACT                                               AC473   AC493
                                                                 AC50.1  AC500
                                                                 AC93.4  AC93.5
                                                                 BR02.2  BR05.1
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR43.1  BR44.1
                                                                 BR65.1  BRCC.1

                         ACCNTRACTX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactivity     ACACTIVITY   Required

                            CNX-ACTIVITY    -> ACV-ACTIVITY

Accntract      ACCNTRACT    Required

                            CNX-CONTRACT    -> CNT-CONTRACT