GLCONTROL FILE
General Ledger Control
This file contains journal entry control information. This information is
used to process the journal entry detail records.
REFERENCED BY
CA15.1 CA15.2 CA190 GL170 GL240 GL241
GL245 GL247 GL256 GL270 GL284 GL285
GL286 GL287 GL288 GL289 GL290 GL297
GL41.1 GL41.3 GL90.1 GL90.2 JB240 GL10.1
IFJR.1 GL12.1 GL12.2
UPDATED BY
GL110 GL145 GL146 GL167 GL190 GL191
GL196 GL199 GL300 GL40.1 GL40.2 GL40.3
GL40.5 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1
GL500 GL75.1 GL951 GL980 IFGT.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLC-COMPANY Numeric 4 GL110 GL167
Company The company number represents an GL191 GL196
established company and is entered on GL199 GL40.2
all function codes. GL40.7 GL45.1
GL500 GL951
IFGT.1
GLC-FISCAL-YEAR Numeric 4 GL167 GL191
Fiscal Year This is the current fiscal year. This GL196 GL199
field is updated by GL199 (Period GL40.2 GL40.7
Closing). GL45.1 GL500
GL951 IFGT.1
GLC-ACCT-PERIOD Numeric 2 GL167 GL191
Account Period The accounting period assigned to the GL196 GL199
journal entry. GL40.2 GL40.7
GL45.1 GL500
GL951 IFGT.1
GLC-SYSTEM Alpha 2 GL167 GL191
System This is the journal entry system code. GL196 GL199
GL40.2 GL40.7
GL45.1 GL500
GL951 IFGT.1
GLC-JE-TYPE Alpha 1 GL167 GL191
Journal Entry Type Displays the type of journal entry GL196 GL199
created. GL40.2 GL40.7
GL45.1 GL500
N = Normal GL951 IFGT.1
I = Intercompany
A = Auto Rev Normal
R = Auto Rev Intco
GLC-JE-TYPE-1 Derived
Journal Entry Type Displays the derived journal entry type.
GLC-CONTROL-GROUP Numeric 8 GL167 GL191
Control Group This field contains the journal entry GL196 GL199
number used for process control of the GL40.2 GL40.7
journal entry detail. GL45.1 GL500
GL951 IFGT.1
GLC-JE-SEQUENCE Numeric 2 GL167 GL190
Journal Entry The unique journal entry sequence GL191 GL196
Sequence number. GL199 GL40.2
GL40.7 GL45.1
GL500 GL951
IFGT.1
GLC-STATUS Numeric 1 GL146 GL167
Status This field contains the processing GL190 GL191
cycle status of the assigned journal GL196 GL199
entry. GL40.7 GL45.1
GL500 GL951
0 = Unreleased IFGT.1
1 = Released
2 = Post In Progress
3 = Load In Process
4 = Quick Posted
5 = Posted
9 = History
GLC-STATUS-1 Derived
Status This field displays the journal entry
status.
GLC-CNTRL-AMOUNT Signed 15.2 GL146 GL190
Control Amount Displays the total journal entry amount. GL45.1 GL500
GL951
GLC-ENTRY-DB Signed 15.2 GL146 GL167
Entry Debit Displays the total debit amount for the GL190 GL191
journal entry. GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL40.9 GL44.1
GL45.1 GL500
GL951 IFGT.1
GLC-ENTRY-CR Signed 15.2 GL146 GL167
Entry Credit Displays the total credit amount for GL190 GL191
the journal entry. GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL40.9 GL44.1
GL45.1 GL500
GL951 IFGT.1
GLC-TRAN-ND Numeric 1 GL167 GL191
Trans Number of The number of decimal positions defined GL196 GL199
Decimals for the transaction currency. GL40.2 GL40.6
GL41.3 GL45.1
GL500 GL951
IFGT.1
GLC-UNIT-CNTRL-DB Signed 15.2 GL190 GL500
Unit Cntrl Db The journal entry total for positive GL951
detail unit balances.
GLC-UNIT-CNTRL-CR Signed 15.2 GL190 GL500
Unit Cntrl Cr The journal entry total for negative GL951
detail unit balances.
GLC-UNIT-ENTRY-DB Signed 15.2 GL146 GL167
Unit Entry Db Displays the total debit units for the GL190 GL191
journal entry. GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL40.9 GL44.1
GL45.1 GL500
GL951 IFGT.1
GLC-UNIT-ENTRY-CR Signed 15.2 GL146 GL167
Unit Entry Cr Displays the total credit units for the GL190 GL191
journal entry. GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL40.9 GL44.1
GL45.1 GL500
GL951 IFGT.1
GLC-AUTO-UNIT-DB Signed 15.2 GL146 GL190
Auto Unit Db The total positive detail auto GL191 GL40.1
reversing units amounts. GL40.2 GL40.3
GL40.7 GL40.8
GL40.9 GL44.1
GL45.1 GL500
GL951 IFGT.1
GLC-AUTO-UNIT-CR Signed 15.2 GL146 GL190
Auto Unit Cr The total negative detail auto GL191 GL40.1
reversing unit amounts. GL40.2 GL40.3
GL40.7 GL40.8
GL40.9 GL44.1
GL45.1 GL500
GL951 IFGT.1
GLC-DATE Numeric 8 (yyyymmdd) GL167 GL191
Date This field contains the system date GL196 GL199
when this was created. GL40.2 GL40.7
GL45.1 GL500
GL951 IFGT.1
GLC-LINE-NBR Numeric 6 GL146 GL167
Line Number This field contains the line number. GL190 GL191
GL196 GL199
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 GL500
GL951 IFGT.1
GLC-NBR-LINES Numeric 6 GL146 GL190
Number of Lines This is the number of detail lines. GL191 GL199
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 GL500
GL951 IFGT.1
GLC-OPERATOR Alpha 10 GL146 GL167
Operator This field is used to store the login GL191 GL196
ID of the person who entered the record. GL199 GL40.2
GL40.7 GL45.1
GL500 GL951
IFGT.1
GLC-REL-OPERATOR Alpha 10 GL199 GL500
Release Operator The operator ID assigned to the GL951 IFGT.1
released journal entry.
GLC-RELEASED-FLAG Alpha 1 GL190 GL199
Released Flag This flag is set to Yes when a Journal GL40.7 GL500
Entry is Released. If the Journal Entry GL951 IFGT.1
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
GLC-HOLD-CODE Alpha 4 GL145 GL146
Hold Code The journal hold code. GL199 GL40.2
GL45.1 GL500
GL951 IFGT.1
GLC-PER-DATE-FLAG Alpha 1 GL40.2 GL40.7
Period Date Flag Indicates the period or date derived. GL45.1 GL500
P = Period Derived GL951 IFGT.1
D = Date Derived
GLC-POSTING-DATE Numeric 8 (yyyymmdd) GL146 GL167
Posting Date The date assigned to the journal entry GL191 GL196
for posting. GL199 GL40.2
GL40.7 GL45.1
GL500 GL951
IFGT.1
GLC-LAST-CMT-SEQ Numeric 4 GL146 GL190
Last Comment The sequence number of the last comment GL199 GL40.1
Sequence Number for the journal entry. GL40.2 GL40.3
GL40.5 GL40.7
GL40.8 GL40.9
GL44.1 GL45.1
GL500 GL951
IFGT.1
GLC-LAST-LOG-SEQ Numeric 6 GL146 GL190
Last Logfile The last sequence control number. GL191 GL199
Sequence Number GL40.2 GL40.7
GL45.1 GL500
GL951 IFGT.1
GLC-BASE-ZONE Alpha 15 GL146 GL167
Base Zone The base zone as assigned for interzone GL191 GL196
balance processing. GL199 GL40.2
GL40.7 GL45.1
GL500 GL951
IFGT.1
GLC-BASE-DEBITS Signed 15.2 GL146 GL167
Base Debits The total positive detail amount in the GL190 GL191
company base currency. GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL40.9 GL44.1
GL45.1 GL500
GL951 IFGT.1
GLC-BASE-CREDITS Signed 15.2 GL146 GL167
Base Credits The total negative detail amount in the GL190 GL191
company base currency. GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL40.9 GL44.1
GL45.1 GL500
GL951 IFGT.1
GLC-BASE-AUTO-DB Signed 15.2 GL146 GL190
Base Auto Debits The total positive detail auto GL191 GL40.1
reversing amount in the company base GL40.2 GL40.3
currency. GL40.7 GL40.8
GL40.9 GL44.1
GL45.1 GL500
GL951 IFGT.1
GLC-BASE-AUTO-CR Signed 15.2 GL146 GL190
Base Auto Credits The total negative detail auto GL191 GL40.1
reversing amount in the company base GL40.2 GL40.3
currency. GL40.7 GL40.8
GL40.9 GL44.1
GL45.1 GL500
GL951 IFGT.1
GLC-BASE-ND Numeric 1 GL167 GL191
Base Number of The number of decimal positions defined GL196 GL199
Decimals for the company base currency. GL40.2 GL40.7
GL45.1 GL500
GL951 IFGT.1
GLC-CURRENCY-CODE Alpha 5 GL167 GL191
Currency Code This field contains the company base GL196 GL199
currency code established in GL10.1 GL40.2 GL45.1
(Company). GL500 GL951
IFGT.1
GLC-BASERATE Signed 12.6 GL167 GL191
Base Rate The exchange rate at the time the GL196 GL199
journal entry was made. If left blank, GL40.2 GL40.7
the current exchange rate defaults. GL45.1 GL500
GL951 IFGT.1
GLC-NET-BASE-AMT Derived
Net Base Amount The net amount in the base currency.
GLC-NET-BASE-AREV Derived
Net Base Reversed The net reversed in the base currency.
GLC-DESCRIPTION Alpha 30 (Lower Case) GL146 GL167
Description The company name or description. GL191 GL196
GL199 GL40.2
GL40.7 GL45.1
GL500 GL951
IFGT.1
GLC-AUTO-REV Alpha 1 GL146 GL199
Auto Reverse Auto reversal is the process of GL40.2 GL45.1
reversing the transaction. If you select GL500 GL951
auto reverse, the Lawson General Ledger IFGT.1
closing program creates a reversing
journal entry in the next period for
this transaction.
Y = Yes
N = No
" " = No
GLC-SOURCE-CODE Alpha 2 GL146 GL196
Source Code A two-character code assigned to a GL199 GL40.2
transaction to identify where the GL45.1 GL500
transaction was created. GL951
GLC-REFERENCE Alpha 10 (Lower Case) GL146 GL167
Reference The reference you enter for this GL191 GL196
journal entry appears on inquiries and GL199 GL40.2
reports. GL40.7 GL45.1
GL500 GL951
IFGT.1
GLC-DOCUMENT-NBR Alpha 24 GL146 GL199
Document Number The document number assigned to the GL40.2 GL45.1
journal entry. GL500 GL951
GL980 IFGT.1
GLC-EFFECT-DATE Numeric 8 (yyyymmdd) GL199 GL40.2
Effective Date The effective date. GL500 GL951
GLC-JRNL-BOOK-NBR Alpha 12 GL146 GL190
Journal Book The journal book assigned to the GL199 GL40.2
transaction. GL40.7 GL45.1
GL500 GL951
IFGT.1
GLC-TRAN-DESC-DFLT Alpha 1 GL146 GL199
Transaction The transaction description default. GL40.2 GL45.1
Description Indicates if the new journal entry is a GL500 GL951
journal entry header or prior
transaction line.
J = Journal Entry
P = Prior Transaction Line
GLC-MX-VALUE Alpha 20 Occurs 3 Times GL199 GL40.2
Matrix Value The attribute value. GL500 GL951
GLC-MX-CATEGORY-1 Derived
Matrix Category The attribute category associated with
the transaction.
GLC-MX-CATEGORY-2 Derived
Matrix Category The attribute category associated with
the transaction.
GLC-MX-CATEGORY-3 Derived
Matrix Category The attribute category associated with
the transaction.
GLC-MX-DESC-1 Derived
Description The attribute category description.
GLC-MX-DESC-2 Derived
Description The attribute category description.
GLC-MX-DESC-3 Derived
Description The attribute category description.
GLC-CLOSE-SEQ Numeric 2 GL146 GL191
Close Sequence Contains the closing sequence number. GL199 GL40.1
GL40.2 GL40.3
GL40.8 GL40.9
GL44.1 GL45.1
GL500 GL951
IFGT.1
GLC-ACT-POST-DATE Numeric 8 (yyyymmdd) GL146 GL190
Act Post Date Contains the posting date for activity GL45.1 GL500
transactions. GL951
GLC-JBK-SEQ-NBR Numeric 10 GL40.2 GL40.7
Journal Book The journal book sequence number GL951 IFGT.1
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).
GLC-JE-APPROVE-FLG Alpha 1 GL146 GL40.1
Je Approve Flg This indicates if the journal entry is GL40.2 GL40.3
released. GL40.8 GL40.9
GL44.1 GL45.1
N = Not Yet Approved GL75.1
Y = Approved
D = Disapproved
GLC-SEGMENT-BLOCK Alpha 103 GL40.2
User Analysis This 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.
GLC-WF-JE-CTRL-NBR Derived
Wf Je Ctrl Nbr The workflow journal entry number.
GLCONTROL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLCSET1 COMPANY CA15.1 CA15.2
FISCAL-YEAR CA190 GL110
ACCT-PERIOD GL146 GL167
SYSTEM GL170 GL190
JE-TYPE GL191 GL196
CONTROL-GROUP GL199 GL240
JE-SEQUENCE GL241 GL245
GL247 GL256
GL270 GL284
GL285 GL286
GL287 GL288
GL289 GL290
GL297 GL300
GL40.1 GL40.2
GL40.3 GL40.5
...
GLCSET2 COMPANY KeyChange GL146 GL199
FISCAL-YEAR GL240 GL45.1
ACCT-PERIOD GL500
STATUS
SYSTEM
CONTROL-GROUP
JE-TYPE
JE-SEQUENCE
GLCSET3 COMPANY KeyChange, Subset GL167
SYSTEM Where STATUS = 3
FISCAL-YEAR
ACCT-PERIOD
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
GLCSET4 COMPANY Subset GL240 GL40.1
FISCAL-YEAR Where STATUS = Zeroes GL40.2
ACCT-PERIOD
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
GLCSET5 COMPANY KeyChange, Subset GL145 GL45.1
HOLD-CODE Where HOLD-CODE != Spaces GL12.1 GL12.2
FISCAL-YEAR
ACCT-PERIOD
STATUS
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
GLCSET6 COMPANY KeyChange GL199
FISCAL-YEAR
ACCT-PERIOD
CLOSE-SEQ
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
GLCONTROL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
GLC-COMPANY -> GLS-COMPANY
Cucontrol One CUCONTROL Not Required
GLC-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 Two CUCONTROL Not Required
GLC-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
Glholdcode GLHOLDCODE Not Required
GLC-HOLD-CODE -> GLH-HOLD-CODE
Glsccat 1 GLSCCAT Not Required
GLC-SOURCE-CODE -> GSC-SOURCE-CODE
1 -> GSC-SEQ-NBR
Glsccat 2 GLSCCAT Not Required
GLC-SOURCE-CODE -> GSC-SOURCE-CODE
2 -> GSC-SEQ-NBR
Glsccat 3 GLSCCAT Not Required
GLC-SOURCE-CODE -> GSC-SOURCE-CODE
3 -> GSC-SEQ-NBR
Glsrccode GLSRCCODE Not Required
GLC-SOURCE-CODE -> GSR-SOURCE-CODE
Glsysje GLSYSJE Not Required
GLC-COMPANY -> GSJ-COMPANY
GLC-SYSTEM -> GSJ-SYSTEM
GLC-FISCAL-YEAR -> GSJ-FISCAL-YEAR
GLC-ACCT-PERIOD -> GSJ-ACCT-PERIOD
Mxcatdef 1 MXCATDEF Required
GSC-MATRIX-CAT -> MXC-MATRIX-CAT
Mxcatdef 2 MXCATDEF Not Required
GSC-MATRIX-CAT -> MXC-MATRIX-CAT
Mxcatdef 3 MXCATDEF Not Required
GSC-MATRIX-CAT -> MXC-MATRIX-CAT
System GLCODES Not Required
GLC-COMPANY -> GCD-COMPANY
GLC-SYSTEM -> GCD-SYSTEM
GLCONTROL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Comments GLCOMMENT Delete Cascades
GLC-COMPANY -> GCM-COMPANY
"J" -> GCM-RECORD-TYPE
GLC-SYSTEM -> GCM-SYSTEM
GLC-FISCAL-YEAR -> GCM-FISCAL-YEAR
GLC-ACCT-PERIOD -> GCM-ACCT-PERIOD
GLC-CONTROL-GROUP -> GCM-CONTROL-GROUP
GLC-JE-TYPE -> GCM-JE-TYPE
GLC-JE-SEQUENCE -> GCM-JE-SEQUENCE
GCM-SEQUENCE-NBR
Gljelog GLJELOG
GLC-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 Cntrl GLJELOG
GLC-COMPANY -> GJL-COMPANY
GLC-FISCAL-YEAR -> GJL-FISCAL-YEAR
GLC-ACCT-PERIOD -> GJL-ACCT-PERIOD
GLC-AUTO-REV -> GJL-SYSTEM
GLC-AUTO-REV -> GJL-JE-TYPE
GLC-CONTROL-GROUP -> GJL-CONTROL-GROUP
GLC-JE-SEQUENCE -> GJL-JE-SEQUENCE
Zeroes -> GJL-LINE-NBR
GJL-LOG-SEQ-NBR
Gljelog Line GLJELOG
GLC-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
Gltrans GLTRANS Delete Cascades
GLC-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
Wfhiswkuni WFHISWKUNI
"GLCSET1 " -> WFI-OBJECT-NAME
GLC-WF-JE-CTRL-NBR -> WFI-KEY-STRING
WFI-WORKUNIT
Wfworkunit WFWORKUNIT
"GLCSET1 " -> WFW-OBJECT-NAME
GLC-WF-JE-CTRL-NBR -> WFW-KEY-STRING
WFW-WORKUNIT
|