GLHISCOMBL

REFERENCED BY
GL299 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 AP510 AP520 API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.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 DR100 IC12.1
IC140 IC141 IC142 IC145 IC243 IC330
IC64.1 IC64.2 IC64.3 IC64.4 IC64.5 IC64.6
IC64.7 IC64.8 IC64.9 IC66.1 IC83.1 EX175
EX542 EXI2.1 EXI4.1 IFGT.1 IFUC.1 LP130
MA180 MA278 MA41.1 MA41.2 MA41.4 MA41.7
MA42.2 MA43.2 MA43.7 MA44.1 MA44.2 MA53.1
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA70.1 MA75.1 MA80.1 MAI1.1 PA182 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PD570
PO04.1 PO04.2 PO10.1 PO10.2 PO100 PO101
PO115 PO120 PO122 PO131 PO132 PO135
PO136 PO15.1 PO15.2 PO15.4 PO150 PO17.1
PO18.1 PO190 PO20.1 PO20.6 PO20.9 PO204
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.3 PO22.4 PO220 PO222 PO224 PO225
PO229 PO23.1 PO230 PO234 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO251 PO26.2 PO26.3
PO26.4 PO26.5 PO26.6 PO26.7 PO26.9 PO27.2
PO27.3 PO27.4 PO275 PO276 PO277 PO28.2
PO280 PO29.1 PO30.1 PO30.2 PO30.3 PO30.4
PO300 PO31.1 PO31.2 PO32.2 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
PO54.5 POCP.1 POD0.1 POI3.1 POID.1 POIF.1
POII.1 POIJ.1 PR128 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 PR36.4 PR37.1
PR38.1 PR45.1 PR529 PR530 PR560 PR582
PR80.1 PR80.4 PR82.1 PR85.1 PR89.1 PRAT.1
UK102 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4
RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ44.1 RQ500 RQ810 RQD0.1 RQIB.1 RQIF.1
RQII.1 RQIJ.1 TA147 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH32.5 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

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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175


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
AP510 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB10.1
CB15.1 CB150
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: Thu Jun 09 02:14:06 2016

Home
Contact Us



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