Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBGRPCC


                              CBGRPCC FILE

                       Cash Code Group Cash Codes

REFERENCED BY

AP150     AP155     AP160     AP161     AP265     CB00.3
CB00.2    CB01.4    CB01.5    CB145     CB150     CB162
CB170     CB175     CB180     CB185     CB186     CB187
CB190     CB191     CB210     CB211     CB215     CB220
CB221     CB245     CB246     CB255     CB260     CB286
CB300     CB544     CB62.1    CBBC.1    CBOP.1

UPDATED BY

CB11.1    CB11.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CCD-CASH-CODE-GRP      Alpha 12                                  CB11.1
Element: 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
Element: 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                                          AP150   AP155
          CASH-CODE                                              AP160   AP161
                                                                 AP265   CB00.3
                                                                 CB01.4  CB01.5
                                                                 CB11.1  CB11.2
                                                                 CB145   CB150
                                                                 CB162   CB170
                                                                 CB175   CB180
                                                                 CB185   CB186
                                                                 CB187   CB190
                                                                 CB191   CB210
                                                                 CB211   CB215
                                                                 CB220   CB221
                                                                 CB245   CB246
                                                                 CB255   CB260
                                                                 ...

CCDSET2   CASH-CODE                                              CB00.2
          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

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