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 GL240 GL241 GL245
GL247 GL256 GL270 GL284 GL285 GL286
GL287 GL288 GL289 GL290 GL297 GL90.1
GL90.2 GL90.5 GL90.6 GLCC.1 JB240 GL10.1
IFJR.1 GL12.1 GL12.2
UPDATED BY
GL110 GL145 GL146 GL148 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 GL75.1 IFGT.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLC-COMPANY Numeric 4 GL110 GL148
Element: Company Identifies the AP company if the GL167 GL191
resource type = V. Identifies the HR GL196 GL197
company if the resource type = E. It is GL199 GL40.2
blank for type A, P or Q resources. GL40.6 GL41.4
GL45.1 GL500
GLCC.1 IFGT.1
GLC-FISCAL-YEAR Numeric 4 GL148 GL167
Element: Fiscal Year This is the current fiscal year. This GL191 GL196
field is updated by Period Closing GL197 GL199
(GL199). GL40.2 GL40.6
GL41.4 GL45.1
GL500 GLCC.1
IFGT.1
GLC-ACCT-PERIOD Numeric 2 GL148 GL167
Element: Account PeriodThe accounting period assigned to the GL191 GL196
journal entry. GL197 GL199
GL40.2 GL40.6
GL41.4 GL45.1
GL500 GLCC.1
IFGT.1
GLC-SYSTEM Alpha 2 GL148 GL167
Element: System This is the journal entry system code. GL191 GL196
GL197 GL199
GL40.2 GL40.6
GL41.4 GL45.1
GL500 GLCC.1
IFGT.1
GLC-JE-TYPE Alpha 1 GL148 GL167
Element: Journal Entry Displays the type of journal entry GL191 GL196
created. GL197 GL199
GL40.2 GL40.6
N = Normal GL41.4 GL45.1
I = Intercompany GL500 GLCC.1
A = Auto Rev Normal IFGT.1
R = Auto Rev Intco
GLC-JE-TYPE-1 Derived
Element: Journal Entry Displays the derived journal entry
type.
GLC-CONTROL-GROUP Numeric 8 GL148 GL167
Element: Control Group This field displays the journal entry GL191 GL196
number used for process control of the GL197 GL199
journal entry detail. GL40.2 GL40.6
GL41.4 GL45.1
GL500 GLCC.1
IFGT.1
GLC-JE-SEQUENCE Numeric 2 GL146 GL148
Journal Entry The unique journal entry sequence GL167 GL190
Sequence number. GL191 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 GL148
Element: Status This field contains the processing GL167 GL190
cycle status of the assigned journal GL191 GL196
entry. GL197 GL199
GL40.1 GL40.2
0 = Unreleased GL40.3 GL40.6
1 = Released GL40.7 GL40.8
2 = Post In Progress GL44.1 GL45.1
3 = Load In Process GL500 IFGT.1
4 = Quick Posted
5 = Posted
6 = Unreleased no AC update
9 = History
GLC-STATUS-1 Derived
Element: Status This field displays the journal entry
status.
GLC-CNTRL-AMOUNT Signed 18.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 18.2 GL146 GL167
Element: Entry Debit Displays the total debit amount for the GL190 GL191
journal entry. 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 18.2 GL146 GL167
Element: Entry Credit Displays the total credit amount for GL190 GL191
the journal entry. 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 GL148 GL167
Trans Number of The number of decimal positions defined GL191 GL196
Decimals for the transaction currency. GL197 GL199
GL40.2 GL40.5
GL41.3 GL45.1
GL500 IFGT.1
GLC-UNIT-CNTRL-DB Signed 15.2 GL190 GL500
Element: Auto Debits The journal entry total for positive
detail unit balances.
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 Displays the total debit units for the GL190 GL191
journal entry. 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 Displays the total credit units for the GL190 GL191
journal entry. 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 The total positive detail auto GL191 GL197
reversing units amounts. 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 The total negative detail auto GL191 GL197
reversing unit amounts. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-DATE Numeric 8 (yyyymmdd) GL148 GL167
Element: Date This field displays the system date GL191 GL196
when this was created. GL197 GL199
GL40.2 GL40.6
GL45.1 GL500
IFGT.1
GLC-LINE-NBR Numeric 6 GL146 GL148
Element: Line Number This field contains the line number. GL167 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 GL148
Element: Number of LineThis is the number of detail lines. GL167 GL190
GL191 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-OPERATOR Alpha 10 GL146 GL148
Element: Operator This field is used to store the login GL167 GL191
ID of the person who entered the record. GL196 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 GL500
Element: Release OperatThe operator ID assigned to the 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 GL148
Element: Posting Date The date assigned to the journal entry GL167 GL191
for posting. 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 The sequence number of the last comment GL500
Sequence Number for the journal entry.
GLC-LAST-LOG-SEQ Numeric 6 GL146 GL148
Last Logfile The last sequence control number. GL190 GL191
Sequence Number GL197 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 GL148
Element: Base Zone The base zone as assigned for interzone GL167 GL191
balance processing. GL196 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 18.2 GL146 GL148
Element: Base Debits The total positive detail amount in the GL167 GL190
company base currency. 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 18.2 GL146 GL167
Element: Base Credits The total negative detail amount in the GL190 GL191
company base currency. 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 18.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 18.2 GL146 GL190
Element: Base Auto CredThe total negative 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-ND Numeric 1 GL148 GL167
Base Number of The number of decimal positions defined GL191 GL196
Decimals for the company base currency. GL197 GL199
GL40.2 GL40.6
GL45.1 GL500
IFGT.1
GLC-CURRENCY-CODE Alpha 5 GL148 GL167
Element: Currency Code This field contains the company base GL191 GL196
currency code established in Company GL197 GL199
(GL10.1 ) unless an alternate currency GL40.2 GL45.1
code is chosen on the GL40.2. GL500 IFGT.1
GLC-BASERATE Signed 14.7 GL148 GL167
Element: Base Rate The exchange rate at the time the GL191 GL196
journal entry was made. If left blank, GL197 GL199
the current exchange rate defaults. GL40.2 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 GL148
Element: Description The company name or description. GL167 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 GL148
Element: Auto Reverse Auto reversal is the process of GL197 GL199
reversing the transaction. If you select GL40.1 GL40.2
auto reverse, the Lawson General Ledger GL40.3 GL40.6
closing program creates a reversing GL40.7 GL40.8
journal entry in the next period for GL44.1 GL45.1
this transaction. GL500 IFGT.1
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 GL148
Element: Reference The reference you enter for this GL167 GL191
journal entry appears on inquiries and GL196 GL197
reports. GL199 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) GL148 GL197
Element: Effective DateThe effective date. GL199 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
Element: Reverse This field indicates if a reversing
journal entry will be created by GL199
for this journal entry.
GLC-HOLD-REM-OPER Alpha 10 GL145 GL40.2
Element: Operator Code GL45.1
GLC-BLANK Derived
Element: Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
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 GL197 GL199
JE-SEQUENCE GL240 GL241
GL245 GL247
GL256 GL270
GL284 GL285
GL286 GL287
GL288 GL289
GL290 GL297
GL300 GL40.1
GL40.2 GL40.3
...
GLCSET2 COMPANY KeyChange GL110 GL146
FISCAL-YEAR GL199 GL240
ACCT-PERIOD GL300 GL45.1
STATUS GL500
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 Or (STATUS = 6 ))
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
|