Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

INSTREGN


                             INSTREGN FILE

                            Intrastat Region

This file contains a list of valid Region codes by Coutry for Intrastat
reporting.

REFERENCED BY

AC551     AM115     AM15.1    AM15.2    AM15.3    AM15.4
AM20.1    AM20.3    AM21.1    AM21.3    AM500     AM51.1
AM551     AM97.1    AP00.5    AP10.1    AP10.2    AP10.3
AP10.9    AP109     AP125     AP126     AP131     AP20.1
AP20.2    AP20.3    AP20.4    AP20.5    AP20.7    AP210
AP23.1    AP25.1    AP25.2    AP26.1    AP27.1    AP30.4
AP51.1    AP510     API1.1    API3.1    API4.1    AR01.1
AR02.1    AR09.1    AR09.4    AR10.1    AR501     AR550
BR11.1    BR120     BR121     BR122     BR123     BR151
BR152     BR156     BR16.1    BR20.7    BR21.1    BR211
BR420     BR521     BR55.1    BRIP.1    BRPI.1    IC02.1
IC28.1    IC840     MA180     MA41.2    MA41.7    MA43.1
MA43.2    MA43.3    MA43.9    MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA66.2    MA66.3    MA67.1
MA67.2    MA70.1    MA75.1    MA80.1    MAI1.1    PBIP.1
PO100     PO101     PO122     PO131     PO20.1    PO21.1
PO21.2    PO21.3    PO21.4    PO21.5    PO22.1    PO23.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    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    POII.1    POIJ.1    PR05.1
PR05.3    PR197     PR226     PR247     PR26.1    PR47.1
PR514     UK47.1    RQ10.1    RQ10.2    RQ10.3    RQIE.1
IN120     IN20.1    IN201     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

UPDATED BY

IN02.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

INR-COUNTRY-CODE       Alpha 2                                   IN02.1
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

INR-REGION             Alpha 2                                   IN02.1
Element: Region Code   The region code, if applicable for the
                       country. Used by Intrastat. Must be
                       defined in IN02.1 (Region Maintenance)

INR-DESCRIPTION        Alpha 30  (Lower Case)                    AP210   AP510
Element: Description   This field displays the description.      AR01.1  IN02.1

INR-EXCLUDE-RPT-FL     Alpha 1                                   IN02.1
Element: Exclude Rpt FlDetermines whether or not the region is
                       excluded from intrastat reporting.
                       Y = Yes
                       N = No

                         INSTREGN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

INRSET1   COUNTRY-CODE                                           AC551   AM115
          REGION                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.5  AP10.1
                                                                 AP10.2  AP10.3
                                                                 AP10.9  AP109
                                                                 AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP210
                                                                 ...