Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLCOMMITX


                             GLCOMMITX FILE

REFERENCED BY

FB11.1    FB111     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     AP131     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    CXCP.1
EE135     EE35.1    EE35.2    EE520     GL120     GL197
GL199     DR100     IC140     IC28.1    IC531     IC83.1
IFGT.1    MA180     MA41.2    MA41.7    MA43.1    MA43.2
MA43.3    MA43.9    MA530     MA531     MA60.2    MA60.3
MA60.5    MA61.1    MA66.2    MA66.3    MA67.1    MA67.2
MA70.1    MA75.1    MA80.1    MAI1.1    PO100     PO101
PO122     PO131     PO135     PO150     PO20.1    PO21.1
PO21.2    PO21.3    PO21.4    PO21.5    PO22.1    PO23.1
PO25.1    PO25.5    PO25.6    PO25.7    PO27.2    PO29.1
PO30.1    PO30.2    PO30.3    PO300     PO31.1    PO31.2
PO32.2    PO33.1    PO34.1    PO35.1    PO36.1    PO36.2
PO38.1    PO39.1    PO39.2    PO44.1    PO50.1    PO52.1
PO520     PO536     POCP.1    POD0.1    POI3.1    POID.1
POIF.1    POII.1    POIJ.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     UK560
RQ10.1    RQ10.2    RQ10.3    RQ11.1    RQ12.1    RQ13.1
RQ140     RQ300     RQ35.1    RQ40.1    RQ41.1    RQ42.1
RQ44.1    RQ44.2    RQ500     RQD0.1    RQIE.1    RQIF.1
TA147     UK120     WH130     WH132     WH190     WH20.2
WH20.7    WH222     WH25.1    WH25.2    WH30.1    WH30.2
WH30.3    WH30.4    WH31.1    WH31.2    WH31.3    WH31.4
WH32.1    WH32.2    WH32.3    WH32.4    WH33.1    WH33.2
WH33.3    WH33.4    WH33.5    WH33.6    WH33.8    WH33.9
WH34.1    WH34.2    WH34.3    WH34.4    WH40.1    WH40.2
WH520     WH830     WO132     WO140

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GOX-COMPANY            Numeric 4                                 AC541   AC542
Element: Company       The company number represents an          AP125   AP126
                       established company and is maintained on  AP131   AP170
                       GL10.                                     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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL197
                                                                 ...

GOX-ACCT-UNIT          Alpha 15                                  AC541   AC542
Element: Accounting UniThe accounting unit is a shorthand        AP125   AP126
                       notation representing the variable level  AP131   AP170
                       number. The accounting unit must be       AP193   AP20.1
                       defined in the General Ledger Names file  AP20.2  AP20.3
                       as a posting accounting Unit.             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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL197
                                                                 ...

GOX-ACCOUNT            Numeric 6                                 AC541   AC542
Element: Account       This field along with the accounting      AP125   AP126
                       unit and subaccount make up the location  AP131   AP170
                       where amounts and other account           AP193   AP20.1
                       information is stored.                    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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL197
                                                                 ...

GOX-SUB-ACCOUNT        Numeric 4                                 AC541   AC542
Element: Subaccount    This field along with the accounting      AP125   AP126
                       unit and account make up the location     AP131   AP170
                       where amounts and other account           AP193   AP20.1
                       information is stored.                    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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL197
                                                                 ...

GOX-FISCAL-YEAR        Numeric 4                                 AC541   AC542
Element: Last Closed YeThis is the fiscal year for the record.   AP125   AP126
                                                                 AP131   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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL197
                                                                 ...

GOX-PERIOD             Numeric 2                                 AC541   AC542
Element: Current PeriodThis is the period for the record.        AP125   AP126
                                                                 AP131   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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL197
                                                                 ...

GOX-SYSTEM             Alpha 2                                   AC541   AC542
Element: System Code   A two-character code representing the     AP125   AP126
                       system in which the commitment is held.   AP131   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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL197
                                                                 ...

GOX-GLT-OBJ-ID         Numeric 12                                AC541   AC542
Object                 This is the object ID sequence number.    AP125   AP126
Identification                                                   AP131   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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 ...

GOX-VAR-LEVELS         Alpha 30                                  AC541   AC542
Element: New Levels    A level that represents the location of   AP125   AP126
                       an accounting unit in an organization's   AP131   AP170
                       level structure.                          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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL120
                                                                 ...

GOX-AMOUNT             Currency 15.2                             AC541   AC542
Element: Amount        The base amount for the record.           AP125   AP126
                                                                 AP131   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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL197
                                                                 ...

GOX-UNIT               Signed 15.2                               AC541   AC542
Element: Unit          The units for the record.                 AP125   AP126
                                                                 AP131   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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL197
                                                                 ...

GOX-CURRENCY-CODE      Alpha 5                                   AC541   AC542
Element: Currency Code This field contains the company base      AP125   AP126
                       currency code established in Company      AP131   AP170
                       (GL10.1 ).                                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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL197
                                                                 ...

GOX-BASERATE           Signed 12.6                               AC541   AC542
Element: Account Rate  The exchange rate at the time the record  AP125   AP126
                       was created.                              AP131   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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL197
                                                                 ...

GOX-TRAN-AMOUNT        Signed 15.2                               AC541   AC542
Element: Adj Amt       This is the amount in transaction         AP125   AP126
                       currency.                                 AP131   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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL197
                                                                 ...

GOX-TRAN-ND            Numeric 1                                 GL197
Account Currency       The number of decimal positions defined
Code                   for the transaction currency.

GOX-INVOICE            Alpha 22                                  AC541   AC542
Element: Invoice NumberUsed to identify the invoice number.      AP125   AP126
                                                                 AP131   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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 ...

GOX-ITEM               Alpha 32                                  AC541   AC542
Element: Item Number   This field contains the item              AP125   AP126
                       identifier.                               AP131   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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 ...

GOX-RESOURCE-CODE      Alpha 10                                  AC541   AC542
Element: Resource Code This field contains the subsystem         AP125   AP126
                       resource number.                          AP131   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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 ...

GOX-RESOURCE-TYPE      Alpha 1                                   AC541   AC542
Element: Resource Type This field contains the resource type.    AP125   AP126
                                                                 AP131   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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 ...

GOX-RESOURCE-DESC      Alpha 30  (Lower Case)                    AC541   AC542
Element: Description   This field contains the resource          AP125   AP126
                       description.  (Required if resource is    AP131   AP170
                       entered).                                 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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 ...

GOX-CREATED-YEAR       Numeric 4                                 AC541   AC542
Element: Created Year  This is the fiscal year the record was    AP125   AP126
                       created in.                               AP131   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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 ...

GOX-CREATED-PERIOD     Numeric 2                                 AC541   AC542
Element: Created PeriodThis is the period that the record was    AP125   AP126
                       created in.                               AP131   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  CXCP.1
                                                                 DR100   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   GL199
                                                                 ...

                         GLCOMMITX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

GOXSET2   GLT-OBJ-ID                                             AC541   AC542
                                                                 AP125   AP126
                                                                 AP131   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
                                                                 ...

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