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
AC191 AC40.4 AC41.4 AC42.1 BR41.4 BR44.1
CB222 CA110 FB145 FB190 FB40.1 FB40.2
FB40.3 FB45.1 GL146 GL165 GL192 GL40.1
GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GL65.1 IC222 EX545 IFAC.1 IFEB.1 ML165
ML65.1 POIK.1 POIM.1 RW80.1 GLRV.1


UPDATED BY
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 AP510 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
EE135 EE35.1 EE35.2 EE520 FB11.1 FB111
FB160 FB211 GL120 GL170 GL197 GL199
GL500 GL70.1 GL70.2 GL70.3 GL70.5 GL70.6
GL75.1 GL76.1 PR521 DR100 IC12.1 IC140
IC141 IC142 IC145 IC243 IC330 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC83.1 EX175 EX542
EXI2.1 EXI4.1 IFGT.1 IFUC.1 LP130 MA180
MA278 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA43.2 MA43.7 MA44.1 MA44.2 MA53.1 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 PA182 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PD570 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO131 PO132 PO135 PO136
PO15.1 PO15.2 PO15.4 PO150 PO17.1 PO18.1
PO190 PO20.1 PO20.6 PO20.9 PO204 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.3
PO22.4 PO220 PO222 PO224 PO225 PO229
PO23.1 PO230 PO234 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO251 PO26.2 PO26.3 PO26.4
PO26.5 PO26.6 PO26.7 PO26.9 PO27.2 PO27.3
PO27.4 PO275 PO276 PO277 PO28.2 PO280
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 PR128 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 PR36.4 PR37.1
PR38.1 PR45.1 PR529 PR530 PR560 PR582
PR80.1 PR80.4 PR82.1 PR85.1 PR89.1 PRAT.1
UK102 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4
RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ44.1 RQ500 RQ810 RQD0.1 RQIB.1 RQIF.1
RQII.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

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
AP510 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
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
AP510 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
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
AP510 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
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
AP510 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
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
AP510 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
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
AP510 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
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
AP510 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
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 IC12.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.1
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA67.2
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 IC12.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.1
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA67.2
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
IC12.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA53.1 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
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
IC12.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA53.1 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
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
AP510 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
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
AP510 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
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
AP510 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


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
AP510 AP520
API1.1 API2.1
ARLL.1 BN150
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
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 AP510
AP520 API1.1
API2.1 BR41.4
BR44.1 CB10.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 02:14:00 2016

Home
Contact Us



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