ICRPTGRP

Report Group

The Report Group file stores the valid report groups used to define groups of locations for reporting purposes.

REFERENCED BY
DR100 IC120 IC134 IC135 IC138 IC140
IC141 IC142 IC145 IC150 IC151 IC152
IC170 IC183 IC211 IC220 IC221 IC222
IC223 IC224 IC225 IC226 IC227 IC228
IC230 IC231 IC235 IC237 IC238 IC239
IC241 IC242 IC281 IC286 IC287 IC31.1
IC330 IC331 IC37.1 IC40.1 IC40.2 IC44.1
IC46.1 IC520 IC522 IC525 IC55.1 IC55.2
IC70.1 IC802 PO100 PO20.9 PO23.1 WH422
WH440 WHD2.1 IC125 IC182 IC203 IC229
IC233 IC234 IC247 IC283 IC285 IC295
IC523 IC526 IC527 IC84.1 IC84.2 PC210
RQ230


UPDATED BY
IC03.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IRG-COMPANY
Element: Company		Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
IC03.1
IRG-REPORT-GRP
Element: Report Grp		Alpha 5
This field contains the set of locations within a company defined for reporting purposes.
IC03.1
IRG-LOCATION
Element: Location		Alpha 5
This field contains a valid stocking location within the company inventory.
IC03.1
IRG-TOTAL-GRP
Element: Total Grp		Numeric 3
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.
IC03.1


ICRPTGRP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IRGSET1 COMPANY
REPORT-GRP
LOCATION
...
DR100 IC03.1
IC120 IC134
IC135 IC138
IC140 IC141
IC142 IC145
IC150 IC151
IC152 IC170
IC183 IC211
IC220 IC221
IC222 IC223
IC224 IC225
IC226 IC227
IC228 IC230
IC231 IC235
IC237 IC238
IRGSET2 COMPANY
REPORT-GRP
TOTAL-GRP
LOCATION
KeyChange
DR100 IC125
IC134 IC135
IC182 IC203
IC229 IC233
IC234 IC247
IC283 IC285
IC295 IC522
IC523 IC525
IC526 IC527
IC84.1 IC84.2
PC210 RQ230


ICRPTGRP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Required
IRG-COMPANY->ICC-COMPANY
Location ICLOCATION Required
IRG-COMPANY->ICL-COMPANY
IRG-LOCATION->ICL-LOCATION

File created: Thu Jun 09 02:18:48 2016

Home
Contact Us



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