ICICDUF – No description in the Lawson data dictionary
- System
- Inventory Control (IC)
- Prefix
UFD- Primary key
COMPANY,LOCATION,DOC-TYPE,SYSTEM-CD,DOCUMENT,SHIPMENT-NBR,LINE-NBR,COMPONENT-SEQ,TRANS-SEQ- Fields
- 14
- Updated by
- 12 programs
- Referenced by
- 0 programs
ICICDUF is a Lawson Inventory Control table (prefix UFD); no description in the lawson data dictionary. It is indexed by COMPANY, LOCATION, DOC-TYPE, SYSTEM-CD, DOCUMENT, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ, TRANS-SEQ (UFDSET1). It is updated by IC20.1, IC20.2, IC21.1, IC21.2, IC21.5, IC22.1, IC22.2, IC23.1 and 4 more. The table has 14 fields, 1 index and 0 documented relations.
About ICICDUF
No description in the Lawson data dictionary.
Fields (14)
Column = COBOL field name without the UFD- 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 |
|---|---|---|---|
#UFD-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. | IC29.1 |
#UFD-LOCATION PKLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | IC29.1 |
#UFD-DOC-TYPE PKDOC_TYPE | Alpha 2 | This field contains the type of transaction. | IC29.1 |
#UFD-SYSTEM-CD PKSYSTEM_CD | Alpha 2 | This field indicates on what system the transaction originated. | IC29.1 |
#UFD-DOCUMENT PKDOCUMENT | Alpha 10 (Right Justified) | This field identifies the document from which this transaction record was created. | IC29.1 |
#UFD-SHIPMENT-NBR PKSHIPMENT_NBR | Numeric 10 | This field contains the shipment number. One order can have several shipment numbers if the items of the order were not shipped at the same time. | IC29.1 |
#UFD-LINE-NBR PKLINE_NBR | Numeric 6 | This field contains the line number. | IC29.1 |
#UFD-COMPONENT-SEQ PKCOMPONENT_SEQ | Numeric 3 | This field contains the record sequence number. | IC29.1 |
#UFD-ICD-USR-FLD-01ICD_USR_FLD_01 | Alpha 20 | — | IC29.1 |
#UFD-ICD-USR-FLD-02ICD_USR_FLD_02 | Alpha 20 | — | IC29.1 |
#UFD-ICD-USR-FLD-03ICD_USR_FLD_03 | Alpha 20 | — | IC29.1 |
#UFD-ICD-USR-FLD-04ICD_USR_FLD_04 | Alpha 20 | — | IC29.1 |
#UFD-ICD-USR-FLD-05ICD_USR_FLD_05 | Alpha 20 | — | IC29.1 |
#UFD-TRANS-SEQ PKTRANS_SEQ | Numeric 6 | — | IC29.1 |
Indexes (1)
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 |
|---|---|---|---|---|
UFDSET1 |
| Primary | IC20.1, IC20.2, IC21.1, IC21.2, IC21.5, IC22.1, IC22.2, IC23.1 +4 more |