Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ICCTRNHDR FILE

UPDATED BY

IC500     IC54.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

ITH-RECRD-TYPE       Numeric 2                                   IC54.1
Recrd Type

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

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

ITH-LINE-NBR         Numeric 6                                   IC54.1
Line Number          This field contains the line number.

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

ITH-TRANS-DATE       Numeric 8  (yyyymmdd)                       IC54.1
Transaction Date     The date of the transaction.

ITH-ACTUAL-TIME      Numeric 4                                   IC54.1
Actual Time          This field contains the actual time the
                     receiver was entered into the system.
                     This filed defaults to the system date
                     if an actual time was not entered.

ITH-GL-DATE          Numeric 8  (yyyymmdd)                       IC54.1
General Ledger Date  This field contains the general ledger
                     posting date.

ITH-EST-DEL-DATE     Numeric 8  (yyyymmdd)                       IC54.1
Estimated Delivery
Date

ITH-FR-TO-LOC        Alpha 5                                     IC54.1
Fr To Loc

ITH-INTRANSIT-FL     Alpha 1                                     IC54.1
Intransit Flag

ITH-INTRAN-RECV      Alpha 10                                    IC54.1
Intran Recv

ITH-REPRINT-FL       Alpha 1                                     IC54.1
Reprint Flag

ITH-FR-TO-CO         Numeric 4                                   IC54.1
Fr To Co

ITH-OPERATOR         Alpha 10                                    IC54.1
Operator Code        This field is used to store the login
                     id of the person who entered the record.


ITH-RECORD-ERROR     Alpha 1                                     IC500   IC54.1
Record Error

                         ICCTRNHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ITHSET1   COMPANY                                                IC500
          LOCATION
          RECRD-TYPE
          DOC-TYPE
          DOCUMENT

ITHSET2   COMPANY       Subset                                   IC54.1
          LOCATION      Where RECORD-ERROR = "Y"
          DOCUMENT
          RECORD-ERROR

                         ICCTRNHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Icctrnlin      ICCTRNLIN

                            ITH-COMPANY       -> ITI-COMPANY
                            ITH-LOCATION      -> ITI-LOCATION
                            ITH-RECRD-TYPE    -> ITI-RECRD-TYPE
                            ITH-DOC-TYPE      -> ITI-DOC-TYPE
                            ITH-DOCUMENT      -> ITI-DOCUMENT
                                                 ITI-LINE-NBR