Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            INSTCTRYCD FILE

REFERENCED BY

AC551     AP00.5    AP10.1    AP10.2    AP10.3    AP10.9
AP510     API1.1    API3.1    API4.1    AR01.1    AR02.1
AR14.1    AR141     AR161     AR219     AR48.1    AR48.3
AR501     AR550     BL00.1    BL01.1    BL02.1    BL04.1
BL121     BL123     BL125     BL202     BL204     BL217
BL220     BL231     BL246     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    BL80.1
BL80.3    BL802     BL81.1    BL82.1    BL85.1    BL85.2
BL90.1    BN01.1    BN15.1    BN171     BN181     BN201
BN245     BN248     BN258     BN270     BN285     BN331
BN48.1    BN70.1    BR10.1    BR11.1    BR120     BR121
BR21.1    BR210     BR211     BR220     BR420     BR450
BRIP.1    CB00.1    CB03.1    CXCP.1    HINT.1    HR00.1
HR01.1    HR03.2    HR04.9    HR10.3    HR10.4    HR13.1
HR15.1    HR155     HR170     HR200     HR201     HR204
HR210     HR211     HR213     HR30.1    HR403     HR511
HR513     HR54.1    HR55.2    HR650     HR70.1    HR91.1
HR91.2    HR91.3    HR91.4    HRS1.1    HRSC.1    DR100
IC02.1    IC141     IC142     IC83.1    GL10.1    GL124
GL20.1    GL23.1    GL23.3    PA12.1    PA120     PA16.1
PA17.1    PA18.1    PA19.1    PA212     PA217     PA218
PA219     PA231     PA232     PA233     PA272     PA290
PA31.1    PA311     PA32.1    PA325     PA33.1    PA372
PA502     PA512     PA513     PA53.1    PA531     PA533
PA54.1    PA590     PA66.3    PA90.1    TR07.1    TR207
TR22.1    TR500     POIJ.1    PR01.1    PR03.1    PR05.1
PR13.1    PR13.5    PR13.6    PR13.8    PR14.1    PR141
PR197     PR20.2    PR201     PR512     PR52.1    PR82.1
RQ11.1    RQ12.1    RQ13.1    IN02.1    IN04.1    IN120
IN20.1    IN201     TX140     TX40.1    WH110     WH120
WH130     WH21.1    WH21.2    WH21.3    WH21.4    WH210
WH22.1    WH33.1    WH33.2    WH33.3    WH33.4    WH33.5
WH33.6    WH33.8    WH33.9    WH34.1    WH34.2    WH34.3
WH34.4

UPDATED BY

GL107     IN01.1    IN501

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


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

INT-ISO-CTRY-NBR     Numeric 3                                   GL107   IN01.1
Iso Ctry Nbr         The ISO country number.                     IN501

INT-COUNTRY-DESC     Alpha 30  (Lower Case)                      GL107   IN01.1
Country Description                                              IN501

INT-EC-FLAG          Alpha 1                                     GL107   IN01.1
Ec Flag              Set to Y if the country is a member of      IN501
                     the European Community. Used for
                     Intrastat processing.
                     Y = Country is a member of EC
                     N = Ctry is not a member of EC

                         INSTCTRYCD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

INTSET1   COUNTRY-CODE                                           AC551   AP00.5
                                                                 AP10.1  AP10.2
                                                                 AP10.3  AP10.9
                                                                 AP510   API1.1
                                                                 API3.1  API4.1
                                                                 AR01.1  AR02.1
                                                                 AR14.1  AR141
                                                                 AR161   AR219
                                                                 AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BL00.1  BL01.1
                                                                 BL02.1  BL04.1
                                                                 BL121   BL123
                                                                 BL125   BL202
                                                                 BL204   BL217
                                                                 ...