INSTNBR – Intrastat Company Numbers

System
Tax (TX)
Prefix
INB
Primary key
COMPANY, FISCAL-YEAR
Fields
3
Updated by
224 programs
Referenced by
0 programs

INSTNBR is the Intrastat Company Numbers table in Lawson Tax (prefix INB). It is indexed by COMPANY, FISCAL-YEAR (INBSET1); alternate indexes: INBSET2. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 216 more. The table has 3 fields, 2 indexes and 0 documented relations.

About INSTNBR

No description in the Lawson data dictionary.

Fields (3)

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

Field / columnTypeDescription & valuesUpdated by
INB-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)
INB-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)
INB-INTRASTAT-NBR
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)

Indexes (2)

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

IndexKeysFlagsConditionUsed in
INBSET1COMPANY, FISCAL-YEARPrimary—
INBSET2COMPANY, INTRASTAT-NBRKeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Programs

Updated by (224)