Lawson Insight Technical Documentation |
|
GLMASTER
GLMASTER FILE
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 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC32.1 AC37.1 AC490 ACVW.1
ATVW.1 AM180 CA10.5 CA10.1 CA10.7 CA110
FB100 FB11.1 FB111 FB160 FB195 FB20.1
FB20.6 FB20.7 FB20.4 FB20.3 FB21.1 FB211
FB296 FB60.1 FB95.1 FB95.2 FB95.3 FB95.4
FB95.5 FB95.6 GL191 GL298 GL90.6 GL90.1
GL90.2 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 RW100 RW230 RW270 RW30.1
RW70.1 GL222 GLAV.1 GLCV.1 GLRV.1 GLVW.1
SLVW.1 SNOA.1 SNRA.1 SNSA.1 ET530 FB145
FB190 FB40.1 FB40.2 FB40.3 GL130 GL141
GL170 GL288 GL35.1 GL70.1 GL70.2 GL70.3
GL70.5 GL70.6 GL75.1 HGLM.1 IC02.1 GL10.1
GL14.8 GL221 GL38.1 MX135 PR195 PR197
PR82.1 PR85.1 SL40.4 SLSE.1 GL50.4 FB120
GL281 GL291 GL100 GL00.3 GL00.7 GL00.2
GL02.1 GL02.2 AC40.4 AC41.4 AC42.1 AP170
AP193 AP30.2 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
EE135 EE35.1 EE35.2 EE520 GL165 GL65.1
PO150 PO25.1 PO25.6 PO25.7 PO536 POIM.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
FB35.1 FB45.1 GL110 GL120 GL122 GL135
GL146 GL167 GL190 GL195 GL196 GL197
GL199 GL30.1 GL330 GL40.1 GL40.2 GL40.3
GL40.7 GL40.8 GL44.1 GL45.1 GL500 CU03.1
GL03.6 GL121 GL124 GL20.2 GL20.4 GL25.1
IFAC.1 MA41.1 MA41.2 MA41.4 MA41.7 MA43.2
MA61.1 MAI1.1 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 Numeric 4 AC191 AP125
Element: Company The company number. 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
FB45.1 GL110
GL121 GL124
GL135 GL167
GL190 GL195
GL196 GL199
GL20.2 GL20.4
GL330 GL45.1
GL500 IFAC.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MAI1.1 RQ10.1
RQ10.3 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQIJ.1
RW100
GLM-VAR-LEVELS Alpha 30 AC191 AP125
Element: Variable LevelRequired. The variable level number is AP126 AP20.1
tied directly to the accounting unit. It AP20.2 AP20.3
is used to indicate an accounting unit's AP20.4 AP20.5
position within the company hierarchy, AP20.7 AP21.1
establishing its consolidation AP23.1 AP25.1
relationship with other units. Must be AP25.2 AP26.1
defined in the GLNAMES file as a posting AP27.1 API1.1
level. API2.1 BR44.1
FB45.1 GL120
GL121 GL124
GL135 GL167
GL190 GL195
GL196 GL199
GL20.2 GL20.4
GL330 GL45.1
GL500 IFAC.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MAI1.1 RQ10.1
RQ10.3 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQIJ.1
GLM-ACCT-UNIT Alpha 15 AC191 AP125
Element: Accounting UniThe accounting unit is a shorthand AP126 AP20.1
notation representing the variable level AP20.2 AP20.3
number. AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
FB45.1 GL121
GL124 GL135
GL167 GL190
GL195 GL196
GL199 GL20.2
GL20.4 GL330
GL45.1 GL500
IFAC.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQIJ.1
GLM-OLD-COMPANY-D Derived
Element: Old Company Contains the old company derived.
GLM-ACCOUNT Numeric 6 AC191 AP125
Element: Account This field along with the accounting AP126 AP20.1
unit and subaccount make up the location AP20.2 AP20.3
(account) where amounts and other AP20.4 AP20.5
account information is stored. AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
FB45.1 GL121
GL124 GL135
GL167 GL190
GL195 GL196
GL199 GL20.2
GL20.4 GL330
GL45.1 GL500
IC02.1 IFAC.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MAI1.1 RQ10.1
RQ10.3 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQIJ.1
RW100
GLM-SUB-ACCOUNT Numeric 4 AC191 AP125
Element: Subaccount This field along with the accounting AP126 AP20.1
unit and account make up the location AP20.2 AP20.3
(account) where amounts and other AP20.4 AP20.5
account information are stored. AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
FB45.1 GL121
GL124 GL135
GL167 GL190
GL195 GL196
GL199 GL20.2
GL20.4 GL330
GL45.1 GL500
IC02.1 IFAC.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MAI1.1 RQ10.1
RQ10.3 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQIJ.1
GLM-OLD-ACCT-NBR-D Derived
Element: Old Account NuContains the derived old account
number.
GLM-ACTIVE-STATUS Alpha 1 GL121 GL122
Element: Active Status Required field if a detail-type GL124 GL167
account, otherwise this field should be GL20.2
blank. Indicates if a detail account is
either active or inactive. Inactive
accounts cannot be used for posting.
" " = Default
I = Inactive
GLM-STATUS-DERIVED Derived
Element: Status Contains the derived status.
GLM-ACCT-ND Numeric 1 AC191 AP125
Account Number of Account amount decimal positions. AP126 AP20.1
Decimals 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
FB45.1 GL110
GL121 GL124
GL135 GL167
GL190 GL195
GL196 GL199
GL20.2 GL20.4
GL330 GL45.1
GL500 IFAC.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MAI1.1 RQ10.1
RQ10.3 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQIJ.1
GLM-UNITS-CODE Alpha 1 GL121 GL122
Element: Units Code Required if a detail-type account. This GL124 GL146
field indicates if units are allowed, GL167 GL190
not allowed, or only allowed. GL197 GL20.2
GL40.1 GL40.2
" " = Default GL40.3 GL40.7
Y = Yes - Not Required GL40.8 GL44.1
N = No GL45.1
O = Only Units
R = Yes - Required
GLM-UNITS-DERIVED Derived
Element: Units Contains the derived units.
GLM-AVG-DAILY-BAL Alpha 1 GL121 GL122
Average Daily Yes value indicates the account is used GL20.2
Balance for calculating average daily balance.
" " = No
N = No
Y = Yes
I = Inactive
GLM-ACTIVITY-REQ Alpha 1 GL121 GL122
Element: Activity RequiIndicates if an Activity code is GL124 GL20.2
required.
Y = Yes
N = No
" " = Default
GLM-GLINTCO-STAT Numeric 3 CU03.1 FB35.1
Element: Intercompany SNot required. This field is used to GL110 GL121
count the number of intercompany or GL20.4 GL25.1
interzone relationships using this GL30.1
account number. Accounts cannot be
deleted if this field is greater than
zero.
GLM-POSTING-LEVEL Alpha 1 GL121 GL122
Element: Posting Level Required if a detail-type account. This GL124 GL20.2
field is used to determine whether
interface transactions should be
combined when creating GLTRANS records.
" " = Default
D = Detail
S = Summary
GLM-OPTION-FLD-1 Alpha 2 (Lower Case) GL121 GL122
Element: Free-form field used to store any GL124 GL167
information relevant to an account. This GL20.2 RW100
field is used for reporting purposes.
GLM-OPTION-FLD-2 Alpha 7 (Lower Case) GL121 GL122
Element: Free-form field used to store GL124 GL167
information relevant to an account. This GL20.2 RW100
field is used for reporting purposes.
GLM-OPTION-FLD-3 Alpha 12 (Lower Case) GL121 GL122
Element: Free-form field used to store any GL124 GL167
information relevant to an account. This GL20.2 RW100
field is used for reporting purposes.
GLM-TRANSL-CODE Alpha 2 FB145 FB190
Element: Contains the translation code. FB195 FB40.1
FB40.2 FB40.3
FB45.1 GL121
GL122 GL124
GL135 GL167
GL191 GL195
GL196 GL197
GL20.2
GLM-CURRENCY-CODE Alpha 5 AC191 AP125
Element: Currency Code The company base currency code. 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
FB45.1 GL110
GL121 GL122
GL124 GL135
GL167 GL190
GL195 GL196
GL199 GL20.2
GL20.4 GL330
GL45.1 GL500
IFAC.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQIJ.1
GLM-CURR-CONTROL Alpha 1 GL121 GL122
Element: Currency ContrFlag used to allow posting GL124 GL20.2
to the account in currencies other than
the account currency.
" " = Default
0 = No
1 = Yes
GLM-REVALUE Alpha 1 GL121 GL122
Element: Revalue Determines whether or not this account GL124 GL20.2
will participate in the revaluation
process.
" " = Default
0 = No
1 = Yes
GLM-DATE-ENTERED Numeric 8 (yyyymmdd) AC191 AP125
Element: Date Entered Date used to document account changes. 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
FB45.1 GL121
GL124 GL135
GL167 GL190
GL195 GL196
GL199 GL20.2
GL20.4 GL330
GL45.1 GL500
IFAC.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQIJ.1
GLM-CHART-NAME Alpha 12 AC191 AP125
Element: Chart Name This is the name assigned to the chart AP126 AP20.1
of accounts when you defined your AP20.2 AP20.3
company structure in the Lawson General AP20.4 AP20.5
Ledger system. AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
FB45.1 GL121
GL124 GL135
GL167 GL190
GL195 GL196
GL199 GL20.2
GL20.4 GL330
GL45.1 GL500
IC02.1 IFAC.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MAI1.1 RQ10.1
RQ10.3 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQIJ.1
GLM-BASE-CURRENCY Alpha 5 AC191 AP125
Element: Base Currency This field contains the company base AP126 AP20.1
currency code established in Company AP20.2 AP20.3
(GL10.1 ). AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
FB45.1 GL110
GL121 GL124
GL135 GL167
GL190 GL195
GL196 GL199
GL20.2 GL20.4
GL330 GL45.1
GL500 IFAC.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MAI1.1 RQ10.1
RQ10.3 RQ11.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQIJ.1
GLM-RESTRICT-SYS Alpha 1 GL03.6 GL121
Element: Restrict SysteIndicates if system codes are validated GL122 GL124
each time the account is used by a GL20.2
system.
Y = Yes
N = No
" " = Default
GLM-ACCT-CATEGORY Alpha 5 GL121 GL122
Element: Account CategoAccount categories are groupings of GL124 GL20.2
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
GLM-DER-X-SYS Derived
Element: Der X Sys Indicates if system restrictions exist
for an account.
GLM-SUMM-ACCT-ID Derived
Element: Summary AccounThe summary account ID.
GLM-ACCT-DESC Derived
Element: Account DescriThis is the account description.
GLM-BLANK Derived
Element: Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
GLM-CUCODE-DESC Derived
Element: Cucode Desc This is the currency code description.
GLM-SL-ACCT-FLAG Alpha 1 GL122 GL20.2
Element: Sl Acct Flag 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
GLM-RELATION Alpha 15 GL122 GL20.2
Element: Relation The user analysis value relation
assigned to the detail or summary
account.
The relation must exist in SL02.1 (User
Analysis Value Relation).
GLM-LEDGER-GROUP Alpha 15 GL122 GL20.2
Element: Ledger Group
GLM-GL-BUD-FL Alpha 1 GL122 GL20.2
Element: Gl Bud Fl This is the Yes/No flag for budget
editing.
N = No Edit
Y = Yes
" " = Default
GLMASTER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLMSET1 COMPANY AC121 AC123
ACCOUNT AC130 AC20.1
SUB-ACCOUNT AC20.2 AC20.3
VAR-LEVELS AC20.4 AC20.5
ACCT-UNIT AC32.1 AC37.1
AC490 ACVW.1
ATVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB195 FB20.1
FB20.6 FB20.7
FB21.1 FB211
FB296 FB60.1
FB95.1 FB95.2
...
GLMSET2 COMPANY AC191 AP125
ACCT-UNIT AP126 AP20.1
ACCOUNT AP20.2 AP20.3
SUB-ACCOUNT AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
ET530 CA10.1
CA10.7 CA110
FB11.1 FB111
FB145 FB160
FB190 FB195
FB20.4 FB211
...
GLMSET3 COMPANY FB20.3 GL120
ACCOUNT GL50.4 RW100
SUB-ACCOUNT GL121 GL20.4
ACCT-UNIT GL222
GLMSET5 COMPANY CA110 FB11.1
VAR-LEVELS FB111 FB120
ACCOUNT FB160 FB211
SUB-ACCOUNT FB296 FB60.1
ACCT-UNIT FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL281 GL291
GL298 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
...
GLMSET6 VAR-LEVELS GLRV.1
ACCOUNT
SUB-ACCOUNT
COMPANY
ACCT-UNIT
GLMSET7 ACCOUNT FB11.1 FB111
SUB-ACCOUNT FB160 FB211
VAR-LEVELS FB296 FB60.1
COMPANY FB95.1 FB95.2
ACCT-UNIT FB95.3 FB95.4
FB95.5 FB95.6
GL100 GL298
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
...
GLMSET8 CHART-NAME KeyChange AC191 AC40.4
ACCOUNT AC41.4 AC42.1
SUB-ACCOUNT AP125 AP126
COMPANY AP170 AP193
ACCT-UNIT 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 AP520
API1.1 API2.1
BR41.4 BR44.1
CB10.1 CB15.1
CB15.2 CB150
...
GLMSET9 LEDGER-GROUP KeyChange, Subset
COMPANY Where LEDGER-GROUP != Spaces
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
GLMASTER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accountunit GLNAMES Required
GLM-COMPANY -> GLN-COMPANY (GLNSET1)
GLM-ACCT-UNIT -> GLN-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
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 RELATED
NAME 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
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
|