Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              INSTNBR FILE

                           Intrastat Number


This file increments the Intrastat Number each time an Intrastat transaction
is added for this company and fiscal year.

UPDATED BY

AP20.1    AP20.2    AP20.5    AP20.7    AP23.1    AP30.2
AP520     AR42.2    AR560     BL92.1    IC22.2    IN20.1
MA40.1    MA40.2    MA41.1    MA41.2    MA41.4    MA41.5
MA41.6    MA43.1    MA43.2    MA43.3    MA43.4    MA52.1
OE10.1    OE10.2    OE10.3    OE10.4    OE10.5    OE10.6
OE10.7    OE10.8    OE11.1    OE11.4    OE11.8    OE11.9
OE110     OE113     OE114     OE129     OE14.4    OE15.1
OE15.2    OE15.3    OE15.4    OE15.5    OE15.7    OE510
OE810     OE920     PO20.1    WH20.7

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

INB-COMPANY          Numeric 4                                   AP20.1  AP20.2
Company              The company number represents an            AP20.5  AP20.7
                     established company and is entered on       AP23.1  AP30.2
                     all function codes.                         AP520   AR42.2
                                                                 AR560   BL92.1
                                                                 IC22.2  IN20.1
                                                                 MA40.1  MA40.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.5
                                                                 MA41.6  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA52.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE113
                                                                 OE114   OE129
                                                                 OE14.4  OE15.1
                                                                 OE15.2  OE15.3
                                                                 OE15.4  OE15.5
                                                                 OE15.7  OE510
                                                                 OE810   OE920
                                                                 PO20.1  WH20.7

INB-FISCAL-YEAR      Numeric 4                                   AP20.1  AP20.2
Fiscal Year          This is the current fiscal year.  This      AP20.5  AP20.7
                     field is updated by GL199 (Period           AP23.1  AP30.2
                     Closing).                                   AP520   AR42.2
                                                                 AR560   BL92.1
                                                                 IC22.2  IN20.1
                                                                 MA40.1  MA40.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.5
                                                                 MA41.6  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA52.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE113
                                                                 OE114   OE129
                                                                 OE14.4  OE15.1
                                                                 OE15.2  OE15.3
                                                                 OE15.4  OE15.5
                                                                 OE15.7  OE510
                                                                 OE810   OE920
                                                                 PO20.1  WH20.7

INB-INTRASTAT-NBR    Numeric 10                                  AP20.1  AP20.2
Intrastat Nbr        The number assigned by the Intrastat        AP20.5  AP20.7
                     system to a transaction that involves       AP23.1  AP30.2
                     Intrastat reporting after it has been       AP520   AR42.2
                     added.                                      AR560   BL92.1
                                                                 IC22.2  IN20.1
                                                                 MA40.1  MA40.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.5
                                                                 MA41.6  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA52.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE113
                                                                 OE114   OE129
                                                                 OE14.4  OE15.1
                                                                 OE15.2  OE15.3
                                                                 OE15.4  OE15.5
                                                                 OE15.7  OE510
                                                                 OE810   OE920
                                                                 PO20.1  WH20.7

                         INSTNBR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

INBSET1   COMPANY                                                AP20.1  AP20.2
          FISCAL-YEAR                                            AP20.5  AP20.7
                                                                 AP23.1  AP30.2
                                                                 AP520   AR42.2
                                                                 AR560   BL92.1
                                                                 IC22.2  IN20.1
                                                                 MA40.1  MA40.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.5
                                                                 MA41.6  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA52.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 ...