Lawson Insight Technical Documentation |
|
INSTHEADER
INSTHEADER FILE
Intrastat Transaction Header
REFERENCED BY
MA54.2
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.1 AP30.2 AP30.4
AP520 API1.1 AR42.1 AR42.2 AR42.7 AR43.1
AR560 BL120 BL122 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.1 MA180 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.7 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA66.3
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PO100 PO101 PO122
PO131 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 POI3.1 POID.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
Element: Company Identifies the AP company if the AP131 AP20.1
resource type = V. Identifies the HR AP20.2 AP20.3
company if the resource type = E. It is AP20.4 AP20.5
blank for type A, P or Q resources. AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-FISCAL-YEAR Numeric 4 AP125 AP126
Element: Year Contains the fiscal year for the data AP131 AP20.1
stored on this record. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-INTRASTAT-NBR Numeric 12 AP125 AP126
Element: Intrastat Nbr The number assigned by the Intrastat AP131 AP20.1
system to a transaction that involves AP20.2 AP20.3
Intrastat reporting after it has been AP20.4 AP20.5
added. AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-REPORT-YEAR Numeric 4 AP125 AP126
Element: Report Year The intrastat reporting year. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN120
IN20.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
...
INH-REPORT-PERIOD Numeric 2 AP125 AP126
Element: Report Period The intrastat reporting period. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN120
IN20.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
...
INH-TRANS-TYPE Alpha 1 AP125 AP126
Element: Trans Type Determines if amounts or units are AP131 AP20.1
processed in each transaction. AP20.2 AP20.3
P = Purchases(Arrivals) AP20.4 AP20.5
S = Sales(Dispatches) AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-SYSTEM-CD Alpha 2 AP125 AP126
Element: System Cd This field indicates on what system the AP131 AP20.1
transaction originated. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-CUSTOMER Alpha 9 (Right Justified) AP125 AP126
Element: Customer This field contains the number that AP131 AP20.1
represents a customer. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-VENDOR Alpha 9 (Right Justified) AP125 AP126
Element: Vendor The vendor's identification code. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-DOCUMENT-NBR Alpha 27 AP125 AP126
Element: Document Nbr The number assigned to the transaction AP131 AP20.1
(invoice, credit memo, etc.) for which AP20.2 AP20.3
the intrastat data was entered. AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-NOTC Alpha 2 AP125 AP126
Element: Notc The Nature of Transaction code. Must AP131 AP20.1
be a valid code defined in IN07.1 (NOTC AP20.2 AP20.3
Maintenance). AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-TAX-PNT-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field displays the system date AP131 AP20.1
when this was created. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-STATUS Numeric 1 AP125 AP126
Element: Status This field displays the status of the AP131 AP20.1
transaction. AP20.2 AP20.3
1 = Open/Not Reported AP20.4 AP20.5
2 = Reported AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN120
IN20.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
...
INH-CUST-VAT-CTRY Alpha 2 AP125 AP126
Element: Cust Vat Ctry The country component of the customer's AP131 AP20.1
VAT registration number. Must be a AP20.2 AP20.3
valid country defined in IN01.1. AP20.4 AP20.5
(Country Maintenance) AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-CUST-VAT-REG-N Alpha 12 AP125 AP126
Element: Cust Vat Reg NThe number component of the customer's AP131 AP20.1
VAT registration number, assigned by the AP20.2 AP20.3
customer's governement. AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-CUST-VAT-NBR Derived
Element: 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
Element: Cust Curr Cd The customers currency code. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-VEND-VAT-CTRY Alpha 2 AP125 AP126
Element: Vend Vat Ctry The country component of the vendor's AP131 AP20.1
VAT registration number. Must be a valid AP20.2 AP20.3
country in IN01.1 (Country Maintenance) AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-VEND-VAT-REG-N Alpha 12 AP125 AP126
Element: Vend Vat Reg NThe number componenet of the vendor's AP131 AP20.1
VAT registration number, assigned by the AP20.2 AP20.3
vendor's governement. AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-VEND-VAT-NBR Derived
Element: 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
Element: Vendor Curr CdVendors currency code. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-CURR-RATE Signed 14.7 AP125 AP126
Element: Curr Rate The currency rate. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-ORIGIN-COUNTRY Alpha 2 AP125 AP126
Element: Origin CountryThe country from which the goods were AP131 AP20.1
shipped. Must be a valid country in AP20.2 AP20.3
IN01.1 (Country Maintenance) AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-ORIGIN-REGION Alpha 2 AP125 AP126
Element: Origin Region The region of the country from which the AP131 AP20.1
goods were shipped, if required. Must be AP20.2 AP20.3
a valid region in IN02.1 (Region AP20.4 AP20.5
Maintenance) AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-LOADING-PORT Alpha 5 AP125 AP126
Element: Loading Port The port where the goods are loaded, if AP131 AP20.1
required. The port code must be defined AP20.2 AP20.3
in IN04.1 (Port Maintenance) AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-DEST-COUNTRY Alpha 2 AP125 AP126
Element: Dest Country The country to which the goods were AP131 AP20.1
shipped. Must be a valid country in AP20.2 AP20.3
IN01.1 (Country Maintenance). AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-DEST-REGION Alpha 2 AP125 AP126
Element: Dest Region The region of the country to which the AP131 AP20.1
goods were shipped, if required. Must AP20.2 AP20.3
be a valid region in IN02.1 (Region AP20.4 AP20.5
Maintenance) AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-UNLOADING-PORT Alpha 5 AP125 AP126
Element: Unloading PortThe prot where the goods are unloaded AP131 AP20.1
if required. Must be defined in IN04.1 AP20.2 AP20.3
(Port Maintenance) AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-TRANSPORT-MODE Alpha 1 AP125 AP126
Element: Transport ModeThe mode of transportation at the AP131 AP20.1
border crossing. Code 7 is used for the AP20.2 AP20.3
Channel Tunnel. AP20.4 AP20.5
AP20.7 AP21.1
1 = Sea AP23.1 AP25.1
2 = Rail AP25.2 AP26.1
3 = Road AP27.1 AP30.1
4 = Air AP30.2 AP30.4
5 = Post AP520 API1.1
7 = Fixed Installation AR42.1 AR42.2
8 = Inland Waterway AR42.7 AR43.1
9 = Own Propulsion AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-DLVRY-TRMS Alpha 3 AP125 AP126
Element: Dlvry Trms The terms of delivery AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-STAT-PROC Alpha 6 AP125 AP126
Element: Stat Proc The statistical procedure code applied AP131 AP20.1
to the data. The code must be defined AP20.2 AP20.3
in IN06.1. (Statistical Procedure AP20.4 AP20.5
Maintenance). AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-DROP-SHIP-IND Alpha 1 AP125 AP126
Element: Drop Ship Ind Specifies whether the shipment is a AP131 AP20.1
drop (triangulated) shipment, that is a AP20.2 AP20.3
shipment where goods are shipped from AP20.4 AP20.5
one EC country to another, but a AP20.7 AP21.1
principal in the transaction is based AP23.1 AP25.1
elsewhere. AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-DELIVERY-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Delivery Date The date the goods were delivered, AP131 AP20.1
shipped or moved. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IN20.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
...
INH-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
Element: Po Number This field contains the number AP131 AP20.1
representing the purchase order. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
INH-PO-RELEASE Numeric 4 AP125 AP126
Element: Po Release Used to identify a purchase order AP131 AP20.1
release (created from a Blanket or AP20.2 AP20.3
Standing order). AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
INH-PO-CODE Alpha 4 AP125 AP126
Element: Po Code This is the purchase order code. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
INSTHEADER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
INHSET1 COMPANY BL120 BL122
FISCAL-YEAR BL130 BL20.1
INTRASTAT-NBR BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA54.2 IN120
WH20.2 WH20.7
INHSET2 COMPANY KeyChange IN120
REPORT-YEAR
REPORT-PERIOD
INTRASTAT-NBR
INHSET3 COMPANY AP125 AP126
INTRASTAT-NBR AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 BL120
BL122 BL130
BL20.1 BL20.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
|