 |
Lawson Insight Technical Documentation |
|
INSTHEADER FILE
Intrastat Transaction Header
UPDATED BY
API1.1 POIJ.1 IN120 IN20.1 WH130 WH33.5
WH34.1 WH34.2 WH34.3 WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
INH-COMPANY Numeric 4 API1.1 IN20.1
Company The company number represents an POIJ.1 WH130
established company and is entered on WH33.5 WH34.1
all function codes. WH34.2 WH34.3
WH34.4
INH-FISCAL-YEAR Numeric 4 API1.1 IN20.1
Fiscal Year This is the current fiscal year. This POIJ.1 WH130
field is updated by Period Closing WH33.5 WH34.1
(GL199). WH34.2 WH34.3
WH34.4
INH-INTRASTAT-NBR Numeric 12 API1.1 IN20.1
Intrastat Nbr The number assigned by the Intrastat POIJ.1 WH130
system to a transaction that involves WH33.5 WH34.1
Intrastat reporting after it has been WH34.2 WH34.3
added. WH34.4
INH-REPORT-YEAR Numeric 4 API1.1 IN120
Report Year The intrastat reporting year. IN20.1 POIJ.1
WH130 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
INH-REPORT-PERIOD Numeric 2 API1.1 IN120
Report Period The intrastat reporting period. IN20.1 POIJ.1
WH130 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
INH-TRANS-TYPE Alpha 1 API1.1 IN20.1
Transaction Type Determines if amounts or units are POIJ.1 WH130
processed in each transaction. WH33.5 WH34.1
P = Purchases(Arrivals) WH34.2 WH34.3
S = Sales(Dispatches) WH34.4
INH-SYSTEM-CD Alpha 2 API1.1 IN20.1
System Code This field indicates on what system the POIJ.1 WH130
transaction originated. WH33.5 WH34.1
WH34.2 WH34.3
WH34.4
INH-CUSTOMER Alpha 9 (Right Justified) API1.1 IN20.1
Customer Number This field contains the number that POIJ.1 WH130
represents a customer. WH33.5 WH34.1
WH34.2 WH34.3
WH34.4
INH-VENDOR Alpha 9 (Right Justified) API1.1 IN20.1
Vendor ID The vendor's identification code. POIJ.1 WH130
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4
INH-DOCUMENT-NBR Alpha 27 API1.1 IN20.1
Document Number The number assigned to the transaction POIJ.1 WH130
(invoice, credit memo, etc.) for which WH33.5 WH34.1
the intrastat data was entered. WH34.2 WH34.3
WH34.4
INH-NOTC Alpha 2 API1.1 IN20.1
Notc The Nature of Transaction code. Must POIJ.1 WH130
be a valid code defined in IN07.1 (NOTC WH33.5 WH34.1
Maintenance). WH34.2 WH34.3
WH34.4
INH-TAX-PNT-DATE Numeric 8 (yyyymmdd) API1.1 IN20.1
Tax Point Date Date goods were delivered or invoiced. POIJ.1 WH130
At time of Payment or when Invoiced. WH33.5 WH34.1
If no date is entered, the system date WH34.2 WH34.3
defaults. WH34.4
INH-STATUS Numeric 1 API1.1 IN120
Status This field displays the status of the IN20.1 POIJ.1
transaction. WH130 WH33.5
1 = Open/Not Reported WH34.1 WH34.2
2 = Reported WH34.3 WH34.4
INH-CUST-VAT-CTRY Alpha 2 API1.1 IN20.1
Cust Vat Ctry The country component of the customer's POIJ.1 WH130
VAT registration number. Must be a WH33.5 WH34.1
valid country defined in IN01.1. WH34.2 WH34.3
(Country Maintenance) WH34.4
INH-CUST-VAT-REG-N Alpha 12 API1.1 IN20.1
Cust Vat Reg N The number component of the customer's POIJ.1 WH130
VAT registration number, assigned by the WH33.5 WH34.1
customer's governement. WH34.2 WH34.3
WH34.4
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 API1.1 IN20.1
Cust Curr Cd The customers currency code. POIJ.1 WH130
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4
INH-VEND-VAT-CTRY Alpha 2 API1.1 IN20.1
Vend Vat Ctry The country component of the vendor's POIJ.1 WH130
VAT registration number. Must be a valid WH33.5 WH34.1
country in IN01.1 (Country Maintenance) WH34.2 WH34.3
WH34.4
INH-VEND-VAT-REG-N Alpha 12 API1.1 IN20.1
Vend Vat Reg N The number componenet of the vendor's POIJ.1 WH130
VAT registration number, assigned by the WH33.5 WH34.1
vendor's governement. WH34.2 WH34.3
WH34.4
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 API1.1 IN20.1
Vendor Curr Cd Vendors currency code. POIJ.1 WH130
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4
INH-CURR-RATE Signed 13.6 API1.1 IN20.1
Currency Rate The currency rate. POIJ.1 WH130
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4
INH-ORIGIN-COUNTRY Alpha 2 API1.1 IN20.1
Origin Country The country from which the goods were POIJ.1 WH130
shipped. Must be a valid country in WH33.5 WH34.1
IN01.1 (Country Maintenance) WH34.2 WH34.3
WH34.4
INH-ORIGIN-REGION Alpha 2 API1.1 IN20.1
Origin Region The region of the country from which the POIJ.1 WH130
goods were shipped, if required. Must be WH33.5 WH34.1
a valid region in IN02.1 (Region WH34.2 WH34.3
Maintenance) WH34.4
INH-LOADING-PORT Alpha 5 API1.1 IN20.1
Loading Port The port where the goods are loaded, if POIJ.1 WH130
required. The port code must be defined WH33.5 WH34.1
in IN04.1 (Port Maintenance) WH34.2 WH34.3
WH34.4
INH-DEST-COUNTRY Alpha 2 API1.1 IN20.1
Dest Country The country to which the goods were POIJ.1 WH130
shipped. Must be a valid country in WH33.5 WH34.1
IN01.1 (Country Maintenance). WH34.2 WH34.3
WH34.4
INH-DEST-REGION Alpha 2 API1.1 IN20.1
Dest Region The region of the country to which the POIJ.1 WH130
goods were shipped, if required. Must WH33.5 WH34.1
be a valid region in IN02.1 (Region WH34.2 WH34.3
Maintenance) WH34.4
INH-UNLOADING-PORT Alpha 5 API1.1 IN20.1
Unloading Port The prot where the goods are unloaded if POIJ.1 WH130
required. Must be defined in IN04.1 WH33.5 WH34.1
(Port Maintenance) WH34.2 WH34.3
WH34.4
INH-TRANSPORT-MODE Alpha 1 API1.1 IN20.1
Transport Mode The mode of transportation at the POIJ.1 WH130
border crossing. Code 7 is used for the WH33.5 WH34.1
Channel Tunnel. WH34.2 WH34.3
WH34.4
1 = Sea
2 = Rail
3 = Road
4 = Air
5 = Post
7 = Fixed Installation
8 = Inland Waterway
9 = Own Propulsion
INH-DLVRY-TRMS Alpha 1 API1.1 IN20.1
Dlvry Trms The terms of delivery POIJ.1 WH130
1 = EXW WH33.5 WH34.1
2 = FDB WH34.2 WH34.3
3 = CIF WH34.4
4 = DDU
5 = CFR
6 = CIP
9 = XXX
INH-STAT-PROC Alpha 6 API1.1 IN20.1
Stat Proc The statistical procedure code applied POIJ.1 WH130
to the data. The code must be defined WH33.5 WH34.1
in IN06.1. (Statistical Procedure WH34.2 WH34.3
Maintenance). WH34.4
INH-DROP-SHIP-IND Alpha 1 API1.1 IN20.1
Drop Ship Ind Specifies whether the shipment is a POIJ.1 WH130
drop (triangulated) shipment, that is a WH33.5 WH34.1
shipment where goods are shipped from WH34.2 WH34.3
one EC country to another, but a WH34.4
principal in the transaction is based
elsewhere.
INH-DELIVERY-DATE Numeric 8 (yyyymmdd) API1.1 POIJ.1
Delivery Date The date the goods were delivered, WH130 WH33.5
shipped or moved. WH34.1 WH34.2
WH34.3 WH34.4
INH-PO-NUMBER Alpha 14 (Right Justified) API1.1 POIJ.1
PO Number This field contains the number WH130 WH33.5
representing the purchase order. WH34.1 WH34.2
WH34.3 WH34.4
INH-PO-RELEASE Numeric 4 API1.1 POIJ.1
PO Release Number Used to identify a purchase order WH130 WH33.5
release (created from a Blanket or WH34.1 WH34.2
Standing order). WH34.3 WH34.4
INH-PO-CODE Alpha 4 API1.1 POIJ.1
Po Code This is the purchase order code. WH130 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
INSTHEADER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
INHSET1 COMPANY IN120
FISCAL-YEAR
INTRASTAT-NBR
INHSET2 COMPANY KeyChange, Duplicates IN120
REPORT-YEAR
REPORT-PERIOD
INTRASTAT-NBR
INHSET3 COMPANY API1.1 POIJ.1
INTRASTAT-NBR IN20.1 WH130
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4
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
|