INSTHEADER – Intrastat Transaction Header

System
Tax (TX)
Prefix
INH
Primary key
COMPANY, FISCAL-YEAR, INTRASTAT-NBR
Fields
36
Updated by
225 programs
Referenced by
1 program

INSTHEADER is the Intrastat Transaction Header table in Lawson Tax (prefix INH). It is indexed by COMPANY, FISCAL-YEAR, INTRASTAT-NBR (INHSET1); alternate indexes: INHSET2 and INHSET3. It is related 1:M to INSTDETAIL. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 217 more and referenced by MA54.2. The table has 36 fields, 3 indexes and 1 documented relation.

About INSTHEADER

No description in the Lawson data dictionary.

Fields (36)

Column = COBOL field name without the INH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
INH-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4Contains the fiscal year for the data stored on this record.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-INTRASTAT-NBR PK
INTRASTAT_NBR		Numeric 12The number assigned by the Intrastat system to a transaction that involves Intrastat reporting after it has been added.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-REPORT-YEAR
REPORT_YEAR		Numeric 4The intrastat reporting year.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-REPORT-PERIOD
REPORT_PERIOD		Numeric 2The intrastat reporting period.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-TRANS-TYPE
TRANS_TYPE		Alpha 1Determines if amounts or units are processed in each transaction.
  • P Purchases(Arrivals)
  • S Sales(Dispatches)
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-SYSTEM-CD
SYSTEM_CD		Alpha 2This field indicates on what system the transaction originated.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-CUSTOMER
CUSTOMER		Alpha 9 (Right Justified)This field contains the number that represents a customer.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-DOCUMENT-NBR
DOCUMENT_NBR		Alpha 27The number assigned to the transaction (invoice, credit memo, etc.) for which the intrastat data was entered.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-NOTC
NOTC		Alpha 2The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-TAX-PNT-DATE
TAX_PNT_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-STATUS
STATUS		Numeric 1This field displays the status of the transaction.
  • 1 Open/Not Reported
  • 2 Reported
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-CUST-VAT-CTRY
CUST_VAT_CTRY		Alpha 2The country component of the customer's VAT registration number. Must be a valid country defined in IN01.1. (Country Maintenance)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-CUST-VAT-REG-N
CUST_VAT_REG_N		Alpha 12The number component of the customer's VAT registration number, assigned by the customer's governement.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-CUST-VAT-NBR
CUST_VAT_NBR		DerivedThe customer's VAT Registration Number, consisting of the concatenation of the VAT registration country and number.—
INH-CUST-CURR-CD
CUST_CURR_CD		Alpha 5The customers currency code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-VEND-VAT-CTRY
VEND_VAT_CTRY		Alpha 2The country component of the vendor's VAT registration number. Must be a valid country in IN01.1 (Country Maintenance)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-VEND-VAT-REG-N
VEND_VAT_REG_N		Alpha 12The number componenet of the vendor's VAT registration number, assigned by the vendor's governement.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-VEND-VAT-NBR
VEND_VAT_NBR		DerivedThe vendor's VAT Registration Number. It consists of the concatenation of the vendors country code and number.—
INH-VENDOR-CURR-CD
VENDOR_CURR_CD		Alpha 5Vendors currency code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-CURR-RATE
CURR_RATE		Signed 14.7The currency rate.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-ORIGIN-COUNTRY
ORIGIN_COUNTRY		Alpha 2The country from which the goods were shipped. Must be a valid country in IN01.1 (Country Maintenance)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-ORIGIN-REGION
ORIGIN_REGION		Alpha 2The region of the country from which the goods were shipped, if required. Must be a valid region in IN02.1 (Region Maintenance)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-LOADING-PORT
LOADING_PORT		Alpha 5The port where the goods are loaded, if required. The port code must be defined in IN04.1 (Port Maintenance)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-DEST-COUNTRY
DEST_COUNTRY		Alpha 2The country to which the goods were shipped. Must be a valid country in IN01.1 (Country Maintenance).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-DEST-REGION
DEST_REGION		Alpha 2The region of the country to which the goods were shipped, if required. Must be a valid region in IN02.1 (Region Maintenance)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-UNLOADING-PORT
UNLOADING_PORT		Alpha 5The prot where the goods are unloaded if required. Must be defined in IN04.1 (Port Maintenance)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-TRANSPORT-MODE
TRANSPORT_MODE		Alpha 1The mode of transportation at the border crossing. Code 7 is used for the Channel Tunnel.
  • 1 Sea
  • 2 Rail
  • 3 Road
  • 4 Air
  • 5 Post
  • 7 Fixed Installation
  • 8 Inland Waterway
  • 9 Own Propulsion
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-DLVRY-TRMS
DLVRY_TRMS		Alpha 3The terms of deliveryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-STAT-PROC
STAT_PROC		Alpha 6The statistical procedure code applied to the data. The code must be defined in IN06.1. (Statistical Procedure Maintenance).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-DROP-SHIP-IND
DROP_SHIP_IND		Alpha 1Specifies whether the shipment is a drop (triangulated) shipment, that is a shipment where goods are shipped from one EC country to another, but a principal in the transaction is based elsewhere.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-DELIVERY-DATE
DELIVERY_DATE		Numeric 8 (yyyymmdd)The date the goods were delivered, shipped or moved.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-PO-NUMBER
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-PO-RELEASE
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
INH-PO-CODE
PO_CODE		Alpha 4This is the purchase order code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
INHSET1COMPANY, FISCAL-YEAR, INTRASTAT-NBRPrimaryMA54.2, IN120, WH20.2, WH20.7
INHSET2COMPANY, REPORT-YEAR, REPORT-PERIOD, INTRASTAT-NBRKeyChangeIN120
INHSET3COMPANY, INTRASTAT-NBRAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
Intrastat DtlINSTDETAILINH-COMPANY → ING-COMPANY, INH-FISCAL-YEAR → ING-FISCAL-YEAR, INH-INTRASTAT-NBR → ING-INTRASTAT-NBR, → ING-MNT-LINE-NBR

Programs

Updated by (225)

Referenced by (1)