Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

INSTNBR


                              INSTNBR FILE

                       Intrastat Company Numbers

UPDATED BY

AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.1    AP30.2    AP30.4
AP520     API1.1    AR42.1    AR42.2    AR42.7    AR43.1
AR560     BL120     BL122     BL130     BL20.1    BL20.3
BL21.2    BL21.5    BL29.1    BL29.2    BL520     BL820
BL92.1    MA180     MA41.1    MA41.2    MA41.4    MA41.7
MA43.1    MA43.2    MA43.3    MA43.7    MA530     MA531
MA60.2    MA60.3    MA60.5    MA61.1    MA66.2    MA66.3
MA67.2    MA67.3    MA68.2    MA68.3    MA68.5    MA70.1
MA75.1    MA80.1    MAI1.1    PD10.1    PD10.2    PD130
PD20.1    PD20.2    PD20.3    PO100     PO101     PO122
PO131     PO20.1    PO21.1    PO21.2    PO21.3    PO21.4
PO21.5    PO22.1    PO23.1    PO24.1    PO25.1    PO25.5
PO25.6    PO25.7    PO27.2    PO29.1    PO30.1    PO30.2
PO30.3    PO300     PO31.1    PO31.2    PO32.2    PO32.4
PO33.1    PO34.1    PO35.1    PO36.1    PO36.2    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
PO536     POI3.1    POID.1    POII.1    POIJ.1    RQ10.1
RQ10.2    IN20.1    WH130     WH132     WH190     WH20.2
WH20.7    WH30.1    WH30.2    WH30.3    WH30.4    WH31.1
WH31.2    WH31.3    WH31.4    WH32.1    WH32.2    WH32.3
WH32.4    WH33.5    WH34.1    WH34.2    WH34.3    WH34.4
WH40.1    WH40.2    WH520     WH830

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

INB-COMPANY            Numeric 4                                 AP125   AP126
Element: Company       Identifies the AP company if the          AP131   AP20.1
                       resource type = V.  Identifies the HR     AP20.2  AP20.3
                       company if the resource type = E.  It is  AP20.4  AP20.5
                       blank for type A, P or Q resources.       AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.1
                                                                 AP30.2  AP30.4
                                                                 AP520   API1.1
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IN20.1
                                                                 MA180   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 MA67.3  MA68.2
                                                                 MA68.3  MA68.5
                                                                 ...

INB-FISCAL-YEAR        Numeric 4                                 AP125   AP126
Element: Year          Contains the fiscal year for the data     AP131   AP20.1
                       stored on this record.                    AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.1
                                                                 AP30.2  AP30.4
                                                                 AP520   API1.1
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IN20.1
                                                                 MA180   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 MA67.3  MA68.2
                                                                 MA68.3  MA68.5
                                                                 ...

INB-INTRASTAT-NBR      Numeric 12                                AP125   AP126
Element: Intrastat Nbr The number assigned by the Intrastat      AP131   AP20.1
                       system to a transaction that involves     AP20.2  AP20.3
                       Intrastat reporting after it has been     AP20.4  AP20.5
                       added.                                    AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.1
                                                                 AP30.2  AP30.4
                                                                 AP520   API1.1
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IN20.1
                                                                 MA180   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 MA67.3  MA68.2
                                                                 MA68.3  MA68.5
                                                                 ...

                         INSTNBR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

INBSET1   COMPANY
          FISCAL-YEAR

INBSET2   COMPANY       KeyChange                                AP125   AP126
          INTRASTAT-NBR                                          AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.1
                                                                 AP30.2  AP30.4
                                                                 AP520   API1.1
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 ...