GLCONDRILL

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
GL Transaction
Object ID
Numeric 12
This is a unique internal GL transaction identification number that is used for Drill Around purposes.
GL195
GLD-ORIG-COMPANY
Element: Original Company
Numeric 4
This field contains the name of the source company that originated the transaction posted to the consolidation company.
GL195
GLD-COMPANY
Element: Company
Numeric 4
This field contains the name of the consolidation company.
GL195
GLD-ACCOUNT
Element: Account
Numeric 6
This field contains the account number containing the amounts being queried.
GL195
GLD-SUB-ACCOUNT
Element: Subaccount
Numeric 4
This field contains the sub-account containing the amounts being queried.
GL195
GLD-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
Tis field contains the fiscal year of the transaction being queried.
GL195 GL500


GLCONDRILL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLDSET1 GLT-OBJ-ID
GL195 GL500


GLCONDRILL FILE RELATIONS


ONE TO MANY RELATIONS

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


File created: Wed Jun 08 20:48:39 2016

Home
Contact Us



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