Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ICCTRNDTL FILE

UPDATED BY

IC54.3    IC500

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ITJ-COMPANY          Numeric 4                                   IC54.3
Company              The company number represents an
                     established company and is entered on
                     all function codes.

ITJ-LOCATION         Alpha 5                                     IC54.3
Location Code        This field contains a valid stocking
                     location within the company inventory.

ITJ-RECRD-TYPE       Numeric 2                                   IC54.3
Recrd Type

ITJ-DOC-TYPE         Alpha 2                                     IC54.3
Document Type        This field contains the type of
                     transaction.

ITJ-DOCUMENT         Alpha 10  (Right Justified)                 IC54.3
Document ID          This field identifies the document from
                     which this transaction record was
                     created.

ITJ-LINE-NBR         Numeric 6                                   IC54.3
Line Number          This field contains the line number.

ITJ-SEQ              Numeric 3                                   IC54.3
Sequence Number      This field contains the record sequence
                     number.

ITJ-SERIAL           Alpha 16                                    IC54.3
Serial Number

ITJ-BIN              Alpha 7                                     IC54.3
Bin                  This field contains a storage area for
                     an item or any number of items.

ITJ-LOT              Alpha 10                                    IC54.3
Lot Number           This field contains the identifier for
                     the homogeneous quantity of material.

ITJ-SUB-LOT          Alpha 6                                     IC54.3
Sub Lot

ITJ-ITEM             Alpha 32                                    IC54.3
Item Number          This field contains the item
                     identifier.

ITJ-QUANTITY         Signed 13.4                                 IC54.3
Quantity             This field contains the desired
                     quantity.

ITJ-HOLD-FL          Alpha 1                                     IC54.3
Hold Fl

ITJ-EXP-DATE         Numeric 8  (yyyymmdd)                       IC54.3
Expiration Date

ITJ-SEC-QTY          Signed 13.4                                 IC54.3
Sec Qty

                         ICCTRNDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ITJSET1   COMPANY                                                IC500   IC54.3
          LOCATION
          RECRD-TYPE
          DOC-TYPE
          DOCUMENT
          LINE-NBR
          SEQ