INSTDETAIL – Intrastat Detail Transactions

System
Tax (TX)
Prefix
ING
Primary key
COMPANY, FISCAL-YEAR, INTRASTAT-NBR, MNT-LINE-NBR
Fields
10
Updated by
224 programs
Referenced by
2 programs

INSTDETAIL is the Intrastat Detail Transactions table in Lawson Tax (prefix ING). It is indexed by COMPANY, FISCAL-YEAR, INTRASTAT-NBR, MNT-LINE-NBR (INGSET1); alternate indexes: INGSET2. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 216 more and referenced by IN120 and MA54.2. The table has 10 fields, 2 indexes and 0 documented relations.

About INSTDETAIL

No description in the Lawson data dictionary.

Fields (10)

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

Field / columnTypeDescription & valuesUpdated by
ING-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)
ING-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)
ING-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)
ING-MNT-LINE-NBR PK
MNT_LINE_NBR		Numeric 4Line number for the distribution line.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
ING-BASE-AMT
BASE_AMT		Signed 18.2—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
ING-ICN-CODE
ICN_CODE		Alpha 8—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
ING-WEIGHT
WEIGHT		Signed 9.3This field contains the unit weight of the item based on the stocking UOM.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
ING-RECEIVED-AMT
RECEIVED_AMT		Signed 18.2—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
ING-SUPLMNTARY-UOM
SUPLMNTARY_UOM		Alpha 4This field contains the valid stock unit of measure for this item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
ING-SUPLMNTARY-QTY
SUPLMNTARY_QTY		Signed 13.4This field contains the desired quantity.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (2)

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

IndexKeysFlagsConditionUsed in
INGSET1COMPANY, FISCAL-YEAR, INTRASTAT-NBR, MNT-LINE-NBRPrimaryMA54.2, IN120
INGSET2COMPANY, INTRASTAT-NBR, MNT-LINE-NBRAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Programs

Updated by (224)

Referenced by (2)