GLHISCOMBL

REFERENCED BY
GL93.1 GL93.2


UPDATED BY
AP125 AP126 AP131 AP170 AP190 AP193
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP21.1 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1
AP30.2 AP30.4 AP520 API1.1 API2.1 BN150
BN66.1 CB10.1 CB15.1 CB150 CB180 CB191
CB20.1 CB30.1 CB45.1 CB46.1 CB500 CB543
CB544 CB55.1 CB554 CB80.1 CB82.1 EE135
EE35.1 EE35.2 EE520 GL170 GL197 GL199
GL322 GL70.1 GL70.2 GL70.3 GL70.5 GL70.6
GL75.1 GL76.1 PR521 EX175 EX542 EXI2.1
EXI4.1 IFGT.1 IFUC.1 LP130 LP140 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MAI1.1 PA182 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POIF.1
POII.1 POIJ.1 PR128 PR130 PR131 PR132
PR134 PR135 PR136 PR137 PR140 PR189
PR195 PR197 PR29.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 PR35.9 PR36.1 PR37.1
PR38.1 PR45.1 PR529 PR530 PR560 PR582
PR80.1 PR80.4 PR82.1 PR85.1 PR89.1 UK102
UK330 UK560 TA147 GL299

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GHB-COMPANY
Element: Company		Numeric 4
 ...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL197 GL199
GL322 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 GL76.1
GHB-ACCT-UNIT
Element: Acct Unit		Alpha 15
 ...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL197 GL199
GL322 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 GL76.1
GHB-ACCOUNT
Element: Account		Numeric 6
 ...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL197 GL199
GL322 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 GL76.1
GHB-SUB-ACCOUNT
Element: Sub Account		Numeric 4
 ...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL197 GL199
GL322 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 GL76.1
GHB-YEAR
Element: Year		Numeric 4
 ...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL197 GL199
GL322 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 GL76.1
GHB-ACTIVITY
Element: Activity		Alpha 15
 ...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL197 GL199
GL322 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 GL76.1
GHB-ACCT-CATEGORY
Element: Acct Category		Alpha 5
 ...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL197 GL199
GL322 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 GL76.1
GHB-VAR-LEVELS
Element: Var Levels		Alpha 30
 ...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL197 GL199
GL322 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 GL76.1
GHB-SYSTEM
Element: System		Alpha 2
 ...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL197 GL199
GL322 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 GL76.1
GHB-FUND-GROUP
Element: Fund Group		Alpha 15
 ...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL197 GL199
GL322 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 GL76.1
GHB-BEG-BAL
Element: Intl Amt		Signed 18.2
GL199 GL322
GHB-AMOUNT
Element: Intl Amt		Signed 18.2 Occurs 13 Times
 ...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL197 GL199
GL322 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 GL76.1


GLHISCOMBL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GHBSET1 COMPANY
YEAR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
SYSTEM
ACTIVITY
ACCT-CATEGORY
...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
GHBSET2 COMPANY
YEAR
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
SYSTEM
ACTIVITY
ACCT-CATEGORY
GL199
GHBSET3 COMPANY
YEAR
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
SYSTEM
ACTIVITY
ACCT-CATEGORY
GHBSET4 ACTIVITY
ACCT-CATEGORY
YEAR
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
SYSTEM
KeyChange, Subset
WhereACTIVITY !=Spaces
GL93.2
GHBSET5 ACTIVITY
YEAR
ACCT-CATEGORY
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
SYSTEM
Subset
WhereACTIVITY !=Spaces
GL299


GLHISCOMBL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
GHB-ACTIVITY->ACV-ACTIVITY
Acct Unit GLNAMES Required
GHB-COMPANY->GLN-COMPANY
GHB-ACCT-UNIT->GLN-ACCT-UNIT
Company GLSYSTEM Required
GHB-COMPANY->GLS-COMPANY
Glmaster GLMASTER Required
GHB-COMPANY->GLM-COMPANY
GHB-ACCT-UNIT->GLM-ACCT-UNIT
GHB-ACCOUNT->GLM-ACCOUNT
GHB-SUB-ACCOUNT->GLM-SUB-ACCOUNT

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

Home
Contact Us



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