Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

INSTDETAIL


                            INSTDETAIL FILE

                     Intrastat Detail Transactions

REFERENCED BY

IN120

UPDATED BY

AP125     AP126     AP131     AP25.1    AP25.2    AP26.1
AP27.1    AP30.4    API1.1    BL120     BL122     BL130
BL20.1    BL20.3    BL21.2    BL21.5    BL29.1    BL29.2
BL520     BL820     BL92.1    IC28.1    MA180     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    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     OE111     OE113     OE114     OE116
OE129     OE13.2    OE13.3    OE13.5    OE13.6    OE14.4
OE30.1    OE30.2    OE30.3    OE30.4    OE30.5    OE30.6
OE30.7    OE30.9    OE510     OE530     OE81.1    OE810
OE830     OE90.1    OE90.2    PO100     PO101     PO122
PO131     PO20.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO23.1    PO29.1    PO30.1    PO30.2    PO30.3
PO300     PO31.1    PO31.2    PO32.2    PO33.1    PO34.1
PO35.1    PO38.1    PO39.1    PO39.2    PO44.1    PO50.1
PO52.1    PO520     POI3.1    POIE.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

ING-COMPANY            Numeric 4                                 AP125   AP126
Element: Company       Identifies the AP company if the          AP131   AP25.1
                       resource type = V.  Identifies the HR     AP25.2  AP26.1
                       company if the resource type = E.  It is  AP27.1  AP30.4
                       blank for type A, P or Q resources.       API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC28.1
                                                                 IN20.1  MA180
                                                                 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
                                                                 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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 ...

ING-FISCAL-YEAR        Numeric 4                                 AP125   AP126
Element: Last Closed YeThis is the current fiscal year.  This    AP131   AP25.1
                       field is updated by Period Closing        AP25.2  AP26.1
                       (GL199).                                  AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC28.1
                                                                 IN20.1  MA180
                                                                 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
                                                                 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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 ...

ING-INTRASTAT-NBR      Numeric 12                                AP125   AP126
Element: Intrastat Nbr The number assigned by the Intrastat      AP131   AP25.1
                       system to a transaction that involves     AP25.2  AP26.1
                       Intrastat reporting after it has been     AP27.1  AP30.4
                       added.                                    API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC28.1
                                                                 IN20.1  MA180
                                                                 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
                                                                 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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 ...

ING-MNT-LINE-NBR       Numeric 4                                 AP125   AP126
Element: Mnt Line Nbr  Line number for the distribution line.    AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC28.1
                                                                 IN20.1  MA180
                                                                 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
                                                                 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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 ...

ING-BASE-AMT           Signed 18.2                               AP125   AP126
Element: Intl Amt      This is the amount of the transaction in  AP131   AP25.1
                       the company base amount.                  AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC28.1
                                                                 IN20.1  MA180
                                                                 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
                                                                 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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 ...

ING-ICN-CODE           Alpha 8                                   AP125   AP126
Element: Icn Code                                                AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC28.1
                                                                 IN20.1  MA180
                                                                 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
                                                                 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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 ...

ING-WEIGHT             Signed 9.3                                AP125   AP126
Element: Unit Weight   This field contains the unit weight of    AP131   AP25.1
                       the item based on the stocking UOM.       AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC28.1
                                                                 IN20.1  MA180
                                                                 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
                                                                 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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 ...

ING-RECEIVED-AMT       Signed 18.2                               AP125   AP126
Element: Intl Amt      This amount is the amount actual          AP131   AP25.1
                       received for this invoiced invoice item.  AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC28.1
                                                                 IN20.1  MA180
                                                                 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
                                                                 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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 ...

ING-SUPLMNTARY-UOM     Alpha 4                                   AP125   AP126
Element: Unit of Measure                                         AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC28.1
                                                                 IN20.1  MA180
                                                                 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
                                                                 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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 ...

ING-SUPLMNTARY-QTY     Signed 13.4                               AP125   AP126
Element: Quantity                                                AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC28.1
                                                                 IN20.1  MA180
                                                                 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
                                                                 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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 ...

                         INSTDETAIL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

INGSET1   COMPANY                                                IN120
          FISCAL-YEAR
          INTRASTAT-NBR
          MNT-LINE-NBR

INGSET2   COMPANY                                                AP125   AP126
          INTRASTAT-NBR                                          AP131   AP25.1
          MNT-LINE-NBR                                           AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC28.1
                                                                 MA180   MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 ...