Lawson Insight Technical Documentation

                            INSTDETAIL FILE

                     Intrastat Detail Transactions

REFERENCED BY

IN120     API1.1

UPDATED BY

POIJ.1    IN20.1    WH130     WH33.5    WH34.1    WH34.2
WH34.3    WH34.4

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ING-COMPANY          Numeric 4                                   IN20.1  POIJ.1
Company              The company number represents an            WH130   WH33.5
                     established company and is entered on       WH34.1  WH34.2
                     all function codes.                         WH34.3  WH34.4

ING-FISCAL-YEAR      Numeric 4                                   IN20.1  POIJ.1
Fiscal Year          This is the current fiscal year.  This      WH130   WH33.5
                     field is updated by Period Closing          WH34.1  WH34.2
                     (GL199).                                    WH34.3  WH34.4

ING-INTRASTAT-NBR    Numeric 12                                  IN20.1  POIJ.1
Intrastat Nbr        The number assigned by the Intrastat        WH130   WH33.5
                     system to a transaction that involves       WH34.1  WH34.2
                     Intrastat reporting after it has been       WH34.3  WH34.4
                     added.

ING-MNT-LINE-NBR     Numeric 4                                   IN20.1  POIJ.1
Mnt Line Nbr         Line number for the distribution line.      WH130   WH33.5
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ING-BASE-AMT         Signed 15.2                                 IN20.1  POIJ.1
Base Amount          This is the amount of the transaction in    WH130   WH33.5
                     the company base amount.                    WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ING-ICN-CODE         Alpha 8                                     IN20.1  POIJ.1
Icn Code                                                         WH130   WH33.5
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ING-WEIGHT           Signed 9.3                                  IN20.1  POIJ.1
Unit Weight          This field contains the unit weight of      WH130   WH33.5
                     the item based on the stocking UOM.         WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ING-RECEIVED-AMT     Signed 15.2                                 IN20.1  POIJ.1
Received Amt         This amount is the amount actual            WH130   WH33.5
                     received for this invoiced invoice item.    WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ING-SUPLMNTARY-UOM   Alpha 4                                     IN20.1  POIJ.1
Suplmntary Uom                                                   WH130   WH33.5
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ING-SUPLMNTARY-QTY   Signed 13.4                                 IN20.1  POIJ.1
Suplmntary Qty                                                   WH130   WH33.5
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

                         INSTDETAIL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

INGSET1   COMPANY                                                IN120
          FISCAL-YEAR
          INTRASTAT-NBR
          MNT-LINE-NBR

INGSET2   COMPANY                                                API1.1  POIJ.1
          INTRASTAT-NBR                                          IN20.1  WH130
          MNT-LINE-NBR                                           WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4