Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             GLCOMMITX FILE

REFERENCED BY

FB11.1    FB211     FB296     FB95.1    FB95.2    FB95.3
FB95.4    FB95.5    FB95.6    GL298     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    POIM.1

UPDATED BY

AC541     AC542     AP125     AP126     AP170     AP193
AP20.1    AP20.2    AP20.3    AP20.4    AP20.5    AP20.7
AP23.1    AP25.1    AP25.2    AP26.1    AP27.1    AP30.2
AP30.4    AP32.2    AP520     API1.1    API2.1    AR115
AR124     AR190     AR20.1    AR21.1    AR21.2    AR21.3
AR24.1    AR29.2    AR30.1    AR30.2    AR30.4    AR42.1
AR42.2    AR42.7    AR43.1    AR560     AR570     AR575
AR580     BN150     BN66.1    CB10.1    CB180     CB191
CB20.1    CB30.1    CB500     CB80.1    EE135     EE35.1
EE35.2    EE520     GL120     GL197     GL199     IFGT.1
MA41.2    MA43.2    MA61.1    MA70.1    MAI1.1    PO135
POIF.1    PR128     PR130     PR131     PR132     PR134
PR136     PR137     PR140     PR189     PR195     PR197
PR29.1    PR32.1    PR32.2    PR33.1    PR33.2    PR33.3
PR35.1    PR35.2    PR35.3    PR35.4    PR35.5    PR35.6
PR35.8    PR36.1    PR37.1    PR38.1    PR45.1    PR529
PR530     PR560     PR80.1    PR82.1    PR85.1    PR89.1
PRSA.1    UK102     UK330     TA147     UK120     WH20.7

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

GOX-COMPANY          Numeric 4                                   AC541   AC542
Company              The company number represents an            AP125   AP126
                     established company and is entered on       AP170   AP193
                     all function codes.                         AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL197   GL199
                                                                 IFGT.1  MA41.2
                                                                 ...

GOX-ACCT-UNIT        Alpha 15                                    AC541   AC542
Accounting Unit      The accounting unit is a shorthand          AP125   AP126
                     notation representing the variable level    AP170   AP193
                     number. When used in the General Ledger     AP20.1  AP20.2
                     Account Master file, the accounting unit    AP20.3  AP20.4
                     must be defined in the General Ledger       AP20.5  AP20.7
                     Names file as a posting accounting unit.    AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL197   GL199
                                                                 IFGT.1  MA41.2
                                                                 ...

GOX-ACCOUNT          Numeric 6                                   AC541   AC542
Account              This field along with the accounting        AP125   AP126
                     unit and subaccount make up the location    AP170   AP193
                     (account) where amounts and other           AP20.1  AP20.2
                     account information is stored.              AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL197   GL199
                                                                 IFGT.1  MA41.2
                                                                 ...

GOX-SUB-ACCOUNT      Numeric 4                                   AC541   AC542
Subaccount           This field along with the accounting        AP125   AP126
                     unit and subaccount make up the location    AP170   AP193
                     (account) where amounts and other           AP20.1  AP20.2
                     account information is stored.              AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL197   GL199
                                                                 IFGT.1  MA41.2
                                                                 ...

GOX-FISCAL-YEAR      Numeric 4                                   AC541   AC542
Fiscal Year          This is the current fiscal year.  This      AP125   AP126
                     field is updated by Period Closing          AP170   AP193
                     (GL199).                                    AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL197   GL199
                                                                 IFGT.1  MA41.2
                                                                 ...

GOX-PERIOD           Numeric 2                                   AC541   AC542
Last Closed Period   This is the current accounting period.      AP125   AP126
                     This field is updated by Period Closing     AP170   AP193
                     (GL199).                                    AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL197   GL199
                                                                 IFGT.1  MA41.2
                                                                 ...

GOX-SYSTEM           Alpha 2                                     AC541   AC542
System Code          A two-character code representing an        AP125   AP126
                     application used within the Lawson          AP170   AP193
                     system. (i.e.: GL = General Ledger, AP =    AP20.1  AP20.2
                     Accounts Payable, etc.)                     AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL197   GL199
                                                                 IFGT.1  MA41.2
                                                                 ...

GOX-GLT-OBJ-ID       Numeric 12                                  AC541   AC542
Subsystem GL         This is a subsystem GL interface            AP125   AP126
Interface ID         identification number. It is used for       AP170   AP193
                     Drill Around purposes.                      AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL199   IFGT.1
                                                                 MA41.2  MA43.2
                                                                 ...

GOX-VAR-LEVELS       Alpha 30                                    AC541   AC542
Variable Levels      A level that represents the location of     AP125   AP126
                     an accounting unit in an organization's     AP170   AP193
                     level structure.                            AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL120   GL197
                                                                 GL199   IFGT.1
                                                                 ...

GOX-AMOUNT           Currency 15.2                               AC541   AC542
Amount               This is the amounts by period for the       AP125   AP126
                     specified record.                           AP170   AP193
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL197   GL199
                                                                 IFGT.1  MA41.2
                                                                 ...

GOX-UNIT             Signed 15.2                                 AC541   AC542
Unit                                                             AP125   AP126
                                                                 AP170   AP193
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL197   GL199
                                                                 IFGT.1  MA41.2
                                                                 ...

GOX-CURRENCY-CODE    Alpha 5                                     AC541   AC542
Currency Code        This field contains the company base        AP125   AP126
                     currency code established in Company        AP170   AP193
                     (GL10.1 ).                                  AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL197   GL199
                                                                 IFGT.1  MA41.2
                                                                 ...

GOX-BASERATE         Signed 12.6                                 AC541   AC542
Exchange Rate        Enter the exchange rate at the time the     AP125   AP126
                     journal entry was made.  If left blank,     AP170   AP193
                     the current exchange rate will default.     AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL197   GL199
                                                                 IFGT.1  MA41.2
                                                                 ...

GOX-TRAN-AMOUNT      Signed 15.2                                 AC541   AC542
Invoice Amount       This is the amount in transaction           AP125   AP126
                     currency to be posted. This amount          AP170   AP193
                     creates a CUAMOUNT type 1 record.           AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL197   GL199
                                                                 IFGT.1  MA41.2
                                                                 ...

GOX-TRAN-ND          Numeric 1                                   GL197
Transaction Number   The number of decimal positions defined
of Decimals          for the transaction currency.

GOX-INVOICE          Alpha 22                                    AC541   AC542
Invoice Number       Used to identify the invoice.               AP125   AP126
                                                                 AP170   AP193
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL199   IFGT.1
                                                                 MA41.2  MA43.2
                                                                 ...

GOX-ITEM             Alpha 32                                    AC541   AC542
Item Number          This field contains the item                AP125   AP126
                     identifier.                                 AP170   AP193
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL199   IFGT.1
                                                                 MA41.2  MA43.2
                                                                 ...

GOX-RESOURCE-CODE    Alpha 10                                    AC541   AC542
Resource Code                                                    AP125   AP126
                                                                 AP170   AP193
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL199   IFGT.1
                                                                 MA41.2  MA43.2
                                                                 ...

GOX-RESOURCE-TYPE    Alpha 1                                     AC541   AC542
Resource Type                                                    AP125   AP126
                                                                 AP170   AP193
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL199   IFGT.1
                                                                 MA41.2  MA43.2
                                                                 ...

GOX-RESOURCE-DESC    Alpha 30  (Lower Case)                      AC541   AC542
Resource Desc                                                    AP125   AP126
                                                                 AP170   AP193
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL199   IFGT.1
                                                                 MA41.2  MA43.2
                                                                 ...

GOX-CREATED-YEAR     Numeric 4                                   AC541   AC542
Created Year                                                     AP125   AP126
                                                                 AP170   AP193
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL199   IFGT.1
                                                                 MA41.2  MA43.2
                                                                 ...

GOX-CREATED-PERIOD   Numeric 2                                   AC541   AC542
Created Period                                                   AP125   AP126
                                                                 AP170   AP193
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   BN150
                                                                 BN66.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   CB80.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 GL199   IFGT.1
                                                                 MA41.2  MA43.2
                                                                 ...

                         GLCOMMITX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GOXSET1   COMPANY                                                FB11.1  FB211
          ACCT-UNIT                                              FB296   FB95.1
          ACCOUNT                                                FB95.2  FB95.3
          SUB-ACCOUNT                                            FB95.4  FB95.5
          FISCAL-YEAR                                            FB95.6  GL120
          PERIOD                                                 GL197   GL298
          SYSTEM                                                 GL94.1  GL94.2
          CURRENCY-CODE                                          GL94.3  GL94.4
          GLT-OBJ-ID                                             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
                                                                 ...

GOXSET2   GLT-OBJ-ID                                             AC541   AC542
                                                                 AP125   AP126
                                                                 AP170   AP193
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   API1.1
                                                                 API2.1  AR115
                                                                 AR124   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 ...

GOXSET3   COMPANY
          SYSTEM
          FISCAL-YEAR
          PERIOD
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          GLT-OBJ-ID

                         GLCOMMITX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glcommit       GLCOMMIT     Required

                            GOX-COMPANY        -> GOT-COMPANY  (GOTSET1)
                            GOX-ACCT-UNIT      -> GOT-ACCT-UNIT
                            GOX-ACCOUNT        -> GOT-ACCOUNT
                            GOX-SUB-ACCOUNT    -> GOT-SUB-ACCOUNT
                            GOX-FISCAL-YEAR    -> GOT-FISCAL-YEAR
                            GOX-SYSTEM         -> GOT-SYSTEM

                         GLCOMMITX FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Actrans        ACTRANS

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

Apapdhist      APAPDHIST

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

Apdistrib      APDISTRIB

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

Apdrftdist     APDRFTDIST

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

Cbdistrib      CBDISTRIB

                            GOX-COMPANY        -> CBD-DIST-COMPANY
                            GOX-ACCT-UNIT      -> CBD-DIS-ACCT-UNIT
                            GOX-ACCOUNT        -> CBD-DIS-ACCOUNT
                            GOX-SUB-ACCOUNT    -> CBD-DIS-SUB-ACCT
                            GOX-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

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

Pommdist       MMDIST
                            Valid When GOX-SYSTEM = "PO"

                            GOX-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

Prdistrib      PRDISTRIB

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

Rqmmdist       MMDIST
                            Valid When GOX-SYSTEM = "RQ"

                            GOX-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