Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CUCONTROL


                             CUCONTROL FILE

The General Ledger Currency Control (CUCONTROL) file stores transaction
currency amounts.


UPDATED BY

GL110     GL146     GL167     GL190     GL191     GL196
GL197     GL199     GL310     GL40.1    GL40.2    GL40.3
GL40.6    GL40.7    GL40.8    GL44.1    GL45.1    IFGT.1
GL300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CLC-COMPANY            Numeric 4                                 GL110   GL146
Element: Company       The company number represents an          GL167   GL190
                       established company and is entered on     GL191   GL196
                       all function codes.                       GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 IFGT.1

CLC-FISCAL-YEAR        Numeric 4                                 GL146   GL167
Element: Last Closed YeThis is the current fiscal year.  This    GL190   GL191
                       field is updated by Period Closing        GL196   GL197
                       (GL199).                                  GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  IFGT.1

CLC-ACCT-PERIOD        Numeric 2                                 GL146   GL167
Element: Current Period                                          GL190   GL191
                                                                 GL196   GL197
                                                                 GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  IFGT.1

CLC-SYSTEM             Alpha 2                                   GL146   GL167
Element: System Code   A two-character code representing an      GL190   GL191
                       application used within the Lawson        GL196   GL197
                       system. (i.e.: GL = General Ledger, AP =  GL199   GL40.1
                       Accounts Payable, etc.)                   GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  IFGT.1

CLC-JE-TYPE            Alpha 1                                   GL146   GL167
Element: Journal Entry The type of journal entry. Valid values   GL190   GL191
                       are Normal and Intercompany.              GL196   GL197
                                                                 GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  IFGT.1

CLC-CONTROL-GROUP      Numeric 8                                 GL146   GL167
Element: Control GroupsThis field displays the journal entry     GL190   GL191
                       number used for process control of the    GL196   GL197
                       journal entry detail.                     GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  IFGT.1

CLC-JE-SEQUENCE        Numeric 2                                 GL146   GL167
Journal Entry          The journal entry sequence number.        GL190   GL191
Sequence Number                                                  GL196   GL197
                                                                 GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  IFGT.1

CLC-CURRENCY-CODE      Alpha 5                                   GL146   GL167
Element: Currency Code This field contains the company base      GL190   GL191
                       currency code established in Company      GL196   GL197
                       (GL10.1 ).                                GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 IFGT.1

CLC-AMT-TYPE           Numeric 1                                 GL146   GL167
Element: Amount Type   The amount type can be either Report      GL190   GL191
                       Currency One or Report Currency Two.      GL196   GL197
                                                                 GL199   GL40.1
                       1 = Report currency 1                     GL40.2  GL40.3
                       2 = Report currency 2                     GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 IFGT.1

CLC-ENTRY-DB           Signed 15.2                               GL146   GL167
Element: Auto Debits                                             GL190   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1

CLC-ENTRY-CR           Signed 15.2                               GL146   GL167
Element: Auto Credits                                            GL190   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1

                         CUCONTROL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CLCSET1   COMPANY                                                GL110   GL146
          FISCAL-YEAR                                            GL167   GL190
          ACCT-PERIOD                                            GL191   GL196
          SYSTEM                                                 GL197   GL199
          JE-TYPE                                                GL300   GL310
          CONTROL-GROUP                                          GL40.1  GL40.2
          JE-SEQUENCE                                            GL40.3  GL40.6
          AMT-TYPE                                               GL40.7  GL40.8
          CURRENCY-CODE                                          GL44.1  GL45.1
                                                                 IFGT.1