Lawson Insight Technical Documentation

                            ACCNTRACTX FILE

REFERENCED BY

DA91.1    BR130     BR131     BR20.1    BR20.2    BR20.3
BR20.4    BR20.5    BR210     BR430     BR65.2    BR65.1
BRCC.1    BRIP.1    AC493     AC50.1    AC93.4    AC93.5
BR02.2    BR02.3    BR05.1    BR05.2    BR05.3    BR05.4
BR05.5

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
Contract                                                         AC120   AC500
                                                                 BR10.1

CNX-ACTIVITY         Alpha 15                                    AC10.1  AC110
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 15.2                                 AC10.1  AC110
Contract Amt                                                     AC500   BR10.1
                                                                 BR10.2  BR65.1
                                                                 BR65.2

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

                         ACCNTRACTX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CNXSET1   CONTRACT                                               AC10.1  AC300
          ACTIVITY                                               AC310   DA91.1
                                                                 BR10.1  BR10.2
                                                                 BR130   BR131
                                                                 BR20.1  BR20.2
                                                                 BR20.3  BR20.4
                                                                 BR20.5  BR210
                                                                 BR430   BR65.2
                                                                 BRCC.1  BRIP.1

CNXSET2   ACTIVITY                                               AC10.1  AC120
          CONTRACT                                               AC493   AC50.1
                                                                 AC500   AC93.4
                                                                 AC93.5  BR02.2
                                                                 BR02.3  BR05.1
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR430   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