ICUSRFLDEF – No description in the Lawson data dictionary
- System
- Inventory Control (IC)
- Prefix
ICU- Primary key
USER-FLD-TYPE,COMPANY,ITEM-GROUP- Fields
- 8
- Updated by
- 2 programs
- Referenced by
- 38 programs
ICUSRFLDEF is a Lawson Inventory Control table (prefix ICU); no description in the lawson data dictionary. It is indexed by USER-FLD-TYPE, COMPANY, ITEM-GROUP (ICUSET1); alternate indexes: ICUSET2 and ICUSET3. It is updated by IC00.1 and IC01.1 and referenced by DR100, IC11.1, IC12.1, IC13.1, IC141, IC142, IC20.1, IC20.2 and 30 more. The table has 8 fields, 3 indexes and 0 documented relations.
About ICUSRFLDEF
No description in the Lawson data dictionary.
Fields (8)
Column = COBOL field name without the ICU- 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 |
|---|---|---|---|
#ICU-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. | IC00.1, IC01.1 |
#ICU-ITEM-GROUP PKITEM_GROUP | Alpha 5 | This field contains the identifier for a group of items that can be shared by one or more companies. | IC00.1, IC01.1 |
#ICU-USER-FLD-TYPE PKUSER_FLD_TYPE | Alpha 1 | —
| IC00.1, IC01.1 |
#ICU-DATA-TYPE-01DATA_TYPE_01 | Alpha 1 | — | IC00.1, IC01.1 |
#ICU-DATA-TYPE-02DATA_TYPE_02 | Alpha 1 | — | IC00.1, IC01.1 |
#ICU-DATA-TYPE-03DATA_TYPE_03 | Alpha 1 | — | IC00.1, IC01.1 |
#ICU-DATA-TYPE-04DATA_TYPE_04 | Alpha 1 | — | IC00.1, IC01.1 |
#ICU-DATA-TYPE-05DATA_TYPE_05 | Alpha 1 | — | IC00.1, IC01.1 |
Indexes (3)
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 |
|---|---|---|---|---|
ICUSET1 |
| Primary | IC00.1, IC01.1 | |
ICUSET2 |
| DR100, IC11.1, IC12.1, IC13.1, IC141, IC142, IC20.1, IC20.2 +22 more (list truncated in source) | ||
ICUSET3 |
| DR100, IC11.1, IC12.1, IC13.1, IC141, IC142, IC20.1, IC20.2 +22 more (list truncated in source) |
Programs
Updated by (2)
Referenced by (38)
- DR100 Distribution Requirements Report
- IC11.1 Item Master
- IC12.1 Item Location
- IC13.1 Associated Items
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC20.1 Receipts
- IC20.2 Detail Receipts
- IC21.1 Issues
- IC21.2 Detail Issues
- IC21.5 Issues Detail List
- IC22.1 Transfers
- IC22.2 Detail Transfer
- IC23.1 Intransit Receiving
- IC23.2 Detail Intransit Receiving
- IC24.1 Adjustments
- IC24.2 Detail Adjustments
- IC29.1 Lots
- IC320 Mass Item Location Copy
- IC501 IC Company Setup Extract
- IC83.1 Par Location Counts
- PO10.1 PO Vendor
- PO10.2 Vendor Purchase From Location
- PO13.1 Vendor Item
- PO13.3 Vendor Items
- POII.1 Invoke for POPCRUPD
- POIJ.1 Invoke for POPLIUPD
- RQ10.1 Requisition
- RQ10.3 Select and Copy
- RQ10.4 Requisition Line Entry Detail
- RQ10.5 Substitutes
- RQ11.1 Kit Accessories
- RQ13.2 Direct Line Approval
- RQ35.1 Requisition Returns
- RQ500 Requisition Interface
- RQIB.1 RQRQHUPD Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQIJ.1 Requisition Copy