|
|
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 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 AC54.1 AC540 AC581
AC62.1 AC81.1 AC94.4 AC98.2 ACAC.1 ACVW.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 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
AM214 AM220 AM221 AM222 AM223 AM224
AM225 AM230 AM235 AM240 AM241 AM245
AM25.1 AM250 AM251 AM252 AM255 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 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 AP05.1 AP05.2 AP05.7
AP05.8 AP10.1 AP10.2 AP10.5 AP10.6 AP110
AP115 AP125 AP126 AP130 AP131 AP150
AP151 AP155 AP156 AP160 AP161 AP166
AP170 AP175 AP176 AP180 AP181 AP185
AP190 AP191 AP193 AP195 AP200 AP201
AP210 AP213 AP220 AP237 AP25.1 AP25.2
AP255 AP26.1 AP260 AP265 AP27.1 AP275
AP28.1 AP28.2 AP284 AP30.2 AP30.3 AP30.4
AP305 AP510 AP520 AP55.1 AP55.2 AP56.1
AP56.2 AP80.1 AP81.1 AP90.5 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
AR105 AR115 AR12.1 AR12.2 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.6 AR30.7
AR30.8 AR301 AR31.1 AR31.5 AR31.6 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 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 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 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.1 BR00.2 BR02.3 BR10.1 BR10.2 BR11.1
BR120 BR121 BR122 BR130 BR131 BR140
BR16.1 BR190 BR20.1 BR20.2 BR20.3 BR20.4
BR20.5 BR20.6 BR21.2 BR40.3 BR400 BR41.1
BR41.4 BR420 BR43.1 BR44.1 BR46.1 BR46.2
BR46.3 BR46.4 BR515 BR516 BR521 BR530
BR65.1 BR65.2 BR96.1 BRCC.1 BRIP.1 CB00.3
CB01.2 CB01.4 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 CB25.1 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
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 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
GL267 GL270 GL275 GL281 GL284 GL285
GL286 GL287 GL288 GL289 GL290 GL291
GL292 GL293 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 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
IC235 IC24.1 IC24.2 IC240 IC25.1 IC28.1
IC280 IC282 IC283 IC330 IC500 IC522
IC523 IC525 IC526 IC527 IC531 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 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 IFOS.1 IFOS.3 IFSG.1 JB00.1
JB00.2 JB00.3 JB00.4 JB200 MX135 MA01.1
MA01.2 MA05.3 MA05.6 MA08.1 MA126 MA180
MA205 MA208 MA231 MA310 MA530 MA531
MA54.1 MA540 MA60.2 MA60.3 MA60.5 MA61.1
MA63.1 MA65.1 MA66.2 MA66.3 MA67.1 MA67.2
MA68.1 MA70.1 MA75.1 MA80.1 MAI1.1 MLRV.1
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 OE111 OE112 OE113 OE114 OE116
OE129 OE13.2 OE13.3 OE13.5 OE13.6 OE130
OE14.1 OE14.2 OE14.4 OE229 OE283 OE291
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE310 OE510 OE530 OE80.1
OE80.2 OE80.3 OE80.4 OE80.5 OE81.1 OE810
OE830 OE90.1 OE90.2 PA02.1 PA100 PA102
PA13.1 PA13.2 PA182 PA213 PA495 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PBIP.1
PO01.1 PO100 PO101 PO122 PO130 PO131
PO132 PO135 PO136 PO150 PO199 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO220 PO23.1 PO25.1 PO25.5 PO25.6 PO25.7
PO26.1 PO27.2 PO29.1 PO295 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.1 PO32.2
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 POA2.4 POCP.1 POED.1 POI3.1 POI7.1
POID.1 POIE.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 PR15.1
PR15.2 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 PR529 PR530 PR560
PR82.1 PR85.1 PRSA.1 UK102 UK330 UK47.1
UK47.2 MM280 RQ01.1 RQ10.1 RQ10.2 RQ10.3
RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ140 RQ235
RQ300 RQ35.1 RQ40.1 RQ41.1 RQ42.1 RQ44.1
RQ44.2 RQ500 RQIB.1 RQIC.1 RQID.1 RQIF.1
RQIG.1 RQIJ.1 SA100 SL40.1 SL40.4 SLSE.1
SLSR.1 SLVW.1 TA147 TA195 TA196 TE01.3
TP135 IN08.1 IN120 IN20.1 TX00.1 TX04.1
TX100 TX101 TX202 TX204 TX226 TX301
TX40.1 TX804 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH25.1 WH25.2 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 WO132 WO140 WO293 WO30.1
WODL.1 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 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 This is the current fiscal year. This GL199 GL500
field is updated by Period Closing RW200 RW299
(GL199).
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 CU01.1 (Currency Code).
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: 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 GL75.1
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 = 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 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
Element: 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
Element: Currency Code Type the currency code you want to GL310
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
Account Currency The number of decimal positions defined
Code 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
Element: Currency Code Type the currency code you want to GL310
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
Account Currency The number of decimal positions defined
Code for Report Currency 2.
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: Currency LedgeThis 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
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 This path is used to retrieve company AC03.1 AC03.2
records. 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 AC190
AC191 AC195
AC197 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
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
|
