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
AC131 AC145 AC160 AC190 AC197 AC30.1
AC30.2 AC30.3 AC40.4 AC41.1 AC41.4 AC45.1
AC540 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
AP510 AP520 AP56.1 AP56.2 AP80.1 API1.1
API2.1 AR01.1 AR09.1 AR10.1 AR12.1 AR12.2
AR301 AR501 AR550 ARLL.1 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 BN80.1 BN81.1
BN81.2 BS10.1 BS12.1 BS13.1 BS14.1 BS15.1
BS32.1 ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2
ZB32.3 BR124 BR130 BR131 BR140 BR153
BR154 BR41.4 BR43.1 BR530 BRIP.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 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 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 GL148 GL165
GL190 GL197 GL199 GL230 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
HR11.4 HR28.1 HR506 HR511 LT101 LT111
PR521 ZH510 DR100 IC12.1 IC130 IC140
IC141 IC142 IC145 IC21.1 IC21.2 IC21.5
IC22.1 IC22.2 IC23.2 IC24.2 IC243 IC330
IC331 IC500 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC81.1 IC81.2 IC83.1 EX545 EXI2.1 EXI4.1
GL10.1 GL225 IFGT.1 IFIC.1 LP03.1 LP03.2
LP03.3 LP03.4 LP03.5 LP03.6 LP100 LP101
LP102 LP103 LP130 LP131 LP151 LP180
LP197 LP198 LP31.1 LP80.1 MA126 MA180
MA26.1 MA278 MA41.1 MA41.2 MA41.4 MA41.7
MA42.1 MA42.2 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MA44.1 MA44.2 MA53.1 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA63.1
MA65.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA69.1 MA70.1 MA75.1 MA80.1 MAI1.1
ML146 ML165 ML190 ML240 ML40.1 ML40.2
ML40.3 ML40.7 ML40.8 ML44.1 ML45.1 ML65.1
ML70.1 ML70.2 ML70.3 ML70.6 MLIT.1 PA02.1
PA100 PA102 PA103 PA115 PA13.1 PA13.2
PA182 PA502 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PD01.2 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD21.1 PD22.1 PD570 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO131 PO132 PO135 PO136
PO15.1 PO15.2 PO15.4 PO150 PO17.1 PO190
PO20.1 PO20.6 PO20.9 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO220 PO222 PO224 PO225 PO229 PO23.1
PO230 PO234 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO251 PO26.1 PO26.3 PO26.7 PO26.9
PO27.2 PO27.3 PO27.4 PO275 PO276 PO277
PO28.2 PO280 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 PO300 PO31.1 PO31.2 PO32.1 PO32.2
PO32.4 PO33.1 PO34.1 PO35.1 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 PO54.5 POCP.1 POI3.1 POID.1
POII.1 POIJ.1 HS01.1 HS36.1 PR01.2 PR04.1
PR05.1 PR05.6 PR05.7 PR110 PR113 PR12.6
PR120 PR128 PR13.1 PR13.2 PR13.5 PR13.6
PR13.8 PR13.9 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 PR30.2 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 PR36.4 PR37.1 PR39.1 PR39.2 PR45.1
PR47.1 PR47.2 PR512 PR514 PR529 PR530
PR539 PR560 PR582 PR80.1 PR80.3 PR80.4
PR82.1 UK102 RQ01.1 RQ04.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ11.3 RQ11.4
RQ11.5 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ44.1
RQ500 RQ810 RQIA.1 RQIB.1 RQIC.1 RQID.1
RQIF.1 RQIG.1 RQII.1 RQIJ.1 TA147 TA20.1
TA40.1 TA60.1 TX04.1 TX140 WH130 WH132
WH190 WH20.2 WH20.7 WH222 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 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


UPDATED BY
GL110 GL30.1 GL30.2 GL25.1

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.
GL110 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
...
AC131 AC145
AC160 AC190
AC197 AC30.1
AC30.2 AC30.3
AC40.4 AC41.1
AC41.4 AC45.1
AC540 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


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: Thu Jun 09 02:20:39 2016

Home
Contact Us



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