Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             INSTCMDTY FILE

                          Intrastat Commodity


This file maintains and validates the Intrastat commodity codes. Commodity
codes refer to the type of goods transported.

REFERENCED BY

AP20.1    AP20.2    AP20.5    AP20.7    AP23.1    AP30.2
AP520     AR42.2    AR560     IC22.2    IN120     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     OE14.4    OE15.1    OE15.2
OE15.3    OE15.4    OE15.5    OE15.7    OE510     OE810
OE920     PO20.1    PO22.3    PO31.1    WH20.2    WH20.7

UPDATED BY

IN03.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

INO-COMMODITY        Alpha 8                                     IN03.1
Commodity            The Intrastat commodity code.
                     Represents a category of goods. Must be
                     defined in IN03.1 (Commodity
                     Maintenance).


INO-DESCRIPTION      Alpha 30  (Lower Case)                      IN03.1
Description          This field contains the description.

                         INSTCMDTY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

INOSET1   COMMODITY     Used to access Intrastat commodity       AP20.1  AP20.2
                        codes.                                   AP20.5  AP20.7
                                                                 AP23.1  AP30.2
                                                                 AP520   AR42.2
                                                                 AR560   IC22.2
                                                                 IN03.1  IN120
                                                                 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
                                                                 ...