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     FB211
FB296     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    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     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     GL700     GL75.1    IFGT.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GLC-COMPANY            Numeric 4                                 GL110   GL167
Element: Company       The company number represents an          GL191   GL196
                       established company and is entered on     GL197   GL199
                       all function codes.                       GL40.2  GL40.6
                                                                 GL41.4  GL45.1
                                                                 GL500   GLCC.1
                                                                 IFGT.1

GLC-FISCAL-YEAR        Numeric 4                                 GL167   GL191
Element: Fiscal Year   This is the current fiscal year.  This    GL196   GL197
                       field is updated by Period Closing        GL199   GL40.2
                       (GL199).                                  GL40.6  GL41.4
                                                                 GL45.1  GL500
                                                                 GLCC.1  IFGT.1

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

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

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

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


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

GLC-JE-SEQUENCE        Numeric 2                                 GL146   GL167
Journal Entry          The unique journal entry sequence         GL190   GL191
Sequence               number.                                   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   GL167
Element: Status        This field contains the processing        GL190   GL191
                       cycle status of the assigned journal      GL196   GL197
                       entry.                                    GL199   GL40.1
                                                                 GL40.2  GL40.3
                       0 = Unreleased                            GL40.6  GL40.7
                       1 = Released                              GL40.8  GL44.1
                       2 = Post In Progress                      GL45.1  GL500
                       3 = Load In Process                       IFGT.1
                       4 = Quick Posted
                       5 = Posted
                       9 = History

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


GLC-CNTRL-AMOUNT       Signed 15.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 15.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 15.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                                 GL167   GL191
Trans Number of                                                  GL196   GL197
Decimals                                                         GL199   GL40.2
                                                                 GL40.5  GL41.3
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLC-UNIT-CNTRL-DB      Signed 15.2                               GL190   GL500
Element: Auto Debits

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                                             GL190   GL191
                                                                 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                                            GL190   GL191
                                                                 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                                             GL191   GL197
                                                                 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                                            GL191   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

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

GLC-LINE-NBR           Numeric 6                                 GL146   GL167
Element: Line Number   This field contains the line number.      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   GL167
Element: Number of LineThis is the number of detail lines.       GL190   GL191
                                                                 GL196   GL197
                                                                 GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLC-OPERATOR           Alpha 10                                  GL146   GL167
Element: Operator      This field is used to store the login     GL191   GL196
                       ID of the person who entered the record.  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   GL167
Element: Posting Date                                            GL191   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                                                     GL500
Sequence Number

GLC-LAST-LOG-SEQ       Numeric 6                                 GL146   GL190
Last Logfile           The last sequence control number.         GL191   GL197
Sequence Number                                                  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   GL167
Element: Base Zone     The base zone as assigned for interzone   GL191   GL196
                       balance processing.                       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 15.2                               GL146   GL167
Element: Base Debits                                             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 15.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 15.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 15.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                                 GL167   GL191
Base Number of                                                   GL196   GL197
Decimals                                                         GL199   GL40.2
                                                                 GL40.6  GL45.1
                                                                 GL500   IFGT.1

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

GLC-BASERATE           Signed 12.6                               GL167   GL191
Element: Base Rate     The exchange rate at the time the         GL196   GL197
                       journal entry was made.  If left blank,   GL199   GL40.2
                       the current exchange rate defaults.       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   GL167
Element: Description   The company name or description.          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   GL197
Element: Auto Reverse  Auto reversal is the process of           GL199   GL40.1
                       reversing the transaction. If you select  GL40.2  GL40.3
                       auto reverse, the Lawson General Ledger   GL40.7  GL40.8
                       closing program creates a reversing       GL44.1  GL45.1
                       journal entry in the next period for      GL500   IFGT.1
                       this transaction.

                       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   GL167
Element: Reference     The reference you enter for this          GL191   GL196
                       journal entry appears on inquiries and    GL197   GL199
                       reports.                                  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)                     GL197   GL199
Element: Effective DateThe effective date.                       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
                                                                 GL500
                       J = Journal Entry
                       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.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500

GLC-JBK-SEQ-NBR        Numeric 10                                GL40.2  GL40.6
Journal Book           The journal book sequence number          IFGT.1
Sequence Number        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  GL75.1

GLC-SEGMENT-BLOCK      Alpha 103                                 GL40.2
Element: User Analysis 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   GL700
Element: Reverse       This field indicates if a reversing
                       journal entry will be created by GL199
                       for this journal entry.

                         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   FB211
          SYSTEM                                                 FB296   FB95.1
          JE-TYPE                                                FB95.2  FB95.3
          CONTROL-GROUP                                          FB95.4  FB95.5
          JE-SEQUENCE                                            FB95.6  GL110
                                                                 GL146   GL167
                                                                 GL170   GL190
                                                                 GL191   GL196
                                                                 GL197   GL199
                                                                 GL240   GL241
                                                                 GL245   GL247
                                                                 GL256   GL270
                                                                 GL284   GL285
                                                                 ...

GLCSET2   COMPANY       KeyChange                                GL110   GL146
          FISCAL-YEAR                                            GL199   GL240
          ACCT-PERIOD                                            GL300   GL45.1
          STATUS                                                 GL500   GL700
          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
          FISCAL-YEAR   Where STATUS = Zeroes
          ACCT-PERIOD
          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