Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICICDUF


                              ICICDUF FILE

UPDATED BY

IC20.1    IC20.2    IC21.1    IC21.2    IC22.1    IC22.2
IC23.1    IC23.2    IC24.1    IC24.2    IC29.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

UFD-COMPANY            Numeric 4                                 IC29.1
Element: Company       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.

UFD-LOCATION           Alpha 5                                   IC29.1
Element: Location Code This field contains a valid stocking
                       location within the company inventory.

UFD-DOC-TYPE           Alpha 2                                   IC29.1
Element: Document Type This field contains the type of
                       transaction.

UFD-SYSTEM-CD          Alpha 2                                   IC29.1
Element: System Code   This field indicates on what system the
                       transaction originated.

UFD-DOCUMENT           Alpha 10  (Right Justified)               IC29.1
Element: Document ID   This field identifies the document from
                       which this transaction record was
                       created.

UFD-SHIPMENT-NBR       Numeric 10                                IC29.1
Element: Shipment NumbeThis 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.


UFD-LINE-NBR           Numeric 6                                 IC29.1
Element: Line Number   This field contains the line number.

UFD-COMPONENT-SEQ      Numeric 3                                 IC29.1
Element: Sequence NumbeThis field contains the component
                       sequence number.

UFD-ICD-USR-FLD-01     Alpha 20                                  IC29.1
Element: Icd Usr Fld 01

UFD-ICD-USR-FLD-02     Alpha 20                                  IC29.1
Element: Icd Usr Fld 02

UFD-ICD-USR-FLD-03     Alpha 20                                  IC29.1
Element: Icd Usr Fld 03

UFD-ICD-USR-FLD-04     Alpha 20                                  IC29.1
Element: Icd Usr Fld 04

UFD-ICD-USR-FLD-05     Alpha 20                                  IC29.1
Element: Icd Usr Fld 05

UFD-TRANS-SEQ          Numeric 6                                 IC29.1
Element: Trans Seq

                         ICICDUF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

UFDSET1   COMPANY                                                IC20.1  IC20.2
          LOCATION                                               IC21.1  IC21.2
          DOC-TYPE                                               IC22.1  IC22.2
          SYSTEM-CD                                              IC23.1  IC23.2
          DOCUMENT                                               IC24.1  IC24.2
          SHIPMENT-NBR                                           IC29.1
          LINE-NBR
          COMPONENT-SEQ
          TRANS-SEQ