Lawson Insight Technical Documentation

                              CBGRPCC FILE

REFERENCED BY

CB175     CB180     CB190     CB191     CB210     CB211
CB215     CB220     CB221     CB260     CB300     CB500

UPDATED BY

CB11.1    CB11.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CCD-CASH-CODE-GRP    Alpha 12                                    CB11.1
Cash Code Grp        A cash code group is an optional
                     paramater that lets you run reports or
                     batch programs for a group of cash
                     codes.

CCD-CASH-CODE        Alpha 4                                     CB11.1
Cash Code            A cash code represents a bank account.
                     More than one company can use the same
                     cash code.  The cash code must be linked
                     to a bank in the Lawson Cash Ledger
                     system.


                         CBGRPCC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CCDSET1   CASH-CODE-GRP                                          CB11.1  CB11.2
          CASH-CODE                                              CB175   CB180
                                                                 CB190   CB191
                                                                 CB210   CB211
                                                                 CB215   CB220
                                                                 CB221   CB260
                                                                 CB300   CB500

CCDSET2   CASH-CODE
          CASH-CODE-GRP

                         CBGRPCC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cbcashcode     CBCASHCODE   Required

                            CCD-CASH-CODE        -> CBC-CASH-CODE  (CBCSET1)

Cbccgrp        CBCCGRP      Required

                            CCD-CASH-CODE-GRP    -> CCG-CASH-CODE-GRP

                         CBGRPCC FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cbstatemnt     CBSTATEMNT

                            CCD-CASH-CODE        -> CSM-CASH-CODE
                                                    CSM-RECON-STMT-NBR