General Ledger Codes
GLCODES is a multi-purpose file. It holds information relating to systems, source codes, folders and process groups. System codes are defined in System Control. Each system code represents a subsystem that interfaces transactions to the Lawson General Ledger or uses Subsystem Control features. Subsystem Control features determine at what point the Lawson General Ledger is closed, and which dates are valid for entry in the subsystems. In addition, the status of the entry as it hits the General Ledger can be controlled for each system. Choices are released or unreleased. Source codes provide the Lawson General Ledger system with a method of identifying and classifying transactions. Any transaction either entering the General Ledger from a subsystem or created in GL must have a source code. Source codes (defined in Source Codes) help to group and total transactions on reports. Folders also provide a method for identifying and classifying. However, they classify the pieces used to create Lawson GL Report Writer reports. Folders are defined in RW01 (Folders). Process groups are created in RW02 (Process Groups). They group Lawson GL Report Writer reports that should be processed (run) at the same time.
REFERENCED BY
| AC195 | AM190 | AM192 | AP195 | CB195 | CA199 |
| GL04.1 | GL04.2 | GL110 | GL167 | GL179 | GL500 |
| RW01.1 | RW01.2 | RW02.1 | RW02.2 | IC199 | GL01.1 |
| GL01.2 | GL10.1 | IFSE.1 | LP900 | ML167 | PO135 |
| PO139 | PO199 | PR196 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GCD-RECORD-TYPE Element: Record Type | Alpha 1 This field is filled by the program creating a GLCODES record. This field specifies the record as a system code, source code, folder, or process group. C = System Code F = Folder P = Process Group R = Reconciliation Code |
|
||||||||||||||
| GCD-FOLDER-NAME Element: Folder | Alpha 12 Required for record type "F," this field is created in RW01. A folder is used to classify the pieces comprising a GL Report Writer report or ratio. |
|
||||||||||||||
| GCD-PROCESS-GROUP Element: Process Group | Alpha 15 Required for record type "P," this field is created in RW02. A process group is used to group GL Report Writer reports together for processing. |
|
||||||||||||||
| GCD-SYSTEM Element: System | Alpha 2 A two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AP = Accounts Payable, etc.) |
|
||||||||||||||
| GCD-SOURCE-CODE Element: Source Code | Alpha 2 Required field for record types of "C" or "S." This field can represent either a system code or a source code. System codes have a record type of "C." They identify all systems that interface to the Lawson General Ledger or use subledger control features. Source codes have a record type of "S." Source codes help to classify transactions in the Lawson General Ledger system. |
|
||||||||||||||
| GCD-COMPANY Element: Company | Numeric 4 The company number as defined in GL10.1 (Company). |
|
||||||||||||||
| GCD-DESCRIPTION Element: Description | Alpha 30 (Lower Case) The system code description. |
|
||||||||||||||
| GCD-SYSTEM-FLAG Element: System Flag | Alpha 1 Indicates if subledger control features are used for the system being defined. Y = Yes N = No |
|
||||||||||||||
| GCD-BEGIN-DATE Element: Begin Date | Numeric 8 (yyyymmdd) The beginning date in a range of dates. |
|
||||||||||||||
| GCD-END-DATE Element: Ending Date | Numeric 8 (yyyymmdd) The ending date in a range of dates. |
|
||||||||||||||
| GCD-PERIOD Element: Last Closed Period | Numeric 2 When the subsystem closing program is run for the indicated system, this field is updated along with the GCD-YEAR to indicate the last period closed. |
|
||||||||||||||
| GCD-YEAR Element: Last Closed Year | Numeric 4 When the subsystem closing program is run for the indicated system, this field is updated to indicate the last year closed along with the GCD-PERIOD. |
|
||||||||||||||
| GCD-OPEN-PERIODS Element: Open Periods | Numeric 2 It is used by the subsystem's closing program to increment the new ending date (GCD-END-DATE) in the valid entry date range. 00 12 |
|
||||||||||||||
| GCD-USER-CLASS Element: User Class | Alpha 12 Represents a group of users that have authority to use a system. |
|
||||||||||||||
| GCD-ACTIVITY-IGNOR Element: Activity Ignore | Alpha 1 Indicates if Activity system transactions are ignored. N = No Y = Yes |
|
||||||||||||||
| GCD-ZONE-IGNORE Element: Zone Ignore | Alpha 1 Indicates if Base Zone transactions are ignored. N = No Y = Yes |
|
||||||||||||||
| GCD-ACTIVITY Element: Activity | Alpha 15 Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. |
|
||||||||||||||
| GCD-HOLD-CODE Element: Hold Code | Alpha 4 This field contains the journal hold code. |
|
||||||||||||||
| GCD-JRNL-BOOK-NBR Element: Journal Book | Alpha 12 The journal book assigned to the transaction. |
|
||||||||||||||
| GCD-AUTH-FLAG Element: All Flag | Alpha 1 Indicates if additional authorization is required to run Report Writer reports by folder or process group. Y = Yes N = No |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GCDSET1 |
RECORD-TYPE FOLDER-NAME PROCESS-GROUP SYSTEM COMPANY |
|
|||||||||||||||||||||||||||||||||||||||||||
| GCDSET2 |
PROCESS-GROUP |
|
| ||||||||||||||||||||||||||||||||||||||||||
| GCDSET3 |
SOURCE-CODE |
|
|||||||||||||||||||||||||||||||||||||||||||
| GCDSET4 |
COMPANY SYSTEM |
|
| ||||||||||||||||||||||||||||||||||||||||||
| GCDSET5 |
USER-CLASS FOLDER-NAME |
|
| ||||||||||||||||||||||||||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Systemcode | SYSTEMCODE |
Not Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Amacctgrp | AMACCTGRP |
| |||||||||||||||||||||||||||
| Amasset | AMASSET |
| |||||||||||||||||||||||||||
| Amasttype | AMASTTYPE |
| |||||||||||||||||||||||||||
| Amcalendar | AMCALENDAR |
| |||||||||||||||||||||||||||
| Amtrans | AMTRANS |
| |||||||||||||||||||||||||||
| Computes | CMPUTE |
Delete Restricted
| |||||||||||||||||||||||||||
| Formats | RWFORMAT |
Delete Restricted
| |||||||||||||||||||||||||||
| Glcontrol H | GLCONTROL |
| |||||||||||||||||||||||||||
| Glsysje | GLSYSJE |
| |||||||||||||||||||||||||||
| Groups | RWHEADER |
Delete Restricted
| |||||||||||||||||||||||||||
| Pr Grp Request | RWREQUEST |
Delete Restricted
| |||||||||||||||||||||||||||
| Ratio Names | RADEFINE |
Delete Restricted
| |||||||||||||||||||||||||||
| Rationames | RADEFINE |
Delete Restricted
| |||||||||||||||||||||||||||
| Requests | RWREQUEST |
Delete Restricted
| |||||||||||||||||||||||||||
| Rows | RWHEADER |
Delete Restricted
| |||||||||||||||||||||||||||
| Rwuser | RWUSER |
| |||||||||||||||||||||||||||
| Total Names | RATOTALS |
Delete Restricted
| |||||||||||||||||||||||||||
| Total Ranges | RWHEADER |
Delete Restricted
| |||||||||||||||||||||||||||
| Totalnames | RATOTALS |
Delete Restricted
| |||||||||||||||||||||||||||
| Totalranges | RWHEADER |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.