GLCOMMIT

GL Commitments

The General Ledger Commit file contains beginning and period account balances by company, accounting unit, account, subaccount, fiscal year, and system.
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 AP520 API1.1 API2.1 BN150
BN66.1 CB10.1 CB15.1 CB15.2 CB150 CB180
CB191 CB20.1 CB30.1 CB45.1 CB46.1 CB500
CB543 CB544 CB55.1 CB554 CB80.1 CB82.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 EX175 EX542 EXI2.1
EXI4.1 IFGT.1 IFUC.1 LP130 LP140 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MAI1.1 PA182 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POIF.1
POII.1 POIJ.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 TA147 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 EX545 IFAC.1
IFEB.1 POIM.1 RW80.1 GLRV.1

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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL197 GL199
GL500 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 GL76.1
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL197 GL199
GL500 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 GL76.1
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL197 GL199
GL500 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 GL76.1
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL197 GL199
GL500 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 GL76.1
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL197 GL199
GL500 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 GL76.1
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL120
GL170 GL197
GL199 GL500
GL70.1 GL70.2
GL70.3 GL70.5
GL70.6 GL75.1
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL197 GL199
GL500 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 GL76.1
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 EE35.1
EE35.2 GL197
GL500 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL76.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 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 PR80.1
PR80.4 PR82.1
PR85.1
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 EE35.1
EE35.2 GL197
GL500 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL76.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 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 PR80.1
PR80.4 PR82.1
PR85.1
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 EE35.1
EE35.2 GL197
GL70.1 GL70.2
GL70.3 GL70.5
GL70.6 GL76.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
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
PR80.1 PR80.4
PR82.1 PR85.1
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 EE35.1
EE35.2 GL197
GL70.1 GL70.2
GL70.3 GL70.5
GL70.6 GL76.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
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
PR80.1 PR80.4
PR82.1 PR85.1
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL197 GL199
GL500 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 GL76.1
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL197 GL199
GL500 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 GL76.1
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 FB11.1
FB111 FB160
FB211 GL170
GL197 GL199
GL500 GL70.1
GL70.2 GL70.3


GLCOMMIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GOTSET1 COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
SYSTEM
...
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 BN150
BN66.1 CB10.1
CB15.1 CB15.2
CB150 CB180
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
...
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
CB10.1 CB15.1
CB15.2 CB150
CB191 CB20.1
CB30.1 CB45.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: Wed Jun 08 20:48:38 2016

Home
Contact Us



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