GLCPYGRP – General Ledger Company Group

System: General Ledger Setup (IF)
Prefix: GCG
Primary key: COMPANY-GROUP
Fields: 4
Updated by: 3 programs
Referenced by: 329 programs

GLCPYGRP is the General Ledger Company Group table in Lawson General Ledger Setup (prefix GCG). It is indexed by COMPANY-GROUP (GCGSET1). It is related 1:M to GLCGCPY and MXOBJCAT. It is updated by GL11.1, GL11.2 and GL110 and referenced by AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 and 321 more. The table has 4 fields, 1 index and 2 documented relations.

About GLCPYGRP

This file contains the valid company group definitions. Company groups are defined in GL11.1 (Company Group).

Fields (4)

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

Field / column	Type	Description & values	Updated by
`GCG-COMPANY-GROUP` PK COMPANY_GROUP	Alpha 12	The company group name.	GL11.2
`GCG-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This is the description.	GL11.2, RW100
`GCG-LST-SEQ-NBR` LST_SEQ_NBR	Numeric 4	The list member sequence number within the company group.	GL11.1
`GCG-SHORT-DESC` SHORT_DESC	Derived	The short description.	—

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`GCGSET1`	`COMPANY-GROUP`	Primary		AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)

Relations

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Glcgcpy	GLCGCPY	Delete Cascades		`GCG-COMPANY-GROUP` → `GCC-COMPANY-GROUP`, → `GCC-SEQ-NBR`, → `GCC-COMPANY`
Matrix Cat	MXOBJCAT			`"ACCTU"` → `MOC-OBJ-TYPE`, `GCG-COMPANY-GROUP` → `MOC-APPLY-TO-GROUP`, → `MOC-MATRIX-CAT`

Programs

Updated by (3)

GL11.1 Company Group
GL11.2 Define Company Group
GL110 Company Copy Delete

Referenced by (329)

AC121 Budget Calculation
AC123 Budget Copy
AC130 Allocation Calculation
AC20.1 Life Only Budget
AC20.2 Annual Budget
AC20.3 Period Budget
AC20.4 Activity Budgets by Activity
AC20.5 Activity Budgets by Account Category
AC32.1 Allocation Pool
AC34.1 Compute Parameters
AC35.1 Activity Total Names
AC36.1 Activity Total Range
AC37.1 Allocation Group
AC490 Activity Reconciliation
ACVW.1 Build GL Accounting Unit View
AD120 AD Mass Account Maintenance
AD190 Transaction Posting
AD210 Average Daily Company Listing
AD290 Average Daily Balance-Cost of Funds Report
AD300 Average Daily Balance History Delete
AD320 Variable Level Rebuild
AD325 ADAMOUNTSX File Rebuild
AD50.1 Average Daily Balance-Cost of Funds Report Setup
AD95.1 Account Analysis
AD96.1 Date
AD97.1 Accounts
AD97.2 Accounts
AD97.3 Compare
AD98.1 Accounting Units
AD98.2 Accounting Units Actuals
AD98.3 Accounting Units Compare
AM152 Inventory Update
AM206 Product Category Workbook
AM211 Asset Template Workbook
AM252 Inventory Comparison
AM520 Book Name Change
AP125 Batch Release
AP126 Mass Invoice Release
AP136 Invoice Accrual Reconciliation
AP175 Invoice Distribution Closing
AP176 Match Discount Accrual
AP178 Paid Invoice Activity Update
AP195 Period Closing
AP220 Invoice Edit Report
AP232 Invoice Accrual Reconciliation Report
AP240 Hold Payments Report
AP256 Foreign Payment Statistics Report
AP275 Invoice Distribution History
ATVW.1 Build Account Category View
CA00.1 Allocation Group
CA00.2 Allocation Groups
CA110 Allocation Calculation
CA190 Allocation Interface
CA195 Budget Allocation Interface
CA199 Allocation Closing
CA200 Allocation Group Listing
CA210 Allocation Edit Listing
CA215 Allocation Control Listing
CA240 Allocation Comparison
CA290 Allocation Ledger
CB145 EFT Extract Update
CB175 Bank Transaction Posting
CB180 Cash Ledger Void Update
CB195 Company Period Close
CU161 Interface Translation Rates
CU203 Company Currency Gain,Loss Accounts Listing
CU220 Translation Rate Listing
CU261 Translation Interface Listing
CU300 Currency Rate History Delete
FB100 Budget Calculation - Computes
FB101 Budget Calculation - Rates
FB11.1 Budget Edit Group
FB111 Budget Edit Group Build
FB122 Budget Version
FB145 Budget Batch Journal Control
FB160 Budget Edit Group Interface
FB190 Budget Double Entry Posting
FB210 Spread Code Listing
FB211 Budget Edit Group Listing
FB215 Budget Annual Amount Report
FB220 Budget Listing
FB225 Budget Control Report
FB230 Computed by Accounting Unit Listing
FB231 Computed by Account Listing
FB235 Interbudget Relationships
FB240 Budget Journal Edit Listing
FB296 Budget Audit
FB325 Budget Actuals Rebuild
FB60.1 Budget Edit Group Interface Maintenance
FB95.1 Budget Analysis
FB95.2 Account, Period
FB95.3 Account, Year to Date
FB95.4 Accounting Unit, Period
FB95.5 Accounting Unit, Year to Date
FB95.6 Totals
GL111 Backposting Control Mass Upd
GL120 Level Reorganization
GL121 Mass Account Addition
GL122 Mass Account Change Delete
GL125 Mass Accounting Unit Change
GL141 Consolidation Unload
GL145 Journal Entry Hold Release
GL146 Batch Journal Control
GL147 General Journal Report
GL148 Zone Rebalancing
GL161 Accounting Unit Interface
GL167 Balance Interface
GL170 Recurring Journal Interface
GL179 Recurring Journal Closing
GL190 Journal Posting
GL191 Currency Revaluation
GL192 Commitment History Update
GL196 Report Currency Translation
GL197 Period, Year End GL Commitments Processing
GL198 Non - GL Period Closing
GL199 Period Closing
GL210 Company Listing
GL211 Company Group Listing
GL220 Accounting Unit Listing
GL221 Posting Accounts Listing
GL222 Posting Accounts Listing by Account
GL225 Intercompany Relationship Listing
GL230 Interzone Relationship Listing
GL238 Split Distribution Report
GL240 Journal Edit Listing
GL241 Period Transaction Listing
GL243 Daily Transaction Listing
GL245 Journal Control Report
GL247 Centralization Book Report
GL250 Ledger Report Listing
GL256 Transaction Writer Report
GL261 Accounting Unit Interface Listing
GL267 Balance Interface Listing
GL270 Recurring Journal Edit Listing
GL275 Recurring Journal Control Report
GL276 Manual Commitment Entry Report
GL290 General Ledger Report
GL291 Trial Balance
GL292 Balance Sheet
GL293 Income Statement
GL294 Projection by Level
GL295 Projection by Account
GL296 Transaction Currency Report
GL297 Posting Sequence Number Report
GL298 GL Commitment Analysis Report
GL299 GL and AC History commitment
GL300 General Ledger History Delete
GL310 Report Currency Purge
GL320 Consolidation File Creation
GL322 GLHISCOMBL File Rebuild
GL325 GLAMOUNTS, GLUNITS File Rebuild
GL326 GLAMOUNTSX, GLUNITSX File Rebuild
GL327 Report Currency Rebuild
GL328 Daily Report Currency Rebuild
GL330 Undistributed Retained Earnings Rebuild
GL342 Journal Entry Log Mass Delete
GL55.1 Transaction Writer
GL90.6 Compare Transaction Analysis
GL94.1 Commitment Analysis
GL94.2 Account
GL94.3 Account Totals
GL94.4 Accounting Unit
GL94.5 Accounting Unit Totals
GL94.6 Commitment Account Detail
GL94.7 Commitment Accounting Unit Detail
GL95.1 Account Analysis
GL95.2 Fiscal Year Summary
GL95.3 Totals
GL95.4 Chart Query
GL95.5 Periods versus Year to Date
GL95.6 Year to Date Current Year versus Last Year
GL95.7 Periods Current Year versus Last Year
GL95.8 Year to Date Actual versus Budget
GL95.9 Periods Actual versus Budget
GL96.1 Accounting Units
GL96.2 Year to Date Current Year versus Last Year
GL96.3 Periods Current Year versus Last Year
GL96.4 Year to Date Actual versus Budget
GL96.5 Periods Actual versus Budget
GL97.1 Accounts
GL97.2 Year to Date Current Year versus Last Year
GL97.3 Periods Current Year versus Last Year
GL97.4 Year to Date Actual versus Budget
GL97.5 Periods Actual versus Budget
GL97.6 Year to Date Account Currencies
GL97.7 Periods Account Currencies
GL97.8 Fiscal Year Summary
GL97.9 Totals
GL98.1 Companies
GL98.2 Year to Date Current Year versus Last Year
GL98.3 Periods Current Year versus Last Year
GL98.4 Year to Date Actual versus Budget
GL98.5 Periods Actual versus Budget
GL99.1 Organization Query
GL99.2 Periods versus Year to Date
GL99.3 Year to Date Current Year versus Last Year
GL99.4 Periods Current Year versus Last Year
GL99.5 Year to Date Actual versus Budget
GL99.6 Periods Actual versus Budget
GLAV.1 Build GL Accounting Unit View
GLCV.1 General Ledger Chart View Build
GLVW.1 Build GL Accounting Unit View
IC130 General Ledger Interface
IC134 Inventory Turnover
IC135 Inventory Turnover by Issues
IC145 Stock Status Report
IC190 Closing
IC199 Subsystem Close
IC223 Availability Report
IC243 Killed Item Report
IC282 Requesting Location Usage
IC330 Item Mass Change
MA126 Auto Matching
MA168 Prepaid Invoice Not Received
MA180 Open Receipt Archive
MA200 Company Listing
MA208 Add on Charge/Allowance Listing
MA231 Unmatched Receipt Listing
MA236 Invoiced, Not Received Report
MA237 Match Update Report
MA264 Invoice Message Listing
MA278 Cost Variance Analysis
MA279 Invoice AOC Detail Report
ML111 Backposting Control Mass Upd
ML145 Ledger Journal Hold Release
ML146 Batch Ledger Journal Control
ML167 Ledger Balance Interface
ML170 Ledger Recurring Journal Interface
ML190 Ledger Journal Posting
ML191 Ledger Currency Revaluation
ML196 Ledger Report Currency Translation
ML199 Ledger Period Closing
ML240 Ledger Journal Edit Listing
ML241 Ledger Period Transaction List
ML245 Ledger Journal Control Report
ML250 Ledger Report Listing
ML267 Ledger Balance Interface List
ML270 Ledger Recurring Jrnl Edit Lis
ML275 Ledger Recurring Jrnl Cntrl Rp
ML290 Ledger Report
ML291 Ledger Trial Balance
ML292 Ledger Balance Sheet
ML293 Ledger Income Statement
ML300 Ledger History Delete
ML320 Ledger Consolidation File Creation
ML325 Ledger AMOUNTS, UNITS Rebuild
ML327 Ledger Report Currency Rebuild
ML330 Ledger Undistributed RE Rebuil
ML94.1 Ytd Ml and Gl Actuals
ML94.2 Period ML and GL Actuals
ML94.3 YTD ML and GL Actuals
ML94.4 Period ML and GL Actuals
ML95.1 Ledger Account Analysis
ML95.2 Fiscal Year Summary
ML95.3 Totals
ML95.4 Ledger Chart Query
ML95.5 Periods vs. YTD
ML95.6 YTD Current Year vs. Last Year
ML95.7 Periods Current Year vs. Last Year
ML95.8 YTD Actual vs. Budget
ML95.9 Periods Actual vs. Budget
ML96.1 Accounting Units
ML96.2 YTD Current Year vs. Last Year
ML96.3 Periods Current Year vs. Last Year
ML96.4 YTD Actual vs. Budget
ML96.5 Periods Actual vs. Budget
ML97.1 Accounts
ML97.2 YTD Current Year vs. Last Year
ML97.3 Periods Current Year vs. Last Year
ML97.4 YTD Actual vs. Budget
ML97.5 Periods Actual vs. Budget
ML97.6 YTD Account Currencies
ML97.7 Periods Account Currencies
ML97.8 Fiscal Year Summary
ML97.9 Totals
ML98.1 Companies
ML98.2 YTD Current Year vs. Last Year
ML98.3 Periods Current Year vs. Last Year
ML98.4 YTD Actual vs. Budget
ML98.5 Periods Actual vs. Budget
ML99.1 Organization Query
ML99.2 Periods vs. YTD
ML99.3 YTD Current Year vs. Last Year
ML99.4 Periods Current Year vs. Last Year
ML99.5 YTD Actual vs. Budget
ML99.6 Periods Actual vs. Budget
MM280 Departmental Procurement Expense Report
MX00.3 Associate Attribute to Objects
MX135 Acct Unit Attribute Value Update For Effective Date
PO135 Received, Not Invoiced Report
PO136 Matched, Not Received Report
PO190 Close Purchase Order Header
PO216 Bid Analysis
PO220 PO Status Report
PO222 Remaining PO Balance Report
PO231 Return Status Report
PO233 PO Received Quantity Exceptions
PO251 PO Buyer Message Listing
PO253 Item Receipt Volume Report
PO254 PO Inquiry Report
PO274 Returns Analysis
PO275 Delivery Date Analysis
PO276 Deliver Quantity Analysis
PO277 Deliver Quality Analysis
PO280 Purchases By Class
PO285 PO Activity By Source Report
PO54.2 Purchase Order Inquiry
PO54.3 Purchase Order Inquiry
RQ260 Requisitioned Items Report
RW00.1 Report Writer
RW10.2 Account Rows
RW10.3 Level Rows
RW10.4 Both Rows
RW10.6 Additional Information
RW10.7 Additional Information
RW100 Report Generation
RW20.5 Level Override
RW20.6 Account Override
RW298 Usage Report
RW60.1 Total Range
RW60.4 Level Range
RW70.1 Total Names
SLVW.1 Build SL Accounting Unit View
SN01.1 General Ledger Notification Parameters
SN80.2 Build Category List
SN80.3 Build Type List
SN85.1 Planned Headcount
SN85.2 Headcount Actuals
TX100 Tax Analysis Report