GLSRCCODE – General Ledger Source Code

System: General Ledger Setup (IF)
Prefix: GSR
Primary key: SOURCE-CODE
Fields: 15
Updated by: 7 programs
Referenced by: 82 programs

GLSRCCODE is the General Ledger Source Code table in Lawson General Ledger Setup (prefix GSR). It is indexed by SOURCE-CODE (GSRSET1). It is related 1:1 to MXCATDEF and GLSCCAT and 1:M to GLSCCAT. It is updated by GL05.1, GL05.2, GL05.3, GL105, GL106, GL167 and ML167 and referenced by AC145, AC169, AC190, AC197, AC198, AC256, AC45.1, AC54.1 and 74 more. The table has 15 fields, 1 index and 7 documented relations.

About GLSRCCODE

This file contains the Lawson and user-defined source codes defined in GL05.1 (Source Code) and GL105 (System, Source Code Load).

Fields (15)

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

Field / column	Type	Description & values	Updated by
`GSR-SOURCE-CODE` PK SOURCE_CODE	Alpha 2	A two-character code assigned to a transaction to identify where the transaction was created.	GL05.1, GL05.2, GL105, GL167, ML167
`GSR-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	The source code description.	GL05.1, GL05.2, GL105, GL167, ML167
`GSR-SOURCE-TYPE` SOURCE_TYPE	Alpha 1	Indicates if the source code is Lawson or user-defined. `L` Lawson `U` User	GL05.1, GL05.2, GL105, GL167, ML167
`GSR-EDIT-TYPE` EDIT_TYPE	Alpha 1	Indicates the type of transaction to be edited. `S` Subledger `G` General Ledger	GL105, GL167, ML167
`GSR-USED-FLAG` USED_FLAG	Alpha 1	Indicates if the record has been accessed by some source after creation.	GL05.1, GL05.2, GL105
`GSR-LAST-SEQ` LAST_SEQ	Numeric 3	The last sequence number.	GL105
`GSR-LAST-FIELD-NBR` LAST_FIELD_NBR	Numeric 3	The last field number.	GL05.3, GL105, GL106
`GSR-PRIMARY-SYSTEM` PRIMARY_SYSTEM	Alpha 2	The primary system associated with the source code.	GL105
`GSR-SOURCE-GROUP` SOURCE_GROUP	Alpha 5	The application group associated with the source code. For example, Financials.	GL105
`GSR-GLSCCAT-SEQ1` GLSCCAT_SEQ1	Derived	The attribute associated with a source code.	—
`GSR-GLSCCAT-SEQ2` GLSCCAT_SEQ2	Derived	The attribute associated with a source code.	—
`GSR-GLSCCAT-SEQ3` GLSCCAT_SEQ3	Derived	The attribute associated with a source code.	—
`GSR-CAT1-DESC` CAT1_DESC	Derived	The attribute category description.	—
`GSR-CAT2-DESC` CAT2_DESC	Derived	The attribute category description.	—
`GSR-CAT3-DESC` CAT3_DESC	Derived	The attribute category 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
`GSRSET1`	`SOURCE-CODE`	Primary		AC145, AC169, AC190, AC197, AC198, AC256, AC45.1, AC54.1 +22 more (list truncated in source)

Relations

One to one (6) — lookups and parents

Relation	Table	Rules	Field map
Cat1 Desc	MXCATDEF	Not Required	`GSC-MATRIX-CAT` → `MXC-MATRIX-CAT`
Cat2 Desc	MXCATDEF	Not Required	`GSC-MATRIX-CAT` → `MXC-MATRIX-CAT`
Cat3 Desc	MXCATDEF	Not Required	`GSC-MATRIX-CAT` → `MXC-MATRIX-CAT`
Glsccat Seq1	GLSCCAT	Not Required	`GSR-SOURCE-CODE` → `GSC-SOURCE-CODE`, `1` → `GSC-SEQ-NBR`
Glsccat Seq2	GLSCCAT	Not Required	`GSR-SOURCE-CODE` → `GSC-SOURCE-CODE`, `2` → `GSC-SEQ-NBR`
Glsccat Seq3	GLSCCAT	Not Required	`GSR-SOURCE-CODE` → `GSC-SOURCE-CODE`, `3` → `GSC-SEQ-NBR`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Src Category	GLSCCAT	Delete Cascades		`GSR-SOURCE-CODE` → `GSC-SOURCE-CODE`, → `GSC-SEQ-NBR`

Programs

Updated by (7)

GL05.1 Source Code
GL05.2 Source Codes
GL05.3 Attribute Origin
GL105 System, Source Code Load
GL106 Subledger Attribute Load
GL167 Balance Interface
ML167 Ledger Balance Interface

Referenced by (82)

AC145 Mass Transaction Backout
AC169 Mass Capitalization Hold
AC190 Activity Posting
AC197 Burden Recalculation Based on Total Cost
AC198 Burden Rate Recalculation
AC256 Transaction Writer Report
AC45.1 Transaction Edit
AC54.1 Transaction Interface Adjustment
AC540 Transaction Interface
AC69.2 Filter
AP20.1 Basic Invoice
AP20.2 Taxed Invoice
AP20.3 Detail Invoice
AP20.4 Invoice Line Detail
AP20.5 Multiple Invoice
AP20.7 Distributions
AP21.1 View Distributions
AP23.1 Transit Invoice Entry
AP30.2 Distribution Adjustments
BR190 Billing and Revenue Recalculation
BR40.1 Revenue Billing Adjustment
BR42.2 Filter
BR44.1 Mass Transaction Transfer
BR96.1 Transaction Analysis - Billable Amounts
CA10.2 Define Allocation
CA10.6 Allocation Copy
CB43.1 Receipts Load Maintenance
CB44.1 Returned Payment Maintenance
CB45.1 EFT/CC Extract Entry
CB46.1 Returned Payment Entry
CB50.1 Bank Transaction Interface Maintenance
CB500 Bank Transaction Interface
CB54.1 Payment Load Maintenance
CB543 Receipts Load
CB544 Returned Payment Load
CB55.1 Payment Entry
CB554 Payment Load
GL146 Batch Journal Control
GL165 Transaction Interface
GL197 Period, Year End GL Commitments Processing
GL205 Source Code Listing
GL256 Transaction Writer Report
GL40.1 Journal Entry
GL40.2 Define Journal
GL40.3 Speed Entry
GL40.4 Additional Information
GL40.7 Totals
GL40.8 Journal Entry
GL44.1 Report Currency Entry
GL45.1 Journal Control
GL50.4 Filters
GL65.1 Transaction Interface Maintenance
GL70.1 Recurring Journal
GL70.2 Define Recurring Journal
GL70.3 Amounts Only
GL70.6 Recurring Copy
MA41.1 Add-On Cost Detail - Purchase Order
MA41.2 Add On Cost Lookup
MA41.4 Miscellaneous Add-On Cost
MA41.7 AOC Approval Entry
MA42.2 Memo Line AOC Detail
MA43.2 Purchase Order Lookup
MA44.1 Invoice Line Detail - Purchase Order
MA44.2 Invoice Line Detail- Service
ML146 Batch Ledger Journal Control
ML165 Ledger Transaction Interface
ML40.1 Ledger Journal Entry
ML40.2 Define Ledger Journal
ML40.3 Ledger Speed Entry
ML40.4 Ledger Additional Information
ML40.7 Ledger Totals
ML40.8 Ledger Journal Entry
ML44.1 Ledger Report Currency Entry
ML45.1 Ledger Journal Control
ML50.4 Filters
ML65.1 Ledger Transaction Interface Maintenance
ML70.1 Ledger Recurring Journal
ML70.2 Define Recurring Journal
ML70.3 Amounts Only
ML70.6 Ledger Recurring Copy
SL40.1 Error Transaction Edit
SL40.4 Filter