Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ICCTRNLIN FILE

UPDATED BY

IC500     IC54.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


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

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

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

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

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

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


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

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

ITI-UNIT-COST        Signed 13.5                                 IC54.2
Unit Cost            This field contains the unit cost.

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

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

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

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

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

ITI-ACTIVITY         Alpha 15                                    IC54.2
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
Acct Cat

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

ITI-OFFSET-ACCTUNI   Alpha 15                                    IC54.2
Offset Acctuni

ITI-OFFSET-ACCT      Numeric 6                                   IC54.2
Offset Acct

ITI-OFFSET-SUBACCT   Numeric 4                                   IC54.2
Offset Subacct

ITI-AOC-ACCTUNIT     Alpha 15                                    IC54.2
Aoc Acctunit

ITI-AOC-ACCT         Numeric 6                                   IC54.2
Aoc Acct

ITI-AOC-SUBACCT      Numeric 4                                   IC54.2
Aoc Subacct

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

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

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

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

ITI-USER-ANALYSIS    Alpha 103
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