Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            INSTCTRYCD FILE

                        Intrastat Country Code


Maintains the Intrastat country codes. Updated by IN01.1 (Country
 Maintenance). Is used by the Intrastat transaction entry forms in AP, AR, OE,
 IC, and PO to verify that the origin and destination coutries in a
transaction as part of the European community and the transaction is therefore
subject to Intrastat reporting.





REFERENCED BY

AC115     AC15.2    AC450     AP00.7    AP02.1    AP10.1
AP10.2    AP10.3    AP20.1    AP20.2    AP20.5    AP20.7
AP23.1    AP30.2    AP51.1    AP51.2    AP510     AP52.1
AP520     AR01.1    AR02.1    AR09.1    AR09.4    AR10.1
AR14.1    AR141     AR161     AR42.2    AR501     AR550
AR560     BL00.1    BL02.1    BL02.2    BL04.1    BL120
BL121     BL122     BL123     BL130     BL20.1    BL20.3
BL202     BL204     BL21.2    BL21.5    BL220     BL231
BL246     BL29.1    BL29.2    BL290     BL291     BL31.1
BL31.2    BL31.3    BL31.5    BL31.7    BL32.3    BL32.4
BL33.1    BL331     BL34.1    BL46.1    BL46.2    BL520
BL80.1    BL80.3    BL802     BL81.1    BL820     BL85.1
BL85.2    BL90.1    BL902     BL92.1    BL940     BN01.1
BN171     BN181     BN201     BN245     BN248     BN258
BN270     BN285     BN331     BN48.1    BN70.1    CB00.1
CB03.1    HINT.1    HR00.1    HR01.1    HR03.2    HR04.9
HR11.1    HR13.1    HR13.2    HR15.1    HR155     HR170
HR200     HR201     HR204     HR211     HR213     HR30.1
HR403     HR511     HR54.1    HR55.2    HR70.1    HR700
HR704     HR91.1    HR91.2    HR91.3    HRS1.1    HRSC.1
IC02.1    IC22.1    IC22.2    GL10.1    GL20.1    IN02.1
IN04.1    IN120     IN20.1    MA04.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     OE112
OE113     OE114     OE129     OE130     OE14.3    OE14.4
OE15.1    OE15.2    OE15.3    OE15.4    OE15.5    OE15.7
OE230     OE254     OE260     OE270     OE271     OE272
OE284     OE285     OE286     OE290     OE291     OE292
OE293     OE294     OE30.1    OE30.2    OE30.3    OE30.4
OE30.5    OE30.6    OE30.7    OE30.9    OE330     OE510
OE53.1    OE54.1    OE60.1    OE80.1    OE80.2    OE81.1
OE81.2    OE810     OE830     OE85.1    OE90.1    OE90.2
OE920     OE950     PA02.1    PA100     PA102     PA115
PA12.1    PA120     PA13.1    PA13.2    PA16.1    PA17.1
PA18.1    PA19.1    PA20.1    PA21.1    PA212     PA217
PA218     PA219     PA22.1    PA231     PA232     PA233
PA24.1    PA272     PA290     PA31.1    PA311     PA32.1
PA325     PA33.1    PA34.1    PA35.1    PA36.1    PA372
PA38.1    PA502     PA512     PA513     PA52.1    PA52.3
PA52.4    PA52.5    PA520     PA53.1    PA531     PA533
PA54.1    PA590     PA66.3    PA90.1    TR07.1    TR207
TR21.1    TR22.1    TR500     PBIP.1    PO100     PO20.1
PO22.1    PO22.2    PO22.3    PR13.1    PR160     PR180
PR80.2    RQ20.1    RQ20.3    RQ20.4    SA03.1    SA100
SA252     SA254     SA256     SA261     SA271     SA281
SA291     SA300     SA80.2    SA90.2    TX06.1    TX140
TX40.1    WH110     WH120     WH130     WH132     WH190
WH20.2    WH20.7    WH21.2    WH30.1    WH30.2    WH30.3
WH31.1    WH31.2    WH31.3    WH32.1    WH32.2    WH32.3
WH33.5    WH34.1    WH34.2    WH34.3    WH34.4    WH40.1
WH40.2    WH520     WH830

UPDATED BY

GL107     IN01.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

INT-COUNTRY-CODE     Alpha 2                                     GL107   IN01.1
Country Code         The two-digit country code. Required for
                     VAT and Intrastat reporting. Must be
                     defined in IN01.1 (Counrty Maintenance).

INT-EC-CTRY-NBR      Numeric 3                                   GL107   IN01.1
EC Country Number    The European Community Country number;
                     leave blank if not a member of the
                     European Community.

INT-ISO-CTRY-NBR     Numeric 3                                   GL107   IN01.1
ISO Coutry Number    The ISO country number.

INT-COUNTRY-DESC     Alpha 30  (Lower Case)                      GL107   IN01.1
Country Description  The name or description of the country.

INT-EC-FLAG          Alpha 1                                     GL107   IN01.1
EC Flag              Set to Y if the country is a member of
                     the European Community. Used for
                     Intrastat processing.

                         INSTCTRYCD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

INTSET1   COUNTRY-CODE  Use to access Intrastat country codes.   AC115   AC15.2
                                                                 AC450   AP00.7
                                                                 AP02.1  AP10.1
                                                                 AP10.2  AP10.3
                                                                 AP20.1  AP20.2
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP30.2
                                                                 AP51.1  AP51.2
                                                                 AP510   AP52.1
                                                                 AP520   AR01.1
                                                                 AR02.1  AR09.1
                                                                 AR09.4  AR10.1
                                                                 AR14.1  AR141
                                                                 AR161   AR42.2
                                                                 AR501   AR550
                                                                 ...