Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            INSTHEADER FILE

                      Intrastat Transaction Header

UPDATED BY

AP125     AP126     AP131     AP25.1    AP25.2    AP26.1
AP27.1    AP30.4    API1.1    IC28.1    MA180     MA43.9
MA530     MA531     MA60.2    MA60.3    MA60.5    MA61.1
MA66.3    MA67.1    MA67.2    MA70.1    MAI1.1    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    IN120     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

INH-COMPANY          Numeric 4                                   AP125   AP126
Company              The company number represents an            AP131   AP25.1
                     established company and is entered on       AP25.2  AP26.1
                     all function codes.                         AP27.1  API1.1
                                                                 IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-FISCAL-YEAR      Numeric 4                                   AP125   AP126
Fiscal Year          This is the current fiscal year.  This      AP131   AP25.1
                     field is updated by Period Closing          AP25.2  AP26.1
                     (GL199).                                    AP27.1  API1.1
                                                                 IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-INTRASTAT-NBR    Numeric 12                                  AP125   AP126
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  API1.1
                     added.                                      IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-REPORT-YEAR      Numeric 4                                   AP125   AP126
Report Year          The intrastat reporting year.               AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 IC28.1  IN120
                                                                 IN20.1  MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 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  WH130
                                                                 ...

INH-REPORT-PERIOD    Numeric 2                                   AP125   AP126
Report Period        The intrastat reporting period.             AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 IC28.1  IN120
                                                                 IN20.1  MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 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  WH130
                                                                 ...

INH-TRANS-TYPE       Alpha 1                                     AP125   AP126
Transaction Type     Determines if amounts or units are          AP131   AP25.1
                     processed in each transaction.              AP25.2  AP26.1
                     P = Purchases(Arrivals)                     AP27.1  API1.1
                     S = Sales(Dispatches)                       IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-SYSTEM-CD        Alpha 2                                     AP125   AP126
System Code          This field indicates on what system the     AP131   AP25.1
                     transaction originated.                     AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-CUSTOMER         Alpha 9  (Right Justified)                  AP125   AP126
Customer Number      This field contains the number that         AP131   AP25.1
                     represents a customer.                      AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-VENDOR           Alpha 9  (Right Justified)                  AP125   AP126
Vendor ID            The vendor's identification code.           AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-DOCUMENT-NBR     Alpha 27                                    AP125   AP126
Document Number      The number assigned to the transaction      AP131   AP25.1
                     (invoice, credit memo, etc.) for which      AP25.2  AP26.1
                     the intrastat data was entered.             AP27.1  API1.1
                                                                 IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-NOTC             Alpha 2                                     AP125   AP126
Notc                 The Nature of Transaction code.  Must       AP131   AP25.1
                     be a valid code defined in IN07.1 (NOTC     AP25.2  AP26.1
                     Maintenance).                               AP27.1  API1.1
                                                                 IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-TAX-PNT-DATE     Numeric 8  (yyyymmdd)                       AP125   AP126
Tax Point Date       Date goods were delivered or invoiced.      AP131   AP25.1
                     At time of Payment or when Invoiced.        AP25.2  AP26.1
                     If no date is entered, the system date      AP27.1  API1.1
                     defaults.                                   IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-STATUS           Numeric 1                                   AP125   AP126
Status               This field displays the status of the       AP131   AP25.1
                     transaction.                                AP25.2  AP26.1
                                                                 AP27.1  API1.1
                     1 = Open/Not Reported                       IC28.1  IN120
                     2 = Reported                                IN20.1  MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 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  WH130
                                                                 ...

INH-CUST-VAT-CTRY    Alpha 2                                     AP125   AP126
Cust Vat Ctry        The country component of the customer's     AP131   AP25.1
                     VAT registration number.  Must be a         AP25.2  AP26.1
                     valid country defined in IN01.1.            AP27.1  API1.1
                     (Country Maintenance)                       IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-CUST-VAT-REG-N   Alpha 12                                    AP125   AP126
Cust Vat Reg N       The number component of the customer's      AP131   AP25.1
                     VAT registration number, assigned by the    AP25.2  AP26.1
                      customer's governement.                    AP27.1  API1.1
                                                                 IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-CUST-VAT-NBR     Derived
Cust Vat Nbr         The customer's VAT Registration Number,
                     consisting of the concatenation of the
                     VAT registration country and number.

INH-CUST-CURR-CD     Alpha 5                                     AP125   AP126
Cust Curr Cd         The customers currency code.                AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-VEND-VAT-CTRY    Alpha 2                                     AP125   AP126
Vend Vat Ctry        The country component of the vendor's       AP131   AP25.1
                     VAT registration number. Must be a valid    AP25.2  AP26.1
                     country in IN01.1 (Country Maintenance)     AP27.1  API1.1
                                                                 IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-VEND-VAT-REG-N   Alpha 12                                    AP125   AP126
Vend Vat Reg N       The number componenet of the vendor's       AP131   AP25.1
                     VAT registration number, assigned by the    AP25.2  AP26.1
                     vendor's governement.                       AP27.1  API1.1
                                                                 IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-VEND-VAT-NBR     Derived
Vend Vat Nbr         The vendor's VAT Registration Number. It
                     consists of the concatenation of the
                     vendors country code and number.

INH-VENDOR-CURR-CD   Alpha 5                                     AP125   AP126
Vendor Curr Cd       Vendors currency code.                      AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-CURR-RATE        Signed 13.6                                 AP125   AP126
Currency Rate        The currency rate.                          AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-ORIGIN-COUNTRY   Alpha 2                                     AP125   AP126
Origin Country       The country from which the goods were       AP131   AP25.1
                     shipped. Must be a valid country in         AP25.2  AP26.1
                     IN01.1 (Country Maintenance)                AP27.1  API1.1
                                                                 IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-ORIGIN-REGION    Alpha 2                                     AP125   AP126
Origin Region        The region of the country from which the    AP131   AP25.1
                     goods were shipped, if required. Must be    AP25.2  AP26.1
                     a valid region in IN02.1 (Region            AP27.1  API1.1
                     Maintenance)                                IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-LOADING-PORT     Alpha 5                                     AP125   AP126
Loading Port         The port where the goods are loaded, if     AP131   AP25.1
                     required.  The port code must be defined    AP25.2  AP26.1
                     in IN04.1 (Port Maintenance)                AP27.1  API1.1
                                                                 IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-DEST-COUNTRY     Alpha 2                                     AP125   AP126
Dest Country         The country to which the goods were         AP131   AP25.1
                     shipped.  Must be a valid country in        AP25.2  AP26.1
                     IN01.1 (Country Maintenance).               AP27.1  API1.1
                                                                 IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-DEST-REGION      Alpha 2                                     AP125   AP126
Dest Region          The region of the country to which the      AP131   AP25.1
                     goods were shipped, if required.  Must      AP25.2  AP26.1
                     be a valid region in IN02.1 (Region         AP27.1  API1.1
                     Maintenance)                                IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-UNLOADING-PORT   Alpha 5                                     AP125   AP126
Unloading Port       The prot where the goods are unloaded if    AP131   AP25.1
                     required.  Must be defined in IN04.1        AP25.2  AP26.1
                     (Port Maintenance)                          AP27.1  API1.1
                                                                 IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-TRANSPORT-MODE   Alpha 1                                     AP125   AP126
Transport Mode       The mode of transportation at the           AP131   AP25.1
                     border crossing.  Code 7 is used for the    AP25.2  AP26.1
                     Channel Tunnel.                             AP27.1  API1.1
                                                                 IC28.1  IN20.1
                     1 = Sea                                     MA180   MA43.9
                     2 = Rail                                    MA530   MA531
                     3 = Road                                    MA60.2  MA60.3
                     4 = Air                                     MA60.5  MA61.1
                     5 = Post                                    MA66.3  MA67.1
                     7 = Fixed Installation                      MA67.2  MA70.1
                     8 = Inland Waterway                         MAI1.1  PO100
                     9 = Own Propulsion                          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
                                                                 WH130   WH132
                                                                 ...

INH-DLVRY-TRMS       Alpha 3                                     AP125   AP126
Dlvry Trms           The terms of delivery                       AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-STAT-PROC        Alpha 6                                     AP125   AP126
Stat Proc            The statistical procedure code applied      AP131   AP25.1
                     to the data.  The code must be defined      AP25.2  AP26.1
                     in IN06.1. (Statistical Procedure           AP27.1  API1.1
                     Maintenance).                               IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-DROP-SHIP-IND    Alpha 1                                     AP125   AP126
Drop Ship Ind        Specifies whether the shipment is a         AP131   AP25.1
                     drop (triangulated) shipment, that is a     AP25.2  AP26.1
                     shipment where goods are shipped from       AP27.1  API1.1
                     one EC country to another, but a            IC28.1  IN20.1
                     principal in the transaction is based       MA180   MA43.9
                     elsewhere.                                  MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-DELIVERY-DATE    Numeric 8  (yyyymmdd)                       AP125   AP126
Delivery Date        The date the goods were delivered,          AP131   AP25.1
                     shipped or moved.                           AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 IC28.1  IN20.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  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
                                                                 WH130   WH132
                                                                 ...

INH-PO-NUMBER        Alpha 14  (Right Justified)                 AP125   AP126
PO Number            This field contains the number              AP131   AP25.1
                     representing the purchase order.            AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 IC28.1  MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 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  WH130
                                                                 WH132   WH190
                                                                 ...

INH-PO-RELEASE       Numeric 4                                   AP125   AP126
PO Release Number    Used to identify a purchase order           AP131   AP25.1
                     release (created from a Blanket or          AP25.2  AP26.1
                     Standing order).                            AP27.1  API1.1
                                                                 IC28.1  MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 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  WH130
                                                                 WH132   WH190
                                                                 ...

INH-PO-CODE          Alpha 4                                     AP125   AP126
Po Code              This is the purchase order code.            AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 IC28.1  MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 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  WH130
                                                                 WH132   WH190
                                                                 ...

                         INSTHEADER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

INHSET1   COMPANY                                                IN120   WH20.2
          FISCAL-YEAR                                            WH20.7
          INTRASTAT-NBR

INHSET2   COMPANY       KeyChange, Duplicates                    IN120
          REPORT-YEAR
          REPORT-PERIOD
          INTRASTAT-NBR

INHSET3   COMPANY                                                AP125   AP126
          INTRASTAT-NBR                                          AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  IC28.1
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  PO100
                                                                 PO101   PO122
                                                                 PO131   PO20.1
                                                                 PO21.2  PO21.3
                                                                 ...

                         INSTHEADER FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Intrastat Dtl  INSTDETAIL

                            INH-COMPANY          -> ING-COMPANY
                            INH-FISCAL-YEAR      -> ING-FISCAL-YEAR
                            INH-INTRASTAT-NBR    -> ING-INTRASTAT-NBR
                                                    ING-MNT-LINE-NBR