ICICTUF – No description in the Lawson data dictionary

System
Inventory Control (IC)
Prefix
UFT
Primary key
COMPANY, LOCATION, DOC-TYPE, SYSTEM-CD, DOCUMENT, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ
Fields
13
Updated by
11 programs
Referenced by
0 programs

ICICTUF is a Lawson Inventory Control table (prefix UFT); no description in the lawson data dictionary. It is indexed by COMPANY, LOCATION, DOC-TYPE, SYSTEM-CD, DOCUMENT, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ (UFTSET1). It is related 1:1 to ICTRANS. It is updated by IC20.1, IC20.2, IC21.1, IC21.2, IC21.5, IC22.1, IC22.2, IC23.1 and 3 more. The table has 13 fields, 1 index and 1 documented relation.

About ICICTUF

No description in the Lawson data dictionary.

Fields (13)

Column = COBOL field name without the UFT- 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 / columnTypeDescription & valuesUpdated by
#UFT-COMPANY PK
COMPANY		Numeric 4Identifies 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.IC20.1, IC20.2, IC21.1, IC21.2, IC21.5, IC22.1, IC22.2, IC23.1 +3 more
#UFT-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.IC20.1, IC20.2, IC21.1, IC21.2, IC21.5, IC22.1, IC22.2, IC23.1 +3 more
#UFT-DOC-TYPE PK
DOC_TYPE		Alpha 2This field contains the type of transaction.IC20.1, IC20.2, IC21.1, IC21.2, IC21.5, IC22.1, IC22.2, IC23.1 +3 more
#UFT-SYSTEM-CD PK
SYSTEM_CD		Alpha 2This field indicates on what system the transaction originated.IC20.1, IC20.2, IC21.1, IC21.2, IC21.5, IC22.1, IC22.2, IC23.1 +3 more
#UFT-DOCUMENT PK
DOCUMENT		Alpha 10 (Right Justified)This field identifies the document from which this transaction record was created.IC20.1, IC20.2, IC21.1, IC21.2, IC21.5, IC22.1, IC22.2, IC23.1 +3 more
#UFT-SHIPMENT-NBR PK
SHIPMENT_NBR		Numeric 10This 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.IC20.1, IC20.2, IC21.1, IC21.2, IC21.5, IC22.1, IC22.2, IC23.1 +3 more
#UFT-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.IC20.1, IC20.2, IC21.1, IC21.2, IC21.5, IC22.1, IC22.2, IC23.1 +3 more
#UFT-COMPONENT-SEQ PK
COMPONENT_SEQ		Numeric 3This field contains the record sequence number.IC20.1, IC20.2, IC21.1, IC21.2, IC21.5, IC22.1, IC22.2, IC23.1 +3 more
#UFT-ICT-USR-FLD-01
ICT_USR_FLD_01		Alpha 20—IC20.1, IC20.2, IC21.1, IC21.2, IC21.5, IC22.1, IC22.2, IC23.1 +3 more
#UFT-ICT-USR-FLD-02
ICT_USR_FLD_02		Alpha 20—IC20.1, IC20.2, IC21.1, IC21.2, IC21.5, IC22.1, IC22.2, IC23.1 +3 more
#UFT-ICT-USR-FLD-03
ICT_USR_FLD_03		Alpha 20—IC20.1, IC20.2, IC21.1, IC21.2, IC21.5, IC22.1, IC22.2, IC23.1 +3 more
#UFT-ICT-USR-FLD-04
ICT_USR_FLD_04		Alpha 20—IC20.1, IC20.2, IC21.1, IC21.2, IC21.5, IC22.1, IC22.2, IC23.1 +3 more
#UFT-ICT-USR-FLD-05
ICT_USR_FLD_05		Alpha 20—IC20.1, IC20.2, IC21.1, IC21.2, IC21.5, IC22.1, IC22.2, IC23.1 +3 more

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.

IndexKeysFlagsConditionUsed in
UFTSET1
  1. COMPANY
  2. LOCATION
  3. DOC-TYPE
  4. SYSTEM-CD
  5. DOCUMENT
  6. SHIPMENT-NBR
  7. LINE-NBR
  8. COMPONENT-SEQ
PrimaryIC20.1, IC20.2, IC21.1, IC21.2, IC21.5, IC22.1, IC22.2, IC23.1 +3 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ICTRANSICICTUF

One to one (1) — lookups and parents

RelationTableRulesConditionField map
IctransICTRANSRequired
UFT-COMPANY→ICT-COMPANY
UFT-LOCATION→ICT-LOCATION
UFT-DOC-TYPE→ICT-DOC-TYPE
UFT-SYSTEM-CD→ICT-SYSTEM-CD
UFT-DOCUMENT→ICT-DOCUMENT
UFT-SHIPMENT-NBR→ICT-SHIPMENT-NBR
UFT-LINE-NBR→ICT-LINE-NBR
UFT-COMPONENT-SEQ→ICT-COMPONENT-SEQ

Programs

Updated by (11)