GLINTCO – General Ledger Intercompany

System
General Ledger Setup (IF)
Prefix
GIC
Primary key
RECORD-TYPE, COMPANY-A, COMPANY-B, ZONE-A, ZONE-B, SYSTEM
Fields
18
Updated by
4 programs
Referenced by
561 programs

GLINTCO is the General Ledger Intercompany table in Lawson General Ledger Setup (prefix GIC). It is indexed by RECORD-TYPE, COMPANY-A, COMPANY-B, ZONE-A, ZONE-B, SYSTEM (GICSET1). It is related 1:1 to GLMASTER, GLSYSTEM, GLCHARTDTL, GLZONE and GLNAMES. It is updated by GL110, GL25.1, GL30.1 and GL30.2 and referenced by AC131, AC145, AC160, AC190, AC197, AC30.1, AC30.2, AC30.3 and 553 more. The table has 18 fields, 1 index and 13 documented relations.

About GLINTCO

This file contains interzone and intercompany relationships. GL30.1 (Interzone Relationships) and GL25.1 (Intercompany Relationship) update this file. Interzone and intercompany relationships are offsetting AP and AR accounts set up between two entities. Relationships can be set up by system if separate accounts are desired.

Fields (18)

Column = COBOL field name without the GIC- 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 / columnTypeDescription & valuesUpdated by
#GIC-RECORD-TYPE PK
RECORD_TYPE		Alpha 1Required field. This field is filled with a value of "L" (level) by GL30 (Interzone Relationships) or with a value of "C" (company) by GL25 (Intercompany Relationships).
  • C Intercompany
  • L Interzone
GL25.1, GL30.1
#GIC-COMPANY-A PK
COMPANY_A		Numeric 4Company A represents the company whose intercompany relationship is being established and balances are transferred from. Must be defined in the GLSYSTEM file.GL110, GL25.1, GL30.1
#GIC-COMPANY-B PK
COMPANY_B		Numeric 4The company number balances are transferred to.GL110, GL25.1, GL30.1
#GIC-ZONE-A PK
ZONE_A		Alpha 15This field represents the originating zone for an interzone relationship where balances are transferred from. It must be defined in the GLNAMES file as a top level.GL25.1, GL30.1
#GIC-ZONE-B PK
ZONE_B		Alpha 15This represents the zone of an interzone relationship where balances are transferred to. It must be defined in the GLNAMES file as a top level.GL25.1, GL30.1
#GIC-SYSTEM PK
SYSTEM		Alpha 2If separate relationships are to be set up by system, then this field contains the system code. Must be defined in the GLCODES file.GL25.1, GL30.1
#GIC-AR-ACCTUNIT-A
AR_ACCTUNIT_A		Alpha 15This field represents the Receivable posting accounting unit amounts are transferred from. Must be defined in the GLMASTER file.GL25.1, GL30.1
#GIC-AR-ACCOUNT-A
AR_ACCOUNT_A		Numeric 6This field represents the Receivable account amounts are transferred from. Must be defined in the GLMASTER file.GL25.1, GL30.1
#GIC-AR-SUB-ACCT-A
AR_SUB_ACCT_A		Numeric 4This field represents the Receivable subaccount amounts are transferred from. Must be defined in the GLMASTER file.GL25.1, GL30.1
#GIC-AP-ACCTUNIT-A
AP_ACCTUNIT_A		Alpha 15This field represents the Payables accounting unit amounts are transferred from. Must be defined in the GLNAMES file as a posting unit.GL25.1, GL30.1
#GIC-AP-ACCOUNT-A
AP_ACCOUNT_A		Numeric 6This field represents the Payables account amounts are transferred from. Must be defined in the GLMASTER file.GL25.1, GL30.1
#GIC-AP-SUB-ACCT-A
AP_SUB_ACCT_A		Numeric 4This field represents the Payables subaccount amounts are transferred from. Must be defined in the GLMASTER file.GL25.1, GL30.1
#GIC-AR-ACCTUNIT-B
AR_ACCTUNIT_B		Alpha 15This field represents the Receivables accounting unit amounts are transferred to. Must be defined in the GLNAMES file.GL25.1, GL30.1
#GIC-AR-ACCOUNT-B
AR_ACCOUNT_B		Numeric 6This field represents the Receivables account amounts are transferred to. Must be defined in the GLMASTER file.GL25.1, GL30.1
#GIC-AR-SUB-ACCT-B
AR_SUB_ACCT_B		Numeric 4This field represents the Receivables subaccount amounts are transferred to. Must be defined in the GLMASTER file.GL25.1, GL30.1
#GIC-AP-ACCTUNIT-B
AP_ACCTUNIT_B		Alpha 15This field represents the Payables accounting unit amounts are transferred to. Must be defined in the GLNAMES file as a posting unit.GL25.1, GL30.1
#GIC-AP-ACCOUNT-B
AP_ACCOUNT_B		Numeric 6This field represents the Payables account amounts are transferred to. Must be defined in the GLMASTER file.GL25.1, GL30.1
#GIC-AP-SUB-ACCT-B
AP_SUB_ACCT_B		Numeric 4This field represents the Payables subaccount amounts are transferred to. Must be defined in the GLMASTER file.GL25.1, GL30.1

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.

IndexKeysFlagsConditionUsed in
GICSET1
  1. RECORD-TYPE
  2. COMPANY-A
  3. COMPANY-B
  4. ZONE-A
  5. ZONE-B
  6. SYSTEM
PrimaryAC131, AC145, AC160, AC190, AC197, AC30.1, AC30.2, AC30.3 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLMASTERGLSYSTEMGLCHARTDTLGLZONEGLNAMESGLINTCO

One to one (13) — lookups and parents

RelationTableRulesConditionField map
Ap Account AGLMASTERRequired
GIC-COMPANY-A→GLM-COMPANY
GIC-AP-ACCTUNIT-A→GLM-ACCT-UNIT
GIC-AP-ACCOUNT-A→GLM-ACCOUNT
GIC-AP-SUB-ACCT-A→GLM-SUB-ACCOUNT
Ap Account BGLMASTERRequired
GIC-COMPANY-B→GLM-COMPANY
GIC-AP-ACCTUNIT-B→GLM-ACCT-UNIT
GIC-AP-ACCOUNT-B→GLM-ACCOUNT
GIC-AP-SUB-ACCT-B→GLM-SUB-ACCOUNT
Ar Account AGLMASTERRequired
GIC-COMPANY-A→GLM-COMPANY
GIC-AR-ACCTUNIT-A→GLM-ACCT-UNIT
GIC-AR-ACCOUNT-A→GLM-ACCOUNT
GIC-AR-SUB-ACCT-A→GLM-SUB-ACCOUNT
Ar Account BGLMASTERRequired
GIC-COMPANY-B→GLM-COMPANY
GIC-AR-ACCTUNIT-B→GLM-ACCT-UNIT
GIC-AR-ACCOUNT-B→GLM-ACCOUNT
GIC-AR-SUB-ACCT-B→GLM-SUB-ACCOUNT
Company AGLSYSTEMRequired
GIC-COMPANY-A→GLS-COMPANY
Company BGLSYSTEMRequired
GIC-COMPANY-B→GLS-COMPANY
Gdt Ap Acct AGLCHARTDTLRequired
GLS-CHART-NAME→GDT-CHART-NAME
GIC-AP-ACCOUNT-A→GDT-ACCOUNT
GIC-AP-SUB-ACCT-A→GDT-SUB-ACCOUNT
Gdt Ap Acct BGLCHARTDTLRequired
GLS-CHART-NAME→GDT-CHART-NAME
GIC-AP-ACCOUNT-B→GDT-ACCOUNT
GIC-AP-SUB-ACCT-B→GDT-SUB-ACCOUNT
Gdt Ar Acct AGLCHARTDTLRequired
GLS-CHART-NAME→GDT-CHART-NAME
GIC-AR-ACCOUNT-A→GDT-ACCOUNT
GIC-AR-SUB-ACCT-A→GDT-SUB-ACCOUNT
Gdt Ar Acct BGLCHARTDTLRequired
GLS-CHART-NAME→GDT-CHART-NAME
GIC-AR-ACCOUNT-B→GDT-ACCOUNT
GIC-AR-SUB-ACCT-B→GDT-SUB-ACCOUNT
Gl LevelGLZONERequired
GIC-COMPANY-A→GLZ-COMPANY
GIC-ZONE-A→GLZ-ZONE
Level AGLNAMESRequired
GIC-COMPANY-A→GLN-COMPANY
GIC-ZONE-A→GLN-VAR-LEVELS
Spaces→GLN-ACCT-UNIT
Level BGLNAMESRequired
GIC-COMPANY-A→GLN-COMPANY
GIC-ZONE-B→GLN-VAR-LEVELS
Spaces→GLN-ACCT-UNIT

Programs

Updated by (4)

Referenced by (561)