Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLTRANS


                              GLTRANS FILE

                      General Ledger Transactions

The General Ledger Transaction file contains the journal entry detail
information to be posted to the Lawson General Ledger system. The transactions
are not deleted when posted and GL300 (General Ledger History Delete) should
be run to clear out information no longer needed.


REFERENCED BY

CA195     FB100     FB101     FB120     FB121     FB122
FB145     FB165     FB190     FB20.1    FB20.3    FB20.4
FB20.6    FB20.7    FB21.1    FB30.1    FB31.1    FB40.1
FB40.2    FB40.3    FB45.1    GL145     GL170     GL240
GL241     GL256     GL284     GL285     GL286     GL287
GL288     GL289     GL297     GL41.1    GL41.3    JB240
GL10.1    GL135     GL290     GL325     GL327     GL235
GL326     GL328     PO135     AC191     AC40.4    AC41.4
AC42.1    AP125     AP126     AP25.1    AP25.2    AP26.1
AP27.1    AP30.2    BR41.4    BR44.1    CB10.1    CB15.1
CB15.2    CB191     CB20.1    CB30.1    CB500     EE135
EE35.1    EE35.2    EE520     CA110     FB11.1    FB111
FB160     FB211     FB296     FB60.1    FB95.1    FB95.2
FB95.3    FB95.4    FB95.5    FB95.6    GL165     GL298
GL65.1    GL70.1    GL70.2    GL70.3    GL70.5    GL70.6
GL75.1    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
RW80.1    IC222     GLRV.1    IFAC.1    PO150     PO25.1
PO25.6    PO25.7    PO536     POIM.1

UPDATED BY

AC145     AC45.1    GL110     GL120     GL146     GL147
GL148     GL167     GL190     GL191     GL196     GL197
GL199     GL310     GL40.1    GL40.2    GL40.3    GL40.6
GL40.7    GL40.8    GL44.1    GL45.1    GL500     GL90.4
IFGT.1    MM280     GL300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GLT-COMPANY            Numeric 4                                 AC45.1  GL110
Element: Company       This is the company into which the        GL146   GL148
                       transactions are to be interfaced. For    GL167   GL190
                       intercompany processing, this field is    GL191   GL196
                       considered the originating company. Must  GL197   GL199
                       be defined in GLSYSTEM.                   GL290   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLT-FISCAL-YEAR        Numeric 4                                 GL146   GL148
Element: Fiscal Year   This is the current fiscal year.  This    GL167   GL190
                       field is updated by Period Closing        GL191   GL196
                       (GL199).                                  GL197   GL199
                                                                 GL290   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

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

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

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

GLT-JE-TYPE            Alpha 1                                   GL146   GL148
Element: Journal Entry The journal entry type.                   GL167   GL190
                       N = Normal                                GL191   GL196
                       I = Intercompany                          GL197   GL199
                       A = A/R Normal                            GL290   GL40.1
                       R = A/R Intercpy                          GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLT-JE-TYPE-1          Derived
Element: Journal Entry The journal entry type.

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

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

GLT-OBJ-ID             Numeric 12                                GL110   GL146
Element: Object ID     Contains the object ID sequence number.   GL148   GL167
                       Ensures that the subsystem transaction    GL190   GL191
                       is sent to the Lawson General Ledger      GL196   GL197
                       system.                                   GL199   GL290
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLT-STATUS             Numeric 1                                 GL146   GL148
Element: Status        This field displays the status of the     GL167   GL190
                       transaction.                              GL191   GL196
                       0 = Unrel                                 GL197   GL199
                       1 = Rel                                   GL290   GL40.1
                       5 = ERROR                                 GL40.2  GL40.3
                       8 = Memo                                  GL40.6  GL40.7
                       9 = Hist                                  GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLT-VAR-LEVELS         Alpha 30                                  GL120   GL146
Element: Variable LevelA level that represents the location of   GL148   GL167
                       an accounting unit in an organization's   GL190   GL191
                       level structure.                          GL196   GL197
                                                                 GL199   GL290
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLT-ACCT-UNIT          Alpha 15                                  AC45.1  GL146
Element: Accounting UniThe accounting unit is a shorthand        GL148   GL167
                       notation representing the variable level  GL190   GL191
                       number. When used in the General Ledger   GL196   GL197
                       Account Master file, the accounting unit  GL199   GL290
                       must be defined in the General Ledger     GL40.1  GL40.2
                       Names file as a posting accounting unit.  GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLT-ACCOUNT            Numeric 6                                 AC45.1  GL146
Element: Account       This field along with the accounting      GL148   GL167
                       unit and subaccount make up the location  GL190   GL191
                       (account) where amounts and other         GL196   GL197
                       account information is stored.            GL199   GL290
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLT-SUB-ACCOUNT        Numeric 4                                 AC45.1  GL146
Element: Subaccount    This field along with the accounting      GL148   GL167
                       unit and account make up the location     GL190   GL191
                       (account) where amounts and other         GL196   GL197
                       account information is stored.            GL199   GL290
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

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

GLT-DATE               Numeric 8  (yyyymmdd)                     GL146   GL148
Element: Date          Contains the system creation date.        GL167   GL190
                                                                 GL191   GL196
                                                                 GL197   GL199
                                                                 GL290   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLT-REFERENCE          Alpha 10  (Lower Case)                    GL146   GL148
Element: Reference     The reference number associated with      GL167   GL190
                       the transaction.                          GL191   GL196
                                                                 GL197   GL199
                                                                 GL290   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLT-DESCRIPTION        Alpha 30  (Lower Case)                    GL146   GL148
Element: Description   Contains the transaction description.     GL167   GL190
                                                                 GL191   GL196
                                                                 GL197   GL199
                                                                 GL290   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLT-SHORT-DESC         Derived
Element: Short DescriptContains the short description.

GLT-BASE-AMOUNT        Signed 18.2                               GL146   GL148
Element: Base Amount   The company base amount.                  GL167   GL190
                                                                 GL191   GL196
                                                                 GL197   GL199
                                                                 GL284   GL285
                                                                 GL286   GL287
                                                                 GL289   GL290
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.5
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL41.3
                                                                 GL44.1  GL45.1
                                                                 GL500   GL90.1
                                                                 GL90.2  GL90.4
                                                                 GL90.6  IFGT.1

GLT-BASE-ND            Numeric 1                                 GL146   GL148
Base Number of         The number of decimal positions defined   GL167   GL190
Decimals               for the company base currency.            GL191   GL196
                                                                 GL197   GL199
                                                                 GL290   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLT-UNITS-AMOUNT       Signed 15.2                               GL146   GL167
Element: Units Amount  Contains the units amount associated      GL190   GL191
                       with the transaction.                     GL196   GL197
                                                                 GL199   GL290
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.5
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL41.3
                                                                 GL44.1  GL45.1
                                                                 GL500   GL90.1
                                                                 GL90.2  GL90.5
                                                                 GL90.6  IFGT.1

GLT-AUTO-REV           Alpha 1                                   GL146   GL148
Element: Auto Reverse  When the Auto Reversal field is set to    GL167   GL190
                       "Y," the Lawson General Ledger Closing    GL191   GL197
                       program (GL199) creates an opposite       GL199   GL290
                       entry  for this transaction in the next   GL40.1  GL40.2
                       period.                                   GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                       Y = Yes                                   GL45.1  GL500
                       N = No                                    IFGT.1

GLT-TO-COMPANY         Numeric 4                                 GL110   GL146
Element: To Company    The company number to which the           GL148   GL167
                       transaction line is posted.               GL190   GL191
                                                                 GL196   GL197
                                                                 GL199   GL290
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLT-BASE-ZONE          Alpha 15                                  GL146   GL148
Element: Base Zone     The zone within the Lawson General        GL167   GL190
                       Ledger System where the transaction       GL191   GL197
                       originating.                              GL290   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

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

GLT-ACTIVITY           Alpha 15                                  AC145   AC45.1
Element: Activity      Activities are the processes or           GL146   GL148
                       procedures that produce work. Cost        GL190   GL191
                       objects (products, services, customers,   GL197   GL290
                       and so on) are the reasons for            GL40.1  GL40.2
                       performing the activity.                  GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  MM280

GLT-ACCT-CATEGORY      Alpha 5                                   AC145   AC45.1
Element: Account CategoAccount categories are groupings of       GL146   GL148
                       costs, revenues, or a combination of      GL191   GL197
                       both used for reporting and inquiries     GL40.1  GL40.2
                       for activities in the Activity            GL40.3  GL40.7
                       Management system. All transactions are   GL40.8  GL44.1
                       posted to an account category within an   GL45.1  GL500
                       activity. You can assign a specific       IFGT.1  MM280
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

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

GLT-BASERATE           Signed 14.7                               GL146   GL148
Element: Base Rate     The exchange rate at the time the         GL167   GL190
                       journal entry was made. If left blank,    GL191   GL196
                       the current exchange rate will default.   GL197   GL199
                                                                 GL290   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLT-TRAN-AMOUNT        Signed 18.2                               GL146   GL148
Element: Transaction AmThis is the amount in transaction         GL167   GL190
                       currency to be posted. This amount        GL191   GL196
                       creates a CUAMOUNT type 1 record.         GL197   GL199
                                                                 GL290   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.5  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL41.3  GL44.1
                                                                 GL45.1  GL500
                                                                 GL90.1  GL90.2
                                                                 GL90.4  GL90.5
                                                                 GL90.6  IFGT.1

GLT-TRAN-ND            Numeric 1                                 GL146   GL167
Transaction Number     The number of decimal positions defined   GL190   GL191
of Decimals            for the transaction currency.             GL196   GL197
                                                                 GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLT-ACCT-CURRENCY      Alpha 5                                   GL146   GL167
Element: Account CurrenThe account currency code.                GL190   GL191
                                                                 GL196   GL197
                                                                 GL290   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLT-ACCT-RATE          Signed 14.7                               GL146   GL167
Element: Account Rate  The account exchange rate.                GL190   GL191
                                                                 GL196   GL197
                                                                 GL290   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLT-ACCT-AMOUNT        Signed 18.2                               GL146   GL167
Element: Account AmountThe account amount.                       GL190   GL191
                                                                 GL196   GL197
                                                                 GL290   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GL90.1  GL90.2
                                                                 GL90.6  IFGT.1

GLT-ACCT-ND            Numeric 1                                 GL146   GL167
Account Number of      The number of decimals assigned to a      GL190   GL191
Decimals               particular account as determined by the   GL196   GL197
                       account currency.                         GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLT-ORIG-COMPANY       Numeric 4                                 GL110   GL146
Element: Originating CoThe originating company number.           GL148   GL167
                                                                 GL190   GL191
                                                                 GL196   GL197
                                                                 GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLT-ORIG-PROGRAM       Alpha 5                                   GL146   GL148
Element: Originating PrThe system code where the transaction     GL167   GL191
                       was originally created.                   GL196   GL197
                                                                 GL290   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

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

GLT-TO-BASE-AMT        Signed 18.2                               GL146   GL148
Element: To Base AmountTo company base amount.                   GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.5  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL41.3  GL44.1
                                                                 GL45.1  GL500
                                                                 GL90.2  IFGT.1

GLT-TO-BASE-ND         Numeric 1                                 GL146   GL148
To Base Number of      To company base number of decimals.       GL197   GL240
Decimals                                                         GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLT-TO-BASERATE        Signed 14.7                               GL146   GL148
Element: To Base Rate  To company base rate.                     GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLT-TO-BASE-CURR       Alpha 5                                   GL146   GL148
Element: To Base CurrenTo company base currency.                 GL167   GL190
                                                                 GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLT-RECONCILE          Alpha 2                                   GL290   GL500
Element: Reconcile     Indicates the reconciliation of           GL90.4
                       transactions.


GLT-NEGATIVE-ADJ       Alpha 1                                   GL146   GL148
Element: Negative AdjusIndicates a negative adjustment.          GL167   GL190
                       Y = -                                     GL196   GL197
                       N                                         GL290   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLT-EFFECT-DATE        Numeric 8  (yyyymmdd)                     GL146   GL148
Element: Effective DateThe effective date of the transaction.    GL167   GL190
                       Used for calculating average daily        GL191   GL197
                       balances.                                 GL199   GL290
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLT-UPDATE-DATE        Numeric 8  (yyyymmdd)                     GL146   GL190
Element: Update Date   This field contains the date the record   GL197   GL199
                       was posted. Used by Average Daily         GL290   GL40.1
                       Balance to track day-to-day activity      GL40.2  GL40.3
                       changes.                                  GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500

GLT-SEQ-TRNS-NBR       Numeric 10                                GL146   GL147
Sequence               Contains the journal entry transaction    GL190   GL197
Transaction Number     sequence number.                          GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500

GLT-JBK-TRNS-NBR       Numeric 10                                GL146   GL190
Journal Book Trans     Contains the journal book transaction     GL197   GL199
Nbr                    number.                                   GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500

GLT-CONSOL-AC-FLAG     Alpha 1                                   GL110   GL500
Element: Consol Ac FlagThis field indicates whether the          IFGT.1
                       transaction has several Activities
                       associated to it. If this flag is set to
                       (Y)es than the Activity value will be
                       spaces.

                       " " = No
                       Y = Yes

GLT-CT-FR-COMPANY      Numeric 4                                 GL500   IFGT.1
Element: Company       This is the company whose currency was
                       converted using GL195 or GL135.


GLT-RPT-AMOUNT-1       Signed 18.2                               GL146   GL148
Element: Intl Amt      The transaction amount for Report         GL167   GL190
                       Currency 1.                               GL191   GL196
                                                                 GL197   GL199
                                                                 GL290   GL310
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   GL90.1
                                                                 GL90.2  GL90.4
                                                                 GL90.6  IFGT.1

GLT-RPT-RATE-1         Signed 14.7                               GL146   GL148
Element: Currency Rate The exchange rate to convert the          GL167   GL190
                       transaction amount to Report Currency 1.  GL191   GL197
                       The exchange rate is defined in CU10.1    GL199   GL290
                       (Exchange Rate).                          GL310   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLT-RPT-ND-1           Numeric 1                                 GL146   GL148
Account Currency       The number of decimal positions for       GL167   GL190
Code                   Report Currency 1.                        GL191   GL196
                                                                 GL197   GL199
                                                                 GL290   GL310
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GLT-RPT-AMOUNT-2       Signed 18.2                               GL146   GL148
Element: Intl Amt      The transaction amount for Report         GL167   GL190
                       Currency 2.                               GL191   GL196
                                                                 GL197   GL199
                                                                 GL290   GL310
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   GL90.1
                                                                 GL90.2  GL90.4
                                                                 GL90.6  IFGT.1

GLT-RPT-RATE-2         Signed 14.7                               GL146   GL148
Element: Currency Rate The exchange rate to convert the          GL167   GL190
                       transaction amount to Report Currency 2.  GL191   GL197
                       The exchange rate is defined in CU10.1    GL199   GL290
                       (Exchange Rate).                          GL310   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GLT-RPT-ND-2           Numeric 1                                 GL146   GL148
Account Currency       The number of decimal positions for       GL167   GL190
Code                   Report Currency 2.                        GL191   GL196
                                                                 GL197   GL199
                                                                 GL290   GL310
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

                         GLTRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GLTSET1   COMPANY                                                AC145   AC45.1
          FISCAL-YEAR                                            CA195   FB100
          ACCT-PERIOD                                            FB101   FB120
          CONTROL-GROUP                                          FB121   FB122
          SYSTEM                                                 FB145   FB165
          JE-TYPE                                                FB190   FB20.1
          JE-SEQUENCE                                            FB20.3  FB20.4
          LINE-NBR                                               FB20.6  FB20.7
                                                                 FB21.1  FB30.1
                                                                 FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL110
                                                                 GL145   GL146
                                                                 GL167   GL170
                                                                 GL190   GL191
                                                                 ...

GLTSET2   TO-COMPANY    KeyChange, Subset                        GL120   GL135
          FISCAL-YEAR   Where STATUS != 8                        GL147   GL199
          ACCT-PERIOD                                            GL256   GL290
          ACCT-UNIT                                              GL325   GL327
          ACCOUNT
          SUB-ACCOUNT
          POSTING-DATE
          SYSTEM
          CONTROL-GROUP
          JE-TYPE
          LINE-NBR
          COMPANY
          JE-SEQUENCE

GLTSET3   TO-COMPANY    KeyChange, Subset                        GL235   GL326
          ACCOUNT       Where STATUS != 8                        GL328   GL90.1
          SUB-ACCOUNT                                            GL90.2  GL90.4
          ACCT-UNIT                                              GL90.5  GL90.6
          FISCAL-YEAR
          ACCT-PERIOD
          SYSTEM
          CONTROL-GROUP
          JE-TYPE
          JE-SEQUENCE
          LINE-NBR
          COMPANY

GLTSET6   TO-COMPANY    KeyChange, Subset                        GL256   GL290
          FISCAL-YEAR   Where STATUS != 8
          ACCT-PERIOD
          ACCOUNT
          SUB-ACCOUNT
          ACCT-UNIT
          OBJ-ID

GLTSET7   OBJ-ID                                                 AC145   AC45.1
                                                                 GL146   GL147
                                                                 GL190   GL197
                                                                 GL256   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 IFGT.1  PO135
                                                                 MM280

GLTSET8   COMPANY       KeyChange, Subset                        AC191   AC40.4
          VAR-LEVELS    Where STATUS = 1                         AC41.4  AC42.1
          ACCT-UNIT                                              AP125   AP126
          ACCOUNT                                                AP25.1  AP25.2
          SUB-ACCOUNT                                            AP26.1  AP27.1
          FISCAL-YEAR                                            AP30.2  BR41.4
          ACCT-PERIOD                                            BR44.1  CB10.1
          SYSTEM                                                 CB15.1  CB15.2
          OBJ-ID                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 CA110   FB11.1
                                                                 FB111   FB145
                                                                 FB160   FB190
                                                                 ...

                         GLTRANS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Account        GLMASTER     Required

                            GLT-TO-COMPANY       -> GLM-COMPANY
                            GLT-ACCT-UNIT        -> GLM-ACCT-UNIT
                            GLT-ACCOUNT          -> GLM-ACCOUNT
                            GLT-SUB-ACCOUNT      -> GLM-SUB-ACCOUNT

Activity       ACACTIVITY   Not Required

                            GLT-ACTIVITY         -> ACV-ACTIVITY

Category 1     GLSCCAT      Not Required

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

Category 3     GLSCCAT      Not Required

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

Categroy 2     GLSCCAT      Not Required

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

Chart Detail   GLCHARTDTL   Not Required

                            GLS-CHART-NAME       -> GDT-CHART-NAME
                            GLT-ACCOUNT          -> GDT-ACCOUNT
                            GLT-SUB-ACCOUNT      -> GDT-SUB-ACCOUNT

Company        GLSYSTEM     Required

                            GLT-COMPANY          -> GLS-COMPANY

Cuamountx 3    CUAMOUNTX    Not Required

                            GLT-COMPANY          -> CAX-COMPANY
                            "3"                  -> CAX-AMT-TYPE
                            GLT-FISCAL-YEAR      -> CAX-FISCAL-YEAR
                            GLT-ACCT-UNIT        -> CAX-ACCT-UNIT
                            GLT-ACCOUNT          -> CAX-ACCOUNT
                            GLT-SUB-ACCOUNT      -> CAX-SUB-ACCOUNT
                            GLT-POSTING-DATE     -> CAX-DATE

Cuamountx 4    CUAMOUNTX    Not Required

                            GLT-COMPANY          -> CAX-COMPANY
                            "4"                  -> CAX-AMT-TYPE
                            GLT-FISCAL-YEAR      -> CAX-FISCAL-YEAR
                            GLT-ACCT-UNIT        -> CAX-ACCT-UNIT
                            GLT-ACCOUNT          -> CAX-ACCOUNT
                            GLT-SUB-ACCOUNT      -> CAX-SUB-ACCOUNT
                            GLT-POSTING-DATE     -> CAX-DATE

Fbfunddtl      FBFUNDDTL    Required

                            GLT-COMPANY          -> FUD-COMPANY
                            GLT-ACCOUNT          -> FUD-ACCOUNT
                            GLT-SUB-ACCOUNT      -> FUD-SUB-ACCOUNT
                            GLT-ACCT-UNIT        -> FUD-ACCT-UNIT

Glamountsx     GLAMOUNTSX   Not Required

                            GLT-COMPANY          -> GAX-COMPANY
                            GLT-POSTING-DATE     -> GAX-DATE
                            GLT-ACCT-UNIT        -> GAX-ACCT-UNIT
                            GLT-ACCOUNT          -> GAX-ACCOUNT
                            GLT-SUB-ACCOUNT      -> GAX-SUB-ACCOUNT

Glcondrill     GLCONDRILL   Required

                            GLT-OBJ-ID           -> GLD-GLT-OBJ-ID

Glcontrol      GLCONTROL    Required

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

Glholdcode     GLHOLDCODE   Not Required

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

Glsegblock     GLSEGBLOCK   Not Required

                            GLT-OBJ-ID           -> GSB-GLT-OBJ-ID

Glsrccode      GLSRCCODE    Required

                            GLT-SOURCE-CODE      -> GSR-SOURCE-CODE

Glsystem       GLSYSTEM     Required

                            GLT-COMPANY          -> GLS-COMPANY

Rjbridge       RJBRIDGE     Not Required

                            "GLTRN"              -> RJB-OBJ-TYPE
                            GLT-OBJ-ID           -> RJB-OBJ-ID

Rjcontrol      RJCONTROL    Not Required

                            GLT-COMPANY          -> RJC-COMPANY
                            GLT-JE-TYPE          -> RJC-JE-TYPE
                            GLT-CONTROL-GROUP    -> RJC-REC-GROUP

Rjcontrol Intf RJCONTROL    Not Required

                            GLT-COMPANY          -> RJC-COMPANY
                            RJB-JE-TYPE          -> RJC-JE-TYPE
                            RJB-REC-GROUP        -> RJC-REC-GROUP

Source Code    GLCODES      Not Required

                            "S"                  -> GCD-RECORD-TYPE
                            Spaces               -> GCD-FOLDER-NAME
                            Spaces               -> GCD-PROCESS-GROUP
                            GLT-SOURCE-CODE      -> GCD-SYSTEM
                            Zeroes               -> GCD-COMPANY

To Company     GLSYSTEM     Required

                            GLT-TO-COMPANY       -> GLS-COMPANY

                         GLTRANS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Actrans        ACTRANS

                            GLT-OBJ-ID           -> ATN-GLT-OBJ-ID
                                                    ATN-OBJ-ID

Amtrans        AMTRANS

                            GLT-OBJ-ID           -> AMT-GLT-OBJ-ID
                                                    AMT-ASSET
                                                    AMT-SEQ-NUMBER

Apapdhist      APAPDHIST

                            GLT-OBJ-ID           -> AH2-GLT-OBJ-ID
                                                    AH2-API-OBJ-ID
                                                    AH2-DIST-SEQ-NBR

Apdistrib      APDISTRIB

                            GLT-OBJ-ID           -> APD-GLT-OBJ-ID
                                                    APD-API-OBJ-ID
                                                    APD-DIST-SEQ-NBR

Apdrftdist     APDRFTDIST

                            GLT-TO-COMPANY       -> DDT-DIST-COMPANY
                            GLT-ACCT-UNIT        -> DDT-DST-ACCT-UNIT
                            GLT-ACCOUNT          -> DDT-DST-ACCOUNT
                            GLT-SUB-ACCOUNT      -> DDT-DST-SUB-ACCT
                            GLT-POSTING-DATE     -> DDT-POST-DATE
                            GLT-OBJ-ID           -> DDT-GLT-OBJ-ID
                                                    DDT-BANK-INST-CODE
                                                    DDT-TRANS-IDENT
                                                    DDT-SEQ-NBR

Ardistrib Det  ARDISTRIB

                            GLT-COMPANY          -> AMD-GL-COMPANY
                            GLT-ACCT-UNIT        -> AMD-ACCT-UNIT
                            GLT-ACCOUNT          -> AMD-ACCOUNT
                            GLT-SUB-ACCOUNT      -> AMD-SUB-ACCT
                            GLT-POSTING-DATE     -> AMD-GL-DATE
                            GLT-OBJ-ID           -> AMD-GLT-OBJ-ID
                                                    AMD-CREATE-DATE
                                                    AMD-CREATE-TIME
                                                    AMD-PROG-SEQ-NBR

Caheader       CAHEADER

                            GLT-ORIG-COMPANY     -> CAH-COMPANY
                            GLT-CONTROL-GROUP    -> CAH-JE-NBR
                            GLT-JE-TYPE          -> CAH-JE-TYPE
                                                    CAH-ALLOC-NAME
                                                    CAH-ALLOC-TYPE

Cbdistrib      CBDISTRIB

                            GLT-TO-COMPANY       -> CBD-DIST-COMPANY
                            GLT-ACCT-UNIT        -> CBD-DIS-ACCT-UNIT
                            GLT-ACCOUNT          -> CBD-DIS-ACCOUNT
                            GLT-SUB-ACCOUNT      -> CBD-DIS-SUB-ACCT
                            GLT-OBJ-ID           -> CBD-GLT-OBJ-ID
                                                    CBD-CASH-CODE
                                                    CBD-TRANS-NBR
                                                    CBD-BANK-INST-CODE
                                                    CBD-DIST-TYPE
                                                    CBD-SEQ-NBR
                                                    CBD-TRANS-IDENT

Eedistrib      EEDISTRIB

                            GLT-OBJ-ID           -> EED-GLT-OBJ-ID
                                                    EED-COMPANY
                                                    EED-VENDOR
                                                    EED-EXPENSE-NBR
                                                    EED-SEQ-NBR

Fbdetail       FBDETAIL

                            GLT-COMPANY          -> FBD-COMPANY
                            GLT-ACCT-UNIT        -> FBD-ACCT-UNIT
                            GLT-ACCOUNT          -> FBD-ACCOUNT
                            GLT-SUB-ACCOUNT      -> FBD-SUB-ACCOUNT
                                                    FBD-BUDGET-NBR
                                                    FBD-FISCAL-YEAR

Glcommit       GLCOMMIT

                            GLT-COMPANY          -> GOT-COMPANY
                            GLT-ACCT-UNIT        -> GOT-ACCT-UNIT
                            GLT-ACCOUNT          -> GOT-ACCOUNT
                            GLT-SUB-ACCOUNT      -> GOT-SUB-ACCOUNT
                            GLT-FISCAL-YEAR      -> GOT-FISCAL-YEAR
                                                    GOT-SYSTEM

Glcommitx      GLCOMMITX

                            GLT-COMPANY          -> GOX-COMPANY
                            GLT-ACCT-UNIT        -> GOX-ACCT-UNIT
                            GLT-ACCOUNT          -> GOX-ACCOUNT
                            GLT-SUB-ACCOUNT      -> GOX-SUB-ACCOUNT
                            GLT-FISCAL-YEAR      -> GOX-FISCAL-YEAR
                            GLT-ACCT-PERIOD      -> GOX-PERIOD
                                                    GOX-SYSTEM
                                                    GOX-CURRENCY-CODE
                                                    GOX-GLT-OBJ-ID

Glsccat        GLSCCAT

                            GLT-SOURCE-CODE      -> GSC-SOURCE-CODE
                                                    GSC-SEQ-NBR

Gltrans        GLTRANS

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

Gtmxvalue      GTMXVALUE    Delete Cascades

                            GLT-OBJ-ID           -> GMV-OBJ-ID
                                                    GMV-MATRIX-CAT

Icmmdist       MMDIST
                            Valid When GLT-SYSTEM = "IC"

                            GLT-OBJ-ID           -> MMD-GLT-OBJ-ID
                                                    MMD-COMPANY
                                                    MMD-SYSTEM-CD
                                                    MMD-LOCATION
                                                    MMD-DOC-TYPE
                                                    MMD-DOC-NUMBER
                                                    MMD-DOC-NBR-NUM
                                                    MMD-LINE-NBR
                                                    MMD-COMPONENT-SEQ
                                                    MMD-LINE-SEQ

Oedist         OEDIST

                            GLT-OBJ-ID           -> ODI-GLT-OBJ-ID
                                                    ODI-INVC-PREFIX
                                                    ODI-INVC-NUMBER
                                                    ODI-AUTH-NO
                                                    ODI-LINE-NBR
                                                    ODI-SEQ
                                                    ODI-POSTING-TYPE

Pbdistrib      PBDISTRIB

                            GLT-COMPANY          -> PDB-DIST-COMPANY
                            GLT-ACCT-UNIT        -> PDB-DST-ACCT-UNIT
                            GLT-ACCOUNT          -> PDB-DST-ACCOUNT
                            GLT-SUB-ACCOUNT      -> PDB-DST-SUB-ACCT
                            GLT-OBJ-ID           -> PDB-GLT-OBJ-ID
                                                    PDB-OBJ-ID

Pommdist       MMDIST
                            Valid When GLT-SYSTEM = "PO"

                            GLT-OBJ-ID           -> MMD-GLT-OBJ-ID
                                                    MMD-COMPANY
                                                    MMD-SYSTEM-CD
                                                    MMD-LOCATION
                                                    MMD-DOC-TYPE
                                                    MMD-DOC-NUMBER
                                                    MMD-DOC-NBR-NUM
                                                    MMD-LINE-NBR
                                                    MMD-COMPONENT-SEQ
                                                    MMD-LINE-SEQ

Pornimmdist    MMDIST
                            Valid When GLT-SYSTEM = "PO"

                            GLT-OBJ-ID           -> MMD-RNI-OBJ-ID
                                                    MMD-COMPANY
                                                    MMD-SYSTEM-CD
                                                    MMD-LOCATION
                                                    MMD-DOC-TYPE
                                                    MMD-DOC-NUMBER
                                                    MMD-DOC-NBR-NUM
                                                    MMD-LINE-NBR
                                                    MMD-COMPONENT-SEQ
                                                    MMD-LINE-SEQ

Prdistrib      PRDISTRIB

                            GLT-TO-COMPANY       -> PRD-DIST-COMPANY
                            GLT-ACCT-UNIT        -> PRD-DST-ACCT-UNIT
                            GLT-ACCOUNT          -> PRD-DST-ACCOUNT
                            GLT-SUB-ACCOUNT      -> PRD-DST-SUB-ACCT
                            GLT-OBJ-ID           -> PRD-GLT-OBJ-ID
                                                    PRD-OBJ-ID

Sltrans        SLTRANS

                            GLT-OBJ-ID           -> SLT-GLT-OBJ-ID
                                                    SLT-OBJ-ID