Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICCTRNLIN


                             ICCTRNLIN FILE

UPDATED BY

IC500     IC54.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ITI-COMPANY            Numeric 4                                 IC54.2
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

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

ITI-RECRD-TYPE         Numeric 2                                 IC54.2
Element: Recrd Type

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

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

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

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

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

ITI-QUANTITY           Signed 13.4                               IC54.2
Element: Quantity      This field contains the desired
                       quantity.

ITI-UNIT-COST          Signed 13.5                               IC54.2
Element: Base Cost

ITI-AOC-UCOST          Signed 13.5                               IC54.2
Element: Aoc Ucost

ITI-TRAN-UOM           Alpha 4                                   IC54.2
Element: Unit of Measure

ITI-REFERENCE          Alpha 10  (Lower Case)                    IC54.2
Element: Requester     The reference number associated with
                       the transaction.

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

ITI-REASON-CODE        Alpha 4                                   IC500   IC54.2
Accounts Receivable    This field contains the reason code,
Code                   which indicates the cause for credit
                       memos.

ITI-ACTIVITY           Alpha 15                                  IC54.2
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


ITI-ACCT-CAT           Alpha 5                                   IC54.2
Element: Acct Cat

ITI-LINE-COMM          Alpha 30                                  IC54.2
Element: Line Comm

ITI-OFFSET-ACCTUNI     Alpha 15                                  IC500   IC54.2
Element: Offset Acctuni

ITI-OFFSET-ACCT        Numeric 6                                 IC500   IC54.2
Element: Offset Acct

ITI-OFFSET-SUBACCT     Numeric 4                                 IC500   IC54.2
Element: Offset Subacct

ITI-AOC-ACCTUNIT       Alpha 15                                  IC500   IC54.2
Element: Aoc Acctunit

ITI-AOC-ACCT           Numeric 6                                 IC500   IC54.2
Element: Aoc Acct

ITI-AOC-SUBACCT        Numeric 4                                 IC500   IC54.2
Element: Aoc Subacct

ITI-FR-TO-BIN          Alpha 7                                   IC500   IC54.2
Element: Fr To Bin

ITI-LST-ISS-FL         Alpha 1                                   IC500   IC54.2
Element: Lst Iss Fl

ITI-SEC-QTY            Signed 13.4                               IC54.2
Element: Sec Qty

ITI-ORIG-QTY           Signed 13.4                               IC54.2
Element: Orig Qty

ITI-USER-ANALYSIS      Alpha 103
Element: User Analysis

                         ICCTRNLIN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ITISET1   COMPANY                                                IC500   IC54.2
          LOCATION
          RECRD-TYPE
          DOC-TYPE
          DOCUMENT
          LINE-NBR

                         ICCTRNLIN FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Icctrndtl      ICCTRNDTL

                            ITI-COMPANY       -> ITJ-COMPANY
                            ITI-LOCATION      -> ITJ-LOCATION
                            ITI-RECRD-TYPE    -> ITJ-RECRD-TYPE
                            ITI-DOC-TYPE      -> ITJ-DOC-TYPE
                            ITI-DOCUMENT      -> ITJ-DOCUMENT
                            ITI-LINE-NBR      -> ITJ-LINE-NBR
                                                 ITJ-SEQ