Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBMXCONV


                             CBMXCONV FILE

                     Cash Code Attribute Conversion

REFERENCED BY

CB262

UPDATED BY

CB162     CB62.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CBN-RUN-GROUP          Alpha 15                                  CB62.1
Element: Run Group     Run Group and Seq Number are the keys
                       to the file.  They should be used to
                       group records together for interfacing.

CBN-COMPANY            Numeric 4                                 CB62.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

CBN-CASH-CODE          Alpha 4                                   CB62.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.


CBN-MATRIX-CAT         Alpha 12                                  CB62.1
Element: Matrix Cat    Attribute name assigned to an object
                       (like accounting unit) to track
                       additional information.  Attribute
                       values may then be used in selection and
                       sorting for report and analysis.

CBN-MX-VALUE           Alpha 32                                  CB62.1
Element: Mx Value      The attribute value.

                         CBMXCONV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CBNSET1   RUN-GROUP                                              CB162   CB262
          COMPANY                                                CB62.1
          CASH-CODE
          MATRIX-CAT

CBNSET2   MATRIX-CAT
          COMPANY
          CASH-CODE
          RUN-GROUP

CBNSET3   COMPANY
          CASH-CODE
          RUN-GROUP
          MATRIX-CAT

                         CBMXCONV FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mxobjcat       MXOBJCAT

                            CBN-MATRIX-CAT    -> MOC-MATRIX-CAT  (MOCSET4)
                                                 MOC-OBJ-TYPE