GLCONTROL – General Ledger Control

System
General Ledger (GL)
Prefix
GLC
Primary key
COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE
Fields
70
Updated by
24 programs
Referenced by
155 programs

GLCONTROL is the General Ledger Control table in Lawson General Ledger (prefix GLC). It is indexed by COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE (GLCSET1); alternate indexes: GLCSET2, GLCSET3, GLCSET4, GLCSET5, GLCSET6 and GLCSET7. It is related 1:1 to GLSYSTEM, CUCONTROL, GLCBOD, GLHOLDCODE, GLSCCAT, GLSRCCODE, GLSYSJE, MXCATDEF and 1 more and 1:M to GLCNTRLAU, GLJELOG and GLTRANS. It is updated by GL110, GL145, GL146, GL148, GL167, GL170, GL190, GL191 and 16 more and referenced by AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 and 147 more. The table has 70 fields, 7 indexes and 19 documented relations.

About GLCONTROL

This file contains journal entry control information. This information is used to process the journal entry detail records.

Fields (70)

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

Field / columnTypeDescription & valuesUpdated by
GLC-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.GL110, GL148, GL167, GL191, GL196, GL197, GL199, GL40.2 +6 more
GLC-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4Contains the fiscal year for the data stored on this record.GL148, GL167, GL191, GL196, GL197, GL199, GL40.2, GL40.6 +5 more
GLC-ACCT-PERIOD PK
ACCT_PERIOD		Numeric 2The accounting period assigned to the journal entry.GL148, GL167, GL191, GL196, GL197, GL199, GL40.2, GL40.6 +5 more
GLC-SYSTEM PK
SYSTEM		Alpha 2This is the journal entry system code.GL148, GL167, GL191, GL196, GL197, GL199, GL40.2, GL40.6 +5 more
GLC-JE-TYPE PK
JE_TYPE		Alpha 1Displays the type of journal entry created.
  • N Normal
  • I Intercompany
  • A Auto Rev Normal
  • R Auto Rev Intco
GL148, GL167, GL191, GL196, GL197, GL199, GL40.2, GL40.6 +5 more
GLC-JE-TYPE-1
JE_TYPE_1		DerivedDisplays the derived journal entry type.—
GLC-CONTROL-GROUP PK
CONTROL_GROUP		Numeric 8This field displays the journal entry number used for process control of the journal entry detail.GL148, GL167, GL191, GL196, GL197, GL199, GL40.2, GL40.6 +5 more
GLC-JE-SEQUENCE PK
JE_SEQUENCE		Numeric 2The unique journal entry sequence number.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +12 more
GLC-STATUS
STATUS		Numeric 1This field contains the processing cycle status of the assigned journal entry.
  • 0 Unreleased
  • 1 Released
  • 2 Post In Progress
  • 3 Load In Process
  • 4 Quick Posted
  • 5 Posted
  • 6 Unreleased no AC update
  • 9 History
GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +10 more
GLC-STATUS-1
STATUS_1		DerivedThis field displays the journal entry status.—
GLC-CNTRL-AMOUNT
CNTRL_AMOUNT		Signed 18.2Displays the total journal entry amount.GL146, GL190, GL197, GL40.1, GL40.2, GL40.3, GL40.7, GL40.8 +3 more
GLC-ENTRY-DB
ENTRY_DB		Signed 18.2—GL146, GL167, GL190, GL191, GL197, GL199, GL40.1, GL40.2 +8 more
GLC-ENTRY-CR
ENTRY_CR		Signed 18.2—GL146, GL167, GL190, GL191, GL197, GL199, GL40.1, GL40.2 +8 more
GLC-TRAN-ND
TRAN_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.GL148, GL167, GL191, GL196, GL197, GL199, GL40.2, GL40.5 +4 more
GLC-UNIT-CNTRL-DB
UNIT_CNTRL_DB		Signed 15.2The total positive detail auto reversing amounts.GL190, GL500
GLC-UNIT-CNTRL-CR
UNIT_CNTRL_CR		Signed 15.2The journal entry total for negative detail unit balances.GL190, GL500
GLC-UNIT-ENTRY-DB
UNIT_ENTRY_DB		Signed 15.2The total positive detail auto reversing amounts.GL146, GL167, GL190, GL191, GL197, GL199, GL40.1, GL40.2 +8 more
GLC-UNIT-ENTRY-CR
UNIT_ENTRY_CR		Signed 15.2The total negative detail auto reversing amounts.GL146, GL167, GL190, GL191, GL197, GL199, GL40.1, GL40.2 +8 more
GLC-AUTO-UNIT-DB
AUTO_UNIT_DB		Signed 15.2The total positive detail auto reversing amounts.GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3, GL40.6 +6 more
GLC-AUTO-UNIT-CR
AUTO_UNIT_CR		Signed 15.2The total negative detail auto reversing amounts.GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3, GL40.6 +6 more
GLC-DATE
DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.GL148, GL167, GL191, GL196, GL197, GL199, GL40.2, GL40.6 +3 more
GLC-LINE-NBR
LINE_NBR		Numeric 6This field contains the line number.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +9 more
GLC-NBR-LINES
NBR_LINES		Numeric 6This is the number of detail lines.GL146, GL148, GL167, GL190, GL191, GL197, GL199, GL40.1 +9 more
GLC-OPERATOR
OPERATOR		Alpha 10This field is used to store the login ID of the person who entered the record.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +10 more
GLC-REL-OPERATOR
REL_OPERATOR		Alpha 10The operator ID assigned to the released journal entry.GL146, GL190, GL197, GL199, GL40.1, GL40.2, GL40.3, GL40.6 +6 more
GLC-RELEASED-FLAG
RELEASED_FLAG		Alpha 1This flag is set to Yes when a Journal Entry is Released. If the Journal Entry is Unreleased this flag will not be reset, instead it is an indicator that the Journal Entry had been released at one time.
  • Y Yes
  • N No
  • S System Generated
GL146, GL190, GL197, GL199, GL40.1, GL40.2, GL40.3, GL40.6 +6 more
GLC-HOLD-CODE
HOLD_CODE		Alpha 4The journal hold code.GL145, GL146, GL197, GL199, GL40.1, GL40.2, GL40.3, GL40.7 +5 more
GLC-PER-DATE-FLAG
PER_DATE_FLAG		Alpha 1Indicates the period or date derived.
  • P Period Derived
  • D Date Derived
GL40.2, GL40.6, GL45.1, GL500, IFGT.1
GLC-POSTING-DATE
POSTING_DATE		Numeric 8 (yyyymmdd)The date assigned to the journal entry for posting.GL146, GL148, GL167, GL191, GL196, GL197, GL199, GL40.1 +9 more
GLC-LAST-CMT-SEQ
LAST_CMT_SEQ		Numeric 4The sequence number of the last comment for the journal entry.GL190, GL199, GL500
GLC-LAST-LOG-SEQ
LAST_LOG_SEQ		Numeric 6The last sequence control number.GL146, GL148, GL190, GL191, GL197, GL199, GL40.1, GL40.2 +8 more
GLC-BASE-ZONE
BASE_ZONE		Alpha 15The base zone as assigned for interzone balance processing.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +10 more
GLC-BASE-DEBITS
BASE_DEBITS		Signed 18.2—GL146, GL148, GL167, GL190, GL191, GL197, GL199, GL40.1 +9 more
GLC-BASE-CREDITS
BASE_CREDITS		Signed 18.2—GL146, GL167, GL190, GL191, GL197, GL199, GL40.1, GL40.2 +8 more
GLC-BASE-AUTO-DB
BASE_AUTO_DB		Signed 18.2The total positive detail auto reversing amount in the company base currency.GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3, GL40.6 +6 more
GLC-BASE-AUTO-CR
BASE_AUTO_CR		Signed 18.2—GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3, GL40.6 +6 more
GLC-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.GL148, GL167, GL191, GL196, GL197, GL199, GL40.2, GL40.6 +3 more
GLC-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ) unless an alternate currency code is chosen on the GL40.2.GL148, GL167, GL191, GL196, GL197, GL199, GL40.2, GL45.1 +2 more
GLC-BASERATE
BASERATE		Signed 14.7The exchange rate at the time the journal entry was made. If left blank, the current exchange rate defaults.GL148, GL167, GL191, GL196, GL197, GL199, GL40.2, GL40.6 +3 more
GLC-NET-BASE-AMT
NET_BASE_AMT		DerivedThe net amount in the base currency.—
GLC-NET-BASE-AREV
NET_BASE_AREV		DerivedThe net reversed in the base currency.—
GLC-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The company name or description.GL146, GL148, GL167, GL191, GL196, GL197, GL199, GL40.1 +9 more
GLC-AUTO-REV
AUTO_REV		Alpha 1Auto reversal is the process of reversing the transaction. If you select auto reverse, the Lawson General Ledger closing program creates a reversing journal entry in the next period for this transaction. " " = No
  • Y Yes
  • N No
GL146, GL148, GL197, GL199, GL40.1, GL40.2, GL40.3, GL40.6 +6 more
GLC-SOURCE-CODE
SOURCE_CODE		Alpha 2A two-character code assigned to a transaction to identify where the transaction was created.GL146, GL196, GL197, GL199, GL40.1, GL40.2, GL40.3, GL40.6 +5 more
GLC-REFERENCE
REFERENCE		Alpha 10 (Lower Case)The reference you enter for this journal entry appears on inquiries and reports.GL146, GL148, GL167, GL191, GL196, GL197, GL199, GL40.1 +9 more
GLC-DOCUMENT-NBR
DOCUMENT_NBR		Alpha 27The document number assigned to the journal entry. This is used in conjunction with the Journal by Document option in GL10 (Company).GL146, GL197, GL199, GL40.1, GL40.2, GL40.3, GL40.7, GL40.8 +4 more
GLC-EFFECT-DATE
EFFECT_DATE		Numeric 8 (yyyymmdd)The effective date.GL148, GL197, GL199, GL40.2, GL500, IFGT.1
GLC-JRNL-BOOK-NBR
JRNL_BOOK_NBR		Alpha 12The journal book assigned to the transaction.GL146, GL190, GL197, GL199, GL40.1, GL40.2, GL40.3, GL40.6 +6 more
GLC-TRAN-DESC-DFLT
TRAN_DESC_DFLT		Alpha 1The transaction description default. Indicates if the new journal entry is a journal entry header or prior transaction line.
  • J Journal Entry
  • P Prior Transaction Line
GL146, GL197, GL199, GL40.1, GL40.2, GL40.3, GL40.7, GL40.8 +3 more
GLC-MX-VALUE
MX_VALUE		Alpha 32 Occurs 3 Times ×3The attribute value.GL199, GL40.2, GL500
GLC-MX-CATEGORY-1
MX_CATEGORY_1		DerivedThe attribute category associated with the transaction.—
GLC-MX-CATEGORY-2
MX_CATEGORY_2		DerivedThe attribute category associated with the transaction.—
GLC-MX-CATEGORY-3
MX_CATEGORY_3		DerivedThe attribute category associated with the transaction.—
GLC-MX-DESC-1
MX_DESC_1		DerivedThe attribute category description.—
GLC-MX-DESC-2
MX_DESC_2		DerivedThe attribute category description.—
GLC-MX-DESC-3
MX_DESC_3		DerivedThe attribute category description.—
GLC-CLOSE-SEQ
CLOSE_SEQ		Numeric 2Contains the closing sequence number.GL146, GL191, GL197, GL199, GL40.1, GL40.2, GL40.3, GL40.6 +6 more
GLC-ACT-POST-DATE
ACT_POST_DATE		Numeric 8 (yyyymmdd)Contains the posting date for activity transactions.GL146, GL190, GL197, GL40.1, GL40.2, GL40.3, GL40.6, GL40.7 +4 more
GLC-JBK-SEQ-NBR
JBK_SEQ_NBR		Numeric 10The journal book sequence number assigned to a journal book transaction when it is added or interfaced to the Lawson system. Used only when Auto Journal Book Seq Nbr is set to Yes in GL10.1 (Company).GL40.2, GL40.6, GL500, IFGT.1
GLC-JE-APPROVE-FLG
JE_APPROVE_FLG		Alpha 1This indicates if the journal entry is released.GL146, GL170, GL197, GL199, GL40.1, GL40.2, GL40.3, GL40.7 +6 more
GLC-SEGMENT-BLOCK
SEGMENT_BLOCK		Alpha 103This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information.GL40.2, GL500
GLC-WF-JE-CTRL-NBR
WF_JE_CTRL_NBR		DerivedThe workflow journal entry number.—
GLC-AUTO-REV-PD
AUTO_REV_PD		Numeric 2—GL146, GL197, GL199, GL40.1, GL40.2, GL40.3, GL40.7, GL40.8 +3 more
GLC-REVERSE
REVERSE		Alpha 1This field indicates if a reversing journal entry will be created by GL199 for this journal entry.GL190, GL500
GLC-HOLD-REM-OPER
HOLD_REM_OPER		Alpha 10This field is used to store the login id of the person who entered the record.GL145, GL146, GL197, GL40.1, GL40.2, GL40.3, GL40.7, GL40.8 +2 more
GLC-BLANK
BLANK		DerivedThis field consists of blank spaces. It is used to provide column headings on Drill Arounds.—
GLC-CREATED-BY
CREATED_BY		Alpha 10—GL146, GL167, GL191, GL196, GL197, GL199, GL40.1, GL40.2 +9 more
GLC-LAST-UPDT-DATE
LAST_UPDT_DATE		Numeric 8 (yyyymmdd)—GL110, GL145, GL146, GL148, GL167, GL170, GL190, GL191 +15 more
GLC-LAST-UPDT-TIME
LAST_UPDT_TIME		Numeric 8—GL110, GL145, GL146, GL148, GL167, GL170, GL190, GL191 +15 more
GLC-LAST-UPDATE-BY
LAST_UPDATE_BY		Alpha 10—GL110, GL145, GL146, GL148, GL167, GL170, GL190, GL191 +15 more

Indexes (7)

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

IndexKeysFlagsConditionUsed in
GLCSET1COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCEPrimaryAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)
GLCSET2COMPANY, FISCAL-YEAR, ACCT-PERIOD, STATUS, SYSTEM, CONTROL-GROUP, JE-TYPE, JE-SEQUENCEKeyChangeGL110, GL146, GL199, GL240, GL300, GL45.1, GL500
GLCSET3COMPANY, SYSTEM, FISCAL-YEAR, ACCT-PERIOD, JE-TYPE, CONTROL-GROUP, JE-SEQUENCEKeyChange, SubsetWhere STATUS = 3GL167
GLCSET4COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCESubsetWhere ((STATUS = Zeroes) Or (STATUS = 6))GL240, GL40.1, GL40.2
GLCSET5COMPANY, HOLD-CODE, FISCAL-YEAR, ACCT-PERIOD, STATUS, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCEKeyChange, SubsetWhere HOLD-CODE != SpacesGL145, GL45.1, GL12.1, GL12.2
GLCSET6COMPANY, FISCAL-YEAR, ACCT-PERIOD, CLOSE-SEQ, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCEKeyChangeGL199
GLCSET7COMPANY, POSTING-DATE, LAST-UPDT-DATE, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCEKeyChange—

Relations

One to one (14) — lookups and parents

RelationTableRulesConditionField map
CompanyGLSYSTEMRequiredGLC-COMPANY → GLS-COMPANY (GLSSET1)
Cucontrol OneCUCONTROLNot RequiredGLC-COMPANY → CLC-COMPANY, GLC-FISCAL-YEAR → CLC-FISCAL-YEAR, GLC-ACCT-PERIOD → CLC-ACCT-PERIOD, GLC-SYSTEM → CLC-SYSTEM, GLC-JE-TYPE → CLC-JE-TYPE, GLC-CONTROL-GROUP → CLC-CONTROL-GROUP, GLC-JE-SEQUENCE → CLC-JE-SEQUENCE, 1 → CLC-AMT-TYPE, GLS-CURR-CODE-1 → CLC-CURRENCY-CODE
Cucontrol TwoCUCONTROLNot RequiredGLC-COMPANY → CLC-COMPANY, GLC-FISCAL-YEAR → CLC-FISCAL-YEAR, GLC-ACCT-PERIOD → CLC-ACCT-PERIOD, GLC-SYSTEM → CLC-SYSTEM, GLC-JE-TYPE → CLC-JE-TYPE, GLC-CONTROL-GROUP → CLC-CONTROL-GROUP, GLC-JE-SEQUENCE → CLC-JE-SEQUENCE, 2 → CLC-AMT-TYPE, GLS-CURR-CODE-2 → CLC-CURRENCY-CODE
GlcbodGLCBODNot RequiredGLC-COMPANY → YCM-COMPANY, GLC-FISCAL-YEAR → YCM-FISCAL-YEAR, GLC-ACCT-PERIOD → YCM-ACCT-PERIOD, GLC-SYSTEM → YCM-SYSTEM, GLC-JE-TYPE → YCM-JE-TYPE, GLC-CONTROL-GROUP → YCM-CONTROL-GROUP, GLC-JE-SEQUENCE → YCM-JE-SEQUENCE
GlholdcodeGLHOLDCODENot RequiredGLC-HOLD-CODE → GLH-HOLD-CODE
Glsccat 1GLSCCATNot RequiredGLC-SOURCE-CODE → GSC-SOURCE-CODE, 1 → GSC-SEQ-NBR
Glsccat 2GLSCCATNot RequiredGLC-SOURCE-CODE → GSC-SOURCE-CODE, 2 → GSC-SEQ-NBR
Glsccat 3GLSCCATNot RequiredGLC-SOURCE-CODE → GSC-SOURCE-CODE, 3 → GSC-SEQ-NBR
GlsrccodeGLSRCCODENot RequiredGLC-SOURCE-CODE → GSR-SOURCE-CODE
GlsysjeGLSYSJENot RequiredGLC-COMPANY → GSJ-COMPANY, GLC-SYSTEM → GSJ-SYSTEM, GLC-FISCAL-YEAR → GSJ-FISCAL-YEAR, GLC-ACCT-PERIOD → GSJ-ACCT-PERIOD
Mxcatdef 1MXCATDEFRequiredGSC-MATRIX-CAT → MXC-MATRIX-CAT
Mxcatdef 2MXCATDEFNot RequiredGSC-MATRIX-CAT → MXC-MATRIX-CAT
Mxcatdef 3MXCATDEFNot RequiredGSC-MATRIX-CAT → MXC-MATRIX-CAT
SystemGLCODESNot RequiredGLC-COMPANY → GCD-COMPANY, GLC-SYSTEM → GCD-SYSTEM

One to many (5) — child tables

RelationTableRulesConditionField map
Glcntrlau1GLCNTRLAUGLC-COMPANY → GCU-COMPANY, GLC-FISCAL-YEAR → GCU-FISCAL-YEAR, GLC-ACCT-PERIOD → GCU-ACCT-PERIOD, GLC-SYSTEM → GCU-SYSTEM, GLC-JE-TYPE → GCU-JE-TYPE, GLC-CONTROL-GROUP → GCU-CONTROL-GROUP, GLC-JE-SEQUENCE → GCU-JE-SEQUENCE, → GCU-ACTION, → GCU-DATE, → GCU-TIME, → GCU-UNIQUE-I-D
GljelogGLJELOGGLC-COMPANY → GJL-COMPANY, GLC-FISCAL-YEAR → GJL-FISCAL-YEAR, GLC-ACCT-PERIOD → GJL-ACCT-PERIOD, GLC-SYSTEM → GJL-SYSTEM, GLC-JE-TYPE → GJL-JE-TYPE, GLC-CONTROL-GROUP → GJL-CONTROL-GROUP, GLC-JE-SEQUENCE → GJL-JE-SEQUENCE, → GJL-LINE-NBR, → GJL-LOG-SEQ-NBR
Gljelog CntrlGLJELOGGLC-COMPANY → GJL-COMPANY, GLC-FISCAL-YEAR → GJL-FISCAL-YEAR, GLC-ACCT-PERIOD → GJL-ACCT-PERIOD, GLC-SYSTEM → GJL-SYSTEM, GLC-JE-TYPE → GJL-JE-TYPE, GLC-CONTROL-GROUP → GJL-CONTROL-GROUP, GLC-JE-SEQUENCE → GJL-JE-SEQUENCE, Zeroes → GJL-LINE-NBR, → GJL-LOG-SEQ-NBR
Gljelog LineGLJELOGGLC-COMPANY → GJL-COMPANY, GLC-FISCAL-YEAR → GJL-FISCAL-YEAR, GLC-ACCT-PERIOD → GJL-ACCT-PERIOD, GLC-SYSTEM → GJL-SYSTEM, GLC-JE-TYPE → GJL-JE-TYPE, GLC-CONTROL-GROUP → GJL-CONTROL-GROUP, GLC-JE-SEQUENCE → GJL-JE-SEQUENCE, → GJL-LINE-NBR, → GJL-LOG-SEQ-NBR
GltransGLTRANSDelete CascadesGLC-COMPANY → GLT-COMPANY, GLC-FISCAL-YEAR → GLT-FISCAL-YEAR, GLC-ACCT-PERIOD → GLT-ACCT-PERIOD, GLC-CONTROL-GROUP → GLT-CONTROL-GROUP, GLC-SYSTEM → GLT-SYSTEM, GLC-JE-TYPE → GLT-JE-TYPE, GLC-JE-SEQUENCE → GLT-JE-SEQUENCE, → GLT-LINE-NBR

Programs

Updated by (24)

Referenced by (155)