Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              ICICDUF FILE

REFERENCED BY

PO01.1

UPDATED BY

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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

UFD-COMPANY          Numeric 4                                   IC29.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

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

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

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

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

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


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

UFD-COMPONENT-SEQ    Numeric 3                                   IC29.1
Component Sequence   This field contains the component
Number               sequence number.

UFD-SEQ              Numeric 3                                   IC29.1  IC887
Sequence Number      This field contains the record sequence
                     number.

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

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

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

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

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

UFD-TRANS-SEQ        Numeric 6                                   IC29.1  IC887
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  IC23.1
          SYSTEM-CD                                              IC24.1  IC29.1
          DOCUMENT                                               IC887   PO01.1
          SHIPMENT-NBR
          LINE-NBR
          COMPONENT-SEQ
          TRANS-SEQ
          SEQ