GLCOMMIT

GL Commitments

The General Ledger Commit file contains beginning and period account balances by company, accounting unit, account, subaccount, fiscal year, and system.

REFERENCED BY
GL192 RW80.1


UPDATED BY
AC191 AC40.4 AC41.4 AC42.1 AP125 AP126
AP131 AP170 AP190 AP193 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP30.2 AP30.4
AP520 API1.1 API2.1 ARLL.1 BN150 BN66.1
BR41.4 BR44.1 CB10.1 CB15.1 CB15.2 CB150
CB180 CB191 CB20.1 CB222 CB30.1 CB45.1
CB46.1 CB500 CB543 CB544 CB55.1 CB554
CB57.1 CB80.1 CB82.1 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CXCP.1 EE135 EE35.1 EE35.2 EE520 CA110
FB11.1 FB111 FB145 FB160 FB190 FB211
FB40.1 FB40.2 FB40.3 FB45.1 GL120 GL146
GL165 GL170 GL197 GL199 GL40.1 GL40.2
GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500
GL65.1 GL70.1 GL70.2 GL70.3 GL70.5 GL70.6
GL75.1 GL76.1 PR521 DR100 IC140 IC141
IC142 IC222 IC66.1 IC83.1 EX175 EX542
EX545 EXI2.1 EXI4.1 GLRV.1 IFAC.1 IFEB.1
IFGT.1 IFUC.1 LP130 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA42.2 MA43.2 MA43.7 MA44.1
MA44.2 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 ML165
ML65.1 PA182 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PO100 PO101 PO122 PO131
PO135 PO136 PO150 PO190 PO20.1 PO20.6
PO20.9 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO23.1 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO26.2 PO26.3 PO26.4
PO26.5 PO26.6 PO26.7 PO26.9 PO27.2 PO28.2
PO29.1 PO30.1 PO30.2 PO30.3 PO30.4 PO300
PO31.1 PO31.2 PO32.2 PO32.4 PO33.1 PO34.1
PO35.1 PO36.1 PO36.2 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 PO536 PO54.5
POCP.1 POD0.1 POI3.1 POID.1 POIF.1 POII.1
POIJ.1 POIK.1 POIM.1 PR128 PR130 PR131
PR132 PR134 PR135 PR136 PR137 PR140
PR189 PR195 PR197 PR198 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 PR35.9
PR36.1 PR37.1 PR38.1 PR45.1 PR529 PR530
PR560 PR582 PR80.1 PR80.4 PR82.1 PR85.1
PR89.1 UK102 UK330 UK560 ZP530 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ500 RQD0.1 RQIB.1 RQIF.1
RQIJ.1 TA147 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH32.5 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 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GOT-COMPANY
Element: Company
Numeric 4
The company number represents an established company and is maintained on GL10.
...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 ARLL.1
BN150 BN66.1
CB10.1 CB15.1
CB150 CB180
CB191 CB20.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB57.1 CB80.1
CB82.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
EX175 EX542
GOT-ACCT-UNIT
Element: Accounting Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. The accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 ARLL.1
BN150 BN66.1
CB10.1 CB15.1
CB150 CB180
CB191 CB20.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB57.1 CB80.1
CB82.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
EX175 EX542
GOT-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location where amounts and other account information is stored.
...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 ARLL.1
BN150 BN66.1
CB10.1 CB15.1
CB150 CB180
CB191 CB20.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB57.1 CB80.1
CB82.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
EX175 EX542
GOT-SUB-ACCOUNT
Element: Subaccount
Numeric 4
This field along with the accounting unit and account make up the location where amounts and other account information is stored.
...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 ARLL.1
BN150 BN66.1
CB10.1 CB15.1
CB150 CB180
CB191 CB20.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB57.1 CB80.1
CB82.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
EX175 EX542
GOT-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
This is the fiscal year for the record.
...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 ARLL.1
BN150 BN66.1
CB10.1 CB15.1
CB150 CB180
CB191 CB20.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB57.1 CB80.1
CB82.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
EX175 EX542
GOT-VAR-LEVELS
Element: Variable Levels
Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.
...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 ARLL.1
BN150 BN66.1
CB10.1 CB15.1
CB150 CB180
CB191 CB20.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB57.1 CB80.1
CB82.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
EX175 EX542
GOT-SYSTEM
Element: System
Alpha 2
A two-character code representing the system in which the commitment is held.
...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 ARLL.1
BN150 BN66.1
CB10.1 CB15.1
CB150 CB180
CB191 CB20.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB57.1 CB80.1
CB82.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
EX175 EX542
GOT-TRAN-ND
Tran Curr Number of
Decimals
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
GL500
GOT-DB-AMOUNT
Element: Debit Amount
Signed 18.2 Occurs 13 Times
The debit amount.
...
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP25.1 AP25.2
AP30.2 AP30.4
CB10.1 CB15.1
CB20.1 CB30.1
CB45.1 CB46.1
CB55.1 CB80.1
CB82.1 CX20.1
CX20.2 CX20.4
CX20.5 EE35.1
EE35.2 GL197
GL500 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL76.1 IC66.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 PD10.1
PD10.2 PD20.1
PD20.2 PD20.3
PO20.1 PO20.6
GOT-CR-AMOUNT
Element: Credit Amount
Signed 18.2 Occurs 13 Times
The credit amount.
...
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP25.1 AP25.2
AP30.2 AP30.4
CB10.1 CB15.1
CB20.1 CB30.1
CB45.1 CB46.1
CB55.1 CB80.1
CB82.1 CX20.1
CX20.2 CX20.4
CX20.5 EE35.1
EE35.2 GL197
GL500 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL76.1 IC66.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 PD10.1
PD10.2 PD20.1
PD20.2 PD20.3
PO20.1 PO20.6
GOT-DB-UNITS
Element: Debit Units
Signed 15.2 Occurs 13 Times
The debit units.
...
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP25.1 AP25.2
AP30.2 AP30.4
CB10.1 CB15.1
CB20.1 CB30.1
CB45.1 CB46.1
CB55.1 CB80.1
CB82.1 CX20.1
CX20.2 CX20.4
CX20.5 EE35.1
EE35.2 GL197
GL70.1 GL70.2
GL70.3 GL70.5
GL70.6 GL76.1
IC66.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
PD10.1 PD10.2
PD20.1 PD20.2
PD20.3 PO20.1
PO20.6 PO20.9
GOT-CR-UNITS
Element: Credit Units
Signed 15.2 Occurs 13 Times
The credit units.
...
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP25.1 AP25.2
AP30.2 AP30.4
CB10.1 CB15.1
CB20.1 CB30.1
CB45.1 CB46.1
CB55.1 CB80.1
CB82.1 CX20.1
CX20.2 CX20.4
CX20.5 EE35.1
EE35.2 GL197
GL70.1 GL70.2
GL70.3 GL70.5
GL70.6 GL76.1
IC66.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
PD10.1 PD10.2
PD20.1 PD20.2
PD20.3 PO20.1
PO20.6 PO20.9
GOT-MAINT-DATE
Element: Maintenance Date
Numeric 8 (yyyymmdd)
The date last changed.
...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 ARLL.1
BN150 BN66.1
CB10.1 CB15.1
CB150 CB180
CB191 CB20.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB57.1 CB80.1
CB82.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
EX175 EX542
GOT-MAINT-TIME
Element: Maintenance Time
Numeric 6 (hhmmss)
...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 ARLL.1
BN150 BN66.1
CB10.1 CB15.1
CB150 CB180
CB191 CB20.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB57.1 CB80.1
CB82.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
EX175 EX542
GOT-FUND-GROUP
Element: Fund Group
Alpha 15
...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 ARLL.1
BN150 BN66.1
CB10.1 CB15.1
CB150 CB180
CB191 CB20.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB57.1 CB80.1
CB82.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
EX175 EX542


GLCOMMIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GOTSET1 COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
SYSTEM
...
AC191 AC40.4
AC41.4 AC42.1
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 ARLL.1
BN150 BN66.1
GOTSET2 COMPANY
VAR-LEVELS
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
SYSTEM
KeyChange
FB11.1 FB111
FB160 FB211
GL120 RW80.1
GLRV.1
GOTSET3 COMPANY
FUND-GROUP
FISCAL-YEAR
SYSTEM
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
KeyChange, Subset
WhereFUND-GROUP !=Spaces
...
AC191 AC40.4
AC41.4 AC42.1
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
BR41.4 BR44.1
CB10.1 CB15.1


GLCOMMIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Glamounts GLAMOUNTS Required
GOT-COMPANY->GAM-COMPANY
GOT-FISCAL-YEAR->GAM-FISCAL-YEAR
GOT-ACCT-UNIT->GAM-ACCT-UNIT
GOT-ACCOUNT->GAM-ACCOUNT
GOT-SUB-ACCOUNT->GAM-SUB-ACCOUNT
Glmaster GLMASTER Required
GOT-COMPANY->GLM-COMPANY
GOT-ACCT-UNIT->GLM-ACCT-UNIT
GOT-ACCOUNT->GLM-ACCOUNT
GOT-SUB-ACCOUNT->GLM-SUB-ACCOUNT


GLCOMMIT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Fbdetail FBDETAIL
GOT-COMPANY->FBD-COMPANY
GOT-ACCT-UNIT->FBD-ACCT-UNIT
GOT-ACCOUNT->FBD-ACCOUNT
GOT-SUB-ACCOUNT->FBD-SUB-ACCOUNT
  FBD-BUDGET-NBR
  FBD-FISCAL-YEAR
Glcommitx GLCOMMITX
GOT-COMPANY->GOX-COMPANY
GOT-ACCT-UNIT->GOX-ACCT-UNIT
GOT-ACCOUNT->GOX-ACCOUNT
GOT-SUB-ACCOUNT->GOX-SUB-ACCOUNT
GOT-FISCAL-YEAR->GOX-FISCAL-YEAR
  GOX-PERIOD
  GOX-SYSTEM
  GOX-CURRENCY-CODE
  GOX-GLT-OBJ-ID
Gltrans GLTRANS
GOT-COMPANY->GLT-TO-COMPANY
GOT-ACCOUNT->GLT-ACCOUNT
GOT-SUB-ACCOUNT->GLT-SUB-ACCOUNT
GOT-ACCT-UNIT->GLT-ACCT-UNIT
GOT-FISCAL-YEAR->GLT-FISCAL-YEAR
  GLT-ACCT-PERIOD
  GLT-SYSTEM
  GLT-CONTROL-GROUP
  GLT-JE-TYPE
  GLT-JE-SEQUENCE
  GLT-LINE-NBR
  GLT-COMPANY
Gltransc GLTRANS
GOT-COMPANY->GLT-COMPANY
GOT-VAR-LEVELS->GLT-VAR-LEVELS
GOT-ACCT-UNIT->GLT-ACCT-UNIT
GOT-ACCOUNT->GLT-ACCOUNT
GOT-SUB-ACCOUNT->GLT-SUB-ACCOUNT
GOT-FISCAL-YEAR->GLT-FISCAL-YEAR
  GLT-ACCT-PERIOD
  GLT-SYSTEM
  GLT-OBJ-ID


File created: Thu Jun 09 11:13:11 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.