ICRPTGRP – Report Group
- System
- Inventory Control (IC)
- Prefix
IRG- Primary key
COMPANY,REPORT-GRP,LOCATION- Fields
- 4
- Updated by
- 1 program
- Referenced by
- 73 programs
ICRPTGRP is the Report Group table in Lawson Inventory Control (prefix IRG). It is indexed by COMPANY, REPORT-GRP, LOCATION (IRGSET1); alternate indexes: IRGSET2. It is related 1:1 to ICCOMPANY and ICLOCATION. It is updated by IC03.1 and referenced by DR100, IC120, IC125, IC134, IC135, IC138, IC140, IC141 and 65 more. The table has 4 fields, 2 indexes and 2 documented relations.
About ICRPTGRP
The Report Group file stores the valid report groups used to define groups of locations for reporting purposes.
Fields (4)
Column = COBOL field name without the IRG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#IRG-COMPANY PKCOMPANY | 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 PKREPORT_GRP | Alpha 5 | This field contains the set of locations within a company defined for reporting purposes. | IC03.1 |
#IRG-LOCATION PKLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | IC03.1 |
#IRG-TOTAL-GRP SET2TOTAL_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 |
Indexes (2)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
IRGSET1 |
| Primary | DR100, IC03.1, IC120, IC134, IC135, IC138, IC140, IC141 +22 more (list truncated in source) | |
IRGSET2 |
| KeyChange | DR100, IC125, IC134, IC135, IC182, IC203, IC229, IC233 +14 more |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Company | ICCOMPANY | Required |
| |||||||
| Location | ICLOCATION | Required |
|
Programs
Updated by (1)
- IC03.1 Report Group
Referenced by (73)
- DR100 Distribution Requirements Report
- IC120 Economic Order Quantity and Reorder Calculation
- IC125 Standard Cost Valuation
- IC134 Inventory Turnover
- IC135 Inventory Turnover by Issues
- IC138 Bin Replenishment Report
- IC140 Vendor Reorder Advice
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC145 Stock Status Report
- IC150 Movement Analysis - Cost
- IC151 Movement Analysis - Sales
- IC152 Movement Analysis - GMROI
- IC170 Freeze Selected Items
- IC182 Par Location Utilization
- IC183 Par Level Load
- IC203 Report Group Listing
- IC211 Item Location Listing
- IC220 Transaction History Report
- IC221 Open Intransit Report
- IC222 Unreleased Documents
- IC223 Availability Report
- IC224 Gross Margin Return on Investment
- IC225 Inventory Reorder Advice
- IC226 Leadtime Review Report
- IC227 Potential Obsolete
- IC228 Potential Overstock
- IC229 Transactions by Reason Code
- IC230 Lot Status Report
- IC231 Issue Summary Report
- IC233 Inventory Valuation
- IC234 Period End Valuation
- IC235 Market Inventory Valuation
- IC237 Unapproved Bin Report
- IC238 Bin Stock on Hand Report
- IC239 Forecast Variance
- IC241 Bin Reorder Policy Listing
- IC242 Transaction Audit Report
- IC247 IFRS FIFO Period End Valuation
- IC281 Par Inventory Worksheet
- IC283 Par Location Valuation
- IC285 Detail Par Loc Utilization
- IC286 Accuracy Progress
- IC287 Transactions by Document Type
- IC295 Count Control Status
- IC31.1 Item Location Balances
- IC330 Item Mass Change
- IC331 Par Cart Mass Changes
- IC37.1 Daily Transaction Summary
- IC40.1 Availability by Location
- IC40.2 Secondary Quantity Availability
- IC44.1 Inventory Stock Status
- IC46.1 Inventory Status
- IC520 Handheld Item Master Interface
- IC522 HL7 Item Master - Atwork
- IC523 HL7 Item Master - OmniCell
- IC525 HL7 Item Master Interface
- IC526 HL7 Item Master - McKesson
- IC527 HL7 Item Master - DeRoyal
- IC55.1 Transaction History Inquiry
- IC55.2 Transaction History Inquiry
- IC70.1 Select IDs
- IC802 Locations to LRO via BCI
- IC84.1 Detail Par Location Utilization by Month
- IC84.2 Detail Par Location Utilization by Month
- PC210 Patient Charge Reconciliation
- PO100 Purchase Order Interface from Lawson Applications
- PO20.9 Multiple Lines
- PO23.1 Purchase Order Worksheet
- RQ230 Department Usage Report
- WH422 WH-IC Integrity Check - Report Only
- WH440 Data Verification Audit Report
- WHD2.1 WH-IC Integrity Check