GLMASTER

General Ledger Account Master

This file contains the chart of accounts. All Lawson subsystems verify the existence of accounts against this file. The Chart of Accounts, Level Reorganization, Mass Account Addition, and Mass Account Change Delete are the primary programs that create and maintain information in the file.

REFERENCED BY
AC121 AC123 AC130 AC131 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC32.1 AC37.1 AC40.4
AC41.4 AC42.1 AC490 AM180 AM19.1 AM19.2
AP115 AP131 AP170 AP193 AP220 AP30.2
AP30.4 AP305 AP520 BR41.4 CB10.1 CB15.1
CB15.2 CB150 CB191 CB20.1 CB30.1 CB45.1
CB46.1 CB500 CB543 CB544 CB55.1 CB554
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 EE135 EE35.1
EE35.2 EE520 CA10.1 CA10.5 CA10.7 FB145
FB190 FB40.1 FB40.2 FB40.3 GL165 GL170
GL194 GL65.1 GL70.1 GL70.2 GL70.3 GL70.5
GL70.6 GL75.1 GL76.1 IC02.1 IC130 IC140
IC66.1 CU01.1 CU01.2 CU02.1 CU02.2 CU10.1
CU10.2 EX545 IFEB.1 MA180 MA26.1 MA310
MA530 MA531 MA60.2 MA60.3 MA60.5 MA63.1
MA65.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA69.1 MA70.1 MA75.1 MA80.1 ML165
ML65.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PD22.1 PO100 PO101 PO122 PO131
PO135 PO136 PO150 PO190 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO23.1 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO26.1 PO26.2 PO26.3 PO26.4 PO26.5 PO26.6
PO26.7 PO26.9 PO27.2 PO28.2 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 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 PO536 PO54.5 POCP.1
POI3.1 POID.1 POII.1 POIJ.1 POIK.1 POIM.1
PR195 PR197 PR582 PR82.1 PR85.1 RQ12.1
RQID.1 SLSE.1 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 WH32.5 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 ZW130 ACVW.1 ATVW.1 AD191 FB100
FB195 FB20.1 FB20.6 FB20.7 FB20.4 FB20.3
FB21.1 GL191 RW230 RW270 RW30.1 RW70.1
GL222 GLAV.1 GLCV.1 GLVW.1 ML191 ML94.1
ML94.2 ML94.3 ML94.4 ML95.1 ML95.2 ML95.3
ML95.4 ML95.5 ML95.6 ML95.7 ML95.8 ML95.9
ML96.1 ML96.2 ML96.3 ML96.4 ML96.5 ML97.1
ML97.2 ML97.3 ML97.4 ML97.5 ML97.6 ML97.7
ML97.8 ML97.9 ML98.1 ML98.2 ML98.3 ML98.4
ML98.5 ML99.1 ML99.2 ML99.3 ML99.4 ML99.5
ML99.6 SLVW.1 SNOA.1 SNRA.1 SNSA.1 AD190
AD220 GL130 GL141 GL288 GL35.1 HGLM.1
GL14.8 GL221 GL38.1 MX135 ML170 ML70.1
ML70.2 ML70.3 ML70.5 ML70.6 ML75.1 ML90.1
ML90.2 ML90.4 ML90.5 SL40.4 GL50.4 ML50.4
FB120 GL281 ML291 ML11.1


UPDATED BY
AC191 AP125 AP126 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 API1.1 API2.1 BR44.1
CB222 CA110 FB11.1 FB111 FB160 FB211
FB296 FB35.1 FB45.1 FB60.1 FB95.1 FB95.2
FB95.3 FB95.4 FB95.5 FB95.6 GL100 GL110
GL120 GL122 GL135 GL146 GL167 GL190
GL195 GL196 GL197 GL199 GL291 GL298
GL299 GL30.1 GL330 GL40.1 GL40.2 GL40.3
GL40.7 GL40.8 GL44.1 GL45.1 GL500 GL90.1
GL90.4 GL90.6 GL93.1 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 RW100 DR100 IC141 IC142
IC222 IC83.1 CU03.1 GL00.2 GL00.3 GL00.7
GL02.1 GL02.2 GL03.6 GL10.1 GL121 GL124
GL125 GL20.1 GL20.2 GL20.4 GL25.1 GLRV.1
IFAC.1 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA44.1
MA44.2 MA61.1 MAI1.1 ML146 ML167 ML190
ML195 ML196 ML199 ML330 ML40.1 ML40.2
ML40.3 ML40.7 ML40.8 ML44.1 ML45.1 PO20.4
RQ10.1 RQ10.3 RQ11.1 RQ13.2 RQ35.1 RQ500
RQIB.1 RQIF.1 RQIJ.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLM-COMPANY
Element: Company
Numeric 4
The company number.
...
AC191 AP125
AP126 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
CB222 DR100
FB45.1 GL110
GL121 GL124
GL135 GL167
GL190 GL195
GL196 GL199
GL20.2 GL20.4
GL330 GL45.1
GL500 IC141
IC142 IC222
IC83.1 IFAC.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MAI1.1
ML167 ML190
ML195 ML196
ML199 ML330
ML45.1 RQ10.1
RQ10.3 RQ11.1
GLM-VAR-LEVELS
Element: Variable Levels
Alpha 30
Required. The variable level number is tied directly to the accounting unit. It is used to indicate an accounting unit's position within the company hierarchy, establishing its consolidation relationship with other units. Must be defined in the GLNAMES file as a posting level.
...
AC191 AP125
AP126 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
CB222 DR100
FB45.1 GL120
GL121 GL124
GL135 GL167
GL190 GL195
GL196 GL199
GL20.2 GL20.4
GL330 GL45.1
GL500 IC141
IC142 IC222
IC83.1 IFAC.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MAI1.1
ML167 ML190
ML195 ML196
ML199 ML330
ML45.1 RQ10.1
RQ10.3 RQ11.1
GLM-ACCT-UNIT
Element: Accounting Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number.
...
AC191 AP125
AP126 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
CB222 DR100
FB45.1 GL121
GL124 GL135
GL167 GL190
GL195 GL196
GL199 GL20.2
GL20.4 GL330
GL45.1 GL500
IC141 IC142
IC222 IC83.1
IFAC.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA61.1
MAI1.1 ML167
ML190 ML195
ML196 ML199
ML330 ML45.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
GLM-OLD-COMPANY-D
Element: Old Company
Derived
Contains the old company derived.
GLM-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
...
AC191 AP125
AP126 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
CB222 DR100
FB45.1 GL121
GL124 GL135
GL167 GL190
GL195 GL196
GL199 GL20.2
GL20.4 GL330
GL45.1 GL500
IC02.1 IC141
IC142 IC222
IC83.1 IFAC.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MAI1.1
ML167 ML190
ML195 ML196
ML199 ML330
ML45.1 RQ10.1
RQ10.3 RQ11.1
GLM-SUB-ACCOUNT
Element: Subaccount
Numeric 4
This field along with the accounting unit and account make up the location (account) where amounts and other account information are stored.
...
AC191 AP125
AP126 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
CB222 DR100
FB45.1 GL121
GL124 GL135
GL167 GL190
GL195 GL196
GL199 GL20.2
GL20.4 GL330
GL45.1 GL500
IC02.1 IC141
IC142 IC222
IC83.1 IFAC.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MAI1.1
ML167 ML190
ML195 ML196
ML199 ML330
ML45.1 RQ10.1
RQ10.3 RQ11.1
GLM-OLD-ACCT-NBR-D
Element: Old Account Number
Derived
Contains the derived old account number.
GLM-ACTIVE-STATUS
Element: Active Status
Alpha 1
Required field if a detail-type account, otherwise this field should be blank. Indicates if a detail account is either active or inactive. Inactive accounts cannot be used for posting.
" " = Default
I = Inactive
GL121 GL122
GL124 GL167
GL20.2 ML167
GLM-STATUS-DERIVED
Element: Status
Derived
Contains the derived status.
GLM-ACCT-ND
Account Number of
Decimals
Numeric 1
Account amount decimal positions.
...
AC191 AP125
AP126 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
CB222 DR100
FB45.1 GL110
GL121 GL124
GL135 GL167
GL190 GL195
GL196 GL199
GL20.2 GL20.4
GL330 GL45.1
GL500 IC141
IC142 IC222
IC83.1 IFAC.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MAI1.1
ML167 ML190
ML195 ML196
ML199 ML330
ML45.1 RQ10.1
RQ10.3 RQ11.1
GLM-UNITS-CODE
Element: Units Code
Alpha 1
Required if a detail-type account. This field indicates if units are allowed, not allowed, or only allowed.
" " = Default
Y = Yes - Not Required
N = No
O = Only Units
R = Yes - Required
GL121 GL122
GL124 GL146
GL167 GL190
GL197 GL20.2
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 ML146
ML167 ML190
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1
GLM-UNITS-DERIVED
Element: Units
Derived
Contains the derived units.
GLM-AVG-DAILY-BAL
Average Daily
Balance
Alpha 1
Yes value indicates the account is used for calculating average daily balance.
" " = No
N = No
Y = Yes
I = Inactive
GL121 GL122
GL20.2
GLM-ACTIVITY-REQ
Element: Activity Required
Alpha 1
Indicates if an Activity code is required.
Y = Yes
N = No
" " = Default
GL121 GL122
GL124 GL20.2
GLM-GLINTCO-STAT
Element: Intercompany Status
Numeric 3
Not required. This field is used to count the number of intercompany or interzone relationships using this account number. Accounts cannot be deleted if this field is greater than zero.
CU03.1 FB35.1
GL110 GL121
GL20.4 GL25.1
GL30.1
GLM-POSTING-LEVEL
Element: Posting Level
Alpha 1
Required if a detail-type account. This field is used to determine whether interface transactions should be combined when creating GLTRANS records.
" " = Default
D = Detail
S = Summary
GL121 GL122
GL124 GL20.2
GLM-OPTION-FLD-1
Element:
Alpha 2 (Lower Case)
Free-form field used to store any information relevant to an account. This field is used for reporting purposes.
GL121 GL122
GL124 GL167
GL20.2 ML167
RW100
GLM-OPTION-FLD-2
Element:
Alpha 7 (Lower Case)
Free-form field used to store information relevant to an account. This field is used for reporting purposes.
GL121 GL122
GL124 GL167
GL20.2 ML167
RW100
GLM-OPTION-FLD-3
Element:
Alpha 12 (Lower Case)
Free-form field used to store any information relevant to an account. This field is used for reporting purposes.
GL121 GL122
GL124 GL167
GL20.2 ML167
RW100
GLM-TRANSL-CODE
Element:
Alpha 2
Contains the translation code.
FB145 FB190
FB195 FB40.1
FB40.2 FB40.3
FB45.1 GL121
GL122 GL124
GL135 GL167
GL191 GL195
GL196 GL197
GL199 GL20.2
ML167 ML191
ML195 ML196
GLM-CURRENCY-CODE
Element: Currency Code
Alpha 5
The company base currency code.
...
AC191 AP125
AP126 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
CB222 DR100
FB45.1 GL110
GL121 GL122
GL124 GL135
GL167 GL190
GL195 GL196
GL199 GL20.2
GL20.4 GL330
GL45.1 GL500
IC141 IC142
IC222 IC83.1
IFAC.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA61.1
MAI1.1 ML167
ML190 ML195
ML196 ML199
ML330 ML45.1
RQ10.1 RQ10.3
GLM-CURR-CONTROL
Element: Currency Control
Alpha 1
Flag used to allow posting to the account in currencies other than the account currency.
" " = Default
0 = No
1 = Yes
GL121 GL122
GL124 GL20.2
GLM-REVALUE
Element: Revalue
Alpha 1
Determines whether or not this account will participate in the revaluation process.
" " = Default
0 = No
1 = Yes
GL121 GL122
GL124 GL20.2
GLM-DATE-ENTERED
Element: Date Entered
Numeric 8 (yyyymmdd)
Date used to document account changes.
...
AC191 AP125
AP126 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
CB222 DR100
FB45.1 GL121
GL124 GL135
GL167 GL190
GL195 GL196
GL199 GL20.2
GL20.4 GL330
GL45.1 GL500
IC141 IC142
IC222 IC83.1
IFAC.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA61.1
MAI1.1 ML167
ML190 ML195
ML196 ML199
ML330 ML45.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
GLM-CHART-NAME
Element: Chart Name
Alpha 12
This is the name assigned to the chart of accounts when you defined your company structure in the Lawson General Ledger system.
...
AC191 AP125
AP126 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
CB222 DR100
FB45.1 GL121
GL124 GL135
GL167 GL190
GL195 GL196
GL199 GL20.2
GL20.4 GL330
GL45.1 GL500
IC02.1 IC141
IC142 IC222
IC83.1 IFAC.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MAI1.1
ML167 ML190
ML195 ML196
ML199 ML330
ML45.1 RQ10.1
RQ10.3 RQ11.1
GLM-BASE-CURRENCY
Element: Base Currency
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
...
AC191 AP125
AP126 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
CB222 DR100
FB45.1 GL110
GL121 GL124
GL135 GL167
GL190 GL195
GL196 GL199
GL20.2 GL20.4
GL330 GL45.1
GL500 IC141
IC142 IC222
IC83.1 IFAC.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MAI1.1
ML167 ML190
ML195 ML196
ML199 ML330
ML45.1 RQ10.1
RQ10.3 RQ11.1
GLM-RESTRICT-SYS
Element: Restrict System
Alpha 1
Indicates if system codes are validated each time the account is used by a system.
Y = Yes
N = No
" " = Default
GL03.6 GL121
GL122 GL124
GL20.2
GLM-ACCT-CATEGORY
Element: Account Category
Alpha 5
Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru
GL121 GL122
GL124 GL20.2
GLM-DER-X-SYS
Element: Der X Sys
Derived
Indicates if system restrictions exist for an account.
GLM-SUMM-ACCT-ID
Element: Summary Account ID
Derived
The summary account ID.
GLM-ACCT-DESC
Element: Account Description
Derived
This is the account description.
GLM-BLANK
Element: Blank
Derived
This derived field is always blank. It is used in the Drill Around feature for column headings.
GLM-CUCODE-DESC
Element: Cucode Desc
Derived
This is the currency code description.
GLM-SL-ACCT-FLAG
Element: Sl Acct Flag
Alpha 1
This flag determines whether user analysis values can be assigned to a specific account. You can select Yes, No, or use the Summary Account selection.
Y = Yes
N = No
" " = Default
GL122 GL20.2
GLM-RELATION
Element: Relation
Alpha 15
The user analysis value relation assigned to the detail or summary account. The relation must exist in SL02.1 (User Analysis Value Relation).
GL122 GL20.2
GLM-LEDGER-GROUP
Element: Ledger Group
Alpha 15
GL122 GL20.2
GLM-GL-BUD-FL
Element: Gl Bud Fl
Alpha 1
This is the Yes/No flag for budget editing.
N = No Edit
Y = Yes
" " = Default
GL122 GL20.2


GLMASTER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLMSET1 COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
...
AC121 AC123
AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
ATVW.1 AD191
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB160 FB195
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
GLMSET2 COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
...
AC131 AC191
AD190 AD191
AD220 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BR44.1
GLMSET3 COMPANY
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
FB20.3 GL120
GL50.4 RW100
GL121 GL20.4
GL222 ML50.4
GLMSET5 COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
...
CA110 FB11.1
FB111 FB120
FB160 FB211
FB296 FB60.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL281 GL291
GL298 GL299
GL90.6 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GLMSET6 VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
COMPANY
ACCT-UNIT
GLRV.1
GLMSET7 ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
COMPANY
ACCT-UNIT
...
FB11.1 FB111
FB160 FB211
FB296 FB60.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL100 GL298
GL299 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
GLMSET8 CHART-NAME
ACCOUNT
SUB-ACCOUNT
COMPANY
ACCT-UNIT
KeyChange
...
AC191 AC40.4
AC41.4 AC42.1
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
BR41.4 BR44.1
CB10.1 CB15.1
GLMSET9 LEDGER-GROUP
COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
KeyChange, Subset
WhereLEDGER-GROUP !=Spaces
ML11.1


GLMASTER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Accountunit GLNAMES Required
GLM-COMPANY->-COMPANY
GLM-ACCT-UNIT->-ACCT-UNIT
Acct Unit GLNAMES Required
GLM-COMPANY->GLN-COMPANY
GLM-ACCT-UNIT->GLN-ACCT-UNIT
Budget 1 FBDETAIL Not Required
GLM-COMPANY->FBD-COMPANY
GLS-FISCAL-YEAR->FBD-FISCAL-YEAR
1->FBD-BUDGET-NBR
GLM-ACCT-UNIT->FBD-ACCT-UNIT
GLM-ACCOUNT->FBD-ACCOUNT
GLM-SUB-ACCOUNT->FBD-SUB-ACCOUNT
Chart Detail GLCHARTDTL Required
GLM-CHART-NAME->GDT-CHART-NAME
GLM-ACCOUNT->GDT-ACCOUNT
GLM-SUB-ACCOUNT->GDT-SUB-ACCOUNT
Company GLSYSTEM Required
GLM-COMPANY->GLS-COMPANY
Consol GLCONSOL Not Required
GLS-FISCAL-YEAR->GCN-FISCAL-YEAR
Zeroes->GCN-LEVEL-DEPTH
Zeroes->GCN-BUDGET-NBR
"A"->GCN-TRANS-TYPE
GLM-COMPANY->GCN-COMPANY
Spaces->GCN-VAR-LEVELS
GLM-ACCOUNT->GCN-ACCOUNT
GLM-SUB-ACCOUNT->GCN-SUB-ACCOUNT
Spaces->GCN-CURRENCY-CODE
Cucodes CUCODES Required
GLM-CURRENCY-CODE->CUC-CURRENCY-CODE
Pocompany POCOMPANY Not Required
GLM-COMPANY->PCY-COMPANY
Procuregrp PROCUREGRP Not Required
PCY-PROCURE-GROUP->PCG-PROCURE-GROUP
Summary Acct GLCHARTSUM Required
GLM-CHART-NAME->GCS-CHART-NAME
GDT-SUMRY-ACCT-ID->GCS-SUMRY-ACCT-ID
Trcodes TRCODES Required
When GLM-TRANSL-CODE =Spaces
GLM-TRANSL-CODE->TRC-TRANSL-CODE
Var Levels GLNAMES Required
GLM-COMPANY->GLN-COMPANY
GLM-VAR-LEVELS->GLN-VAR-LEVELS
GLM-ACCT-UNIT->GLN-ACCT-UNIT
Variablelevel GLNAMES Required
GLM-COMPANY->GLN-COMPANY
GLM-VAR-LEVELS->GLN-VAR-LEVELS
GLM-ACCT-UNIT->GLN-ACCT-UNIT


GLMASTER FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amounts GLAMOUNTS Delete Restricted
GLM-COMPANY->GAM-COMPANY
GLM-ACCT-UNIT->GAM-ACCT-UNIT
GLM-ACCOUNT->GAM-ACCOUNT
GLM-SUB-ACCOUNT->GAM-SUB-ACCOUNT
  GAM-FISCAL-YEAR
Budget All FBDETAIL Delete Restricted
GLM-COMPANY->FBD-COMPANY
GLM-ACCT-UNIT->FBD-ACCT-UNIT
GLM-ACCOUNT->FBD-ACCOUNT
GLM-SUB-ACCOUNT->FBD-SUB-ACCOUNT
  FBD-BUDGET-NBR
  FBD-FISCAL-YEAR
Budgets FBDETAIL Delete Restricted
GLM-COMPANY->FBD-COMPANY
GLM-ACCT-UNIT->FBD-ACCT-UNIT
GLM-ACCOUNT->FBD-ACCOUNT
GLM-SUB-ACCOUNT->FBD-SUB-ACCOUNT
  FBD-BUDGET-NBR
  FBD-FISCAL-YEAR
Cuamount1 CUAMOUNT Delete Cascades
GLM-COMPANY->CAM-COMPANY
GLM-ACCT-UNIT->CAM-ACCT-UNIT
GLM-ACCOUNT->CAM-ACCOUNT
GLM-SUB-ACCOUNT->CAM-SUB-ACCOUNT
1->CAM-AMT-TYPE
GLM-CURRENCY-CODE->CAM-CURRENCY-CODE
  CAM-FISCAL-YEAR
  CAM-VAR-LEVELS
Cuamount2 CUAMOUNT Delete Cascades
GLM-COMPANY->CAM-COMPANY
GLM-ACCT-UNIT->CAM-ACCT-UNIT
GLM-ACCOUNT->CAM-ACCOUNT
GLM-SUB-ACCOUNT->CAM-SUB-ACCOUNT
2->CAM-AMT-TYPE
  CAM-CURRENCY-CODE
  CAM-FISCAL-YEAR
  CAM-VAR-LEVELS
Cuamount3 CUAMOUNT Delete Cascades
GLM-COMPANY->CAM-COMPANY
GLM-ACCT-UNIT->CAM-ACCT-UNIT
GLM-ACCOUNT->CAM-ACCOUNT
GLM-SUB-ACCOUNT->CAM-SUB-ACCOUNT
3->CAM-AMT-TYPE
GLS-CURR-CODE-1->CAM-CURRENCY-CODE
  CAM-FISCAL-YEAR
  CAM-VAR-LEVELS
Cuamount4 CUAMOUNT Delete Cascades
GLM-COMPANY->CAM-COMPANY
GLM-ACCT-UNIT->CAM-ACCT-UNIT
GLM-ACCOUNT->CAM-ACCOUNT
GLM-SUB-ACCOUNT->CAM-SUB-ACCOUNT
4->CAM-AMT-TYPE
GLS-CURR-CODE-2->CAM-CURRENCY-CODE
  CAM-FISCAL-YEAR
  CAM-VAR-LEVELS
Cuamountx 3 CUAMOUNTX
GLM-COMPANY->CAX-COMPANY
3->CAX-AMT-TYPE
GLM-ACCT-UNIT->CAX-ACCT-UNIT
GLM-ACCOUNT->CAX-ACCOUNT
GLM-SUB-ACCOUNT->CAX-SUB-ACCOUNT
  CAX-DATE
Cuamountx 4 CUAMOUNTX
GLM-COMPANY->CAX-COMPANY
4->CAX-AMT-TYPE
GLM-ACCT-UNIT->CAX-ACCT-UNIT
GLM-ACCOUNT->CAX-ACCOUNT
GLM-SUB-ACCOUNT->CAX-SUB-ACCOUNT
  CAX-DATE
Dailytrans GLAMOUNTSX
GLM-COMPANY->GAX-COMPANY
GLM-ACCT-UNIT->GAX-ACCT-UNIT
GLM-ACCOUNT->GAX-ACCOUNT
GLM-SUB-ACCOUNT->GAX-SUB-ACCOUNT
  GAX-DATE
Glacctvld Gcs GLACCTVLD
"S"->VLD-RECORD-TYPE
GLS-CHART-NAME->VLD-CHART-NAME
GDT-SUMRY-ACCT-ID->VLD-SUMRY-ACCT-ID
Zeroes->VLD-ACCOUNT
Zeroes->VLD-SUB-ACCOUNT
Zeroes->VLD-COMPANY
Spaces->VLD-ACCT-UNIT
  VLD-SYSTEM
Glacctvld Gdt GLACCTVLD
GLS-CHART-NAME->VLD-CHART-NAME
GLM-ACCOUNT->VLD-ACCOUNT
GLM-SUB-ACCOUNT->VLD-SUB-ACCOUNT
  VLD-SYSTEM
Glacctvld Glm GLACCTVLD
GLM-COMPANY->VLD-COMPANY
GLM-ACCT-UNIT->VLD-ACCT-UNIT
GLM-ACCOUNT->VLD-ACCOUNT
GLM-SUB-ACCOUNT->VLD-SUB-ACCOUNT
  VLD-SYSTEM
Glacctvld Sys GLACCTVLD
"M"->VLD-RECORD-TYPE
GLM-CHART-NAME->VLD-CHART-NAME
GDT-SUMRY-ACCT-ID->VLD-SUMRY-ACCT-ID
GLM-ACCOUNT->VLD-ACCOUNT
GLM-SUB-ACCOUNT->VLD-SUB-ACCOUNT
GLM-COMPANY->VLD-COMPANY
GLM-ACCT-UNIT->VLD-ACCT-UNIT
  VLD-SYSTEM
Glcommit GLCOMMIT
GLM-COMPANY->GOT-COMPANY
GLM-ACCT-UNIT->GOT-ACCT-UNIT
GLM-ACCOUNT->GOT-ACCOUNT
GLM-SUB-ACCOUNT->GOT-SUB-ACCOUNT
  GOT-FISCAL-YEAR
  GOT-SYSTEM
Glcommitx GLCOMMITX
GLM-COMPANY->GOX-COMPANY
GLM-ACCT-UNIT->GOX-ACCT-UNIT
GLM-ACCOUNT->GOX-ACCOUNT
GLM-SUB-ACCOUNT->GOX-SUB-ACCOUNT
  GOX-FISCAL-YEAR
  GOX-PERIOD
  GOX-SYSTEM
  GOX-CURRENCY-CODE
  GOX-GLT-OBJ-ID
Glhistcom GLHISTCOM
GLM-COMPANY->GHT-COMPANY
GLM-ACCT-UNIT->GHT-ACCT-UNIT
GLM-ACCOUNT->GHT-ACCOUNT
GLM-SUB-ACCOUNT->GHT-SUB-ACCOUNT
  GHT-YEAR
  GHT-SYSTEM
  GHT-UNIQUE-I-D
Othr Acct Unit GLMASTER
GLM-COMPANY->GLM-COMPANY
GLM-ACCOUNT->GLM-ACCOUNT
GLM-SUB-ACCOUNT->GLM-SUB-ACCOUNT
  GLM-VAR-LEVELS
  GLM-ACCT-UNIT
Trans All Prds GLTRANS
GLM-COMPANY->GLT-TO-COMPANY
GLM-ACCOUNT->GLT-ACCOUNT
GLM-SUB-ACCOUNT->GLT-SUB-ACCOUNT
GLM-ACCT-UNIT->GLT-ACCT-UNIT
GLS-FISCAL-YEAR->GLT-FISCAL-YEAR
  GLT-ACCT-PERIOD
  GLT-SYSTEM
  GLT-CONTROL-GROUP
  GLT-JE-TYPE
  GLT-JE-SEQUENCE
  GLT-LINE-NBR
  GLT-COMPANY
Transactions GLTRANS
GLM-COMPANY->GLT-TO-COMPANY
GLS-FISCAL-YEAR->GLT-FISCAL-YEAR
GLS-ACCT-PERIOD->GLT-ACCT-PERIOD
GLM-ACCT-UNIT->GLT-ACCT-UNIT
GLM-ACCOUNT->GLT-ACCOUNT
GLM-SUB-ACCOUNT->GLT-SUB-ACCOUNT
  GLT-POSTING-DATE
  GLT-SYSTEM
  GLT-CONTROL-GROUP
  GLT-JE-TYPE
  GLT-LINE-NBR
  GLT-COMPANY
  GLT-JE-SEQUENCE
Units GLUNITS Delete Restricted
GLM-COMPANY->GLU-COMPANY
GLM-ACCOUNT->GLU-ACCOUNT
GLM-SUB-ACCOUNT->GLU-SUB-ACCOUNT
GLM-VAR-LEVELS->GLU-VAR-LEVELS
GLM-ACCT-UNIT->GLU-ACCT-UNIT
  GLU-FISCAL-YEAR


File created: Thu Jun 09 11:18:39 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.