GLHISTCOM

UPDATED BY
GL192 GLRV.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GHT-UNIQUE-I-D
Element: Unique I D
Bad Type 36
GHT-COMPANY
Element: Company
Numeric 4
GL192
GHT-ACCT-UNIT
Element: Acct Unit
Alpha 15
GL192
GHT-ACCOUNT
Element: Account
Numeric 6
GL192
GHT-SUB-ACCOUNT
Element: Sub Account
Numeric 4
GL192
GHT-YEAR
Element: Year
Numeric 4
GL192
GHT-VAR-LEVELS
Element: Var Levels
Alpha 30
GL192
GHT-SYSTEM
Element: System
Alpha 2
GL192
GHT-DB-AMOUNT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
GL192
GHT-CR-AMOUNT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
GL192
GHT-DB-UNITS
Element: Auto Debits
Signed 15.2 Occurs 13 Times
GL192
GHT-CR-UNITS
Element: Auto Credits
Signed 15.2 Occurs 13 Times
GL192
GHT-MAINT-DATE
Element: Maint Date
Numeric 8 (yyyymmdd)
GL192
GHT-MAINT-TIME
Element: Sys Time
Numeric 6 (hhmmss)
GL192
GHT-FUND-GROUP
Element: Fund Group
Alpha 15
GL192


GLHISTCOM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GHTSET1 COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
YEAR
SYSTEM
UNIQUE-I-D
KeyChange
GL192
GHTSET2 COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
YEAR
SYSTEM
UNIQUE-I-D
KeyChange
GLRV.1
GHTSET3 COMPANY
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
YEAR
SYSTEM
UNIQUE-I-D
KeyChange
GL192
GHTSET4 COMPANY
FUND-GROUP
YEAR
SYSTEM
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
UNIQUE-I-D
KeyChange, Subset
WhereFUND-GROUP !=Spaces
GHTUID UNIQUE-I-D


GLHISTCOM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Glcommit GLCOMMIT Not Required
GHT-COMPANY->GOT-COMPANY (GOTSET1)
GHT-ACCT-UNIT->GOT-ACCT-UNIT
GHT-ACCOUNT->GOT-ACCOUNT
GHT-SUB-ACCOUNT->GOT-SUB-ACCOUNT
GHT-YEAR->GOT-FISCAL-YEAR
GHT-SYSTEM->GOT-SYSTEM
Glmaster GLMASTER Required
GHT-COMPANY->GLM-COMPANY
GHT-ACCT-UNIT->GLM-ACCT-UNIT
GHT-ACCOUNT->GLM-ACCOUNT
GHT-SUB-ACCOUNT->GLM-SUB-ACCOUNT


GLHISTCOM FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Fbdetail FBDETAIL
GHT-COMPANY->FBD-COMPANY
GHT-ACCT-UNIT->FBD-ACCT-UNIT
GHT-ACCOUNT->FBD-ACCOUNT
GHT-SUB-ACCOUNT->FBD-SUB-ACCOUNT
  FBD-BUDGET-NBR
  FBD-FISCAL-YEAR


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

Home
Contact Us



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