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 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
GL299 GL322 GL70.1 GL70.2 GL70.3 GL70.5
GL70.6 GL75.1 GL76.1 PR521 DR100 IC140
IC66.1 IC83.1 EX175 EX542 EXI2.1 EXI4.1
IFGT.1 IFUC.1 LP130 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA42.2 MA43.2 MA43.7 MA44.1
MA44.2 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
PO100 PO101 PO122 PO131 PO135 PO136
PO150 PO190 PO20.1 PO20.6 PO20.9 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.3
PO22.4 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO26.2 PO26.3 PO26.4 PO26.5 PO26.6
PO26.7 PO26.9 PO27.2 PO28.2 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
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 ZP530
RQ10.1 RQ10.2 RQ10.4 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ500 RQD0.1 RQIF.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 ZW130

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 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 EX542
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 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 EX542
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 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 EX542
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 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 EX542
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 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 EX542
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 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 EX542
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 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 EX542
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 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 EX542
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 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 EX542
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 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 EX542
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 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 EX542


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 ARLL.1
BN150 BN66.1
CB10.1 CB15.1
CB150 CB180
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 11:13:17 2016

Home
Contact Us



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