Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLCONTROL


                             GLCONTROL FILE

                         General Ledger Control

This file contains journal entry control information. This information is
used to process the journal entry detail records.


REFERENCED BY

CA15.1    CA15.2    CA190     FB11.1    FB111     FB160
FB211     FB296     FB60.1    FB95.1    FB95.2    FB95.3
FB95.4    FB95.5    FB95.6    GL240     GL241     GL245
GL247     GL256     GL270     GL284     GL285     GL286
GL287     GL288     GL289     GL290     GL297     GL298
GL90.1    GL90.2    GL90.5    GL90.6    GL94.1    GL94.2
GL94.3    GL94.4    GL94.5    GL94.6    GL94.7    GL95.1
GL95.2    GL95.3    GL95.4    GL95.5    GL95.6    GL95.7
GL95.8    GL95.9    GL96.1    GL96.2    GL96.3    GL96.4
GL96.5    GL97.1    GL97.2    GL97.3    GL97.4    GL97.5
GL97.6    GL97.7    GL97.8    GL97.9    GL98.1    GL98.2
GL98.3    GL98.4    GL98.5    GL99.1    GL99.2    GL99.3
GL99.4    GL99.5    GL99.6    GLCC.1    JB240     GL10.1
IFJR.1    GL12.1    GL12.2

UPDATED BY

GL110     GL145     GL146     GL148     GL167     GL170
GL190     GL191     GL196     GL197     GL199     GL300
GL40.1    GL40.2    GL40.3    GL40.6    GL40.7    GL40.8
GL41.4    GL44.1    GL45.1    GL500     GL75.1    IFGT.1


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GLC-COMPANY            Numeric 4                                 GL110   GL148
Element: Company       Identifies the AP company if the          GL167   GL191
                       resource type = V.  Identifies the HR     GL196   GL197
                       company if the resource type = E.  It is  GL199   GL40.2
                       blank for type A, P or Q resources.       GL40.6  GL41.4
                                                                 GL45.1  GL500
                                                                 GLCC.1  IFGT.1

GLC-FISCAL-YEAR        Numeric 4                                 GL148   GL167
Element: Fiscal Year   Contains the fiscal year for the data     GL191   GL196
                       stored on this record.                    GL197   GL199
                                                                 GL40.2  GL40.6
                                                                 GL41.4  GL45.1
                                                                 GL500   GLCC.1
                                                                 IFGT.1

GLC-ACCT-PERIOD        Numeric 2                                 GL148   GL167
Element: Account PeriodThe accounting period assigned to the     GL191   GL196
                       journal entry.                            GL197   GL199
                                                                 GL40.2  GL40.6
                                                                 GL41.4  GL45.1
                                                                 GL500   GLCC.1
                                                                 IFGT.1

GLC-SYSTEM             Alpha 2                                   GL148   GL167
Element: System        This is the journal entry system code.    GL191   GL196
                                                                 GL197   GL199
                                                                 GL40.2  GL40.6
                                                                 GL41.4  GL45.1
                                                                 GL500   GLCC.1
                                                                 IFGT.1

GLC-JE-TYPE            Alpha 1                                   GL148   GL167
Element: Journal Entry Displays the type of journal entry        GL191   GL196
                       created.                                  GL197   GL199
                       N = Normal                                GL40.2  GL40.6
                       I = Intercompany                          GL41.4  GL45.1
                       A = Auto Rev Normal                       GL500   GLCC.1
                       R = Auto Rev Intco                        IFGT.1

GLC-JE-TYPE-1          Derived
Element: Journal Entry Displays the derived journal entry
                       type.


GLC-CONTROL-GROUP      Numeric 8                                 GL148   GL167
Element: Control Group This field displays the journal entry     GL191   GL196
                       number used for process control of the    GL197   GL199
                       journal entry detail.                     GL40.2  GL40.6
                                                                 GL41.4  GL45.1
                                                                 GL500   GLCC.1
                                                                 IFGT.1

GLC-JE-SEQUENCE        Numeric 2                                 GL146   GL148
Journal Entry          The unique journal entry sequence         GL167   GL190
Sequence               number.                                   GL191   GL196
                                                                 GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL41.4  GL44.1
                                                                 GL45.1  GL500
                                                                 GLCC.1  IFGT.1

GLC-STATUS             Numeric 1                                 GL146   GL148
Element: Status        This field contains the processing        GL167   GL190
                       cycle status of the assigned journal      GL191   GL196
                       entry.                                    GL197   GL199
                                                                 GL40.1  GL40.2
                       0 = Unreleased                            GL40.3  GL40.6
                       1 = Released                              GL40.7  GL40.8
                       2 = Post In Progress                      GL44.1  GL45.1
                       3 = Load In Process                       GL500   IFGT.1
                       4 = Quick Posted
                       5 = Posted
                       6 = Unreleased no AC update
                       9 = History

GLC-STATUS-1           Derived
Element: Status        This field displays the journal entry
                       status.


GLC-CNTRL-AMOUNT       Signed 18.2                               GL146   GL190
Element: Control AmountDisplays the total journal entry          GL197   GL40.1
                       amount.                                   GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500

GLC-ENTRY-DB           Signed 18.2                               GL146   GL167
Element: Entry Debit                                             GL190   GL191
                                                                 GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLC-ENTRY-CR           Signed 18.2                               GL146   GL167
Element: Entry Credit                                            GL190   GL191
                                                                 GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLC-TRAN-ND            Numeric 1                                 GL148   GL167
Trans Number of        The number of decimals assigned to a      GL191   GL196
Decimals               particular account as determined by the   GL197   GL199
                       account currency.                         GL40.2  GL40.5
                                                                 GL41.3  GL45.1
                                                                 GL500   IFGT.1

GLC-UNIT-CNTRL-DB      Signed 15.2                               GL190   GL500
Element: Auto Debits   The total positive detail auto
                       reversing amounts.


GLC-UNIT-CNTRL-CR      Signed 15.2                               GL190   GL500
Element: Auto Credits  The journal entry total for negative
                       detail unit balances.

GLC-UNIT-ENTRY-DB      Signed 15.2                               GL146   GL167
Element: Auto Debits   The total positive detail auto            GL190   GL191
                       reversing amounts.                        GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLC-UNIT-ENTRY-CR      Signed 15.2                               GL146   GL167
Element: Auto Credits  The total negative detail auto            GL190   GL191
                       reversing  amounts.                       GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLC-AUTO-UNIT-DB       Signed 15.2                               GL146   GL190
Element: Auto Debits   The total positive detail auto            GL191   GL197
                       reversing amounts.                        GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLC-AUTO-UNIT-CR       Signed 15.2                               GL146   GL190
Element: Auto Credits  The total negative detail auto            GL191   GL197
                       reversing  amounts.                       GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLC-DATE               Numeric 8  (yyyymmdd)                     GL148   GL167
Element: Date          This field displays the system date       GL191   GL196
                       when this was created.                    GL197   GL199
                                                                 GL40.2  GL40.6
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLC-LINE-NBR           Numeric 6                                 GL146   GL148
Element: Line Number   This field contains the line number.      GL167   GL190
                                                                 GL191   GL196
                                                                 GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLC-NBR-LINES          Numeric 6                                 GL146   GL148
Element: Number of LineThis is the number of detail lines.       GL167   GL190
                                                                 GL191   GL197
                                                                 GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLC-OPERATOR           Alpha 10                                  GL146   GL148
Element: Operator      This field is used to store the login     GL167   GL191
                       ID of the person who entered the record.  GL196   GL197
                                                                 GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLC-REL-OPERATOR       Alpha 10                                  GL199   GL40.6
Element: Release OperatThe operator ID assigned to the           GL500   IFGT.1
                       released journal entry.


GLC-RELEASED-FLAG      Alpha 1                                   GL190   GL199
Element: Released Flag This flag is set to Yes when a Journal    GL40.6  GL500
                       Entry is Released. If the Journal Entry   IFGT.1
                       is Unreleased this flag will not be
                       reset, instead it is an indicator that
                       the Journal Entry had been released at
                       one time.

                       Y = Yes
                       N = No
                       S = System Generated

GLC-HOLD-CODE          Alpha 4                                   GL145   GL146
Element: Hold Code     The journal hold code.                    GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLC-PER-DATE-FLAG      Alpha 1                                   GL40.2  GL40.6
Element: Period Date FlIndicates the period or date derived.     GL45.1  GL500
                       P = Period Derived                        IFGT.1
                       D = Date Derived

GLC-POSTING-DATE       Numeric 8  (yyyymmdd)                     GL146   GL148
Element: Posting Date  The date assigned to the journal entry    GL167   GL191
                       for posting.                              GL196   GL197
                                                                 GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLC-LAST-CMT-SEQ       Numeric 4                                 GL190   GL199
Last Comment           The sequence number of the last comment   GL500
Sequence Number        for the journal entry.


GLC-LAST-LOG-SEQ       Numeric 6                                 GL146   GL148
Last Logfile           The last sequence control number.         GL190   GL191
Sequence Number                                                  GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLC-BASE-ZONE          Alpha 15                                  GL146   GL148
Element: Base Zone     The base zone as assigned for interzone   GL167   GL190
                       balance processing.                       GL191   GL196
                                                                 GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLC-BASE-DEBITS        Signed 18.2                               GL146   GL148
Element: Base Debits                                             GL167   GL190
                                                                 GL191   GL197
                                                                 GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLC-BASE-CREDITS       Signed 18.2                               GL146   GL167
Element: Base Credits                                            GL190   GL191
                                                                 GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLC-BASE-AUTO-DB       Signed 18.2                               GL146   GL190
Element: Base Auto DebiThe total positive detail auto            GL191   GL197
                       reversing amount in the company base      GL40.1  GL40.2
                       currency.                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLC-BASE-AUTO-CR       Signed 18.2                               GL146   GL190
Element: Base Auto Credits                                       GL191   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLC-BASE-ND            Numeric 1                                 GL148   GL167
Base Number of         The number of decimal positions defined   GL191   GL196
Decimals               for the company base currency.            GL197   GL199
                                                                 GL40.2  GL40.6
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLC-CURRENCY-CODE      Alpha 5                                   GL148   GL167
Element: Currency Code This field contains the company base      GL191   GL196
                       currency code established in Company      GL197   GL199
                       (GL10.1 ) unless an alternate currency    GL40.2  GL45.1
                       code is chosen on the GL40.2.             GL500   IFGT.1

GLC-BASERATE           Signed 14.7                               GL148   GL167
Element: Base Rate     The exchange rate at the time the         GL191   GL196
                       journal entry was made.  If left blank,   GL197   GL199
                       the current exchange rate defaults.       GL40.2  GL40.6
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLC-NET-BASE-AMT       Derived
Element: Net Base AmounThe net amount in the base currency.

GLC-NET-BASE-AREV      Derived
Element: Net Base ReverThe net reversed in the base currency.

GLC-DESCRIPTION        Alpha 30  (Lower Case)                    GL146   GL148
Element: Description   The company name or description.          GL167   GL191
                                                                 GL196   GL197
                                                                 GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLC-AUTO-REV           Alpha 1                                   GL146   GL148
Element: Auto Reverse  Auto reversal is the process of           GL197   GL199
                       reversing the transaction. If you select  GL40.1  GL40.2
                       auto reverse, the Lawson General Ledger   GL40.3  GL40.6
                       closing program creates a reversing       GL40.7  GL40.8
                       journal entry in the next period for      GL44.1  GL45.1
                       this transaction.                         GL500   IFGT.1
                       Y = Yes
                       N = No
                       " " = No

GLC-SOURCE-CODE        Alpha 2                                   GL146   GL196
Element: Source Code   A two-character code assigned to a        GL197   GL199
                       transaction to identify where the         GL40.1  GL40.2
                       transaction was created.                  GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500

GLC-REFERENCE          Alpha 10  (Lower Case)                    GL146   GL148
Element: Reference     The reference you enter for this          GL167   GL191
                       journal entry appears on inquiries and    GL196   GL197
                       reports.                                  GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLC-DOCUMENT-NBR       Alpha 27                                  GL146   GL197
Element: Document NumbeThe document number assigned to the       GL199   GL40.1
                       journal entry. This is used in            GL40.2  GL40.3
                       conjunction with the Journal by Document  GL40.7  GL40.8
                       option in GL10 (Company).                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLC-EFFECT-DATE        Numeric 8  (yyyymmdd)                     GL148   GL197
Element: Effective DateThe effective date.                       GL199   GL40.2
                                                                 GL500   IFGT.1

GLC-JRNL-BOOK-NBR      Alpha 12                                  GL146   GL190
Element: Journal Book  The journal book assigned to the          GL197   GL199
                       transaction.                              GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLC-TRAN-DESC-DFLT     Alpha 1                                   GL146   GL197
Transaction            The transaction description default.      GL199   GL40.1
Description            Indicates if the new journal entry is a   GL40.2  GL40.3
                       journal entry header or prior             GL40.7  GL40.8
                       transaction line.                         GL44.1  GL45.1
                       J = Journal Entry                         GL500
                       P = Prior Transaction Line

GLC-MX-VALUE           Alpha 32 Occurs 3 Times                   GL199   GL40.2
Element: Matrix Value  The attribute value.                      GL500

GLC-MX-CATEGORY-1      Derived
Element: Matrix CategorThe attribute category associated with
                       the transaction.


GLC-MX-CATEGORY-2      Derived
Element: Matrix CategorThe attribute category associated with
                       the transaction.


GLC-MX-CATEGORY-3      Derived
Element: Matrix CategorThe attribute category associated with
                       the transaction.


GLC-MX-DESC-1          Derived
Element: Description   The attribute category description.

GLC-MX-DESC-2          Derived
Element: Description   The attribute category description.

GLC-MX-DESC-3          Derived
Element: Description   The attribute category description.

GLC-CLOSE-SEQ          Numeric 2                                 GL146   GL191
Element: Close SequenceContains the closing sequence number.     GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLC-ACT-POST-DATE      Numeric 8  (yyyymmdd)                     GL146   GL190
Element: Act Post Date Contains the posting date for activity    GL197   GL40.1
                       transactions.                             GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500

GLC-JBK-SEQ-NBR        Numeric 10                                GL40.2  GL40.6
Element: Jbk Seq Nbr   The journal book sequence number          GL500   IFGT.1
                       assigned to a journal book transaction
                       when it is added or interfaced to the
                       Lawson system. Used only when  Auto
                       Journal Book Seq Nbr is set to Yes in
                       GL10.1 (Company).


GLC-JE-APPROVE-FLG     Alpha 1                                   GL146   GL170
Element: Account Flag  This indicates if the journal entry is    GL197   GL40.1
                       released.                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL41.4  GL44.1
                                                                 GL45.1  GL500
                                                                 GL75.1

GLC-SEGMENT-BLOCK      Alpha 103                                 GL40.2  GL500
Element: Segment Block This field identifies the user analysis
                       values included in the transaction.

                       You can either type up to four values
                       or use Define (F6) to open the User
                       Analysis Entry subform. Use this subform
                       to select the user analysis values you
                       want to include in the transaction. If
                       you choose to type values, use commas to
                       separate them. For example:
                       value1,value2,value3,value4

                       There are three conditions that affect
                       how you can select user analysis values.
                       See the User Analysis Entry form help or
                       the Strategic Ledger procedures manual
                       for additional information.

GLC-WF-JE-CTRL-NBR     Derived
Element: Wf Je Ctrl NbrThe workflow journal entry number.

GLC-AUTO-REV-PD        Numeric 2                                 GL146   GL197
Element: Auto Rev Pd                                             GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 IFGT.1

GLC-REVERSE            Alpha 1                                   GL190   GL500
Element: Reverse       This field indicates if a reversing
                       journal entry will be created by GL199
                       for this journal entry.

GLC-HOLD-REM-OPER      Alpha 10                                  GL145   GL40.2
Element: Operator      This field is used to store the login     GL45.1
                       id of the person who entered the record.


GLC-BLANK              Derived
Element: Blankam       This field consists of blank spaces. It
                       is used to provide column headings on
                       Drill Arounds.


                         GLCONTROL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GLCSET1   COMPANY                                                CA15.1  CA15.2
          FISCAL-YEAR                                            CA190   FB11.1
          ACCT-PERIOD                                            FB111   FB160
          SYSTEM                                                 FB211   FB296
          JE-TYPE                                                FB60.1  FB95.1
          CONTROL-GROUP                                          FB95.2  FB95.3
          JE-SEQUENCE                                            FB95.4  FB95.5
                                                                 FB95.6  GL110
                                                                 GL146   GL167
                                                                 GL170   GL190
                                                                 GL191   GL196
                                                                 GL197   GL199
                                                                 GL240   GL241
                                                                 GL245   GL247
                                                                 GL256   GL270
                                                                 ...

GLCSET2   COMPANY       KeyChange                                GL110   GL146
          FISCAL-YEAR                                            GL199   GL240
          ACCT-PERIOD                                            GL300   GL45.1
          STATUS                                                 GL500
          SYSTEM
          CONTROL-GROUP
          JE-TYPE
          JE-SEQUENCE

GLCSET3   COMPANY       KeyChange, Subset                        GL167
          SYSTEM        Where STATUS = 3
          FISCAL-YEAR
          ACCT-PERIOD
          JE-TYPE
          CONTROL-GROUP
          JE-SEQUENCE

GLCSET4   COMPANY       Subset                                   GL240   GL40.1
          FISCAL-YEAR   Where((STATUS = Zeroes )                 GL40.2
          ACCT-PERIOD   Or    (STATUS = 6 ))
          SYSTEM
          JE-TYPE
          CONTROL-GROUP
          JE-SEQUENCE

GLCSET5   COMPANY       KeyChange, Subset                        GL145   GL45.1
          HOLD-CODE     Where HOLD-CODE != Spaces                GL12.1  GL12.2
          FISCAL-YEAR
          ACCT-PERIOD
          STATUS
          SYSTEM
          JE-TYPE
          CONTROL-GROUP
          JE-SEQUENCE

GLCSET6   COMPANY       KeyChange                                GL199
          FISCAL-YEAR
          ACCT-PERIOD
          CLOSE-SEQ
          SYSTEM
          JE-TYPE
          CONTROL-GROUP
          JE-SEQUENCE

                         GLCONTROL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        GLSYSTEM     Required

                            GLC-COMPANY          -> GLS-COMPANY

Cucontrol One  CUCONTROL    Not Required

                            GLC-COMPANY          -> CLC-COMPANY
                            GLC-FISCAL-YEAR      -> CLC-FISCAL-YEAR
                            GLC-ACCT-PERIOD      -> CLC-ACCT-PERIOD
                            GLC-SYSTEM           -> CLC-SYSTEM
                            GLC-JE-TYPE          -> CLC-JE-TYPE
                            GLC-CONTROL-GROUP    -> CLC-CONTROL-GROUP
                            GLC-JE-SEQUENCE      -> CLC-JE-SEQUENCE
                            1                    -> CLC-AMT-TYPE
                            GLS-CURR-CODE-1      -> CLC-CURRENCY-CODE

Cucontrol Two  CUCONTROL    Not Required

                            GLC-COMPANY          -> CLC-COMPANY
                            GLC-FISCAL-YEAR      -> CLC-FISCAL-YEAR
                            GLC-ACCT-PERIOD      -> CLC-ACCT-PERIOD
                            GLC-SYSTEM           -> CLC-SYSTEM
                            GLC-JE-TYPE          -> CLC-JE-TYPE
                            GLC-CONTROL-GROUP    -> CLC-CONTROL-GROUP
                            GLC-JE-SEQUENCE      -> CLC-JE-SEQUENCE
                            2                    -> CLC-AMT-TYPE
                            GLS-CURR-CODE-2      -> CLC-CURRENCY-CODE

Glholdcode     GLHOLDCODE   Not Required

                            GLC-HOLD-CODE        -> GLH-HOLD-CODE

Glsccat 1      GLSCCAT      Not Required

                            GLC-SOURCE-CODE      -> GSC-SOURCE-CODE
                            1                    -> GSC-SEQ-NBR

Glsccat 2      GLSCCAT      Not Required

                            GLC-SOURCE-CODE      -> GSC-SOURCE-CODE
                            2                    -> GSC-SEQ-NBR

Glsccat 3      GLSCCAT      Not Required

                            GLC-SOURCE-CODE      -> GSC-SOURCE-CODE
                            3                    -> GSC-SEQ-NBR

Glsrccode      GLSRCCODE    Not Required

                            GLC-SOURCE-CODE      -> GSR-SOURCE-CODE

Glsysje        GLSYSJE      Not Required

                            GLC-COMPANY          -> GSJ-COMPANY
                            GLC-SYSTEM           -> GSJ-SYSTEM
                            GLC-FISCAL-YEAR      -> GSJ-FISCAL-YEAR
                            GLC-ACCT-PERIOD      -> GSJ-ACCT-PERIOD

Mxcatdef 1     MXCATDEF     Required

                            GSC-MATRIX-CAT       -> MXC-MATRIX-CAT

Mxcatdef 2     MXCATDEF     Not Required

                            GSC-MATRIX-CAT       -> MXC-MATRIX-CAT

Mxcatdef 3     MXCATDEF     Not Required

                            GSC-MATRIX-CAT       -> MXC-MATRIX-CAT

System         GLCODES      Not Required

                            GLC-COMPANY          -> GCD-COMPANY
                            GLC-SYSTEM           -> GCD-SYSTEM

                         GLCONTROL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Gljelog        GLJELOG

                            GLC-COMPANY          -> GJL-COMPANY
                            GLC-FISCAL-YEAR      -> GJL-FISCAL-YEAR
                            GLC-ACCT-PERIOD      -> GJL-ACCT-PERIOD
                            GLC-SYSTEM           -> GJL-SYSTEM
                            GLC-JE-TYPE          -> GJL-JE-TYPE
                            GLC-CONTROL-GROUP    -> GJL-CONTROL-GROUP
                            GLC-JE-SEQUENCE      -> GJL-JE-SEQUENCE
                                                    GJL-LINE-NBR
                                                    GJL-LOG-SEQ-NBR

Gljelog Cntrl  GLJELOG

                            GLC-COMPANY          -> GJL-COMPANY
                            GLC-FISCAL-YEAR      -> GJL-FISCAL-YEAR
                            GLC-ACCT-PERIOD      -> GJL-ACCT-PERIOD
                            GLC-SYSTEM           -> GJL-SYSTEM
                            GLC-JE-TYPE          -> GJL-JE-TYPE
                            GLC-CONTROL-GROUP    -> GJL-CONTROL-GROUP
                            GLC-JE-SEQUENCE      -> GJL-JE-SEQUENCE
                            Zeroes               -> GJL-LINE-NBR
                                                    GJL-LOG-SEQ-NBR

Gljelog Line   GLJELOG

                            GLC-COMPANY          -> GJL-COMPANY
                            GLC-FISCAL-YEAR      -> GJL-FISCAL-YEAR
                            GLC-ACCT-PERIOD      -> GJL-ACCT-PERIOD
                            GLC-SYSTEM           -> GJL-SYSTEM
                            GLC-JE-TYPE          -> GJL-JE-TYPE
                            GLC-CONTROL-GROUP    -> GJL-CONTROL-GROUP
                            GLC-JE-SEQUENCE      -> GJL-JE-SEQUENCE
                                                    GJL-LINE-NBR
                                                    GJL-LOG-SEQ-NBR

Gltrans        GLTRANS      Delete Cascades

                            GLC-COMPANY          -> GLT-COMPANY
                            GLC-FISCAL-YEAR      -> GLT-FISCAL-YEAR
                            GLC-ACCT-PERIOD      -> GLT-ACCT-PERIOD
                            GLC-CONTROL-GROUP    -> GLT-CONTROL-GROUP
                            GLC-SYSTEM           -> GLT-SYSTEM
                            GLC-JE-TYPE          -> GLT-JE-TYPE
                            GLC-JE-SEQUENCE      -> GLT-JE-SEQUENCE
                                                    GLT-LINE-NBR