Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCTRCATG


                             ACCTRCATG FILE

REFERENCED BY

BR00.2    BR00.3    BR01.1    BR01.2    BR02.3    BR03.1
BR03.2    BR03.3    BR120     BR121     BR122     BR140
BR19.2    BR190     BR20.1    BR20.2    BR20.3    BR20.4
BR20.5    BR218     BR420     BR521

UPDATED BY

AC300     AC310     BR18.1    BR18.2    BR18.3    AC10.1
BR10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BCG-CONTRACT           Alpha 10                                  BR18.1  BR18.2
Element: Contract      Activity Management contract.             BR18.3

BCG-CTR-CAT-GRP        Alpha 5                                   BR18.1  BR18.2
Element: Ctr Cat Grp                                             BR18.3

BCG-DESCRIPTION        Alpha 30  (Lower Case)                    BR18.1  BR18.2
Element: Description   This field displays the description.      BR18.3

                         ACCTRCATG FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BCGSET1   CTR-CAT-GRP                                            BR00.2  BR00.3
          CONTRACT                                               BR01.1  BR01.2
                                                                 BR02.3  BR03.1
                                                                 BR03.2  BR03.3
                                                                 BR120   BR121
                                                                 BR122   BR140
                                                                 BR18.1  BR19.2
                                                                 BR190   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR218   BR420
                                                                 BR521

BCGSET2   CONTRACT                                               AC10.1  AC300
          CTR-CAT-GRP                                            AC310   BR10.1
                                                                 BR18.1  BR18.2
                                                                 BR18.3  BR218

                         ACCTRCATG FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accntract      ACCNTRACT    Required

                            BCG-CONTRACT       -> CNT-CONTRACT

                         ACCTRCATG FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acctrcatgx     ACCTRCATGX

                            BCG-CONTRACT       -> BCX-CONTRACT
                            BCG-CTR-CAT-GRP    -> BCX-CTR-CAT-GRP
                                                  BCX-ACCT-CATEGORY