GLCONDRILL FILE
GL Drill Around
The GL Consolidation Drill file provides drill around functionality from a
consolidation company balance amount back to the originating company source
transaction that created the amounts.
UPDATED BY
GL195 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLD-GLT-OBJ-ID Numeric 12 GL195
GL Transaction This is a unique internal GL transaction
Object ID identification number that is used for
Drill Around purposes.
GLD-ORIG-COMPANY Numeric 4 GL195
Element: Original CompaThis field contains the name of the
source company that originated the
transaction posted to the consolidation
company.
GLD-COMPANY Numeric 4 GL195
Element: Company This field contains the name of the
consolidation company.
GLD-ACCOUNT Numeric 6 GL195
Element: Account This field contains the account number
containing the amounts being queried.
GLD-SUB-ACCOUNT Numeric 4 GL195
Element: Subaccount This field contains the sub-account
containing the amounts being queried.
GLD-FISCAL-YEAR Numeric 4 GL195 GL500
Element: Fiscal Year Tis field contains the fiscal year of
the transaction being queried.
GLCONDRILL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLDSET1 GLT-OBJ-ID Provides access to the GLTRANS and GL195 GL500
GLAMOUNTS records of the originating
company.
GLCONDRILL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glamacct GLAMOUNTS
GLD-ORIG-COMPANY -> GAM-COMPANY
GLD-FISCAL-YEAR -> GAM-FISCAL-YEAR
GAM-ACCOUNT
GAM-SUB-ACCOUNT
GAM-ACCT-UNIT
Glamounts GLAMOUNTS
GLD-FISCAL-YEAR -> GAM-FISCAL-YEAR
GLD-ORIG-COMPANY -> GAM-COMPANY
GLD-ACCOUNT -> GAM-ACCOUNT
GLD-SUB-ACCOUNT -> GAM-SUB-ACCOUNT
GAM-VAR-LEVELS
GAM-ACCT-UNIT
|
