GLAMOUNTS – General Ledger Amounts

System
General Ledger (GL)
Prefix
GAM
Primary key
COMPANY, FISCAL-YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT
Fields
78
Updated by
23 programs
Referenced by
357 programs

GLAMOUNTS is the General Ledger Amounts table in Lawson General Ledger (prefix GAM). It is indexed by COMPANY, FISCAL-YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT (GAMSET1); alternate indexes: GAMSET10, GAMSET2, GAMSET3, GAMSET4, GAMSET5, GAMSET6, GAMSET7 and GAMSET8. It is related 1:1 to GLNAMES, ADBALANCE, GLCHARTDTL, GLSYSTEM, GLAMTSBOD and GLMASTER and 1:M to CUAMOUNT, GLTRANS, GLCONSOL, GLCOMMIT and GLCOMMITX. It is updated by CA110, CA190, GL110, GL120, GL146, GL148, GL167, GL190 and 15 more and referenced by AC191, AC40.4, AC41.4, AC42.1, AD190, AD191, AD290, AD97.2 and 349 more. The table has 78 fields, 9 indexes and 16 documented relations.

About GLAMOUNTS

The General Ledger Amounts-Period file contains beginning and period account balances by accounting unit, account, and subaccount.

Fields (78)

Column = COBOL field name without the GAM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
GAM-COMPANY PK
COMPANY
Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.CA110, GL110, GL146, GL148, GL167, GL190, GL194, GL197 +13 more
GAM-FISCAL-YEAR PK
FISCAL_YEAR
Numeric 4Select the fiscal year. If you leave this field blank, the current year defaults.CA110, GL146, GL148, GL167, GL190, GL194, GL197, GL199 +12 more
GAM-ACCT-UNIT PK
ACCT_UNIT
Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.CA110, GL146, GL148, GL167, GL190, GL194, GL197, GL199 +12 more
GAM-ACCOUNT PK
ACCOUNT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.CA110, GL146, GL148, GL167, GL190, GL194, GL197, GL199 +12 more
GAM-SUB-ACCOUNT PK
SUB_ACCOUNT
Numeric 4This field along with the accounting unit and account make up the location (account) where amounts and other account information is stored.CA110, GL146, GL148, GL167, GL190, GL194, GL197, GL199 +12 more
GAM-VAR-LEVELS
VAR_LEVELS
Alpha 30A level that represents the location of an accounting unit in an organization's level structure.CA110, GL120, GL146, GL148, GL167, GL190, GL194, GL197 +13 more
GAM-CHART-NAME
CHART_NAME
Alpha 12This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system.CA110, GL146, GL148, GL167, GL190, GL194, GL197, GL199 +12 more
GAM-DB-BEG-BAL
DB_BEG_BAL
Signed 18.2FB20.6, GL110, GL167, GL194, GL199, GL281, GL291, GL325 +4 more
GAM-CR-BEG-BAL
CR_BEG_BAL
Signed 18.2FB20.6, GL110, GL167, GL194, GL199, GL281, GL291, GL325 +4 more
GAM-DB-AMOUNT
DB_AMOUNT
Signed 18.2 Occurs 13 Times ×13The debit amount.FB20.6, GL110, GL146, GL148, GL167, GL190, GL197, GL281 +13 more
GAM-CR-AMOUNT
CR_AMOUNT
Signed 18.2 Occurs 13 Times ×13The credit amount.FB20.6, GL110, GL146, GL148, GL167, GL190, GL197, GL281 +13 more
GAM-ACTIVITY-FLAG
ACTIVITY_FLAG
Alpha 1 Occurs 13 Times ×13This field indicates if transaction activity has occurred in a period.GL146, GL148, GL167, GL190, GL197, GL325, GL40.1, GL40.2 +6 more
GAM-MAINT-DATE
MAINT_DATE
Numeric 8 (yyyymmdd)The date last changed.GL120, GL146, GL148, GL167, GL190, GL194, GL197, GL199 +9 more
GAM-MAINT-TIME
MAINT_TIME
Numeric 6 (hhmmss)GL120, GL146, GL148, GL167, GL190, GL194, GL197, GL199 +9 more
GAM-CPAMT-DR
CPAMT_DR
DerivedThe current period debit amount.
GAM-CPAMT-CR
CPAMT_CR
DerivedThe current period credit amount.
GAM-CPAMT
CPAMT
DerivedThe total current period amount.
GAM-CYBAMT
CYBAMT
DerivedThe current year beginning amount.
GAM-CUR-PD-SUM-DR
CUR_PD_SUM_DR
DerivedThe current period summary debit amount.
GAM-CUR-PD-SUM-CR
CUR_PD_SUM_CR
DerivedThe current period summary credit amount.
GAM-CUR-PD-SUM
CUR_PD_SUM
DerivedThe current period summary amount.
GAM-CYDAMT
CYDAMT
DerivedThe current year-to-date amount.
GAM-CYPAMT1-DR
CYPAMT1_DR
DerivedThe current year period 1 debit amount.
GAM-CYPAMT1-CR
CYPAMT1_CR
DerivedThe current year period 1 credit amount.
GAM-CYPAMT1
CYPAMT1
DerivedThe current year period 1 amount.
GAM-CYPYTD1
CYPYTD1
DerivedCurrent year period year to date period 1.
GAM-CYPAMT2-DR
CYPAMT2_DR
DerivedThe current year period 2 debit amount.
GAM-CYPAMT2-CR
CYPAMT2_CR
DerivedThe current year period 2 credit amount.
GAM-CYPAMT2
CYPAMT2
DerivedThe current year period 2 amount.
GAM-CYPYTD2
CYPYTD2
DerivedCurrent year period year to date period 2.
GAM-CYPAMT3-DR
CYPAMT3_DR
DerivedThe current year period 3 debit amount.
GAM-CYPAMT3-CR
CYPAMT3_CR
DerivedThe current year period 3 credit amount.
GAM-CYPAMT3
CYPAMT3
DerivedThe current year period 3 amount.
GAM-CYPYTD3
CYPYTD3
DerivedCurrent year period year to date period 3.
GAM-CYPAMT4-DR
CYPAMT4_DR
DerivedThe current year period 4 debit amount.
GAM-CYPAMT4-CR
CYPAMT4_CR
DerivedThe current year period 4 credit amount.
GAM-CYPAMT4
CYPAMT4
DerivedThe current year period 4 amount.
GAM-CYPYTD4
CYPYTD4
DerivedCurrent year period year to date period 4.
GAM-CYPAMT5-DR
CYPAMT5_DR
DerivedThe current year period 5 debit amount.
GAM-CYPAMT5-CR
CYPAMT5_CR
DerivedThe current year period 5 credit amount.
GAM-CYPAMT5
CYPAMT5
DerivedThe current year period 5 amount.
GAM-CYPYTD5
CYPYTD5
DerivedCurrent year period year to date period 5.
GAM-CYPAMT6-DR
CYPAMT6_DR
DerivedThe current year period 6 debit amount.
GAM-CYPAMT6-CR
CYPAMT6_CR
DerivedThe current year period 6 credit amount.
GAM-CYPAMT6
CYPAMT6
DerivedThe current year period 6 amount.
GAM-CYPYTD6
CYPYTD6
DerivedCurrent year period year to date period 6.
GAM-CYPAMT7-DR
CYPAMT7_DR
DerivedThe current year period 7 debit amount.
GAM-CYPAMT7-CR
CYPAMT7_CR
DerivedThe current year period 7 credit amount.
GAM-CYPAMT7
CYPAMT7
DerivedThe current year period 7 amount.
GAM-CYPYTD7
CYPYTD7
DerivedCurrent year period year to date period 7.
GAM-CYPAMT8-DR
CYPAMT8_DR
DerivedThe current year period 8 debit amount.
GAM-CYPAMT8-CR
CYPAMT8_CR
DerivedThe current year period 8 credit amount.
GAM-CYPAMT8
CYPAMT8
DerivedThe current year period 8 amount.
GAM-CYPYTD8
CYPYTD8
DerivedCurrent year period year to date period 8.
GAM-CYPAMT9-DR
CYPAMT9_DR
DerivedThe current year period 9 debit amount.
GAM-CYPAMT9-CR
CYPAMT9_CR
DerivedThe current year period 9 credit amount.
GAM-CYPAMT9
CYPAMT9
DerivedThe current year period 9 amount.
GAM-CYPYTD9
CYPYTD9
DerivedCurrent year period year to date period 9.
GAM-CYPAMT10-DR
CYPAMT10_DR
DerivedThe current year period 10 debit amount.
GAM-CYPAMT10-CR
CYPAMT10_CR
DerivedThe current year period 10 credit amount.
GAM-CYPAMT10
CYPAMT10
DerivedThe current year period 10 amount.
GAM-CYPYTD10
CYPYTD10
DerivedCurrent year period year to date period 10.
GAM-CYPAMT11-DR
CYPAMT11_DR
DerivedThe current year period 11 debit amount.
GAM-CYPAMT11-CR
CYPAMT11_CR
DerivedThe current year period 11 credit amount.
GAM-CYPAMT11
CYPAMT11
DerivedThe current year period 11 amount.
GAM-CYPYTD11
CYPYTD11
DerivedCurrent year period year to date period 11.
GAM-CYPAMT12-DR
CYPAMT12_DR
DerivedThe current year period 12 debit amount.
GAM-CYPAMT12-CR
CYPAMT12_CR
DerivedThe current year period 12 credit amount.
GAM-CYPAMT12
CYPAMT12
DerivedThe current year period 12 amount.
GAM-CYPYTD12
CYPYTD12
DerivedCurrent year period year to date period 12.
GAM-CYPAMT13-DR
CYPAMT13_DR
DerivedThe current year period 13 debit amount.
GAM-CYPAMT13-CR
CYPAMT13_CR
DerivedThe current year period 13 credit amount.
GAM-CYPAMT13
CYPAMT13
DerivedThe current year period 13 amount.
GAM-CYPYTD13
CYPYTD13
DerivedCurrent year period year to date period 13.
GAM-BLANK
BLANK
DerivedThis derived field is always blank. It is used in the Drill Around feature for column headings.
GAM-CPAMT-THOU
CPAMT_THOU
DerivedThe current period amount divided by 1,000.
GAM-CYDAMT-THOU
CYDAMT_THOU
DerivedThe current year-to-date amount divided by 1,000.
GAM-PARENT-VAR-LEV
PARENT_VAR_LEV
Alpha 30The variable level address of the parent accounting unit.CA110, GL120, GL146, GL148, GL167, GL190, GL194, GL197 +12 more

Indexes (9)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GAMSET1COMPANY, FISCAL-YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNTPrimaryAC191, AC40.4, AC41.4, AC42.1, AD190, AD191, AD290, AD97.2 +22 more (list truncated in source)
GAMSET10PARENT-VAR-LEV, COMPANY, ACCOUNT, SUB-ACCOUNT, FISCAL-YEAR, ACCT-UNITKeyChange
GAMSET2FISCAL-YEAR, COMPANY, VAR-LEVELS, ACCOUNT, SUB-ACCOUNT, ACCT-UNITKeyChangeFB120, GL135, GL195, GL196, GL281, GL290, GL291, GL325 +6 more
GAMSET3COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, FISCAL-YEARFB11.1, FB111, FB160, FB211, GL120, GL122, GL148, GL296 +3 more
GAMSET4FISCAL-YEAR, COMPANY, ACCOUNT, SUB-ACCOUNT, VAR-LEVELS, ACCT-UNITKeyChangeGL199, GL281, GL290, GL295, GL320, GLSV.1, GLRV.1, ML290
GAMSET5FISCAL-YEAR, VAR-LEVELS, ACCOUNT, SUB-ACCOUNT, COMPANY, ACCT-UNITKeyChangeGLSV.1, GLRV.1
GAMSET6FISCAL-YEAR, ACCOUNT, SUB-ACCOUNT, VAR-LEVELS, COMPANY, ACCT-UNITKeyChangeGLSV.1, GLRV.1
GAMSET7COMPANY, FISCAL-YEAR, ACCOUNT, SUB-ACCOUNT, ACCT-UNITAD97.3, GL325, GL330
GAMSET8MAINT-DATE, MAINT-TIME, COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, FISCAL-YEARKeyChangeGLOP.1

Relations

One to one (7) — lookups and parents

RelationTableRulesConditionField map
Acct UnitGLNAMESRequiredGAM-COMPANYGLN-COMPANY, GAM-ACCT-UNITGLN-ACCT-UNIT
Adbalance BADBALANCERequiredGAM-COMPANYADE-COMPANY, GAM-FISCAL-YEARADE-FISCAL-YEAR, GAM-ACCT-UNITADE-ACCT-UNIT, GAM-ACCOUNTADE-ACCOUNT, GAM-SUB-ACCOUNTADE-SUB-ACCOUNT, "B"ADE-RECORD-TYPE
Adbalance CADBALANCERequiredGAM-COMPANYADE-COMPANY, GAM-FISCAL-YEARADE-FISCAL-YEAR, GAM-ACCT-UNITADE-ACCT-UNIT, GAM-ACCOUNTADE-ACCOUNT, GAM-SUB-ACCOUNTADE-SUB-ACCOUNT, "C"ADE-RECORD-TYPE
Chart DetailGLCHARTDTLRequiredGAM-CHART-NAMEGDT-CHART-NAME, GAM-ACCOUNTGDT-ACCOUNT, GAM-SUB-ACCOUNTGDT-SUB-ACCOUNT
CompanyGLSYSTEMRequiredGAM-COMPANYGLS-COMPANY
GlamtsbodGLAMTSBODNot Required, Delete CascadesGAM-COMPANYYBS-COMPANY, GAM-FISCAL-YEARYBS-FISCAL-YEAR, GAM-ACCT-UNITYBS-ACCT-UNIT, GAM-ACCOUNTYBS-ACCOUNT, GAM-SUB-ACCOUNTYBS-SUB-ACCOUNT
GlmasterGLMASTERRequiredGAM-COMPANYGLM-COMPANY, GAM-ACCT-UNITGLM-ACCT-UNIT, GAM-ACCOUNTGLM-ACCOUNT, GAM-SUB-ACCOUNTGLM-SUB-ACCOUNT

One to many (9) — child tables

RelationTableRulesConditionField map
Cam Curr 1CUAMOUNTGAM-PARENT-VAR-LEVCAM-PARENT-VAR-LEV, 3CAM-AMT-TYPE, GAM-COMPANYCAM-COMPANY, GAM-ACCOUNTCAM-ACCOUNT, GAM-SUB-ACCOUNTCAM-SUB-ACCOUNT, GAM-FISCAL-YEARCAM-FISCAL-YEAR, GAM-ACCT-UNITCAM-ACCT-UNIT, GAM-VAR-LEVELSCAM-VAR-LEVELS, CAM-CURRENCY-CODE
Cam Curr 2CUAMOUNTGAM-PARENT-VAR-LEVCAM-PARENT-VAR-LEV, 4CAM-AMT-TYPE, GAM-COMPANYCAM-COMPANY, GAM-ACCOUNTCAM-ACCOUNT, GAM-SUB-ACCOUNTCAM-SUB-ACCOUNT, GAM-FISCAL-YEARCAM-FISCAL-YEAR, GAM-ACCT-UNITCAM-ACCT-UNIT, GAM-VAR-LEVELSCAM-VAR-LEVELS, CAM-CURRENCY-CODE
Company TransGLTRANSGAM-COMPANYGLT-TO-COMPANY, GAM-FISCAL-YEARGLT-FISCAL-YEAR, GLS-DEFAULT-PERIODGLT-ACCT-PERIOD, GAM-ACCOUNTGLT-ACCOUNT, GAM-SUB-ACCOUNTGLT-SUB-ACCOUNT, GLT-ACCT-UNIT, GLT-OBJ-ID
Consol ParentGLCONSOLGAM-PARENT-VAR-LEVGCN-VAR-LEVELS, "A"GCN-TRANS-TYPE, GAM-COMPANYGCN-COMPANY, GAM-ACCOUNTGCN-ACCOUNT, GAM-SUB-ACCOUNTGCN-SUB-ACCOUNT, GAM-FISCAL-YEARGCN-FISCAL-YEAR, GCN-BUDGET-NBR, GCN-LEVEL-DEPTH, GCN-CURRENCY-CODE
GlcommitGLCOMMITGAM-COMPANYGOT-COMPANY, GAM-ACCT-UNITGOT-ACCT-UNIT, GAM-ACCOUNTGOT-ACCOUNT, GAM-SUB-ACCOUNTGOT-SUB-ACCOUNT, GAM-FISCAL-YEARGOT-FISCAL-YEAR, GOT-SYSTEM
GlcommitxGLCOMMITXGAM-COMPANYGOX-COMPANY, GAM-ACCT-UNITGOX-ACCT-UNIT, GAM-ACCOUNTGOX-ACCOUNT, GAM-SUB-ACCOUNTGOX-SUB-ACCOUNT, GAM-FISCAL-YEARGOX-FISCAL-YEAR, GOX-PERIOD, GOX-SYSTEM, GOX-CURRENCY-CODE, GOX-GLT-OBJ-ID
Trans Fis YearGLTRANSGAM-COMPANYGLT-TO-COMPANY, GAM-ACCOUNTGLT-ACCOUNT, GAM-SUB-ACCOUNTGLT-SUB-ACCOUNT, GAM-ACCT-UNITGLT-ACCT-UNIT, GAM-FISCAL-YEARGLT-FISCAL-YEAR, GLT-ACCT-PERIOD, GLT-SYSTEM, GLT-CONTROL-GROUP, GLT-JE-TYPE, GLT-JE-SEQUENCE, GLT-LINE-NBR, GLT-COMPANY
Trans One PrdGLTRANSGAM-COMPANYGLT-TO-COMPANY, GAM-FISCAL-YEARGLT-FISCAL-YEAR, GLS-DEFAULT-PERIODGLT-ACCT-PERIOD, GAM-ACCT-UNITGLT-ACCT-UNIT, GAM-ACCOUNTGLT-ACCOUNT, GAM-SUB-ACCOUNTGLT-SUB-ACCOUNT, GLT-POSTING-DATE, GLT-SYSTEM, GLT-CONTROL-GROUP, GLT-JE-TYPE, GLT-LINE-NBR, GLT-COMPANY, GLT-JE-SEQUENCE
Trans One PrdsGLTRANSGAM-COMPANYGLT-TO-COMPANY, GAM-ACCOUNTGLT-ACCOUNT, GAM-SUB-ACCOUNTGLT-SUB-ACCOUNT, GAM-ACCT-UNITGLT-ACCT-UNIT, GLS-FISCAL-YEARGLT-FISCAL-YEAR, GLT-ACCT-PERIOD, GLT-SYSTEM, GLT-CONTROL-GROUP, GLT-JE-TYPE, GLT-JE-SEQUENCE, GLT-LINE-NBR, GLT-COMPANY

Programs

Updated by (23)

Referenced by (357)