GLCOMMIT – GL Commitments

System
General Ledger (GL)
Prefix
GOT
Primary key
COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, FISCAL-YEAR, SYSTEM
Fields
15
Updated by
326 programs
Referenced by
35 programs

GLCOMMIT is the GL Commitments table in Lawson General Ledger (prefix GOT). It is indexed by COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, FISCAL-YEAR, SYSTEM (GOTSET1); alternate indexes: GOTSET2 and GOTSET3. It is related 1:1 to GLAMOUNTS and GLMASTER and 1:M to FBDETAIL, GLCOMMITX and GLTRANS. It is updated by AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 and 318 more and referenced by AC191, AC40.4, AC41.4, AC42.1, BR41.4, BR44.1, CA110, CB222 and 27 more. The table has 15 fields, 3 indexes and 6 documented relations.

About GLCOMMIT

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

Fields (15)

Column = COBOL field name without the GOT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
GOT-COMPANY PK
COMPANY		Numeric 4The company number represents an established company and is maintained on GL10.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GOT-ACCT-UNIT PK
ACCT_UNIT		Alpha 15The 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 +52 more (list truncated in source)
GOT-ACCOUNT PK
ACCOUNT		Numeric 6This 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 +52 more (list truncated in source)
GOT-SUB-ACCOUNT PK
SUB_ACCOUNT		Numeric 4This 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 +52 more (list truncated in source)
GOT-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4This is the fiscal year for the record.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GOT-VAR-LEVELS
VAR_LEVELS		Alpha 30A 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 +52 more (list truncated in source)
GOT-SYSTEM PK
SYSTEM		Alpha 2A two-character code representing the system in which the commitment is held.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GOT-TRAN-ND
TRAN_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.GL500
GOT-DB-AMOUNT
DB_AMOUNT		Signed 18.2 Occurs 13 Times ×13The debit amount.AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP25.1, AP25.2 +52 more (list truncated in source)
GOT-CR-AMOUNT
CR_AMOUNT		Signed 18.2 Occurs 13 Times ×13The credit amount.AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP25.1, AP25.2 +52 more (list truncated in source)
GOT-DB-UNITS
DB_UNITS		Signed 15.2 Occurs 13 Times ×13The debit units.AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP25.1, AP25.2 +52 more (list truncated in source)
GOT-CR-UNITS
CR_UNITS		Signed 15.2 Occurs 13 Times ×13The credit units.AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP25.1, AP25.2 +52 more (list truncated in source)
GOT-MAINT-DATE
MAINT_DATE		Numeric 8 (yyyymmdd)The date last changed.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GOT-MAINT-TIME
MAINT_TIME		Numeric 6 (hhmmss)—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
GOT-FUND-GROUP
FUND_GROUP		Alpha 15—AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GOTSET1COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, FISCAL-YEAR, SYSTEMPrimaryAC191, AC40.4, AC41.4, AC42.1, AP125, AP126, AP131, AP170 +22 more (list truncated in source)
GOTSET2COMPANY, VAR-LEVELS, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, FISCAL-YEAR, SYSTEMKeyChangeFB11.1, FB111, FB160, FB211, GL120, RW80.1, GLRV.1
GOTSET3COMPANY, FUND-GROUP, FISCAL-YEAR, SYSTEM, ACCT-UNIT, ACCOUNT, SUB-ACCOUNTSubsetWhere FUND-GROUP != SpacesAC191, AC40.4, AC41.4, AC42.1, AP125, AP126, AP131, AP170 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
GlamountsGLAMOUNTSRequiredGOT-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
GlmasterGLMASTERRequiredGOT-COMPANY → GLM-COMPANY, GOT-ACCT-UNIT → GLM-ACCT-UNIT, GOT-ACCOUNT → GLM-ACCOUNT, GOT-SUB-ACCOUNT → GLM-SUB-ACCOUNT

One to many (4) — child tables

RelationTableRulesConditionField map
FbdetailFBDETAILGOT-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
GlcommitxGLCOMMITXGOT-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
GltransGLTRANSGOT-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
GltranscGLTRANSGOT-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

Programs

Updated by (326)

Referenced by (35)