GLINTCO

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
AM135 AM154 AM19.1 AM19.2 AM20.5 AM30.1
AM30.2 AM35.1 AP00.4 AP00.5 AP00.7 AP01.1
AP05.3 AP10.5 AP101 AP115 AP125 AP126
AP131 AP151 AP156 AP180 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP20.8 AP21.1
AP220 AP23.1 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 AR12.1 AR12.2 AR301 AR501
AR550 BN00.1 BN00.2 BN100 BN101 BN102
BN103 BN104 BN105 BN145 BN15.1 BN150
BN20.1 BN245 BN305 BN31.1 BN31.2 BN32.1
BN32.2 BN32.3 BN45.1 BN531 BN65.1 BN71.1
BN72.1 BN729 BN80.1 BN81.1 BN81.2 BN991
BS13.1 BS14.1 BS15.1 BS32.1 CB10.3 CB10.5
CB15.1 CB15.2 CB150 CB185 CB20.1 CB20.6
CB30.1 CB43.1 CB44.1 CB45.1 CB46.1 CB50.1
CB500 CB54.1 CB543 CB544 CB55.1 CB554
EE11.1 EE20.2 EE20.3 EE520 CA10.1 CA10.2
CA10.4 CA10.6 CA10.7 CA190 FB145 FB190
FB40.1 FB40.2 FB40.3 FB45.1 GL146 GL165
GL190 GL197 GL199 GL240 GL40.1 GL40.2
GL40.3 GL40.6 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 PR521 EXI2.1 EXI4.1 IFGT.1 IFIC.1
LP03.1 LP03.2 LP03.3 LP03.4 LP03.5 LP03.6
LP100 LP101 LP102 LP103 LP130 LP131
LP140 LP180 LP197 LP198 LP31.1 LP80.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PA02.1
PA100 PA102 PA103 PA115 PA13.1 PA13.2
PA182 PA502 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PO136 PO190 PO300 PO520 POCP.1
POI3.1 POII.1 POIJ.1 HS36.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
PR13.9 PR130 PR131 PR132 PR134 PR135
PR136 PR137 PR14.1 PR14.2 PR15.1 PR15.2
PR189 PR195 PR20.4 PR205 PR23.1 PR23.3
PR26.1 PR26.2 PR29.1 PR30.1 PR32.1 PR32.2
PR33.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR35.9 PR36.1
PR37.1 PR39.1 PR39.2 PR45.1 PR47.1 PR47.2
PR514 PR529 PR530 PR539 PR560 PR582
PR80.1 PR80.3 PR80.4 PR82.1 UK102 UK47.1
UK47.2 UK560 RQ01.1 TA147 TA195 TA196
TA20.1 TA40.1 TA60.1 TX04.1 TX140


UPDATED BY
GL110 GL30.1 GL30.2 GL25.1 GL148 GL230
GL10.1 GL225

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GIC-RECORD-TYPE
Element: Record Type		Alpha 1
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
GL25.1 GL30.1
GIC-COMPANY-A
Element: Company		Numeric 4
Company 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
Element: Company		Numeric 4
The company number balances are transferred to.
GL25.1 GL30.1
GIC-ZONE-A
Element: Zone		Alpha 15
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.
GL25.1 GL30.1
GIC-ZONE-B
Element: Zone		Alpha 15
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.
GL25.1 GL30.1
GIC-SYSTEM
Element: System		Alpha 2
If 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
Element: Acct Unit		Alpha 15
This 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
Element: Account		Numeric 6
This 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
Element: Sub Acct		Numeric 4
This field represents the Receivable subaccount amounts are transferred from. Must be defined in the GLMASTER file.
GL25.1 GL30.1
GIC-AP-ACCTUNIT-A
Element: Acct Unit		Alpha 15
This 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
Element: Account		Numeric 6
This 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
Element: Sub Acct		Numeric 4
This field represents the Payables subaccount amounts are transferred from. Must be defined in the GLMASTER file.
GL25.1 GL30.1
GIC-AR-ACCTUNIT-B
Element: Acct Unit		Alpha 15
This 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
Element: Account		Numeric 6
This 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
Element: Sub Acct		Numeric 4
This field represents the Receivables subaccount amounts are transferred to. Must be defined in the GLMASTER file.
GL25.1 GL30.1
GIC-AP-ACCTUNIT-B
Element: Acct Unit		Alpha 15
This 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
Element: Account		Numeric 6
This 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
Element: Sub Acct		Numeric 4
This field represents the Payables subaccount amounts are transferred to. Must be defined in the GLMASTER file.
GL25.1 GL30.1


GLINTCO FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GICSET1 RECORD-TYPE
COMPANY-A
COMPANY-B
ZONE-A
ZONE-B
SYSTEM
...
AM135 AM154
AM19.1 AM19.2
AM20.5 AM30.1
AM30.2 AM35.1
AP00.4 AP00.5
AP00.7 AP01.1
AP05.3 AP10.5
AP101 AP115
AP125 AP126
AP131 AP151
AP156 AP180
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP20.8 AP21.1


GLINTCO FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Wed Jun 08 20:49:44 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.