Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCNTRACTX


                            ACCNTRACTX FILE

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

REFERENCED BY

BR12.2    BR130     BR131     BR140     BR153     BR165
BR210     BR430     BR515     BR516     BR530     BR65.2
BR65.1    BR65.3    BRIP.1    AC19.1    AC473     AC493
AC50.1    AC56.1    AC560     AC93.4    AC93.5    AR21.2
AR237     AR239     AR257     AR27.2    AR29.1    AR296
AR32.1    AR42.1    AR42.2    AR42.7    AR43.1    AR502
AR503     AR55.1    AR560     AR575     AR800     AR91.1
ARLL.1    BR02.2    BR05.1    BR05.2    BR05.3    BR05.4
BR05.5    BR154     BR43.1    BR44.1    BR51.1    BR570
BR70.1

UPDATED BY

AC10.1    AC110     AC120     AC300     AC310     AC500
BR10.1    BR10.2    BR10.9    BR22.1    PW110     PW510


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CNX-CONTRACT           Alpha 15                                  AC10.1  AC110
Element: Contract      Activity Management contract.             AC120   AC500
                                                                 BR10.1  BR10.9
                                                                 PW110   PW510

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


CNX-CONTRACT-AMT       Signed 18.2                               AC10.1  AC110
Element: Intl Amt                                                AC120   AC500
                                                                 BR10.1  BR10.2
                                                                 BR10.9  BR22.1
                                                                 PW110   PW510

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

                         ACCNTRACTX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CNXSET1   CONTRACT                                               AC10.1  AC10.5
          ACTIVITY                                               AC300   AC310
                                                                 BR10.1  BR10.2
                                                                 BR10.9  BR12.2
                                                                 BR130   BR131
                                                                 BR140   BR153
                                                                 BR165   BR210
                                                                 BR22.1  BR430
                                                                 BR515   BR516
                                                                 BR530   BR65.2
                                                                 BRIP.1  PW110

CNXSET2   ACTIVITY                                               AC10.1  AC120
          CONTRACT                                               AC19.1  AC473
                                                                 AC493   AC50.1
                                                                 AC500   AC56.1
                                                                 AC560   AC93.4
                                                                 AC93.5  AR21.2
                                                                 AR237   AR239
                                                                 AR257   AR27.2
                                                                 AR29.1  AR296
                                                                 AR32.1  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR502
                                                                 AR503   AR55.1
                                                                 AR560   AR575
                                                                 AR800   AR91.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