|
|
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
AC170 AM135 AM30.1 AM30.2 AM35.1 AP00.4
AP00.7 AP01.1 AP05.3 AP10.5 AP125 AP126
AP151 AP156 AP180 AP20.1 AP20.2 AP20.5
AP20.7 AP20.8 AP225 AP226 AP23.1 AP25.1
AP25.2 AP26.1 AP28.1 AP28.2 AP30.2 AP32.2
AP520 AP56.1 AP56.2 AP80.1 AR01.1 AR10.1
AR100 AR12.1 AR12.2 AR130 AR21.3 AR29.2
AR30.1 AR30.2 AR30.3 AR30.4 AR31.5 AR42.2
AR42.6 AR501 AR502 AR504 AR550 AR560
AR80.1 AR80.2 BL02.1 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 CB10.3 CB15.1
CB15.2 CB20.1 CB30.1 EE20.2 EE20.3 EE520
CA10.1 CA10.2 CA10.7 CA10.8 CA190 GL146
GL165 GL190 GL230 GL240 GL40.1 GL40.2
GL40.3 GL40.8 GL40.9 GL44.1 GL45.1 GL65.1
GL70.1 GL70.2 GL70.3 GL70.7 HCGL.1 HR00.1
HR01.1 HR02.1 HR06.1 HR11.1 HR511 DR100
IC130 IC141 IC142 IC21.1 IC21.2 IC22.1
IC22.2 IC500 IC83.1 GL225 IFGT.1 IN20.1
MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5
MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1
MA520 MA530 MA540 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 OE113 OE114
OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4
OE15.5 OE15.7 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE810
OE830 OE920 OE950 PA02.1 PA100 PA102
PA13.1 PA13.2 PA502 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PBIP.1 PO100 PO135 PO180
PO20.1 PO21.1 PO21.2 PO21.3 PO21.5 PO21.6
PO22.1 PO22.2 PO22.3 PO25.1 PO25.2 PO25.4
PO26.1 PO28.6 PO30.1 PO31.1 PO32.1 PO33.1
PO34.1 PO35.1 PO530 PO821 PO990 PR01.2
PR05.1 PR128 PR13.1 PR13.2 PR131 PR132
PR134 PR136 PR137 PR14.1 PR140 PR15.1
PR15.2 PR150 PR195 PR199 PR20.4 PR205
PR23.1 PR23.3 PR26.1 PR26.2 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 PR36.1
PR37.1 PR39.1 PR39.2 PR45.1 PR514 PR530
PR80.1 PR82.1 PR85.1 UK102 UK330 RQ10.1
RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ20.1
RQ20.3 RQ20.4 RQ35.1 RQ500 RQ990 TA195
TA20.1 TA60.1 UK120 UK60.1 UK70.1 WH130
WH132 WH190 WH20.2 WH20.7 WH30.1 WH30.2
WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2
WH32.3 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 WO132
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
Record 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
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
Company The company number balances are
transferred to.
GIC-ZONE-A Alpha 15 GL25.1 GL30.1
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
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
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
AR Accounting 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
AR 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
AR 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
AP Accounting 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
AP 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
AP 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
AR Accouting 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
AR 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
AR 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
AP Accounting 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
AP 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
AP 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 AC170 AM135
COMPANY-A intercompany records. AM30.1 AM30.2
COMPANY-B AM35.1 AP00.4
ZONE-A AP00.7 AP01.1
ZONE-B AP05.3 AP10.5
SYSTEM AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.5
AP20.7 AP20.8
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP30.2 AP32.2
...
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
|