GLSYSTEM FILE
General Ledger Company
This file contains company information used by the Lawson General Ledger
system and subsystems defined in GL10.1 (Company).
REFERENCED BY
AC03.1 AC03.2 AC03.3 AC03.4 AC03.5 AC03.6
AC03.8 AC10.1 AC12.2 AC121 AC123 AC127
AC130 AC131 AC160 AC17.3 AC17.4 AC170
AC176 AC18.2 AC18.3 AC190 AC191 AC195
AC196 AC198 AC20.1 AC20.2 AC20.3 AC20.4
AC20.5 AC20.6 AC20.7 AC210 AC256 AC27.1
AC298 AC30.2 AC30.3 AC32.1 AC34.1 AC35.1
AC36.1 AC40.1 AC40.2 AC40.4 AC40.5 AC41.1
AC41.2 AC41.4 AC41.5 AC41.7 AC42.1 AC42.2
AC42.4 AC45.1 AC45.2 AC45.4 AC45.5 AC490
AC494 AC50.1 AC500 AC52.1 AC520 AC530
AC54.1 AC54.2 AC54.3 AC540 AC541 AC542
AC550 AC581 AC59.1 AC62.1 AC70.1 AC70.2
AC70.4 AC742 AC750 AC76.1 AC81.1 AC94.4
AC98.2 ACAC.1 ACVW.1 GR742 AM01.1 AM01.2
AM01.3 AM05.1 AM06.1 AM06.2 AM06.3 AM06.5
AM09.1 AM115 AM118 AM12.1 AM120 AM125
AM135 AM145 AM15.1 AM15.2 AM15.3 AM15.4
AM152 AM154 AM16.1 AM170 AM18.1 AM18.2
AM180 AM185 AM190 AM192 AM195 AM20.1
AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM20.7
AM20.8 AM200 AM205 AM206 AM21.1 AM21.2
AM21.3 AM21.4 AM21.5 AM21.6 AM21.7 AM21.8
AM211 AM212 AM220 AM221 AM222 AM223
AM224 AM225 AM230 AM235 AM240 AM241
AM245 AM25.1 AM250 AM251 AM252 AM255
AM260 AM265 AM266 AM270 AM275 AM277
AM278 AM280 AM281 AM282 AM285 AM290
AM292 AM295 AM30.1 AM30.2 AM30.3 AM300
AM310 AM320 AM35.1 AM40.1 AM40.2 AM40.3
AM41.1 AM45.1 AM500 AM51.1 AM551 AM580
AM60.1 AM70.1 AM75.1 AM80.1 AM85.1 AM88.7
AM90.1 AM90.4 AM90.5 AM90.6 AM91.1 AM91.4
AM91.5 AM93.1 AM95.1 AM95.4 AM95.5 AM95.6
AM96.1 AM97.1 AM98.1 AM99.1 AP00.3 AP00.4
AP01.1 AP05.1 AP05.2 AP05.7 AP05.8 AP10.1
AP10.2 AP10.5 AP10.6 AP110 AP115 AP130
AP150 AP151 AP155 AP156 AP160 AP161
AP166 AP170 AP175 AP176 AP180 AP181
AP185 AP190 AP191 AP193 AP195 AP200
AP201 AP210 AP213 AP220 AP255 AP260
AP265 AP275 AP28.1 AP28.2 AP284 AP30.2
AP30.3 AP30.4 AP305 AP32.2 AP510 AP520
AP55.1 AP55.2 AP56.1 AP80.1 AP81.1 AP90.5
AP91.4 AP95.2 AP95.3 API1.1 API2.1 API3.1
API4.1 API5.1 AR01.1 AR08.1 AR100 AR105
AR110 AR115 AR124 AR129 AR13.1 AR13.2
AR130 AR131 AR135 AR137 AR14.1 AR15.4
AR150 AR160 AR161 AR170 AR180 AR190
AR191 AR194 AR196 AR199 AR20.1 AR21.1
AR21.2 AR21.3 AR21.4 AR230 AR232 AR24.1
AR25.1 AR250 AR251 AR252 AR253 AR255
AR256 AR258 AR271 AR275 AR28.1 AR286
AR287 AR29.1 AR29.2 AR29.3 AR290 AR30.1
AR30.2 AR30.3 AR30.4 AR30.6 AR30.7 AR30.8
AR30.9 AR31.1 AR31.5 AR31.6 AR35.1 AR35.2
AR36.1 AR37.1 AR37.2 AR37.3 AR37.4 AR37.5
AR37.6 AR37.7 AR42.1 AR42.2 AR42.6 AR42.7
AR42.8 AR43.1 AR44.3 AR45.1 AR48.3 AR50.1
AR501 AR502 AR503 AR504 AR507 AR53.1
AR550 AR560 AR570 AR575 AR580 AR70.1
AR70.2 AR72.1 AR75.1 AR82.1 AR90.1 BL00.1
BL01.1 BL02.1 BL09.1 BL123 BL125 BL140
BL199 BL202 BL30.1 BL30.2 BL30.3 BL30.5
BL31.1 BL31.2 BL31.3 BL31.5 BL31.7 BL32.1
BL32.2 BL32.3 BL32.4 BL80.1 BL802 BL85.1
BL85.2 BL90.1 BL91.1 BN00.1 BN00.2 BN100
BN101 BN102 BN103 BN104 BN105 BN145
BN15.1 BN150 BN190 BN20.1 BN245 BN31.1
BN31.2 BN32.1 BN32.2 BN32.3 BN45.1 BN531
BN65.1 BN71.1 BN72.1 BN80.1 BN81.1 BN81.2
BS13.1 BS14.1 BS15.1 BS32.1 BR00.2 BR10.1
BR10.2 BR11.1 BR120 BR121 BR40.3 BR400
BR41.1 BR420 BRIP.1 CB00.3 CB01.2 CB03.1
CB03.2 CB05.1 CB06.1 CB06.2 CB10.1 CB10.3
CB15.1 CB15.2 CB175 CB180 CB185 CB190
CB191 CB195 CB20.1 CB210 CB215 CB220
CB221 CB260 CB30.1 CB500 CB80.1 CB90.2
CB90.5 CXCP.1 DT150 DT155 DT160 DT161
DT165 DT166 DT170 DT180 DT181 DT185
DT190 DT220 DT30.1 DT30.2 DT40.1 DT45.1
DT52.1 DT520 DT60.1 DT60.2 DT70.1 DT70.3
DT80.1 DT80.4 DT85.1 DT85.2 DT90.1 DT90.3
DT92.1 EE05.1 EE135 EE175 EE20.1 EE20.2
EE20.3 EE20.4 EE220 EE230 EE275 EE35.1
EE35.2 EE520 CA00.1 CA00.2 CA05.1 CA10.1
CA10.2 CA10.4 CA10.5 CA10.6 CA10.7 CA110
CA15.1 CA15.2 CA195 CA199 CA200 CA210
CA215 CA240 CA290 FB10.1 FB100 FB101
FB120 FB121 FB122 FB141 FB165 FB195
FB20.1 FB20.2 FB20.3 FB20.4 FB20.6 FB20.7
FB21.1 FB210 FB220 FB225 FB230 FB231
FB25.1 FB295 FB30.1 FB31.1 FB65.1 FB95.1
FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 GL122
GL130 GL135 GL141 GL145 GL165 GL179
GL195 GL196 GL230 GL235 GL238 GL240
GL241 GL243 GL245 GL247 GL250 GL256
GL267 GL270 GL275 GL281 GL284 GL285
GL286 GL287 GL288 GL289 GL290 GL291
GL292 GL293 GL294 GL295 GL296 GL297
GL30.1 GL30.2 GL300 GL320 GL325 GL326
GL327 GL328 GL330 GL36.1 GL41.1 GL41.3
GL41.4 GL43.1 GL50.1 GL50.2 GL50.4 GL50.5
GL55.1 GL65.1 GL65.3 GL67.1 GL70.1 GL70.2
GL70.3 GL70.5 GL70.6 GL90.1 GL90.2 GL90.3
GL90.4 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 GLSR.1
JB240 RW00.1 RW00.2 RW00.4 RW10.2 RW10.3
RW10.4 RW10.6 RW10.7 RW100 RW20.5 RW20.6
RW200 RW210 RW220 RW230 RW240 RW260
RW270 RW299 RW30.1 RW40.1 RW40.2 RW60.1
RW60.4 RW70.1 RW80.1 HCGL.1 HGDT.1 HGLS.1
HR00.1 HR01.1 HR02.1 HR200 HR511 HR650
DR100 IC02.1 IC10.1 IC10.2 IC11.1 IC12.1
IC125 IC130 IC134 IC135 IC141 IC142
IC150 IC151 IC152 IC175 IC199 IC20.1
IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC222
IC224 IC227 IC228 IC23.1 IC23.2 IC233
IC234 IC24.1 IC24.2 IC240 IC25.1 IC280
IC283 IC330 IC500 IC522 IC523 IC525
IC526 IC527 IC81.1 IC811 IC812 IC82.1
IC83.1 IC840 ICLC.1 PC521 CU01.1 CU01.2
CU03.1 CU161 CU20.3 CU20.4 CU203 CU220
CU261 CU300 CU61.2 GL01.1 GL01.2 GL03.6
GL08.1 GL08.2 GL11.1 GL121 GL123 GL124
GL14.8 GL161 GL162 GL201 GL208 GL210
GL211 GL220 GL221 GL222 GL223 GL225
GL23.1 GL24.1 GL25.1 GL261 GL311 GL312
GL313 GL342 GL38.2 GL42.1 GL61.1 GL62.1
GL721 GLAV.1 GLCV.1 GLEX.1 GLOP.1 GLRV.1
GLVW.1 IF720 IFAC.1 IFBO.1 IFCU.1 IFGT.1
IFOS.1 IFOS.3 IFSG.1 IFTR.1 JB00.1 JB00.2
JB00.3 JB00.4 JB200 MX135 MA01.1 MA05.3
MA05.6 MA08.1 MA126 MA205 MA208 MA231
MA310 MA63.1 MA65.1 MA68.1 MLRV.1 PA213
PA502 PA513 PO01.1 PO130 PO132 PO135
PO136 PO199 PO220 PO26.1 PO295 POA2.4
POED.1 POI7.1 POIF.1 POIH.1 POIJ.1 POIT.1
PR05.1 PR05.3 PR128 PR13.1 PR13.2 PR13.5
PR13.6 PR13.8 PR131 PR132 PR134 PR136
PR137 PR14.1 PR15.1 PR15.2 PR195 PR197
PR198 PR20.4 PR205 PR23.1 PR26.1 PR26.2
PR32.1 PR32.2 PR33.1 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR36.1 PR37.1 PR38.1 PR39.1 PR39.2 PR45.1
PR47.1 PR47.2 PR514 PR530 PR70.1 PR82.1
PR85.1 PRSA.1 UK102 UK330 RQ01.1 RQ11.1
RQ12.1 RQ13.1 RQ235 SLSE.1 SLVW.1 TA195
TE01.3 UK120 IN08.1 IN120 IN20.1 TX00.1
TX04.1 TX100 TX204 TX40.1 TX804 WH130
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
GL00.2 GL00.7 CU00.1
UPDATED BY
CA190 GL110 GL120 GL146 GL167 GL170
GL190 GL191 GL199 GL310 GL40.1 GL40.2
GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500
GL75.1 GL10.1 GL10.2 GL198 GL20.6
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLS-COMPANY Numeric 4 GL10.1 GL110
Company The number that identifies a company. A GL20.1 GL240
company represents a business or legal RW100
entity of an organization.
GLS-NAME Alpha 30 (Lower Case) GL10.1 GL110
Name This is the company name or GL210
description.
GLS-BS-ACCT-UNIT Alpha 15 GL20.6
Base Accounting Unit The accounting unit name which is a
unique location within the company.
GLS-NBR-ACCT-PERS Numeric 2 GL10.1
Number of The number of periods for a company
Accounting Periods fiscal year. Valid values are 1 - 13.
01
13
GLS-ACCT-PERIOD Numeric 2 GL10.1 GL167
Accounting Period This is the current accounting period. GL198 GL199
This field is updated by GL199 (Period GL500
Closing).
01
13
GLS-COND-DFT-PRD Derived
Default Period This field determines the period for
viewing when using the Drill Around
Chart Name feature.
GLS-FISCAL-YEAR Numeric 4 GL10.1 GL198
Fiscal Year This is the current fiscal year. This GL199 GL500
field is updated by Period Closing RW200 RW299
(GL199).
GLS-LAST-FISC-YR Derived
Last Fiscal Year The last fiscal year.
GLS-NEXT-FISC-YR Derived
Next Fiscal Year The next fiscal year.
GLS-LST-YR-CLOSED Numeric 4
Last Year Closed This field is updated by GL199 with the
last year when using limited closing.
When the last year is closed final, this
field is set back to zero. Changes to
the retained earnings account number are
prohibited if this field is not equal to
zero.
GLS-PER-END-DATE Numeric 8 (yyyymmdd) Occurs 39 Times GL10.1 GL198
Period End Date Required for the number of account GL199 GL500
periods for each year (current, last,
next). This period ending date is used
to determine the period to which
transactions are posted.
Occurrence 1-13 = Current period ending
dates.
Occurrence 14-26 = Last year period
ending dates.
Occurrence 27-39 = Next year period
ending dates.
These dates are changed by GL199 (Period
Closing) when closing period 12 of the
current year. The current year dates
become last year dates, next year dates
become current year dates, and new next
year dates are calculated.
GLS-PER-END-CODE Alpha 1 Occurs 39 Times GL10.1 GL10.2
Period End Code This field is used to indicate the GL110 GL167
closing status for each period. GL198 GL199
Occurrence 1-13 = Current year period GL500
ending code.
Occurrence 14-26 = Last year period
ending code.
Occurrence 27-39 = Next year period
ending code.
These fields are updated by GL199
(Period Closing) and Backposting
Control. If closing the period, the
period end code is set to indicate a
limited close or a final close. If
closing for a year, the period end code
will be set to indicate a limited or
final close, and also current year is
changed to last year, next year is
changed to current year, and next year
is set to spaces.
B = Backpost
F = Final
L = Limited
" " = Open
GLS-CONTROL-CODE Alpha 1 GL10.1
Control Group This field is used to indicate whether
control totals are required for journal
entries before releasing.
If you select Yes in the Control Totals
field on the Journals form tab in
GL10.1, GL40.1 (Journal Entry) will use
required control totals, which are set
up using GL45 (Journal Control).
N = No
Y = Yes
GLS-INTLV-BAL-FLG Alpha 1 GL10.1
Interlevel Balance Indicates if interzone balancing is
Flag used. If interzone balancing is used, a
base zone must be defined.
N = No
Y = Yes
GLS-CURRENCY-TABLE Alpha 12 GL10.1
Currency Table The currency table name. Currency
tables are assigned to companies and
define currency exchange and translation
information. Currency tables are defined
in CU00.1 (Currency Table).
GLS-CURR-CONV-FLG Alpha 1 GL10.1
Curr Exchange Flag Not required.
Y = Yes
N = No
GLS-CURR-TRAN-FLG Alpha 1 GL10.1
Currency Used to control currency translation
Translation Flag processing.
Y = Yes
N = No
GLS-CURRENCY-CODE Alpha 5 GL10.1 GL110
Currency Code This is the company base currency code
as defined in CU01.1 (Currency Code).
GLS-COMPANY-ND Numeric 1 GL10.1 GL110
Number of Decimals Decimal positions in the company
currency code amount fields.
GLS-IS-ACCT-UNIT Alpha 15 GL20.6
Is Acct Unit
GLS-ACTIVE-STATUS Alpha 1 GL10.1
Active Status The active status field is used to
display the development status of a
company.
D = Delete
L = Live
T = Test
C = Consolidation
E = Elimination
GLS-AVG-DAILY-BAL Alpha 1 GL110
Average Daily Not required.
Balance N = No
Y = Yes
" " = No
GLS-AUTO-JE-NBR Alpha 1 GL10.1
Auto Journal Entry If you select Yes in the Auto Journal
Number Numbering field on the Journals form tab
in GL10, GL40 (Journal Entry) will
assign journal entry numbers
automatically using the Last JE Used
Field.
N = No
Y = Yes
GLS-LEVEL-DESC Alpha 12 (Lower Case) GL10.1
Level Description Occurs 5 Times
This is the level description.
GLS-NBR-DIGITS Numeric 2 Occurs 5 Times GL10.1 GL120
Number Digits This is the level size. GL124 GL161
00 GL190 GL20.1
15 GL240
GLS-LVL-ONE-DIGIT Derived
Level One Digit Displays the array value.
GLS-GL190-RUN-DT.html">GL190-RUN-DT Numeric 8 (yyyymmdd) GL190
GL190 Run Date This is the date that GL190 (Journal
Posting) was run. Updated each time
GL190 is run.
GLS-GL190-RUN-TM.html">GL190-RUN-TM Numeric 6 (hhmmss) GL190
GL190 Run Time This is the last time that GL190
(Journal Posting) was run. Updated each
time GL190 is run.
GLS-POSTED-TH-DT Numeric 8 (yyyymmdd) GL190
Posted Through Date This is the last posted- through date
used by GL190 (Journal Posting).
GLS-PROJ-ACCT-FLG Alpha 1
Activity Flag This field is for the Activity system
only. It reports the option chosen for
the Edit Account Number field.
Valid values are:
Blank = No Activity system company
exists.
E = The Activity company exists. Edit
Account Number is Yes. Edits are done
validating the account for the project.
Y = The Activity company exists. Edit
Account Number is No. Transactions will
post to Activities if the project is
defined in the Activity system, but no
edits for account validation are
performed.
N = No
GLS-BASE-ZONE Alpha 15 GL10.1
Base Zone This is the default base zone used to
create interzone balancing transactions.
GLS-BACKPOST Alpha 1 Occurs 26 Times GL110 GL190
Backpost This field is used to indicate if GL198 GL199
backposting occurred for a period. GL45.1 GL500
Occurrence 1-13 = Current year periods.
Occurrence 14-26 = Last year periods.
* = Backposting has occurred
GLS-GL150-RUN-DTE Numeric 8 (yyyymmdd)
Run Date Indicates the last time that
Consolidation File Creation was run.
GLS-CHART-NAME Alpha 12 GL10.1 GL110
Chart Name This is the name you assigned to the
chart of accounts when you defined your
company structure in the General Ledger
system.
GLS-DEFAULT-PERIOD Numeric 2 GL10.1
Default Period This field determines the period for
viewing when using the Drill Around
Chart Name feature.
00
13
GLS-JOURNAL-BY-DOC Alpha 1 GL10.1
Journal by Document Determines if each interfaced document
(for example an invoice) is assigned a
journal number. No is the default
value.
N = No
Y = Yes
GLS-UPDATING Numeric 2 CA190 GL110
Updating This will be set with a value when an GL120 GL146
update program is running in GL. The GL170 GL190
value will determine the program that is GL191 GL199
running. No other updates may take GL40.1 GL40.2
place while this field is not blank. GL40.3 GL40.7
GL40.8 GL44.1
00 = None GL45.1 GL75.1
01 = GL170 Running
02 = GL180 Running
03 = CA190 Running
04 = GL190 Running
05 = GL199 Running
06 = GL110 Running
07 = GL120 Running
08 = GL191 Running
09 = AD190 Running
10 = AD191 Running
11 = GL45 Running
12 = GL40 Running
13 = GL75 Running
14 = GL161 Running
GLS-CLOSE-SEQ Numeric 2 Occurs 39 Times GL110 GL167
Close Sequence The sequence number of the entry. GL199
GLS-LEVEL-DEPTH Numeric 1 GL10.1
Level Depth The company can contain up to 5 levels
of accounting units.
1 = One Level
2 = Two Levels
3 = Three Levels
4 = Four Levels
5 = Five Levels
GLS-JRNL-BOOK-REQ Alpha 1 GL10.1
Journal Book This field determines whether a Journal
Required Book value must be assigned to all
General Ledger transactions.
N = No
Y = Yes
GLS-SEQ-TRNS-CD Alpha 1 GL10.1
Seq Trans Code Determines whether each General Ledger
transaction created must be assigned a
unique transaction sequence number by
the system.
J = by Journal Book
C = by Company
N = Not Required
GLS-RESET-SEQ-NBR Alpha 1 GL10.1
Reset Seq Number This field determines whether the
Transaction Sequence Number is reset at
year-end or continues.
N = No
Y = Yes
GLS-CHG-POST-TRAN Alpha 1 GL10.1
Change Post Tran This field determines whether posted
journal entries can be backed out, or
unposted, in GL45.1 (Journal Control) or
GL146 (Journal Backout and Unrelease).
N = No
Y = Yes
GLS-CHG-REL-TRAN Alpha 1 GL10.1
Change Rel Tran This field determines whether released
journal entries can be unreleased in
GL45.1 (Journal Control) or GL146
(Journal Backout and Unrelease).
N = No
Y = Yes
GLS-ERROR-SP-JBOOK Alpha 12 GL10.1
Error Suspense This field represents the Journal Book
Journal Book value assigned to system-generated Error
Suspense entries.
GLS-YEAR-END-JBOOK Alpha 12 GL10.1
Year End Journal This field represents the Journal Book
Book value assigned to transactions created
by the system at year-end.
GLS-AUTO-JBK-SEQ Alpha 1 GL10.1
Auto Jbk Seq This field determines if internal or
interfaced journal book entries should
be numbered sequentially by the system
as they are added.
GLS-SNGL-ACCT-TYPE Alpha 1 GL10.1
Sngl Acct Type Indicates if an account must be either
all credits or all debits.
GLS-JE-APPROVE-AMT Signed 15.2 GL10.1
Je Approve Amt The minimum journal entry amount that
requires approval. When released,
journal entries that are less that the
defined approval amount are available
for posting. Journal entries with an
amount greater than or equal to the
defined approval amount are routed to
the Workflow system for approval.
GLS-WORKFLOW-FLAG Alpha 1 GL10.1
Workflow This field determines whether you are
using a Workflow system for approving
journal entries.
GLS-CURR-NAME-1 Alpha 12 GL10.1 GL110
Report Currency 1 Type or select a name that identifies GL240 GL310
Name the report currency. You must define
exchange rates (CU10.1) and currency
relationships (CU02.1) for the report
currency with the company base currency.
The report currencies are additional
non-base currencies that identify a
company operating currency. This report
currency is for reports and analysis
only.
The report currencies are calculated in
the same manner as base currency.
Transaction amounts will always be
converted to the Base Currency. If you
also use a report currency, amounts will
convert to both the Base and Report
Currency.
Note: The report currency cannot be the
same as the company base currency.
GLS-CURR-CODE-1 Alpha 5 GL10.1 GL110
Report Currency 1 Type the currency code you want to GL310
Code associate with the report currency name.
The currency code must exist in CU01.1
(Currency Codes).
GLS-CURR-CODE-ND-1 Numeric 1 GL10.1 GL310
Curr Code Nd 1 The number of decimal positions defined
for Report Currency 1.
GLS-CURR-NAME-2 Alpha 12 GL10.1 GL110
Report Currency 2 Type or select a name that identifies GL240 GL310
Name the report currency. You must define
exchange rates (CU10.1) and currency
relationships (CU02.1) for the report
currency with the company base currency.
The report currencies are additional
non-base currencies that identify a
company operating currency. This
report currency is for reports and
analysis only. The report currencies are
calculated in the same manner as base
currency.
Transaction amounts will always be
converted to the Base Currency. If you
also use a report currency, amounts will
convert to both the Base and Report
Currency.
Note: The report currency cannot be the
same as the company base currency.
GLS-CURR-CODE-2 Alpha 5 GL10.1 GL110
Report Currency 2 Type the currency code you want to GL310
Code associate with the report currency name.
The currency code must exist in CU01.1
(Currency Codes).
GLS-CURR-CODE-ND-2 Numeric 1 GL10.1 GL310
Curr Code Nd 2 The number of decimal positions defined
for Report Currency 2.
GLS-AUTO-BASE-BAL Alpha 1 GL10.1
Auto Base Bal Indicates whether the company requires
journal autobalancing in company base
currency.
GLS-CURR-RE-FLAG Alpha 1 GL10.1
Currency Ledger This field is used to track journal
entry amounts by the transaction
currency in addition to the company base
currency.
GLSYSTEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLSSET1 COMPANY This path is used to retrieve company AC03.1 AC03.2
records. AC03.3 AC03.4
AC03.5 AC03.6
AC03.8 AC10.1
AC12.2 AC121
AC123 AC127
AC130 AC131
AC160 AC17.3
AC17.4 AC170
AC176 AC18.2
AC18.3 AC190
AC191 AC195
AC196 AC198
AC20.1 AC20.2
AC20.3 AC20.4
...
GLSSET2 CHART-NAME KeyChange GL00.2 GL00.7
COMPANY
GLSSET3 CURRENCY-TABLEKeyChange CU00.1
COMPANY
GLSYSTEM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
All Co Addr GLADDRESS Not Required, Delete Cascades
GLS-COMPANY -> GAD-COMPANY
Spaces -> GAD-ACCT-UNIT
Bal Acct GLCHARTDTL Required
GLS-CHART-NAME -> GDT-CHART-NAME
GCH-BAL-ACCOUNT -> GDT-ACCOUNT
GCH-BAL-SUB-ACCT -> GDT-SUB-ACCOUNT
Bs Acct Unit GLNAMES Not Required
GLS-COMPANY -> GLN-COMPANY
GLS-BS-ACCT-UNIT -> GLN-ACCT-UNIT
Chart Of Accts GLCHART Required
GLS-CHART-NAME -> GCH-CHART-NAME
Co Address GLADDRESS Not Required, Delete Cascades
GLS-COMPANY -> GAD-COMPANY
Spaces -> GAD-ACCT-UNIT
Cucodes CUCODES Required
GLS-CURRENCY-CODE -> CUC-CURRENCY-CODE
Curr 1 CUCODES Not Required
GLS-CURR-CODE-1 -> CUC-CURRENCY-CODE
Curr 2 CUCODES Not Required
GLS-CURR-CODE-2 -> CUC-CURRENCY-CODE
Cutable CUTABLE Required
GLS-CURRENCY-TABLE -> CTB-CURRENCY-TABLE
Es Acct GLCHARTDTL Not Required
GLS-CHART-NAME -> GDT-CHART-NAME
GCH-ES-ACCOUNT -> GDT-ACCOUNT
GCH-ES-SUB-ACCT -> GDT-SUB-ACCOUNT
Gain Acct GLCHARTDTL Not Required
GLS-CHART-NAME -> GDT-CHART-NAME
GCH-GAIN-ACCT -> GDT-ACCOUNT
GCH-GAIN-SUB-ACCT -> GDT-SUB-ACCOUNT
Glsysje Cp GLSYSJE Not Required
GLS-COMPANY -> GSJ-COMPANY
"GL" -> GSJ-SYSTEM
GLS-FISCAL-YEAR -> GSJ-FISCAL-YEAR
GLS-ACCT-PERIOD -> GSJ-ACCT-PERIOD
Is Acct Unit GLNAMES Not Required
GLS-COMPANY -> GLN-COMPANY
GLS-IS-ACCT-UNIT -> GLN-ACCT-UNIT
Loss Acct GLCHARTDTL Not Required
GLS-CHART-NAME -> GDT-CHART-NAME
GCH-LOSS-ACCT -> GDT-ACCOUNT
GCH-LOSS-SUB-ACCT -> GDT-SUB-ACCOUNT
Re Acct GLCHARTDTL Not Required
GLS-CHART-NAME -> GDT-CHART-NAME
GCH-RE-ACCOUNT -> GDT-ACCOUNT
GCH-RE-SUB-ACCT -> GDT-SUB-ACCOUNT
Rnd Acct GLCHARTDTL Not Required
GLS-CHART-NAME -> GDT-CHART-NAME
GCH-RND-ACCOUNT -> GDT-ACCOUNT
GCH-RND-SUB-ACCT -> GDT-SUB-ACCOUNT
Ure Acct GLCHARTDTL Not Required
GLS-CHART-NAME -> GDT-CHART-NAME
GCH-URE-ACCOUNT -> GDT-ACCOUNT
GCH-URE-SUB-ACCT -> GDT-SUB-ACCOUNT
GLSYSTEM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Units GLNAMES Delete Restricted
GLS-COMPANY -> GLN-COMPANY
GLN-ACCT-UNIT
Caheader CAHEADER
GLS-COMPANY -> CAH-COMPANY
CAH-ALLOC-NAME
CAH-ALLOC-TYPE
Coledger MLCOLEDGER
GLS-COMPANY -> MLE-COMPANY
MLE-LEDGER
Company Groups GLCGCPY
GLS-COMPANY -> GCC-COMPANY
GCC-COMPANY-GROUP
Consol GLCONSOL
GLS-FISCAL-YEAR -> GCN-FISCAL-YEAR
Zeroes -> GCN-LEVEL-DEPTH
Zeroes -> GCN-BUDGET-NBR
"A" -> GCN-TRANS-TYPE
GLS-COMPANY -> GCN-COMPANY
GCN-VAR-LEVELS
GCN-ACCOUNT
GCN-SUB-ACCOUNT
GCN-CURRENCY-CODE
Consol Y GLCONSOL
GLS-FISCAL-YEAR -> GCN-FISCAL-YEAR
Zeroes -> GCN-LEVEL-DEPTH
Zeroes -> GCN-BUDGET-NBR
"Y" -> GCN-TRANS-TYPE
GLS-COMPANY -> GCN-COMPANY
GCN-VAR-LEVELS
GCN-ACCOUNT
GCN-SUB-ACCOUNT
GCN-CURRENCY-CODE
Consol Z GLCONSOL
GLS-FISCAL-YEAR -> GCN-FISCAL-YEAR
Zeroes -> GCN-LEVEL-DEPTH
Zeroes -> GCN-BUDGET-NBR
"Z" -> GCN-TRANS-TYPE
GLS-COMPANY -> GCN-COMPANY
GCN-VAR-LEVELS
GCN-ACCOUNT
GCN-SUB-ACCOUNT
GCN-CURRENCY-CODE
Curelat CURELAT
GLS-CURRENCY-TABLE -> CRL-CURRENCY-TABLE
CRL-FR-CURR-CODE
CRL-TO-CURR-CODE
Fbheader FBHEADER
GLS-COMPANY -> FBH-COMPANY
FBH-FISCAL-YEAR
FBH-BUDGET-NBR
Glclsaudit GLCLSAUDIT
GLS-COMPANY -> GCA-COMPANY
GCA-FISCAL-YEAR
GCA-ACCT-PERIOD
GCA-CLOSE-SEQ
Glcodes Sys GLCODES
GLS-COMPANY -> GCD-COMPANY
GCD-SYSTEM
Glcontrol GLCONTROL
GLS-COMPANY -> GLC-COMPANY
GLC-FISCAL-YEAR
GLC-ACCT-PERIOD
GLC-SYSTEM
GLC-JE-TYPE
GLC-CONTROL-GROUP
GLC-JE-SEQUENCE
Glmaster GLMASTER
GLS-COMPANY -> GLM-COMPANY
GLM-ACCT-UNIT
GLM-ACCOUNT
GLM-SUB-ACCOUNT
Glsysje GLSYSJE Delete Cascades
GLS-COMPANY -> GSJ-COMPANY
GSJ-SYSTEM
GSJ-FISCAL-YEAR
GSJ-ACCT-PERIOD
Gltrans GLTRANS
GLS-COMPANY -> GLT-COMPANY
GLT-FISCAL-YEAR
GLT-ACCT-PERIOD
GLT-CONTROL-GROUP
GLT-SYSTEM
GLT-JE-TYPE
GLT-JE-SEQUENCE
GLT-LINE-NBR
Glunits GLUNITS
GLS-COMPANY -> GLU-COMPANY
GLU-ACCOUNT
GLU-SUB-ACCOUNT
GLU-VAR-LEVELS
GLU-ACCT-UNIT
GLU-FISCAL-YEAR
Intercompany GLINTCO
"C" -> GIC-RECORD-TYPE
GLS-COMPANY -> GIC-COMPANY-A
GIC-COMPANY-B
GIC-ZONE-A
GIC-ZONE-B
GIC-SYSTEM
Interzone GLINTCO
"L" -> GIC-RECORD-TYPE
GLS-COMPANY -> GIC-COMPANY-A
GIC-COMPANY-B
GIC-ZONE-A
GIC-ZONE-B
GIC-SYSTEM
Jbookhdr JBOOKHDR Delete Cascades
GLS-COMPANY -> JBK-COMPANY
JBK-JRNL-BOOK-NBR
|
