Lawson Insight Technical Documentation |
|
ICRPTGRP
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 IC220 IC221 IC222 IC223 IC224
IC225 IC226 IC227 IC228 IC230 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 IC530 IC55.1 IC55.2 IC70.1 PO20.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
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 Group This field contains the set of
locations within a company defined for
reporting purposes.
IRG-LOCATION Alpha 5 IC03.1
Element: Location Code This field contains a valid stocking
location within the company inventory.
IRG-TOTAL-GRP Numeric 3 IC03.1
Element: 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
IC220 IC221
IC222 IC223
IC224 IC225
IC226 IC227
IC228 IC230
IC235 IC237
IC238 IC239
IC241 IC242
...
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
|