Lawson Insight Technical Documentation |
|
GLAMOUNTS
GLAMOUNTS FILE
General Ledger Amounts
The General Ledger Amounts-Period file contains beginning and period account
balances by accounting unit, account, and subaccount.
REFERENCED BY
AC191 AC40.4 AC41.4 AC42.1 AP125 AP126
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 API1.1
API2.1 BR41.4 CB10.1 CB191 CB20.1 CB30.1
CB500 EE135 EE35.1 EE35.2 EE520 CA290
FB120 FB145 FB190 FB20.1 FB20.3 FB20.4
FB20.6 FB20.7 FB40.1 FB40.2 FB40.3 FB45.1
GL141 GL147 GL165 GL170 GL281 GL290
GL291 GL320 GL65.1 GL75.1 GL90.1 GL90.4
IC222 GL198 GLOP.1 IFAC.1 MA41.2 MA41.7
MA43.2 MA61.1 MAI1.1 PO150 PO25.1 PO25.6
PO25.7 PO536 POIM.1 GL135 GL195 GL196
GLSV.1 RW80.1 GLRV.1 GL122 GL296 GL00.7
GL20.2 GL295
UPDATED BY
CA110 GL110 GL120 GL146 GL167 GL190
GL197 GL199 GL300 GL325 GL327 GL330
GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1
GL45.1 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GAM-COMPANY Numeric 4 CA110 GL110
Element: Company The company number represents an GL146 GL167
established company and is entered on GL190 GL197
all function codes. GL199 GL325
GL327 GL330
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GAM-FISCAL-YEAR Numeric 4 CA110 GL146
Element: Fiscal Year Select the fiscal year. If you leave GL167 GL190
this field blank, the current year GL197 GL199
defaults. GL325 GL327
GL330 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 GLSV.1
GAM-ACCT-UNIT Alpha 15 CA110 GL146
Element: Accounting UniThe accounting unit is a shorthand GL167 GL190
notation representing the variable level GL197 GL199
number. When used in the General Ledger GL325 GL327
Account Master file, the accounting unit GL330 GL40.1
must be defined in the General Ledger GL40.2 GL40.3
Names file as a posting accounting unit. GL40.7 GL40.8
GL44.1 GL45.1
GL500 GLSV.1
GAM-ACCOUNT Numeric 6 CA110 GL146
Element: Account This field along with the accounting GL167 GL190
unit and subaccount make up the location GL197 GL199
(account) where amounts and other GL325 GL327
account information is stored. GL330 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 GLSV.1
GAM-SUB-ACCOUNT Numeric 4 CA110 GL146
Element: Subaccount This field along with the accounting GL167 GL190
unit and account make up the location GL197 GL199
(account) where amounts and other GL325 GL327
account information is stored. GL330 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 GLSV.1
GAM-VAR-LEVELS Alpha 30 CA110 GL120
Element: Variable Levels GL146 GL167
GL190 GL197
GL199 GL325
GL327 GL330
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GAM-CHART-NAME Alpha 12 CA110 GL146
Element: Chart Name This is the name you assigned to the GL167 GL190
chart of accounts when you defined your GL197 GL199
company structure in the General Ledger GL325 GL327
system. GL330 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 GLSV.1
GAM-DB-BEG-BAL Currency 15.2 FB20.6 GL110
Debit Beginning GL167 GL199
Balance GL281 GL291
GL325 GL500
GLSV.1
GAM-CR-BEG-BAL Currency 15.2 FB20.6 GL110
Credit Beginning GL167 GL199
Balance GL281 GL291
GL325 GL500
GLSV.1
GAM-DB-AMOUNT Currency 15.2 Occurs 13 Times FB20.6 GL110
Element: Debit Amount The debit amount. GL146 GL167
GL190 GL197
GL281 GL291
GL325 GL330
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GAM-CR-AMOUNT Currency 15.2 Occurs 13 Times FB20.6 GL110
Element: Credit Amount The credit amount. GL146 GL167
GL190 GL197
GL281 GL291
GL325 GL330
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GAM-ACTIVITY-FLAG Alpha 1 Occurs 13 Times GL146 GL167
Element: Activity Flag This field indicates if transaction GL190 GL197
activity has occurred in a period. GL325 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
GAM-MAINT-DATE Numeric 8 (yyyymmdd) GL120 GL146
Element: Date GL167 GL190
GL197 GL199
GL330 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
GAM-MAINT-TIME Numeric 6 (hhmmss) GL120 GL146
Element: Sys Time GL167 GL190
GL197 GL199
GL330 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
GAM-CPAMT-DR Derived
Current Period Amt The current period debit amount.
Debit
GAM-CPAMT-CR Derived
Current Period Amt The current period credit amount.
Credit
GAM-CPAMT Derived
Current Period The total current period amount.
Amount
GAM-CYBAMT Derived
Element: Cybamt The current year beginning amount.
GAM-CUR-PD-SUM-DR Derived
Element: Cur Pd Sum Dr The current period summary debit
amount.
GAM-CUR-PD-SUM-CR Derived
Element: Cur Pd Sum Cr The current period summary credit
amount.
GAM-CUR-PD-SUM Derived
Element: Cur Pd Sum The current period summary amount.
GAM-CYDAMT Derived
Element: Cydamt The current year-to-date amount.
GAM-CYPAMT1-DR Derived
Period 1 Base Debit The current year period 1 debit amount.
Amount
GAM-CYPAMT1-CR Derived
Period 1 Base The current year period 1 credit
Credit Amount amount.
GAM-CYPAMT1 Derived
Element: Period 1 Base The current year period 1 amount.
GAM-CYPAMT2-DR Derived
Period 2 Base Debit The current year period 2 debit amount.
Amount
GAM-CYPAMT2-CR Derived
Period 2 Base The current year period 2 credit
Credit Amount amount.
GAM-CYPAMT2 Derived
Element: Period 2 Base The current year period 2 amount.
GAM-CYPAMT3-DR Derived
Period 3 Base Debit The current year period 3 debit amount.
Amount
GAM-CYPAMT3-CR Derived
Period 3 Base The current year period 3 credit
Credit Amount amount.
GAM-CYPAMT3 Derived
Element: Period 3 Base The current year period 3 amount.
GAM-CYPAMT4-DR Derived
Period 4 Base Debit The current year period 4 debit amount.
Amount
GAM-CYPAMT4-CR Derived
Period 4 Base The current year period 4 credit
Credit Amount amount.
GAM-CYPAMT4 Derived
Element: Period 4 Base The current year period 4 amount.
GAM-CYPAMT5-DR Derived
Period 5 Base Debit The current year period 5 debit amount.
Amount
GAM-CYPAMT5-CR Derived
Peirod 5 Base The current year period 5 credit
Credit Amount amount.
GAM-CYPAMT5 Derived
Element: Peirod 5 Base The current year period 5 amount.
GAM-CYPAMT6-DR Derived
Period 6 Base Debit The current year period 6 debit amount.
Amount
GAM-CYPAMT6-CR Derived
Period 6 Base The current year period 6 credit
Credit Amount amount.
GAM-CYPAMT6 Derived
Element: Period 6 Base The current year period 6 amount.
GAM-CYPAMT7-DR Derived
Period 7 Base Debit The current year period 7 debit amount.
Amount
GAM-CYPAMT7-CR Derived
Period 7 Base The current year period 7 credit
Credit Amount amount.
GAM-CYPAMT7 Derived
Element: Period 7 Base The current year period 7 amount.
GAM-CYPAMT8-DR Derived
Period 8 Base The current year period 8 debit amount.
Detail Amount
GAM-CYPAMT8-CR Derived
Period 8 Base The current year period 8 credit
Credit Amount amount.
GAM-CYPAMT8 Derived
Element: Period 8 Base The current year period 8 amount.
GAM-CYPAMT9-DR Derived
Period 9 Base Debit The current year period 9 debit amount.
Amount
GAM-CYPAMT9-CR Derived
Period 9 Base The current year period 9 credit
Credit Amount amount.
GAM-CYPAMT9 Derived
Element: Period 9 Base The current year period 9 amount.
GAM-CYPAMT10-DR Derived
Period 10 Base The current year period 10 debit
Debit Amount amount.
GAM-CYPAMT10-CR Derived
Period 10 Base The current year period 10 credit
Credit Amount amount.
GAM-CYPAMT10 Derived
Period 10 Baes The current year period 10 amount.
Amount
GAM-CYPAMT11-DR Derived
Period 11 Base The current year period 11 debit
Debit Amount amount.
GAM-CYPAMT11-CR Derived
Period 11 Base The current year period 11 credit
Credit Amount amount.
GAM-CYPAMT11 Derived
Period 11 Base The current year period 11 amount.
Amount
GAM-CYPAMT12-DR Derived
Period 12 Base The current year period 12 debit
Debit Amount amount.
GAM-CYPAMT12-CR Derived
Period 12 Base The current year period 12 credit
Credit Amount amount.
GAM-CYPAMT12 Derived
Period 12 Base The current year period 12 amount.
Amount
GAM-CYPAMT13-DR Derived
Period 13 Base The current year period 13 debit
Debit Amount amount.
GAM-CYPAMT13-CR Derived
Period 13 Base The current year period 13 credit
Credit Amount amount.
GAM-CYPAMT13 Derived
Period 13 Base The current year period 13 amount.
Amount
GAM-CPVAR-PCT Derived
Element: Cpvar Pct The percent variance between the
current period budget and current period
amount.
GAM-BLANK Derived
Element: Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
GAM-CPAMT-THOU Derived
Element: Cpamt Thou The current period amount divided by
1,000.
GAM-CYDAMT-THOU Derived
Element: Cydamt Thou The current year-to-date amount divided
by 1,000.
GAM-PARENT-OBJ-ID Numeric 12 GL146 GL167
Object This is the parent object identifier. GL190 GL197
Identification This unique key facilitates drill around GL199 GL325
to the parent record. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
GLAMOUNTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GAMSET1 COMPANY AC191 AC40.4
FISCAL-YEAR AC41.4 AC42.1
ACCT-UNIT AP125 AP126
ACCOUNT AP20.1 AP20.2
SUB-ACCOUNT AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR41.4
CB10.1 CB191
CB20.1 CB30.1
CB500 EE135
EE35.1 EE35.2
EE520 CA110
...
GAMSET2 FISCAL-YEAR KeyChange FB120 GL135
COMPANY GL195 GL196
VAR-LEVELS GL281 GL290
ACCOUNT GL291 GL325
SUB-ACCOUNT GLSV.1 RW80.1
ACCT-UNIT GLOP.1 GLRV.1
GAMSET3 COMPANY GL120 GL122
ACCT-UNIT GL296 GL500
ACCOUNT GL00.7 GL20.2
SUB-ACCOUNT
FISCAL-YEAR
GAMSET4 FISCAL-YEAR KeyChange GL199 GL281
COMPANY GL290 GL295
ACCOUNT GL320 GL325
SUB-ACCOUNT GLSV.1 GLRV.1
VAR-LEVELS
ACCT-UNIT
GAMSET5 FISCAL-YEAR KeyChange GLSV.1 GLRV.1
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
COMPANY
ACCT-UNIT
GAMSET6 FISCAL-YEAR KeyChange GLSV.1 GLRV.1
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
COMPANY
ACCT-UNIT
GAMSET7 COMPANY GL325 GL330
FISCAL-YEAR
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
GAMSET8 MAINT-DATE KeyChange GLOP.1
MAINT-TIME
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
GAMSET9 PARENT-OBJ-ID KeyChange
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
GLAMOUNTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Unit GLNAMES Required
GAM-COMPANY -> GLN-COMPANY (GLNSET1)
GAM-ACCT-UNIT -> GLN-ACCT-UNIT
Budget 1 FBDETAIL Not Required
GAM-COMPANY -> FBD-COMPANY
GAM-FISCAL-YEAR -> FBD-FISCAL-YEAR
1 -> FBD-BUDGET-NBR
GAM-ACCT-UNIT -> FBD-ACCT-UNIT
GAM-ACCOUNT -> FBD-ACCOUNT
GAM-SUB-ACCOUNT -> FBD-SUB-ACCOUNT
Chart Detail GLCHARTDTL Required
GAM-CHART-NAME -> GDT-CHART-NAME
GAM-ACCOUNT -> GDT-ACCOUNT
GAM-SUB-ACCOUNT -> GDT-SUB-ACCOUNT
Company GLSYSTEM Required
GAM-COMPANY -> GLS-COMPANY
Glmaster GLMASTER Required
GAM-COMPANY -> GLM-COMPANY
GAM-ACCT-UNIT -> GLM-ACCT-UNIT
GAM-ACCOUNT -> GLM-ACCOUNT
GAM-SUB-ACCOUNT -> GLM-SUB-ACCOUNT
GLAMOUNTS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cam Curr 1 CUAMOUNT
GAM-PARENT-OBJ-ID -> CAM-PARENT-OBJ-ID
3 -> CAM-AMT-TYPE
GAM-COMPANY -> CAM-COMPANY
GAM-ACCT-UNIT -> CAM-ACCT-UNIT
GAM-ACCOUNT -> CAM-ACCOUNT
GAM-SUB-ACCOUNT -> CAM-SUB-ACCOUNT
GAM-VAR-LEVELS -> CAM-VAR-LEVELS
GAM-FISCAL-YEAR -> CAM-FISCAL-YEAR
CAM-CURRENCY-CODE
Cam Curr 2 CUAMOUNT
GAM-PARENT-OBJ-ID -> CAM-PARENT-OBJ-ID
4 -> CAM-AMT-TYPE
GAM-COMPANY -> CAM-COMPANY
GAM-ACCT-UNIT -> CAM-ACCT-UNIT
GAM-ACCOUNT -> CAM-ACCOUNT
GAM-SUB-ACCOUNT -> CAM-SUB-ACCOUNT
GAM-VAR-LEVELS -> CAM-VAR-LEVELS
GAM-FISCAL-YEAR -> CAM-FISCAL-YEAR
CAM-CURRENCY-CODE
Company Trans GLTRANS
GAM-COMPANY -> GLT-TO-COMPANY
GAM-FISCAL-YEAR -> GLT-FISCAL-YEAR
GLS-DEFAULT-PERIOD -> GLT-ACCT-PERIOD
GAM-ACCOUNT -> GLT-ACCOUNT
GAM-SUB-ACCOUNT -> GLT-SUB-ACCOUNT
GLT-ACCT-UNIT
GLT-OBJ-ID
Consol Parent GLCONSOL
GAM-PARENT-OBJ-ID -> GCN-OBJ-ID
"A" -> GCN-TRANS-TYPE
GAM-COMPANY -> GCN-COMPANY
GCN-VAR-LEVELS
GCN-ACCOUNT
GCN-SUB-ACCOUNT
GCN-FISCAL-YEAR
GCN-LEVEL-DEPTH
GCN-CURRENCY-CODE
GCN-BUDGET-NBR
Trans One Prd GLTRANS
GAM-COMPANY -> GLT-TO-COMPANY
GAM-FISCAL-YEAR -> GLT-FISCAL-YEAR
GLS-DEFAULT-PERIOD -> GLT-ACCT-PERIOD
GAM-ACCT-UNIT -> GLT-ACCT-UNIT
GAM-ACCOUNT -> GLT-ACCOUNT
GAM-SUB-ACCOUNT -> GLT-SUB-ACCOUNT
GLT-POSTING-DATE
GLT-SYSTEM
GLT-CONTROL-GROUP
GLT-JE-TYPE
GLT-LINE-NBR
GLT-COMPANY
GLT-JE-SEQUENCE
Trans One Prds GLTRANS
GAM-COMPANY -> GLT-TO-COMPANY
GAM-ACCOUNT -> GLT-ACCOUNT
GAM-SUB-ACCOUNT -> GLT-SUB-ACCOUNT
GAM-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
|