|
|
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 AC113 AC12.2 AC121 AC123
AC127 AC130 AC131 AC160 AC17.3 AC17.4
AC176 AC18.2 AC18.3 AC190 AC191 AC192
AC195 AC196 AC198 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC20.6 AC20.7 AC210 AC256
AC27.1 AC298 AC32.1 AC34.1 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 AC490
AC494 AC50.1 AC500 AC52.1 AC520 AC53.1
AC530 AC54.1 AC54.2 AC54.3 AC540 AC541
AC542 AC550 AC581 AC59.1 AC62.1 AC76.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 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 AM330 AM35.1 AM40.1 AM40.2 AM40.3
AM40.4 AM41.1 AM41.2 AM45.1 AM500 AM501
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 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 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.6 AP20.7 AP20.8 AP200 AP201 AP210
AP213 AP220 AP23.1 AP25.1 AP25.2 AP255
AP26.1 AP260 AP265 AP27.1 AP275 AP28.1
AP28.2 AP284 AP30.2 AP30.3 AP30.4 AP305
AP32.2 AP510 AP520 AP55.1 AP55.2 AP56.1
AP56.2 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 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.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 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 BN66.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 BR122 BR123 BR124 BR130 BR131
BR15.2 BR151 BR152 BR153 BR154 BR155
BR156 BR16.1 BR20.6 BR252 BR40.3 BR400
BR41.1 BR41.4 BR420 BR43.1 BR47.1 BR51.1
BR51.2 BR52.1 BR52.2 BR52.4 BR52.5 BR521
BR530 BR55.2 BR65.1 BR65.2 BR901 BRCC.1
BRIP.1 BRPI.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
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 CA195 CA199 CA200 CA210
CA215 CA240 CA290 FB10.1 FB100 FB101
FB11.1 FB11.2 FB111 FB120 FB121 FB122
FB141 FB165 FB195 FB20.1 FB20.2 FB20.3
FB20.4 FB20.6 FB20.7 FB21.1 FB210 FB211
FB220 FB225 FB230 FB231 FB240 FB25.1
FB265 FB295 FB296 FB30.1 FB31.1 FB40.1
FB40.2 FB40.3 FB40.4 FB40.5 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 GL700
GL90.1 GL90.2 GL90.3 GL90.4 GL90.5 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 HCGL.1 HGDT.1 HGLS.1 HR00.1
HR01.1 HR02.1 HR11.1 HR11.2 HR200 HR511
HR650 ZR621 DR100 IC01.1 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 IC28.1 IC280 IC282
IC283 IC285 IC330 IC500 IC522 IC523
IC525 IC526 IC527 IC531 IC81.1 IC811
IC812 IC82.1 IC83.1 IC84.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 GL312 GL313 GL342
GL38.2 GL42.1 GL61.1 GL62.1 GL721 GLAV.1
GLCV.1 GLEX.1 GLOP.1 GLRV.1 GLVW.1 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
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.5 MA43.7 MA43.8 MA43.9
MA53.1 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 MA730
MA75.1 MA80.1 MAI1.1 MLRV.1 PA02.1 PA100
PA102 PA13.1 PA13.2 PA213 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PBIP.1 PO01.1
PO100 PO101 PO122 PO130 PO131 PO132
PO135 PO136 PO139 PO150 PO199 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO220 PO229 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 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
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 PR36.1 PR37.1
PR38.1 PR39.1 PR39.2 PR45.1 PR47.1 PR47.2
PR514 PR529 PR530 PR560 PR80.1 PR80.3
PR82.1 PR85.1 PR89.1 PRSA.1 UK102 UK330
UK47.1 UK47.2 UK560 MM280 MM80.1 MM80.2
RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1
RQ13.1 RQ140 RQ235 RQ300 RQ35.1 RQ40.1
RQ41.1 RQ42.1 RQ44.1 RQ44.2 RQ500 RQD0.1
RQIB.1 RQIC.1 RQID.1 RQIE.1 RQIF.1 RQIG.1
RQIJ.1 SL40.1 SL40.4 SLSE.1 SLSR.1 SLVW.1
TA147 TA195 TA196 TE01.3 UK120 IN08.1
IN120 IN20.1 TX00.1 TX04.1 TX100 TX202
TX204 TX226 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 FB45.1 GL110 GL120
GL146 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: Is Acct 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 FB45.1
update program is running in GL. The GL110 GL120
value will determine the program that is GL146 GL170
running. No other updates may take GL190 GL191
place while this field is not blank. GL197 GL199
GL40.1 GL40.2
00 = None GL40.3 GL40.7
01 = GL170 Running GL40.8 GL44.1
02 = GL146 Running GL45.1 GL75.1
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
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-SNGL-ACCT-TYPE Alpha 1 GL10.1
Element: Sngl Acct TypeIndicates if an account must be either
all credits or all debits.
GLS-JE-APPROVE-AMT Signed 15.2 GL10.1
Element: Adj Amt
GLS-WORKFLOW-FLAG Alpha 1 GL10.1
Element: All Flag
GLS-CURR-NAME-1 Alpha 12 GL10.1 GL110
Element: Name User GL240 GL310
GLS-CURR-CODE-1 Alpha 5 GL10.1 GL110
Element: Currency Code GL310
GLS-CURR-CODE-ND-1 Numeric 1 GL10.1 GL310
Account Currency
Code
GLS-CURR-NAME-2 Alpha 12 GL10.1 GL110
Element: Name User GL240 GL310
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
Account Currency
Code
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 GL110
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 GL110
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
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
AC113 AC12.2
AC121 AC123
AC127 AC130
AC131 AC160
AC17.3 AC17.4
AC176 AC18.2
AC18.3 AC190
AC191 AC192
AC195 AC196
AC198 AC20.1
AC20.2 AC20.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
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
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
|
