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     BR123
BR140     BR151     BR152     BR156     BR19.2    BR190
BR20.1    BR20.2    BR20.3    BR20.4    BR20.5    BR218
BR420     BR450     BR521     BRIP.1

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BCG-CONTRACT           Alpha 15                                  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   BR123
                                                                 BR140   BR151
                                                                 BR152   BR156
                                                                 BR18.1  BR19.2
                                                                 BR190   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR218   BR420
                                                                 BR450   BR521
                                                                 BRIP.1

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

                         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