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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#GCG-COMPANY-GROUP PKCOMPANY_GROUP | Alpha 12 | The company group name. | GL11.2 |
#GCG-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This is the description. | GL11.2, RW100 |
#GCG-LST-SEQ-NBRLST_SEQ_NBR | Numeric 4 | The list member sequence number within the company group. | GL11.1 |
#GCG-SHORT-DESCSHORT_DESC | Derived | The short description. | — |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
GCGSET1 |
| 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
Programs
Updated by (3)
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