ICRPTGRP FILE
Report Group
The Report Group file stores the valid report groups used to define groups of
locations for reporting purposes.
REFERENCED BY
DR100 IC120 IC138 IC140 IC141 IC142
IC145 IC150 IC151 IC152 IC170 IC183
IC211 IC221 IC222 IC223 IC224 IC225
IC226 IC227 IC228 IC230 IC237 IC238
IC239 IC241 IC242 IC281 IC286 IC31.1
IC40.1 IC40.2 IC520 IC522 IC525 IC530
IC70.1 IC125 IC134 IC135 IC182 IC203
IC229 IC233 IC234 IC283 IC295 IC523
IC526 IC527 PC210 RQ230
UPDATED BY
IC03.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IRG-COMPANY Numeric 4 IC03.1
Company The company number represents an
established company and is entered on
all function codes.
IRG-REPORT-GRP Alpha 5 IC03.1
Report Group This field contains the set of
locations within a company defined for
reporting purposes.
IRG-LOCATION Alpha 5 IC03.1
Location Code This field contains a valid stock
location within the company inventory.
IRG-TOTAL-GRP Numeric 3 IC03.1
Total Group This field contains a value assigned to
a location within a report group. This
value is used to group locations for
printing total breaks on reports when
this value changes.
ICRPTGRP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IRGSET1 COMPANY DR100 IC03.1
REPORT-GRP IC120 IC138
LOCATION IC140 IC141
IC142 IC145
IC150 IC151
IC152 IC170
IC183 IC211
IC221 IC222
IC223 IC224
IC225 IC226
IC227 IC228
IC230 IC237
IC238 IC239
IC241 IC242
IC281 IC286
...
IRGSET2 COMPANY KeyChange DR100 IC125
REPORT-GRP IC134 IC135
TOTAL-GRP IC182 IC203
LOCATION IC229 IC233
IC234 IC283
IC295 IC522
IC523 IC525
IC526 IC527
PC210 RQ230
ICRPTGRP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Required
IRG-COMPANY -> ICC-COMPANY
Location ICLOCATION Required
IRG-COMPANY -> ICL-COMPANY
IRG-LOCATION -> ICL-LOCATION
|