Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLINTCO


                              GLINTCO FILE

                      General Ledger Intercompany

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.


REFERENCED BY

AC131     AC145     AC160     AC197     AC30.1    AC30.2
AC30.3    AC40.4    AC41.4    AC45.1    AC540     AM135
AM154     AM30.1    AM30.2    AM35.1    AP00.4    AP00.5
AP00.7    AP01.1    AP05.3    AP10.5    AP115     AP125
AP126     AP131     AP151     AP156     AP180     AP220
AP25.1    AP25.2    AP26.1    AP27.1    AP28.1    AP28.2
AP30.2    AP30.4    AP305     AP520     AP56.1    AP56.2
AP80.1    API1.1    API2.1    AR01.1    AR09.1    AR10.1
AR100     AR12.1    AR12.2    AR130     AR21.3    AR29.2
AR30.1    AR30.2    AR301     AR31.5    AR33.1    AR33.5
AR34.1    AR42.2    AR42.6    AR501     AR502     AR504
AR550     AR560     AR80.1    AR80.2    ARLL.1    BL02.1
BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
BN00.1    BN00.2    BN100     BN101     BN102     BN103
BN104     BN105     BN145     BN15.1    BN150     BN20.1
BN245     BN31.1    BN31.2    BN32.1    BN32.2    BN32.3
BN45.1    BN531     BN65.1    BN71.1    BN72.1    BN80.1
BN81.1    BN81.2    BS13.1    BS14.1    BS15.1    BS32.1
BR130     BR131     BR140     BR41.4    BR530     BRIP.1
CB10.3    CB15.1    CB15.2    CB20.1    CB30.1    EE20.2
EE20.3    EE520     CA10.1    CA10.2    CA10.6    CA10.7
CA190     FB145     FB190     FB40.1    FB40.2    FB40.3
FB45.1    GL146     GL148     GL165     GL190     GL197
GL230     GL240     GL40.1    GL40.2    GL40.3    GL40.7
GL40.8    GL44.1    GL45.1    GL65.1    GL70.1    GL70.2
GL70.3    GL70.6    HR00.1    HR01.1    HR02.1    HR06.1
HR11.1    HR11.2    HR506     HR511     DR100     IC130
IC141     IC142     IC21.1    IC21.2    IC22.1    IC22.2
IC28.1    IC331     IC500     IC81.1    IC81.2    IC83.1
GL10.1    GL225     IFGT.1    MA126     MA180     MA530
MA531     MA60.2    MA60.3    MA60.5    MA61.1    MA63.1
MA65.1    MA66.2    MA66.3    MA67.1    MA67.2    MA68.1
MA70.1    MA75.1    MA80.1    MAI1.1    OE10.1    OE10.2
OE10.3    OE10.4    OE10.5    OE10.6    OE10.7    OE10.8
OE11.1    OE11.4    OE11.8    OE11.9    OE110     OE111
OE113     OE114     OE116     OE129     OE13.2    OE13.3
OE13.5    OE13.6    OE14.4    OE30.1    OE30.2    OE30.3
OE30.4    OE30.5    OE30.6    OE30.7    OE30.9    OE510
OE530     OE81.1    OE810     OE830     OE90.1    OE90.2
PA02.1    PA100     PA102     PA103     PA13.1    PA13.2
PA182     PA502     PA513     PA52.1    PA52.3    PA52.4
PA52.5    PBIP.1    PO100     PO101     PO122     PO131
PO135     PO136     PO20.1    PO21.1    PO21.2    PO21.3
PO21.4    PO21.5    PO22.1    PO23.1    PO25.5    PO26.1
PO27.2    PO29.1    PO30.1    PO30.2    PO30.3    PO300
PO31.1    PO31.2    PO32.1    PO32.2    PO33.1    PO34.1
PO35.1    PO38.1    PO39.1    PO39.2    PO44.1    PO50.1
PO52.1    PO520     POI3.1    POIE.1    POII.1    POIJ.1
PR01.2    PR04.1    PR05.1    PR05.6    PR05.7    PR110
PR113     PR120     PR128     PR13.1    PR13.2    PR13.5
PR13.6    PR13.8    PR130     PR131     PR132     PR134
PR136     PR14.1    PR15.1    PR15.2    PR197     PR20.4
PR205     PR23.1    PR23.3    PR26.1    PR26.2    PR29.1
PR30.1    PR32.2    PR33.2    PR33.3    PR35.1    PR35.2
PR35.3    PR35.4    PR35.5    PR35.6    PR35.8    PR35.9
PR36.1    PR39.1    PR39.2    PR45.1    PR47.1    PR47.2
PR529     PR530     PR560     PR82.1    UK102     UK47.1
UK47.2    RQ01.1    RQ10.1    RQ10.2    RQ10.3    RQ11.1
RQ12.1    RQ13.1    RQ13.2    RQ35.1    RQ500     RQIA.1
RQIB.1    RQID.1    RQIF.1    RQII.1    RQIJ.1    TA147
TA195     TA196     TA20.1    TA40.1    TA60.1    TP135
WH130     WH132     WH190     WH20.2    WH20.7    WH30.1
WH30.2    WH30.3    WH30.4    WH31.1    WH31.2    WH31.3
WH31.4    WH32.1    WH32.2    WH32.3    WH32.4    WH33.1
WH33.2    WH33.3    WH33.4    WH33.5    WH33.6    WH33.8
WH33.9    WH34.1    WH34.2    WH34.3    WH34.4    WH40.1
WH40.2    WH520     WH830     WO140

UPDATED BY

GL110     GL30.1    GL30.2    GL25.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GIC-RECORD-TYPE        Alpha 1                                   GL25.1  GL30.1
Element: Record Type   Required 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

GIC-COMPANY-A          Numeric 4                                 GL110   GL25.1
Element: Company       Company A represents the company whose    GL30.1
                       intercompany relationship is being
                       established and balances are transferred
                       from. Must be defined in the GLSYSTEM
                       file.


GIC-COMPANY-B          Numeric 4                                 GL25.1  GL30.1
Element: Company       The company number balances are
                       transferred to.


GIC-ZONE-A             Alpha 15                                  GL25.1  GL30.1
Element: Zone          This 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.


GIC-ZONE-B             Alpha 15                                  GL25.1  GL30.1
Element: Zone          This represents the zone of an
                       interzone relationship where balances
                       are transferred to. It must be defined
                       in the GLNAMES file as a top level.


GIC-SYSTEM             Alpha 2                                   GL25.1  GL30.1
Element: System Code   If separate relationships are to be set
                       up by system, then this field contains
                       the system code. Must be defined in the
                       GLCODES file.


GIC-AR-ACCTUNIT-A      Alpha 15                                  GL25.1  GL30.1
Element: Accounting UniThis field represents the Receivable
                       posting accounting unit amounts are
                       transferred from.
                       Must be  defined in the GLMASTER file.


GIC-AR-ACCOUNT-A       Numeric 6                                 GL25.1  GL30.1
Element: Account       This field represents the Receivable
                       account amounts are transferred from.
                       Must be defined in the GLMASTER file.


GIC-AR-SUB-ACCT-A      Numeric 4                                 GL25.1  GL30.1
Element: Subaccount    This field represents the Receivable
                       subaccount amounts are transferred from.

                       Must be defined in the GLMASTER file.


GIC-AP-ACCTUNIT-A      Alpha 15                                  GL25.1  GL30.1
Element: Accounting UniThis field represents the Payables
                       accounting unit amounts are transferred
                       from.
                       Must be defined in the GLNAMES file as a
                       posting unit.



GIC-AP-ACCOUNT-A       Numeric 6                                 GL25.1  GL30.1
Element: Account       This field represents the Payables
                       account amounts are transferred from.
                       Must be defined in the GLMASTER file.


GIC-AP-SUB-ACCT-A      Numeric 4                                 GL25.1  GL30.1
Element: Subaccount    This field represents the Payables
                       subaccount amounts are transferred from.

                       Must be defined in the GLMASTER file.


GIC-AR-ACCTUNIT-B      Alpha 15                                  GL25.1  GL30.1
Element: Accounting UniThis field represents the Receivables
                       accounting unit amounts are transferred
                       to.
                       Must be defined in the GLNAMES file.


GIC-AR-ACCOUNT-B       Numeric 6                                 GL25.1  GL30.1
Element: Account       This field represents the Receivables
                       account amounts are transferred to.
                       Must be defined in the GLMASTER file.


GIC-AR-SUB-ACCT-B      Numeric 4                                 GL25.1  GL30.1
Element: Subaccount    This field represents the Receivables
                       subaccount amounts are transferred to.
                       Must be defined in the GLMASTER file.


GIC-AP-ACCTUNIT-B      Alpha 15                                  GL25.1  GL30.1
Element: Accounting UniThis field represents the Payables
                       accounting unit amounts are transferred
                       to.
                       Must be defined in the GLNAMES file as a
                       posting unit.



GIC-AP-ACCOUNT-B       Numeric 6                                 GL25.1  GL30.1
Element: Account       This field represents the Payables
                       account amounts are transferred to.
                       Must be defined in the GLMASTER file.


GIC-AP-SUB-ACCT-B      Numeric 4                                 GL25.1  GL30.1
Element: Subaccount    This field represents the Payables
                       subaccount amounts are transferred to.
                       Must be defined in the GLMASTER file.


                         GLINTCO FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GICSET1   RECORD-TYPE   This path is used to retrieve            AC131   AC145
          COMPANY-A     intercompany records.                    AC160   AC197
          COMPANY-B                                              AC30.1  AC30.2
          ZONE-A                                                 AC30.3  AC40.4
          ZONE-B                                                 AC41.4  AC45.1
          SYSTEM                                                 AC540   AM135
                                                                 AM154   AM30.1
                                                                 AM30.2  AM35.1
                                                                 AP00.4  AP00.5
                                                                 AP00.7  AP01.1
                                                                 AP05.3  AP10.5
                                                                 AP115   AP125
                                                                 AP126   AP131
                                                                 AP151   AP156
                                                                 AP180   AP220
                                                                 ...

                         GLINTCO FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ap Account A   GLMASTER     Required

                            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 B   GLMASTER     Required

                            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 A   GLMASTER     Required

                            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 B   GLMASTER     Required

                            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 A      GLSYSTEM     Required

                            GIC-COMPANY-A        -> GLS-COMPANY

Company B      GLSYSTEM     Required

                            GIC-COMPANY-B        -> GLS-COMPANY

Gdt Ap Acct A  GLCHARTDTL   Required

                            GLS-CHART-NAME       -> GDT-CHART-NAME
                            GIC-AP-ACCOUNT-A     -> GDT-ACCOUNT
                            GIC-AP-SUB-ACCT-A    -> GDT-SUB-ACCOUNT

Gdt Ap Acct B  GLCHARTDTL   Required

                            GLS-CHART-NAME       -> GDT-CHART-NAME
                            GIC-AP-ACCOUNT-B     -> GDT-ACCOUNT
                            GIC-AP-SUB-ACCT-B    -> GDT-SUB-ACCOUNT

Gdt Ar Acct A  GLCHARTDTL   Required

                            GLS-CHART-NAME       -> GDT-CHART-NAME
                            GIC-AR-ACCOUNT-A     -> GDT-ACCOUNT
                            GIC-AR-SUB-ACCT-A    -> GDT-SUB-ACCOUNT

Gdt Ar Acct B  GLCHARTDTL   Required

                            GLS-CHART-NAME       -> GDT-CHART-NAME
                            GIC-AR-ACCOUNT-B     -> GDT-ACCOUNT
                            GIC-AR-SUB-ACCT-B    -> GDT-SUB-ACCOUNT

Gl Level       GLZONE       Required

                            GIC-COMPANY-A        -> GLZ-COMPANY
                            GIC-ZONE-A           -> GLZ-ZONE

Level A        GLNAMES      Required

                            GIC-COMPANY-A        -> GLN-COMPANY
                            GIC-ZONE-A           -> GLN-VAR-LEVELS
                            Spaces               -> GLN-ACCT-UNIT

Level B        GLNAMES      Required

                            GIC-COMPANY-A        -> GLN-COMPANY
                            GIC-ZONE-B           -> GLN-VAR-LEVELS
                            Spaces               -> GLN-ACCT-UNIT