Lawson Insight Technical Documentation |
|
GLCONTROL
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 FB11.1 FB111 FB211
FB296 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5
FB95.6 GL240 GL241 GL245 GL247 GL256
GL270 GL284 GL285 GL286 GL287 GL288
GL289 GL290 GL297 GL298 GL90.1 GL90.2
GL90.5 GL94.1 GL94.2 GL94.3 GL94.4 GL94.5
GL94.6 GL94.7 GL95.1 GL95.2 GL95.3 GL95.4
GL95.5 GL95.6 GL95.7 GL95.8 GL95.9 GL96.1
GL96.2 GL96.3 GL96.4 GL96.5 GL97.1 GL97.2
GL97.3 GL97.4 GL97.5 GL97.6 GL97.7 GL97.8
GL97.9 GL98.1 GL98.2 GL98.3 GL98.4 GL98.5
GL99.1 GL99.2 GL99.3 GL99.4 GL99.5 GL99.6
GLCC.1 JB240 GL10.1 IFJR.1 GL12.1 GL12.2
UPDATED BY
GL110 GL145 GL146 GL167 GL170 GL190
GL191 GL196 GL197 GL199 GL300 GL40.1
GL40.2 GL40.3 GL40.6 GL40.7 GL40.8 GL41.4
GL44.1 GL45.1 GL500 GL700 GL75.1 IFGT.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLC-COMPANY Numeric 4 GL110 GL167
Element: Company The company number represents an GL191 GL196
established company and is entered on GL197 GL199
all function codes. GL40.2 GL40.6
GL41.4 GL45.1
GL500 GLCC.1
IFGT.1
GLC-FISCAL-YEAR Numeric 4 GL167 GL191
Element: Fiscal Year This is the current fiscal year. This GL196 GL197
field is updated by Period Closing GL199 GL40.2
(GL199). GL40.6 GL41.4
GL45.1 GL500
GLCC.1 IFGT.1
GLC-ACCT-PERIOD Numeric 2 GL167 GL191
Element: Account PeriodThe accounting period assigned to the GL196 GL197
journal entry. GL199 GL40.2
GL40.6 GL41.4
GL45.1 GL500
GLCC.1 IFGT.1
GLC-SYSTEM Alpha 2 GL167 GL191
Element: System This is the journal entry system code. GL196 GL197
GL199 GL40.2
GL40.6 GL41.4
GL45.1 GL500
GLCC.1 IFGT.1
GLC-JE-TYPE Alpha 1 GL167 GL191
Element: Journal Entry Displays the type of journal entry GL196 GL197
created. GL199 GL40.2
GL40.6 GL41.4
N = Normal GL45.1 GL500
I = Intercompany GLCC.1 IFGT.1
A = Auto Rev Normal
R = Auto Rev Intco
GLC-JE-TYPE-1 Derived
Element: Journal Entry Displays the derived journal entry
type.
GLC-CONTROL-GROUP Numeric 8 GL167 GL191
Element: Control Group This field displays the journal entry GL196 GL197
number used for process control of the GL199 GL40.2
journal entry detail. GL40.6 GL41.4
GL45.1 GL500
GLCC.1 IFGT.1
GLC-JE-SEQUENCE Numeric 2 GL146 GL167
Journal Entry The unique journal entry sequence GL190 GL191
Sequence number. GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL41.4
GL44.1 GL45.1
GL500 GLCC.1
IFGT.1
GLC-STATUS Numeric 1 GL146 GL167
Element: Status This field contains the processing GL190 GL191
cycle status of the assigned journal GL196 GL197
entry. GL199 GL40.1
GL40.2 GL40.3
0 = Unreleased GL40.6 GL40.7
1 = Released GL40.8 GL44.1
2 = Post In Progress GL45.1 GL500
3 = Load In Process IFGT.1
4 = Quick Posted
5 = Posted
9 = History
GLC-STATUS-1 Derived
Element: Status This field displays the journal entry
status.
GLC-CNTRL-AMOUNT Signed 15.2 GL146 GL190
Element: Control AmountDisplays the total journal entry GL197 GL40.1
amount. GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
GLC-ENTRY-DB Signed 15.2 GL146 GL167
Element: Entry Debit GL190 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-ENTRY-CR Signed 15.2 GL146 GL167
Element: Entry Credit GL190 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-TRAN-ND Numeric 1 GL167 GL191
Trans Number of GL196 GL197
Decimals GL199 GL40.2
GL40.5 GL41.3
GL45.1 GL500
IFGT.1
GLC-UNIT-CNTRL-DB Signed 15.2 GL190 GL500
Element: Auto Debits
GLC-UNIT-CNTRL-CR Signed 15.2 GL190 GL500
Element: Auto Credits The journal entry total for negative
detail unit balances.
GLC-UNIT-ENTRY-DB Signed 15.2 GL146 GL167
Element: Auto Debits GL190 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-UNIT-ENTRY-CR Signed 15.2 GL146 GL167
Element: Auto Credits GL190 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-AUTO-UNIT-DB Signed 15.2 GL146 GL190
Element: Auto Debits GL191 GL197
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-AUTO-UNIT-CR Signed 15.2 GL146 GL190
Element: Auto Credits GL191 GL197
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-DATE Numeric 8 (yyyymmdd) GL167 GL191
Element: Date This field displays the system date GL196 GL197
when this was created. GL199 GL40.2
GL40.6 GL45.1
GL500 IFGT.1
GLC-LINE-NBR Numeric 6 GL146 GL167
Element: Line Number This field contains the line number. GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-NBR-LINES Numeric 6 GL146 GL167
Element: Number of LineThis is the number of detail lines. GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-OPERATOR Alpha 10 GL146 GL167
Element: Operator This field is used to store the login GL191 GL196
ID of the person who entered the record. GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-REL-OPERATOR Alpha 10 GL199 GL40.6
Element: Release OperatThe operator ID assigned to the GL500 IFGT.1
released journal entry.
GLC-RELEASED-FLAG Alpha 1 GL190 GL199
Element: Released Flag This flag is set to Yes when a Journal GL40.6 GL500
Entry is Released. If the Journal Entry 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
Element: Hold Code The journal hold code. GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLC-PER-DATE-FLAG Alpha 1 GL40.2 GL40.6
Element: Period Date FlIndicates the period or date derived. GL45.1 GL500
P = Period Derived IFGT.1
D = Date Derived
GLC-POSTING-DATE Numeric 8 (yyyymmdd) GL146 GL167
Element: Posting Date GL191 GL196
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-LAST-CMT-SEQ Numeric 4 GL190 GL199
Last Comment GL500
Sequence Number
GLC-LAST-LOG-SEQ Numeric 6 GL146 GL190
Last Logfile The last sequence control number. GL191 GL197
Sequence Number GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLC-BASE-ZONE Alpha 15 GL146 GL167
Element: Base Zone The base zone as assigned for interzone GL191 GL196
balance processing. GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-BASE-DEBITS Signed 15.2 GL146 GL167
Element: Base Debits GL190 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-BASE-CREDITS Signed 15.2 GL146 GL167
Element: Base Credits GL190 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-BASE-AUTO-DB Signed 15.2 GL146 GL190
Element: Base Auto DebiThe total positive detail auto GL191 GL197
reversing amount in the company base GL40.1 GL40.2
currency. GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-BASE-AUTO-CR Signed 15.2 GL146 GL190
Element: Base Auto Credits GL191 GL197
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-BASE-ND Numeric 1 GL167 GL191
Base Number of GL196 GL197
Decimals GL199 GL40.2
GL40.6 GL45.1
GL500 IFGT.1
GLC-CURRENCY-CODE Alpha 5 GL167 GL191
Element: Currency Code This field contains the company base GL196 GL197
currency code established in Company GL199 GL40.2
(GL10.1 ). GL45.1 GL500
IFGT.1
GLC-BASERATE Signed 12.6 GL167 GL191
Element: Base Rate The exchange rate at the time the GL196 GL197
journal entry was made. If left blank, GL199 GL40.2
the current exchange rate defaults. GL40.6 GL45.1
GL500 IFGT.1
GLC-NET-BASE-AMT Derived
Element: Net Base AmounThe net amount in the base currency.
GLC-NET-BASE-AREV Derived
Element: Net Base ReverThe net reversed in the base currency.
GLC-DESCRIPTION Alpha 30 (Lower Case) GL146 GL167
Element: Description The company name or description. GL191 GL196
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-AUTO-REV Alpha 1 GL146 GL197
Element: Auto Reverse Auto reversal is the process of GL199 GL40.1
reversing the transaction. If you select GL40.2 GL40.3
auto reverse, the Lawson General Ledger GL40.7 GL40.8
closing program creates a reversing GL44.1 GL45.1
journal entry in the next period for GL500 IFGT.1
this transaction.
Y = Yes
N = No
" " = No
GLC-SOURCE-CODE Alpha 2 GL146 GL196
Element: Source Code A two-character code assigned to a GL197 GL199
transaction to identify where the GL40.1 GL40.2
transaction was created. GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLC-REFERENCE Alpha 10 (Lower Case) GL146 GL167
Element: Reference The reference you enter for this GL191 GL196
journal entry appears on inquiries and GL197 GL199
reports. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-DOCUMENT-NBR Alpha 27 GL146 GL197
Element: Document NumbeThe document number assigned to the GL199 GL40.1
journal entry. This is used in GL40.2 GL40.3
conjunction with the Journal by Document GL40.7 GL40.8
option in GL10 (Company). GL44.1 GL45.1
GL500 IFGT.1
GLC-EFFECT-DATE Numeric 8 (yyyymmdd) GL197 GL199
Element: Effective DateThe effective date. GL40.2 GL500
IFGT.1
GLC-JRNL-BOOK-NBR Alpha 12 GL146 GL190
Element: Journal Book The journal book assigned to the GL197 GL199
transaction. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-TRAN-DESC-DFLT Alpha 1 GL146 GL197
Transaction The transaction description default. GL199 GL40.1
Description Indicates if the new journal entry is a GL40.2 GL40.3
journal entry header or prior GL40.7 GL40.8
transaction line. GL44.1 GL45.1
GL500
J = Journal Entry
P = Prior Transaction Line
GLC-MX-VALUE Alpha 32 Occurs 3 Times GL199 GL40.2
Element: Matrix Value The attribute value. GL500
GLC-MX-CATEGORY-1 Derived
Element: Matrix CategorThe attribute category associated with
the transaction.
GLC-MX-CATEGORY-2 Derived
Element: Matrix CategorThe attribute category associated with
the transaction.
GLC-MX-CATEGORY-3 Derived
Element: Matrix CategorThe attribute category associated with
the transaction.
GLC-MX-DESC-1 Derived
Element: Description The attribute category description.
GLC-MX-DESC-2 Derived
Element: Description The attribute category description.
GLC-MX-DESC-3 Derived
Element: Description The attribute category description.
GLC-CLOSE-SEQ Numeric 2 GL146 GL191
Element: Close SequenceContains the closing sequence number. GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-ACT-POST-DATE Numeric 8 (yyyymmdd) GL146 GL190
Element: Act Post Date Contains the posting date for activity GL197 GL40.1
transactions. GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
GLC-JBK-SEQ-NBR Numeric 10 GL40.2 GL40.6
Journal Book The journal book sequence number 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 GL170
Element: Account Flag This indicates if the journal entry is GL197 GL40.1
released. GL40.2 GL40.3
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL75.1
GLC-SEGMENT-BLOCK Alpha 103 GL40.2
Element: 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
Element: Wf Je Ctrl NbrThe workflow journal entry number.
GLC-AUTO-REV-PD Numeric 2 GL146 GL197
Element: Auto Rev Pd GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1
GLC-REVERSE Alpha 1 GL190 GL700
Element: Reverse This field indicates if a reversing
journal entry will be created by GL199
for this journal entry.
GLCONTROL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLCSET1 COMPANY CA15.1 CA15.2
FISCAL-YEAR CA190 FB11.1
ACCT-PERIOD FB111 FB211
SYSTEM FB296 FB95.1
JE-TYPE FB95.2 FB95.3
CONTROL-GROUP FB95.4 FB95.5
JE-SEQUENCE FB95.6 GL110
GL146 GL167
GL170 GL190
GL191 GL196
GL197 GL199
GL240 GL241
GL245 GL247
GL256 GL270
GL284 GL285
...
GLCSET2 COMPANY KeyChange GL110 GL146
FISCAL-YEAR GL199 GL240
ACCT-PERIOD GL300 GL45.1
STATUS GL500 GL700
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
FISCAL-YEAR Where STATUS = Zeroes
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
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-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 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
|