|
|
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 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 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 AR100 AR12.1 AR12.2 AR130
AR21.3 AR29.2 AR30.1 AR30.2 AR301 AR32.1
AR33.1 AR33.5 AR34.1 AR39.1 AR39.2 AR42.2
AR42.6 AR501 AR502 AR504 AR550 AR560
AR575 AR80.1 AR80.2 ARLL.1 BL02.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL802 BL820 BL92.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 BS13.1 BS14.1 BS15.1
BS32.1 BR124 BR130 BR131 BR140 BR153
BR154 BR41.4 BR530 BRIP.1 CB10.3 CB15.1
CB15.2 CB185 CB20.1 CB30.1 CB43.1 CB44.1
CB45.1 CB46.1 CB50.1 CB500 CB54.1 CB543
CB544 CB55.1 CB554 EE20.2 EE20.3 EE520
ET530 ETI1.1 ETI2.1 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 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 HR506
HR511 IC130 GL10.1 GL225 IFGT.1 IFIC.1
LP03.1 LP03.2 LP03.3 LP03.4 LP03.5 LP03.6
LP100 LP101 LP130 LP180 LP197 LP198
LP31.1 LP80.1 MA180 MA310 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA66.3
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.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 PO100 PO101 PO122 PO131
PO135 PO136 PO190 PO20.1 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO23.1 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO26.1 PO27.2
PO29.1 PO30.1 PO30.2 PO30.3 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 POI3.1
POID.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
PR130 PR131 PR132 PR134 PR136 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.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
PR514 PR529 PR530 PR539 PR560 PR80.1
PR80.3 PR82.1 UK102 UK47.1 UK47.2 UK560
PW550 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500 RQIA.1
RQIB.1 RQIC.1 RQID.1 RQIF.1 RQIG.1 RQII.1
RQIJ.1 TA147 TA195 TA196 TA20.1 TA40.1
TA60.1 TX140 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
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 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: Acct Unit This 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: Sub Acct 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: Acct Unit This 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: Sub Acct 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: Acct Unit This 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: Sub Acct 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: Acct Unit This 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: Sub Acct 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 AC131 AC145
COMPANY-A AC160 AC190
COMPANY-B AC197 AC30.1
ZONE-A AC30.2 AC30.3
ZONE-B AC40.4 AC41.1
SYSTEM 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 AP115
AP125 AP126
...
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
|
