Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CUCONTROL


                             CUCONTROL FILE

                            Currency Control

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    GL500
IFGT.1    GL300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CLC-COMPANY            Numeric 4                                 GL110   GL146
Element: Company       Identifies the AP company if the          GL167   GL190
                       resource type = V.  Identifies the HR     GL191   GL196
                       company if the resource type = E.  It is  GL197   GL199
                       blank for type A, P or Q resources.       GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

CLC-FISCAL-YEAR        Numeric 4                                 GL146   GL167
Element: Year          Contains the fiscal year for the data     GL190   GL191
                       stored on this record.                    GL196   GL197
                                                                 GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

CLC-ACCT-PERIOD        Numeric 2                                 GL146   GL167
Element: Acct Period   This is the current accounting period.    GL190   GL191
                       This field is updated by GL199 (Period    GL196   GL197
                       Closing).                                 GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

CLC-SYSTEM             Alpha 2                                   GL146   GL167
Element: System        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  GL500
                                                                 IFGT.1

CLC-JE-TYPE            Alpha 1                                   GL146   GL167
Element: Je Type       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  GL500
                                                                 IFGT.1

CLC-CONTROL-GROUP      Numeric 8                                 GL146   GL167
Element: Control Group This 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  GL500
                                                                 IFGT.1

CLC-JE-SEQUENCE        Numeric 2                                 GL146   GL167
Element: Je Sequence   The journal entry sequence number.        GL190   GL191
                                                                 GL196   GL197
                                                                 GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 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.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

CLC-AMT-TYPE           Numeric 1                                 GL146   GL167
Element: Amt 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.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

CLC-ENTRY-DB           Signed 18.2                               GL146   GL167
Element: Intl Amt                                                GL190   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500

CLC-ENTRY-CR           Signed 18.2                               GL146   GL167
Element: Intl Amt                                                GL190   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500

CLC-AUTO-DB            Signed 18.2                               GL40.1  GL40.2
Element: Intl Amt      This field will store the Auto Reverse    GL40.3  GL40.6
                       Total Debits for a Journal Entry for      GL40.7  GL40.8
                       Report Currency 1 and Report 2.           GL45.1  GL500

CLC-AUTO-CR            Signed 18.2                               GL40.1  GL40.2
Element: Intl Amt      This field will store the Auto Reverse    GL40.3  GL40.6
                       Total Credits for a Journal Entry for     GL40.7  GL40.8
                       Report Currency 1 and Report Currency 2.  GL45.1  GL500

                         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
                                                                 GL500   IFGT.1