General Ledger Company
This file contains company information used by the Lawson General Ledger system and subsystems defined in GL10.1 (Company).
REFERENCED BY
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GLS-COMPANY Element: Company | Numeric 4 The number that identifies a company. A company represents a business or legal entity of an organization. |
|
||||||||||||||||||||||||||||||
| GLS-NAME Element: Name | Alpha 30 (Lower Case) This is the company name or description. |
|
||||||||||||||||||||||||||||||
| GLS-BS-ACCT-UNIT Element: Base Accounting Unit | Alpha 15 The accounting unit name which is a unique location within the company. |
|
||||||||||||||||||||||||||||||
| GLS-NBR-ACCT-PERS Number of Accounting Periods | Numeric 2 The number of periods for a company fiscal year. Valid values are 1 - 13. 01 13 |
|
||||||||||||||||||||||||||||||
| GLS-ACCT-PERIOD Element: Accounting Period | Numeric 2 This is the current accounting period. This field is updated by GL199 (Period Closing). 01 13 |
|
||||||||||||||||||||||||||||||
| GLS-COND-DFT-PRD Element: Default Period | Derived This field determines the period for viewing when using the Drill Around Chart Name feature. |
|
||||||||||||||||||||||||||||||
| GLS-FISCAL-YEAR Element: Fiscal Year | Numeric 4 Contains the fiscal year for the data stored on this record. |
|
||||||||||||||||||||||||||||||
| GLS-LAST-FISC-YR Element: Last Fiscal Year | Derived The last fiscal year. |
|
||||||||||||||||||||||||||||||
| GLS-NEXT-FISC-YR Element: Next Fiscal Year | Derived The next fiscal year. |
|
||||||||||||||||||||||||||||||
| GLS-LST-YR-CLOSED Element: Last Year Closed | Numeric 4 This field is updated by GL199 with the last year when using limited closing. When the last year is closed final, this field is set back to zero. Changes to the retained earnings account number are prohibited if this field is not equal to zero. |
|
||||||||||||||||||||||||||||||
| GLS-PER-END-DATE Element: Period End Date | Numeric 8 (yyyymmdd) Occurs 39 Times Required for the number of account periods for each year (current, last, next). This period ending date is used to determine the period to which transactions are posted. Occurrence 1-13 = Current period ending dates. Occurrence 14-26 = Last year period ending dates. Occurrence 27-39 = Next year period ending dates. These dates are changed by GL199 (Period Closing) when closing period 12 of the current year. The current year dates become last year dates, next year dates become current year dates, and new next year dates are calculated. |
|
||||||||||||||||||||||||||||||
| GLS-PER-END-CODE Element: Period End Code | Alpha 1 Occurs 39 Times This field is used to indicate the closing status for each period. Occurrence 1-13 = Current year period ending code. Occurrence 14-26 = Last year period ending code. Occurrence 27-39 = Next year period ending code. These fields are updated by GL199 (Period Closing) and Backposting Control. If closing the period, the period end code is set to indicate a limited close or a final close. If closing for a year, the period end code will be set to indicate a limited or final close, and also current year is changed to last year, next year is changed to current year, and next year is set to spaces. B = Backpost F = Final L = Limited " " = Open |
|
||||||||||||||||||||||||||||||
| GLS-CONTROL-CODE Element: Control Group | Alpha 1 This field is used to indicate whether control totals are required for journal entries before releasing. If you select Yes in the Control Totals field on the Journals form tab in GL10.1, GL40.1 (Journal Entry) will use required control totals, which are set up using GL45 (Journal Control). N = No Y = Yes |
|
||||||||||||||||||||||||||||||
| GLS-INTLV-BAL-FLG Interlevel Balance Flag | Alpha 1 Indicates if interzone balancing is used. If interzone balancing is used, a base zone must be defined. N = No Y = Yes |
|
||||||||||||||||||||||||||||||
| GLS-CURRENCY-TABLE Element: Currency Table | Alpha 12 The currency table name. Currency tables are assigned to companies and define currency exchange and translation information. Currency tables are defined in CU00.1 (Currency Table). |
|
||||||||||||||||||||||||||||||
| GLS-CURR-CONV-FLG Element: Curr Exchange Flag | Alpha 1 Not required. Y = Yes N = No |
|
||||||||||||||||||||||||||||||
| GLS-CURR-TRAN-FLG Currency Translation Flag | Alpha 1 Used to control currency translation processing. Y = Yes N = No |
|
||||||||||||||||||||||||||||||
| GLS-CURRENCY-CODE Element: Currency Code | Alpha 5 This is the company base currency code as defined in Currency Code (CU01.1). |
|
||||||||||||||||||||||||||||||
| GLS-COMPANY-ND Element: Number of Decimals | Numeric 1 Decimal positions in the company currency code amount fields. |
|
||||||||||||||||||||||||||||||
| GLS-IS-ACCT-UNIT Element: Acct Unit | Alpha 15 The 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. |
|
||||||||||||||||||||||||||||||
| GLS-ACTIVE-STATUS Element: Active Status | Alpha 1 The active status field is used to display the development status of a company. D = Delete L = Live T = Test C = Consolidation E = Elimination |
|
||||||||||||||||||||||||||||||
| GLS-AVG-DAILY-BAL Average Daily Balance | Alpha 1 Not required. N = No Y = Yes " " = No |
|
||||||||||||||||||||||||||||||
| GLS-AUTO-JE-NBR Auto Journal Entry Number | Alpha 1 If you select Yes in the Auto Journal Numbering field on the Journals form tab in GL10, GL40 (Journal Entry) will assign journal entry numbers automatically using the Last JE Used Field. N = No Y = Yes |
|
||||||||||||||||||||||||||||||
| GLS-LEVEL-DESC Element: Level Description | Alpha 12 (Lower Case) Occurs 5 Times This is the level description. |
|
||||||||||||||||||||||||||||||
| GLS-NBR-DIGITS Element: Number Digits | Numeric 2 Occurs 5 Times This is the level size. 00 15 |
|
||||||||||||||||||||||||||||||
| GLS-LVL-ONE-DIGIT Element: Level One Digit | Derived Displays the array value. |
|
||||||||||||||||||||||||||||||
| GLS-GL190-RUN-DT Element: GL190 Run Date | Numeric 8 (yyyymmdd) This is the date that GL190 (Journal Posting) was run. Updated each time GL190 is run. |
|
||||||||||||||||||||||||||||||
| GLS-GL190-RUN-TM Element: GL190 Run Time | Numeric 6 (hhmmss) This is the last time that GL190 (Journal Posting) was run. Updated each time GL190 is run. |
|
||||||||||||||||||||||||||||||
| GLS-POSTED-TH-DT Element: Posted Through Date | Numeric 8 (yyyymmdd) This is the last posted- through date used by GL190 (Journal Posting). |
|
||||||||||||||||||||||||||||||
| GLS-PROJ-ACCT-FLG Element: Activity Flag | Alpha 1 This field is for the Activity system only. It reports the option chosen for the Edit Account Number field. Valid values are: Blank = No Activity system company exists. E = The Activity company exists. Edit Account Number is Yes. Edits are done validating the account for the project. Y = The Activity company exists. Edit Account Number is No. Transactions will post to Activities if the project is defined in the Activity system, but no edits for account validation are performed. N = No |
|
||||||||||||||||||||||||||||||
| GLS-BASE-ZONE Element: Base Zone | Alpha 15 This is the default base zone used to create interzone balancing transactions. |
|
||||||||||||||||||||||||||||||
| GLS-BACKPOST Element: Backpost | Alpha 1 Occurs 26 Times This field is used to indicate if backposting occurred for a period. Occurrence 1-13 = Current year periods. Occurrence 14-26 = Last year periods. * = Backposting has occurred |
|
||||||||||||||||||||||||||||||
| GLS-GL150-RUN-DTE Element: Run Date | Numeric 8 (yyyymmdd) Indicates the last time that Consolidation File Creation was run. |
|
||||||||||||||||||||||||||||||
| GLS-CHART-NAME Element: Chart Name | Alpha 12 This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system. |
|
||||||||||||||||||||||||||||||
| GLS-DEFAULT-PERIOD Element: Default Period | Numeric 2 This field determines the period for viewing when using the Drill Around Chart Name feature. 00 13 |
|
||||||||||||||||||||||||||||||
| GLS-JOURNAL-BY-DOC Element: Journal by Document | Alpha 1 Determines if each interfaced document (for example an invoice) is assigned a journal number. No is the default value. N = No Y = Yes |
|
||||||||||||||||||||||||||||||
| GLS-UPDATING Element: Updating | Numeric 2 This will be set with a value when an update program is running in GL. The value will determine the program that is running. No other updates may take place while this field is not blank. 00 = None 01 = GL170 Running 02 = GL146 Running 03 = CA190 Running 04 = GL190 Running 05 = GL199 Running 06 = GL110 Running 07 = GL120 Running 08 = GL191 Running 09 = AD190 Running 10 = AD191 Running 11 = GL45 Running 12 = GL40 Running 13 = GL75 Running 14 = AC Programs Running 15 = FB40 Running 16 = FB45 Running 17 = FB190 Running |
|
||||||||||||||||||||||||||||||
| GLS-CLOSE-SEQ Element: Close Sequence | Numeric 2 Occurs 39 Times The sequence number of the entry. |
|
||||||||||||||||||||||||||||||
| GLS-LEVEL-DEPTH Element: Level Depth | Numeric 1 The company can contain up to 5 levels of accounting units. 1 = One Level 2 = Two Levels 3 = Three Levels 4 = Four Levels 5 = Five Levels |
|
||||||||||||||||||||||||||||||
| GLS-JRNL-BOOK-REQ Journal Book Required | Alpha 1 This field determines whether a Journal Book value must be assigned to all General Ledger transactions. N = No Y = Yes |
|
||||||||||||||||||||||||||||||
| GLS-SEQ-TRNS-CD Element: Seq Trans Code | Alpha 1 Determines whether each General Ledger transaction created must be assigned a unique transaction sequence number by the system. J = by Journal Book C = by Company N = Not Required |
|
||||||||||||||||||||||||||||||
| GLS-RESET-SEQ-NBR Element: Reset Seq Number | Alpha 1 This field determines whether the Transaction Sequence Number is reset at year-end or continues. N = No Y = Yes |
|
||||||||||||||||||||||||||||||
| GLS-CHG-POST-TRAN Element: Change Post Tran | Alpha 1 This field determines whether posted journal entries can be backed out, or unposted, in GL45.1 (Journal Control) or GL146 (Journal Backout and Unrelease). N = No Y = Yes |
|
||||||||||||||||||||||||||||||
| GLS-CHG-REL-TRAN Element: Change Rel Tran | Alpha 1 This field determines whether released journal entries can be unreleased in GL45.1 (Journal Control) or GL146 (Journal Backout and Unrelease). N = No Y = Yes |
|
||||||||||||||||||||||||||||||
| GLS-ERROR-SP-JBOOK Error Suspense Journal Book | Alpha 12 This field represents the Journal Book value assigned to system-generated Error Suspense entries. |
|
||||||||||||||||||||||||||||||
| GLS-YEAR-END-JBOOK Year End Journal Book | Alpha 12 This field represents the Journal Book value assigned to transactions created by the system at year-end. |
|
||||||||||||||||||||||||||||||
| GLS-AUTO-JBK-SEQ Element: Auto Jbk Seq | Alpha 1 This field determines if internal or interfaced journal book entries should be numbered sequentially by the system as they are added. |
|
||||||||||||||||||||||||||||||
| GLS-JE-APPROVE-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||||||||||
| GLS-WORKFLOW-FLAG Element: Workflow Flag | Alpha 1 This field determines whether you are using a Workflow system for approving journal entries. |
|
||||||||||||||||||||||||||||||
| GLS-CURR-NAME-1 Element: Curr Name 1 | Alpha 12 Type or select a name that identifies the report currency. You must define exchange rates (CU10.1) and currency relationships (CU02.1) for the report currency with the company base currency. The report currencies are additional non-base currencies that identify a company operating currency. This report currency is for reports and analysis only. The report currencies are calculated in the same manner as base currency. Transaction amounts will always be converted to the Base Currency. If you also use a report currency, amounts will convert to both the Base and Report Currency. Note: The report currency cannot be the same as the company base currency. |
|
||||||||||||||||||||||||||||||
| GLS-CURR-CODE-1 Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||||||||||||||||||||||||||||
| GLS-CURR-CODE-ND-1 Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||||||||||||||||||||||
| GLS-CURR-NAME-2 Element: Curr Name 2 | Alpha 12 Type or select a name that identifies the report currency. You must define exchange rates (CU10.1) and currency relationships (CU02.1) for the report currency with the company base currency. The report currencies are additional non-base currencies that identify a company operating currency. This report currency is for reports and analysis only. The report currencies are calculated in the same manner as base currency. Transaction amounts will always be converted to the Base Currency. If you also use a report currency, amounts will convert to both the Base and Report Currency. Note: The report currency cannot be the same as the company base currency. |
|
||||||||||||||||||||||||||||||
| GLS-CURR-CODE-2 Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||||||||||||||||||||||||||||
| GLS-CURR-CODE-ND-2 Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||||||||||||||||||||||
| GLS-AUTO-BASE-BAL Element: Auto Base Bal | Alpha 1 Indicates whether the company requires journal autobalancing in company base currency. |
|
||||||||||||||||||||||||||||||
| GLS-CURR-RE-FLAG Element: Curr Re Flag | Alpha 1 This field is used to track journal entry amounts by the transaction currency in addition to the company base currency. |
|
||||||||||||||||||||||||||||||
| GLS-BUD-EDIT-RANGE Element: Bud Edit Range | Alpha 1 This field indicates the budget range against which GL commitments should be edited. The valid values are: N = No Edit P = Period Y = Year-To-Date A = Annual |
|
||||||||||||||||||||||||||||||
| GLS-BUD-EDIT-TYPE Element: Bud Edit Type | Alpha 1 This field indicates whether GL commitments are edited against summarized budget amounts or detail budget amounts. D = Detail S = Summary |
|
||||||||||||||||||||||||||||||
| GLS-FB-UPDATING Element: Fb Updating | Numeric 2 |
|
||||||||||||||||||||||||||||||
| GLS-ML-UPDATING Element: Ml Updating | Numeric 2 |
|
||||||||||||||||||||||||||||||
| GLS-BUD-TOLERANCE Element: Bud Tolerance | Signed 5.2 The budget edit tolerance percentage for GL commitments. |
|
||||||||||||||||||||||||||||||
| GLS-BUD-ACT Element: Flag Num | Numeric 1 |
|
||||||||||||||||||||||||||||||
| GLS-CREATED-BY Element: Operator | Alpha 10 |
|
||||||||||||||||||||||||||||||
| GLS-LAST-UPDT-DATE Element: Date | Numeric 8 (yyyymmdd) |
|||||||||||||||||||||||||||||||
| GLS-LAST-UPDT-TIME Element: Time | Numeric 8 |
|||||||||||||||||||||||||||||||
| GLS-LAST-UPDATE-BY Element: Operator | Alpha 10 |
|||||||||||||||||||||||||||||||
| GLS-Z4-RPT-FLAG Element: Flag | Alpha 1 |
|
||||||||||||||||||||||||||||||
| GLS-Z4-MIN-AMT Element: Intl Amt | Signed 18.2 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GLSSET1 |
COMPANY |
|
|||||||||||
| GLSSET2 |
CHART-NAME COMPANY |
|
| ||||||||||
| GLSSET3 |
CURRENCY-TABLE COMPANY |
|
| ||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Addrdata | ADDRDATA |
Not Required
| ||||||||||||
| All Co Addr | GLADDRESS |
Not Required, Delete Cascades
| ||||||||||||
| Bal Acct | GLCHARTDTL |
Required
| ||||||||||||
| Bs Acct Unit | GLNAMES |
Not Required
| ||||||||||||
| Chart Of Accts | GLCHART |
Required
| ||||||||||||
| Co Address | GLADDRESS |
Not Required, Delete Cascades
| ||||||||||||
| Comt Acct | GLCHARTDTL |
Not Required
| ||||||||||||
| Cucodes | CUCODES |
Required
| ||||||||||||
| Curr 1 | CUCODES |
Not Required
| ||||||||||||
| Curr 2 | CUCODES |
Not Required
| ||||||||||||
| Cutable | CUTABLE |
Required
| ||||||||||||
| Es Acct | GLCHARTDTL |
Not Required
| ||||||||||||
| Gain Acct | GLCHARTDTL |
Not Required
| ||||||||||||
| Glsysbod | GLSYSBOD |
Required
| ||||||||||||
| Glsysje Cp | GLSYSJE |
Not Required
| ||||||||||||
| Is Acct Unit | GLNAMES |
Not Required
| ||||||||||||
| Loss Acct | GLCHARTDTL |
Not Required
| ||||||||||||
| Re Acct | GLCHARTDTL |
Not Required
| ||||||||||||
| Rnd Acct | GLCHARTDTL |
Not Required
| ||||||||||||
| Ure Acct | GLCHARTDTL |
Not Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Acct Units | GLNAMES |
Delete Restricted
| |||||||||||||||||||||||||||
| Caheader | CAHEADER |
| |||||||||||||||||||||||||||
| Coledger | MLCOLEDGER |
| |||||||||||||||||||||||||||
| Company Audit | GLSYSTEMAU |
| |||||||||||||||||||||||||||
| Company Groups | GLCGCPY |
| |||||||||||||||||||||||||||
| Consol | GLCONSOL |
| |||||||||||||||||||||||||||
| Consol Y | GLCONSOL |
| |||||||||||||||||||||||||||
| Consol Z | GLCONSOL |
| |||||||||||||||||||||||||||
| Cuacct | CUACCT |
| |||||||||||||||||||||||||||
| Curelat | CURELAT |
| |||||||||||||||||||||||||||
| Fbheader | FBHEADER |
| |||||||||||||||||||||||||||
| Glclsaudit | GLCLSAUDIT |
| |||||||||||||||||||||||||||
| Glcodes Sys | GLCODES |
| |||||||||||||||||||||||||||
| Glcontrol | GLCONTROL |
| |||||||||||||||||||||||||||
| Glmaster | GLMASTER |
| |||||||||||||||||||||||||||
| Glsysje | GLSYSJE |
Delete Cascades
| |||||||||||||||||||||||||||
| Gltrans | GLTRANS |
| |||||||||||||||||||||||||||
| Glunits | GLUNITS |
| |||||||||||||||||||||||||||
| Intercompany | GLINTCO |
| |||||||||||||||||||||||||||
| Interzone | GLINTCO |
| |||||||||||||||||||||||||||
| Jbookhdr | JBOOKHDR |
Delete Cascades
| |||||||||||||||||||||||||||
| Mlcalmap | MLCALMAP |
| |||||||||||||||||||||||||||
| Mlcoledger | MLCOLEDGER |
|
All trademarks and registered trademarks are the property of their
respective owners.