Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCNTRACTX


                            ACCNTRACTX FILE

REFERENCED BY

BR130     BR131     BR153     BR20.1    BR20.2    BR20.3
BR20.4    BR20.5    BR210     BR430     BR521     BR530
BR65.2    BR65.1    BRCC.1    BRIP.1    BRPI.1    AC493
AC50.1    AC93.4    AC93.5    BR02.2    BR02.3    BR05.1
BR05.2    BR05.3    BR05.4    BR05.5    BR154     BR43.1
BR51.1

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CNX-CONTRACT           Alpha 10                                  AC10.1  AC110
Element: Bid Name                                                AC120   AC500
                                                                 BR10.1  BR15.1

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


CNX-CONTRACT-AMT       Signed 15.2                               AC10.1  AC110
Element: Adj Amt                                                 AC500   BR10.1
                                                                 BR10.2  BR15.1
                                                                 BR15.2

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

                         ACCNTRACTX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CNXSET1   CONTRACT                                               AC10.1  AC300
          ACTIVITY                                               AC310   BR10.1
                                                                 BR10.2  BR130
                                                                 BR131   BR15.1
                                                                 BR15.2  BR153
                                                                 BR20.1  BR20.2
                                                                 BR20.3  BR20.4
                                                                 BR20.5  BR210
                                                                 BR430   BR521
                                                                 BR530   BR65.2
                                                                 BRCC.1  BRIP.1
                                                                 BRPI.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
                                                                 BR153   BR154
                                                                 BR43.1  BR430
                                                                 BR51.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