Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICCTRNDTL


                             ICCTRNDTL FILE

UPDATED BY

IC500     IC54.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ITJ-COMPANY            Numeric 4                                 IC54.3
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.

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

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

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

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

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

ITJ-SEQ                Numeric 3                                 IC54.3
Element: Sequence NumbeThis field contains the record sequence
                       number.

ITJ-SERIAL             Alpha 16                                  IC54.3
Element: Serial Number

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

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

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

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

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

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

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

ITJ-SEC-QTY            Signed 13.4                               IC54.3
Element: 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