|
|
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 AC121 AC123 AC127 AC130
AC15.1 AC15.4 AC160 AC170 AC176 AC191
AC195 AC196 AC20.1 AC20.2 AC20.3 AC20.4
AC210 AC22.1 AC240 AC256 AC30.2 AC30.3
AC32.1 AC40.1 AC41.1 AC42.1 AC45.1 AC45.2
AC50.1 AC500 AC52.1 AC520 AC530 AC54.1
AC540 AC70.3 AC76.1 AC87.1 AC950 AC952
ACAC.1 ACBO.1 ACVW.1 AM01.1 AM01.2 AM01.3
AM05.1 AM06.1 AM06.2 AM09.1 AM115 AM118
AM12.1 AM120 AM125 AM135 AM145 AM15.1
AM15.2 AM15.3 AM15.4 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 AM212 AM220 AM221
AM222 AM223 AM224 AM225 AM230 AM235
AM240 AM245 AM250 AM255 AM260 AM265
AM270 AM275 AM277 AM280 AM285 AM290
AM292 AM295 AM30.1 AM30.2 AM30.3 AM300
AM310 AM35.1 AM40.1 AM40.2 AM40.3 AM45.1
AM500 AM580 AM60.1 AM70.1 AM75.1 AM80.1
AM85.1 AM90.1 AM95.1 AM951 AM952 AM953
AM956 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 AP125
AP126 AP150 AP151 AP155 AP156 AP157
AP160 AP166 AP170 AP175 AP180 AP181
AP185 AP190 AP191 AP193 AP195 AP20.1
AP20.2 AP20.5 AP20.6 AP20.7 AP20.8 AP200
AP201 AP210 AP213 AP225 AP226 AP23.1
AP25.1 AP25.2 AP255 AP26.1 AP260 AP265
AP275 AP28.1 AP28.2 AP284 AP30.2 AP30.3
AP30.4 AP32.2 AP510 AP520 AP55.1 AP55.2
AP56.1 AP80.1 AP81.1 AP90.5 AP90.6 AP90.7
AP91.4 AP95.2 AP95.3 AP981 AR01.1 AR08.1
AR10.1 AR100 AR105 AR110 AR115 AR12.1
AR12.2 AR124 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 AR50.1 AR501 AR502 AR503
AR504 AR507 AR53.1 AR550 AR560 AR570
AR575 AR580 AR70.1 AR70.2 AR72.1 AR73.1
AR75.1 AR82.1 AR90.1 AR970 AR973 BL00.1
BL02.1 BL08.1 BL09.1 BL120 BL122 BL123
BL130 BL140 BL199 BL20.1 BL20.3 BL202
BL21.2 BL21.5 BL29.1 BL29.2 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 BL520
BL80.1 BL802 BL820 BL85.1 BL85.2 BL90.1
BL902 BL91.1 BL92.1 BL940 BN150 BN190
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 CB733 CB80.1 CB90.2 CB90.5 CB980
CX05.1 CX05.2 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CX805
CXA2.1 CXA3.1 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.3 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.7 CA10.8
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 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 GL324 GL325
GL326 GL327 GL328 GL330 GL36.1 GL41.1
GL41.3 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.6 GL70.7 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 GL950 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
GL980 GL99.1 GL99.2 GL99.3 GL99.4 GL99.5
GL99.6 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 HR200 HR700 DR100
IC02.1 IC10.1 IC10.2 IC11.1 IC12.1 IC125
IC130 IC134 IC135 IC140 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 IC50.2 IC500 IC522 IC523 IC524
IC525 IC526 IC527 IC81.1 IC811 IC812
IC82.1 IC83.1 IC840 PC120 PC20.1 PC521
PC540 CU01.1 CU01.2 CU03.1 CU20.3 CU20.4
CU203 CU220 CU300 GL01.1 GL01.2 GL03.6
GL08.1 GL08.2 GL11.1 GL121 GL161 GL162
GL201 GL208 GL210 GL211 GL220 GL221
GL222 GL225 GL25.1 GL261 GL311 GL312
GL313 GL342 GL38.2 GL42.1 GL61.1 GL62.1
GL87.1 GL88.1 GLCV.1 GLOB.1 GLOP.1 GLRV.1
GLVW.1 IFAC.1 IFCR.1 IFCU.1 IFGT.1 IFSG.1
IFTR.1 JB00.1 JB00.2 JB00.3 JB00.4 JB200
IN08.1 IN120 IN20.1 MA00.1 MA08.1 MA140
MA208 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4
MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4
MA52.1 MA520 MA530 MA540 OE10.1 OE10.2
OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8
OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE112
OE113 OE114 OE129 OE130 OE14.1 OE14.2
OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5
OE15.7 OE283 OE291 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE310
OE510 OE80.1 OE80.2 OE80.3 OE80.4 OE80.5
OE810 OE830 OE90.2 OE920 OE950 PA213
PBIP.1 PO100 PO120 PO121 PO122 PO123
PO130 PO132 PO135 PO150 PO180 PO199
PO20.1 PO21.1 PO21.2 PO21.3 PO21.5 PO21.6
PO216 PO22.1 PO22.2 PO22.3 PO220 PO225
PO227 PO25.1 PO25.2 PO25.3 PO25.4 PO25.7
PO26.1 PO274 PO28.3 PO28.6 PO28.8 PO30.1
PO31.1 PO32.1 PO33.1 PO34.1 PO35.1 PO530
PO820 PO821 PO990 POA2.1 POA3.1 PR05.1
PR05.3 PR128 PR131 PR132 PR134 PR136
PR137 PR140 PR150 PR195 PR199 PR26.1
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 PR45.1 PR514 PR530
PR80.1 PR82.1 PR85.1 PRSA.1 UK102 UK330
RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1
RQ20.1 RQ20.2 RQ20.3 RQ20.4 RQ235 RQ35.1
RQ500 RQ990 SEA3.1 SA100 SL40.1 SL40.4
SLSE.1 SLSR.1 TA195 TE01.3 UK120 TX00.1
TX04.1 TX204 TX225 TX40.1 TX804 TX904
WH130 WH132 WH190 WH20.2 WH20.7 WH222
WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3
WH32.1 WH32.2 WH32.3 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830 WO132 WO140 WO293 WOA1.1 WOA2.1
WOA3.1 GL00.2 GL00.7 CU00.1
UPDATED BY
CA190 GL110 GL120 GL146 GL167 GL170
GL190 GL191 GL199 GL40.1 GL40.2 GL40.3
GL40.8 GL40.9 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
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 GL199 (Period RW200 RW299
Closing).
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-GAIN-ACCT-UNT Alpha 15 GL20.6
Gain Accounting Unit Accounting Unit used for maintaining
gains from translation processing.
GLS-LOSS-ACCT-UNT Alpha 15 GL20.6
Loss Accounting Unit Accounting unit used for maintaining
losses from translation processing.
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. GL161 GL190
00 GL20.1 GL240
15
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
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.8
GL40.9 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 Jrnal Book This field determines if internal or
Transac Nbr interfaced journal book entries should
be numbered sequentially by the system
as they are added.
Y = Yes
N = No
GLS-SNGL-ACCT-TYPE Alpha 1 GL10.1
Single Account Type Indicates if an account must be either
all credits or all debits.
GLS-INTRASTAT-IND Alpha 1 GL10.1
Intrastat Indicator Determines whether the company is
subject to Intrastat reporting.
GLS-CHART-MAP-FLG Alpha 1
Chart Map Flag
GLS-RESET-JRNL-NBR Alpha 1
Reset Journal Number Determines whether journal numbering
should be reset at year's end.
GLS-JE-APPROVE-AMT Signed 15.2 GL10.1
Journal Entry 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 Flag This field determines whether you are
using a Workflow system for approving
journal entries.
Y = Yes
N = No
GLS-CURR-NAME-1 Alpha 12 GL10.1 GL110
Currency Name 1 Type or select a name that identifies
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
Currency Code 1 Type the currency code you want to
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
Currency Code The number of decimal positions defined
for Report Currency 1.
GLS-CURR-NAME-2 Alpha 12 GL10.1 GL110
Currency name 2 Type or select a name that identifies
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
Currency Code 2 Type the currency code you want to
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
Currency Code The number of decimal positions defined
for Report Currency 2.
GLS-AUTO-BASE-BAL Alpha 1 GL10.1
Autobalance in Base Indicates whether the company requires
Currency journal autobalancing in company base
currency.
" " = No
Y = Yes
N = No
GLS-CURR-BAL-FLAG Alpha 1
Currency Balance Y = Yes
N = No
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.
Y = Yes
N = No
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
AC121 AC123
AC127 AC130
AC15.1 AC15.4
AC160 AC170
AC176 AC191
AC195 AC196
AC20.1 AC20.2
AC20.3 AC20.4
AC210 AC22.1
AC240 AC256
AC30.2 AC30.3
...
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
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
Spaces -> GAD-ADDR-TYPE
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
Gain Acct Unt GLNAMES Not Required
GLS-COMPANY -> GLN-COMPANY
GLS-GAIN-ACCT-UNT -> GLN-ACCT-UNIT
Glsysje Cp GLSYSJE Not Required
GLS-COMPANY -> GSJ-COMPANY
"GL" -> GSJ-SYSTEM
GLS-FISCAL-YEAR -> GSJ-FISCAL-YEAR
GLS-ACCT-PERIOD -> GSJ-ACCT-PERIOD
Loss Acct GLCHARTDTL Not Required
GLS-CHART-NAME -> GDT-CHART-NAME
GCH-LOSS-ACCT -> GDT-ACCOUNT
GCH-LOSS-SUB-ACCT -> GDT-SUB-ACCOUNT
Loss Acct Unt GLNAMES Not Required
GLS-COMPANY -> GLN-COMPANY
GLS-LOSS-ACCT-UNT -> GLN-ACCT-UNIT
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
All Co Addr GLADDRESS Delete Cascades
GLS-COMPANY -> GAD-COMPANY
Spaces -> GAD-ACCT-UNIT
GAD-ADDR-TYPE
Caheader CAHEADER
GLS-COMPANY -> CAH-COMPANY
CAH-ALLOC-NAME
CAH-ALLOC-TYPE
Comp.comments CACOMMENT
GLS-COMPANY -> CAC-COMPANY
CAC-ALLOC-NAME
CAC-ALLOC-TYPE
CAC-SEQ-NBR
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
|