|
|
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.7 AC10.1 AC113 AC12.2 AC121 AC123
AC127 AC130 AC131 AC145 AC160 AC17.3
AC17.4 AC18.2 AC18.3 AC19.2 AC19.3 AC190
AC191 AC195 AC197 AC198 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC20.6 AC20.7 AC210
AC246 AC256 AC27.1 AC298 AC32.1 AC34.1
AC346 AC35.1 AC36.1 AC37.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 AC46.1 AC46.2 AC46.3 AC490
AC494 AC50.1 AC500 AC52.1 AC520 AC527
AC54.1 AC540 AC56.1 AC560 AC581 AC62.1
AC69.2 AC71.1 AC81.1 AC94.4 AC98.2 ACAC.1
ACVW.1 ATVW.1 AM01.1 AM01.2 AM01.3 AM05.1
AM06.1 AM06.2 AM06.3 AM06.5 AM06.6 AM09.1
AM115 AM117 AM118 AM12.1 AM120 AM125
AM135 AM145 AM15.1 AM15.2 AM15.3 AM15.4
AM152 AM154 AM16.1 AM17.1 AM170 AM18.1
AM18.2 AM180 AM185 AM19.1 AM19.2 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 AM214
AM219 AM220 AM221 AM222 AM223 AM224
AM225 AM230 AM235 AM240 AM241 AM245
AM25.1 AM250 AM251 AM252 AM255 AM258
AM260 AM265 AM266 AM267 AM270 AM275
AM277 AM278 AM280 AM281 AM282 AM285
AM287 AM290 AM292 AM295 AM30.1 AM30.2
AM30.3 AM300 AM310 AM320 AM330 AM35.1
AM40.1 AM40.2 AM40.3 AM40.4 AM41.1 AM41.2
AM45.1 AM500 AM501 AM502 AM51.1 AM52.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 AM92.1 AM93.1 AM95.1
AM95.4 AM95.5 AM95.6 AM96.1 AM97.1 AM98.1
AM99.1 AP00.3 AP00.4 AP00.7 AP01.1 AP03.3
AP05.1 AP05.2 AP05.7 AP05.8 AP10.1 AP10.2
AP10.5 AP10.6 AP110 AP115 AP125 AP126
AP130 AP131 AP136 AP150 AP151 AP155
AP156 AP160 AP161 AP166 AP170 AP175
AP176 AP180 AP181 AP185 AP190 AP191
AP193 AP195 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.6 AP20.7 AP20.8 AP200 AP201
AP21.1 AP210 AP213 AP220 AP23.1 AP237
AP25.1 AP25.2 AP255 AP26.1 AP265 AP27.1
AP275 AP28.1 AP28.2 AP284 AP30.1 AP30.2
AP30.3 AP30.4 AP305 AP510 AP52.1 AP52.3
AP520 AP55.1 AP55.2 AP56.1 AP56.2 AP80.1
AP81.1 AP90.1 AP90.5 AP91.1 AP91.4 AP95.1
AP95.2 AP95.3 API1.1 API2.1 API3.1 API4.1
API5.1 AR01.1 AR08.1 AR09.1 AR10.1 AR100
AR115 AR12.1 AR12.2 AR120 AR124 AR129
AR13.1 AR13.2 AR130 AR131 AR135 AR137
AR14.1 AR15.4 AR150 AR160 AR161 AR170
AR180 AR190 AR191 AR194 AR195 AR196
AR199 AR20.1 AR21.1 AR21.2 AR21.3 AR21.4
AR230 AR232 AR237 AR239 AR24.1 AR250
AR251 AR252 AR253 AR255 AR256 AR258
AR271 AR275 AR28.1 AR286 AR287 AR29.1
AR29.2 AR29.3 AR290 AR296 AR30.1 AR30.2
AR30.3 AR30.6 AR30.7 AR30.8 AR301 AR32.1
AR32.3 AR33.1 AR33.3 AR33.5 AR33.6 AR34.1
AR34.2 AR34.3 AR34.4 AR35.1 AR35.2 AR36.1
AR37.1 AR37.2 AR37.3 AR37.4 AR37.5 AR37.6
AR37.7 AR38.1 AR38.2 AR38.3 AR39.1 AR39.2
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 AR80.1 AR80.2 AR800 AR82.1 AR90.1
ARLL.1 BL00.1 BL01.1 BL02.1 BL09.1 BL120
BL122 BL123 BL125 BL130 BL140 BL199
BL20.1 BL20.3 BL20.5 BL20.6 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 BL91.1
BL92.1 BN00.1 BN00.2 BN100 BN101 BN102
BN103 BN104 BN105 BN145 BN15.1 BN150
BN190 BN20.1 BN245 BN305 BN31.1 BN31.2
BN32.1 BN32.2 BN32.3 BN45.1 BN531 BN65.1
BN66.1 BN71.1 BN72.1 BN80.1 BN81.1 BN81.2
BS13.1 BS14.1 BS15.1 BS32.1 BR00.1 BR00.2
BR02.3 BR10.1 BR10.2 BR11.1 BR120 BR121
BR122 BR123 BR124 BR130 BR131 BR140
BR151 BR152 BR153 BR154 BR155 BR156
BR16.1 BR165 BR190 BR20.1 BR20.2 BR20.3
BR20.4 BR20.5 BR20.6 BR21.2 BR252 BR40.3
BR400 BR41.1 BR41.4 BR420 BR43.1 BR44.1
BR46.1 BR46.2 BR46.3 BR46.4 BR47.1 BR48.1
BR51.1 BR51.2 BR515 BR516 BR52.1 BR52.2
BR52.4 BR52.5 BR521 BR530 BR55.2 BR570
BR65.1 BR65.2 BR70.1 BR70.2 BR96.1 BRIP.1
CB00.3 CB01.2 CB01.4 CB03.1 CB03.2 CB05.1
CB06.1 CB06.2 CB10.1 CB10.3 CB145 CB15.1
CB15.2 CB150 CB162 CB175 CB180 CB185
CB186 CB187 CB190 CB191 CB195 CB20.1
CB210 CB215 CB220 CB221 CB25.1 CB255
CB260 CB286 CB30.1 CB43.1 CB44.1 CB45.1
CB46.1 CB50.1 CB500 CB54.1 CB543 CB544
CB55.1 CB554 CB62.1 CB80.1 CB82.1 CB90.2
CB90.5 CB90.7 CB99.3 CB99.4 CB99.5 CBBO.1
CBOP.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.1 EE135 EE175 EE20.1 EE20.2
EE20.3 EE20.4 EE220 EE230 EE275 EE35.1
EE35.2 EE520 ET09.1 ET175 ET530 ET540
ET542 ET545 ET700 ETI1.1 ETI2.1 CA00.1
CA00.2 CA05.1 CA10.1 CA10.2 CA10.4 CA10.5
CA10.6 CA10.7 CA110 CA15.1 CA15.2 CA160
CA195 CA199 CA200 CA210 CA215 CA240
CA290 CA60.1 FB10.1 FB100 FB101 FB11.1
FB11.2 FB111 FB120 FB121 FB122 FB141
FB160 FB165 FB195 FB20.1 FB20.2 FB20.3
FB20.4 FB20.6 FB20.7 FB21.1 FB210 FB211
FB215 FB220 FB225 FB230 FB231 FB235
FB240 FB25.1 FB265 FB295 FB296 FB30.1
FB31.1 FB35.1 FB60.1 FB65.1 FB95.1 FB95.2
FB95.3 FB95.4 FB95.5 FB95.6 GL122 GL130
GL135 GL141 GL145 GL147 GL165 GL179
GL195 GL196 GL230 GL235 GL238 GL240
GL241 GL243 GL245 GL247 GL250 GL256
GL265 GL267 GL270 GL275 GL281 GL284
GL285 GL286 GL287 GL288 GL289 GL290
GL291 GL294 GL295 GL296 GL297 GL298
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 GL90.5 GL90.6 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 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
HGDT.1 HGLS.1 HR00.1 HR01.1 HR02.1 HR11.1
HR11.2 HR200 HR511 IC01.1 IC02.1 IC11.1
IC12.1 IC130 IC330 IC811 IC812 ICLC.1
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 GL16.4 GL161 GL162
GL201 GL208 GL210 GL211 GL220 GL221
GL222 GL223 GL225 GL23.1 GL24.1 GL25.1
GL261 GL311 GL342 GL38.2 GL42.1 GL61.1
GL62.1 GLAV.1 GLCV.1 GLEX.1 GLOP.1 GLRV.1
GLVW.1 IF20.1 IF20.2 IF20.3 IF20.4 IF20.5
IF20.6 IF20.7 IFAC.1 IFBO.1 IFCU.1 IFFC.1
IFGT.1 IFIC.1 IFOS.1 IFOS.3 IFSG.1 JB00.1
JB00.2 JB00.3 JB00.4 JB200 MX123 MX135
MX500 LP130 LP198 MA01.1 MA01.2 MA05.3
MA05.6 MA08.1 MA180 MA205 MA208 MA231
MA279 MA310 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MA53.1 MA53.6 MA530 MA531 MA54.1 MA54.2
MA54.7 MA540 MA60.2 MA60.3 MA60.5 MA61.1
MA63.1 MA65.1 MA66.2 MA66.3 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA70.1 MA75.1 MA80.1
MAI1.1 MLRV.1 PA02.1 PA100 PA102 PA115
PA13.1 PA13.2 PA182 PA213 PA495 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PD01.2
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PD21.1 PD22.1 PD230 PD235 PO01.1 PO10.1
PO100 PO101 PO115 PO120 PO122 PO130
PO131 PO132 PO135 PO136 PO139 PO15.1
PO15.2 PO150 PO190 PO199 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO220
PO223 PO229 PO23.1 PO233 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO253 PO254 PO26.1
PO27.2 PO278 PO29.1 PO295 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.1 PO32.2
PO32.4 PO33.1 PO34.1 PO35.1 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO53.4 PO536 PO54.1 PO54.2 PO54.3
PO54.4 POA2.4 POCP.1 POD0.1 POED.1 POI3.1
POI7.1 POID.1 POIF.1 POIG.1 POIH.1 POII.1
POIJ.1 POIM.1 POIT.1 PR05.1 PR05.3 PR05.6
PR05.7 PR110 PR113 PR120 PR128 PR13.1
PR13.2 PR13.5 PR13.6 PR13.8 PR130 PR131
PR132 PR134 PR136 PR137 PR14.1 PR14.2
PR140 PR15.1 PR15.2 PR189 PR195 PR196
PR197 PR198 PR20.4 PR205 PR226 PR23.1
PR247 PR26.1 PR26.2 PR29.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 PR35.9 PR36.1
PR37.1 PR38.1 PR39.1 PR39.2 PR45.1 PR47.1
PR47.2 PR514 PR529 PR530 PR539 PR560
PR80.1 PR80.3 PR82.1 PR85.1 PR89.1 UK102
UK330 UK47.1 UK47.2 UK560 PW110 PW510
PW550 MM280 MM80.1 MM80.2 RQ01.1 RQ02.1
RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ111 RQ12.1
RQ13.1 RQ13.2 RQ202 RQ230 RQ235 RQ240
RQ35.1 RQ44.2 RQ50.1 RQ500 RQD0.1 RQIA.1
RQIB.1 RQIC.1 RQID.1 RQIF.1 RQIG.1 RQIJ.1
SB15.1 SB515 SL40.1 SL40.4 SLSE.1 SLSR.1
SLVW.1 SN01.1 SN60.2 SN70.1 SN70.2 SNAU.1
SNFL.1 SNGL.1 SNOA.1 SNRA.1 SNRP.1 SNSA.1
SNSP.1 TA147 TA195 TA196 TE01.3 IN08.1
IN120 IN20.1 TX00.1 TX04.1 TX100 TX101
TX140 TX202 TX204 TX222 TX226 TX301
TX40.1 TX804 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 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
GL00.2 GL00.7 CU00.1
UPDATED BY
CA190 FB145 FB190 FB40.1 FB40.2 FB40.3
FB45.1 GL110 GL120 GL146 GL148 GL167
GL170 GL190 GL191 GL197 GL199 GL292
GL293 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
Element: 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
Element: Name This is the company name or GL210
description.
GLS-BS-ACCT-UNIT Alpha 15 GL20.6
Element: Base AccountinThe 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
Element: Accounting PerThis is the current accounting period. GL198 GL199
This field is updated by GL199 (Period GL500
Closing).
01
13
GLS-COND-DFT-PRD Derived
Element: Default PeriodThis field determines the period for
viewing when using the Drill Around
Chart Name feature.
GLS-FISCAL-YEAR Numeric 4 GL10.1 GL198
Element: Fiscal Year Contains the fiscal year for the data GL199 GL500
stored on this record. RW200 RW299
GLS-LAST-FISC-YR Derived
Element: Last Fiscal YeThe last fiscal year.
GLS-NEXT-FISC-YR Derived
Element: Next Fiscal YeThe next fiscal year.
GLS-LST-YR-CLOSED Numeric 4
Element: Last Year ClosThis 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
Element: Period End DatRequired 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
Element: Period End CodThis 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
Element: 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
Element: Currency TableThe 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
Element: Curr Exchange 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
Element: Currency Code This is the company base currency code
as defined in Currency Code (CU01.1).
GLS-COMPANY-ND Numeric 1 GL10.1 GL110
Element: Number of DeciDecimal positions in the company
currency code amount fields.
GLS-IS-ACCT-UNIT Alpha 15 GL20.6
Element: Acct Unit The accounting unit is a shorthand
notation representing the variable level
number. When used in the General Ledger
Account Master file, the accounting unit
must be defined in the General Ledger
Names file as a posting accounting unit.
GLS-ACTIVE-STATUS Alpha 1 GL10.1
Element: 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
Element: Level DescriptOccurs 5 Times
This is the level description.
GLS-NBR-DIGITS Numeric 2 Occurs 5 Times GL10.1 GL120
Element: Number Digits This is the level size. GL124 GL161
00 GL190 GL20.1
15 GL240
GLS-LVL-ONE-DIGIT Derived
Element: Level One DigiDisplays the array value.
GLS-GL190-RUN-DT.html">GL190-RUN-DT Numeric 8 (yyyymmdd) GL190
Element: GL190 Run DateThis 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
Element: GL190 Run TimeThis is the last time that GL190
(Journal Posting) was run. Updated each
time GL190 is run.
GLS-POSTED-TH-DT Numeric 8 (yyyymmdd) GL190
Element: Posted ThroughThis is the last posted- through date
used by GL190 (Journal Posting).
GLS-PROJ-ACCT-FLG Alpha 1
Element: 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
Element: Base Zone This is the default base zone used to
create interzone balancing transactions.
GLS-BACKPOST Alpha 1 Occurs 26 Times GL110 GL190
Element: 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)
Element: Run Date Indicates the last time that
Consolidation File Creation was run.
GLS-CHART-NAME Alpha 12 GL10.1 GL110
Element: 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
Element: Default PeriodThis field determines the period for
viewing when using the Drill Around
Chart Name feature.
00
13
GLS-JOURNAL-BY-DOC Alpha 1 GL10.1
Element: Journal by DocDetermines 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 FB145
Element: Updating This will be set with a value when an FB190 FB40.1
update program is running in GL. The FB40.2 FB40.3
value will determine the program that is FB45.1 GL110
running. No other updates may take GL120 GL146
place while this field is not blank. GL148 GL170
GL190 GL191
00 = None GL197 GL199
01 = GL170 Running GL40.1 GL40.2
02 = GL146 Running GL40.3 GL40.7
03 = CA190 Running GL40.8 GL44.1
04 = GL190 Running GL45.1 GL500
05 = GL199 Running GL75.1
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 = AC Programs Running
15 = FB40 Running
16 = FB45 Running
17 = FB190 Running
GLS-CLOSE-SEQ Numeric 2 Occurs 39 Times GL110 GL167
Element: Close SequenceThe sequence number of the entry. GL199
GLS-LEVEL-DEPTH Numeric 1 GL10.1
Element: 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
Element: Seq Trans CodeDetermines 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
Element: Reset Seq NumbThis 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
Element: Change Post TrThis 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
Element: Change Rel TraThis 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
Element: 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-JE-APPROVE-AMT Signed 18.2 GL10.1
Element: Intl Amt
GLS-WORKFLOW-FLAG Alpha 1 GL10.1
Element: Workflow Flag This field determines whether you are
using a Workflow system for approving
journal entries.
GLS-CURR-NAME-1 Alpha 12 GL10.1 GL110
Element: Curr Name 1 Type or select a name that identifies GL240 GL310
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
Element: Currency Code This field contains the company base GL310
currency code established in Company
(GL10.1 ).
GLS-CURR-CODE-ND-1 Numeric 1 GL10.1 GL310
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
GLS-CURR-NAME-2 Alpha 12 GL10.1 GL110
Element: Curr Name 2 Type or select a name that identifies GL240 GL310
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
Element: Currency Code This field contains the company base GL310
currency code established in Company
(GL10.1 ).
GLS-CURR-CODE-ND-2 Numeric 1 GL10.1 GL310
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
GLS-AUTO-BASE-BAL Alpha 1 GL10.1
Element: Auto Base Bal Indicates whether the company requires
journal autobalancing in company base
currency.
GLS-CURR-RE-FLAG Alpha 1 GL10.1
Element: Curr Re Flag This field is used to track journal
entry amounts by the transaction
currency in addition to the company base
currency.
GLS-BUD-EDIT-RANGE Alpha 1 GL10.1 POIM.1
Element: Bud Edit RangeThis field indicates the budget range
against which GL commitments should be
edited. The valid values are:
N = No Edit
P = Period
Y = Year-To-Date
A = Annual
GLS-BUD-EDIT-TYPE Alpha 1 GL10.1
Element: Bud Edit Type This field indicates whether GL
commitments are edited against
summarized budget amounts or detail
budget amounts.
D = Detail
S = Summary
GLS-FB-UPDATING Numeric 2
Element: Fb Updating
GLS-ML-UPDATING Numeric 2
Element: Ml Updating
GLS-BUD-TOLERANCE Signed 5.2 GL10.1
Element: Bud Tolerance The budget edit tolerance percentage
for GL commitments.
GLSYSTEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLSSET1 COMPANY AC03.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC113 AC12.2
AC121 AC123
AC127 AC130
AC131 AC145
AC160 AC17.3
AC17.4 AC18.2
AC18.3 AC19.2
AC19.3 AC190
AC191 AC195
AC197 AC198
AC20.1 AC20.2
...
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
Addrdata ADDRDATA Not Required
GAD-ADDR-CODE -> GDD-ADDR-CODE
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
Comt Acct GLCHARTDTL Not Required
GLS-CHART-NAME -> GDT-CHART-NAME
GCH-COMT-ACCOUNT -> GDT-ACCOUNT
GCH-COMT-SUB-ACCT -> GDT-SUB-ACCOUNT
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
Cuacct CUACCT
GLS-COMPANY -> CUA-COMPANY
CUA-FR-CURR-CODE
CUA-TO-CURR-CODE
CUA-SYSTEM
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
Mlcalmap MLCALMAP
GLS-COMPANY -> MCM-COMPANY
MCM-LEDGER
MCM-CURRENT-YR-FL
Mlcoledger MLCOLEDGER
GLS-COMPANY -> MLE-COMPANY
MLE-LEDGER
|
