|
ICRPTGRP FILE
Report Group
The Report Group file stores the valid report groups used to define groups of
locations for reporting purposes.
REFERENCED BY
IC211 IC330 PO20.1 WH422 WH440 WHD2.1
IC203 RQ230
UPDATED BY
IC03.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IRG-COMPANY Numeric 4 IC03.1
Element: Company 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.
IRG-REPORT-GRP Alpha 5 IC03.1
Element: Report Grp This field contains the set of
locations within a company defined for
reporting purposes.
IRG-LOCATION Alpha 5 IC03.1
Element: Location This field contains a valid stocking
location within the company inventory.
IRG-TOTAL-GRP Numeric 3 IC03.1
Element: Total Grp 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 IC03.1 IC211
REPORT-GRP IC330 PO20.1
LOCATION WH422 WH440
WHD2.1
IRGSET2 COMPANY KeyChange IC203 RQ230
REPORT-GRP
TOTAL-GRP
LOCATION
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
|