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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GICSET1RECORD-TYPE, COMPANY-A, COMPANY-B, ZONE-A, ZONE-B, SYSTEMPrimaryAC131, AC145, AC160, AC190, AC197, AC30.1, AC30.2, AC30.3 +22 more (list truncated in source)

Relations

One to one (13) — lookups and parents

RelationTableRulesConditionField map
Ap Account AGLMASTERRequiredGIC-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 BGLMASTERRequiredGIC-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 AGLMASTERRequiredGIC-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 BGLMASTERRequiredGIC-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 AGLSYSTEMRequiredGIC-COMPANY-A → GLS-COMPANY
Company BGLSYSTEMRequiredGIC-COMPANY-B → GLS-COMPANY
Gdt Ap Acct AGLCHARTDTLRequiredGLS-CHART-NAME → GDT-CHART-NAME, GIC-AP-ACCOUNT-A → GDT-ACCOUNT, GIC-AP-SUB-ACCT-A → GDT-SUB-ACCOUNT
Gdt Ap Acct BGLCHARTDTLRequiredGLS-CHART-NAME → GDT-CHART-NAME, GIC-AP-ACCOUNT-B → GDT-ACCOUNT, GIC-AP-SUB-ACCT-B → GDT-SUB-ACCOUNT
Gdt Ar Acct AGLCHARTDTLRequiredGLS-CHART-NAME → GDT-CHART-NAME, GIC-AR-ACCOUNT-A → GDT-ACCOUNT, GIC-AR-SUB-ACCT-A → GDT-SUB-ACCOUNT
Gdt Ar Acct BGLCHARTDTLRequiredGLS-CHART-NAME → GDT-CHART-NAME, GIC-AR-ACCOUNT-B → GDT-ACCOUNT, GIC-AR-SUB-ACCT-B → GDT-SUB-ACCOUNT
Gl LevelGLZONERequiredGIC-COMPANY-A → GLZ-COMPANY, GIC-ZONE-A → GLZ-ZONE
Level AGLNAMESRequiredGIC-COMPANY-A → GLN-COMPANY, GIC-ZONE-A → GLN-VAR-LEVELS, Spaces → GLN-ACCT-UNIT
Level BGLNAMESRequiredGIC-COMPANY-A → GLN-COMPANY, GIC-ZONE-B → GLN-VAR-LEVELS, Spaces → GLN-ACCT-UNIT

Programs

Updated by (4)

Referenced by (561)