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 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 WH422
WH440 WHD2.1 IC125 IC134 IC135 IC182
IC203 IC229 IC233 IC234 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 Numeric 4 IC03.1
Element: Company The company number represents an
established company and is entered on
all function codes.
IRG-REPORT-GRP Alpha 5 IC03.1
Element: Buyer 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
IC237 IC238
IC239 IC241
IC242 IC281
...
IRGSET2 COMPANY KeyChange DR100 IC125
REPORT-GRP IC134 IC135
TOTAL-GRP IC182 IC203
LOCATION IC229 IC233
IC234 IC283
IC285 IC295
IC522 IC523
IC525 IC526
IC527 IC84.1
IC84.2 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
|