INSTCTRYCD – Intrastat Country Codes

System
Tax (TX)
Prefix
INT
Primary key
COUNTRY-CODE
Fields
9
Updated by
2 programs
Referenced by
1537 programs

INSTCTRYCD is the Intrastat Country Codes table in Lawson Tax (prefix INT). It is indexed by COUNTRY-CODE (INTSET1). It is updated by IN01.1 and IN501 and referenced by AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 and 1529 more. The table has 9 fields, 1 index and 0 documented relations.

About INSTCTRYCD

No description in the Lawson data dictionary.

Fields (9)

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

Field / columnTypeDescription & valuesUpdated by
INT-COUNTRY-CODE PK
COUNTRY_CODE
Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).IN01.1, IN501
INT-EC-CTRY-NBR
EC_CTRY_NBR
Numeric 3The European Community Country number; leave blank if not a member of the European Community.IN01.1, IN501
INT-ISO-CTRY-NBR
ISO_CTRY_NBR
Numeric 3The ISO country number.IN01.1, IN501
INT-COUNTRY-DESC
COUNTRY_DESC
Alpha 30 (Lower Case)IN01.1, IN501
INT-EC-FLAG
EC_FLAG
Alpha 1Set to Y if the country is a member of the European Community. Used for Intrastat processing.
  • Y Country is a member of EC
  • N Ctry is not a member of EC
IN01.1, IN501
INT-ADDR-FORMAT
ADDR_FORMAT
Numeric 2
  • 01 Address Format 1
  • 02 Address Format 2
  • 03 Address Format 3
  • 04 Address Format 4
  • 05 Address Format 5
  • 06 Address Format 6
  • 07 Address Format 7
  • 08 Address Format 8
  • 09 Address Format 9
  • 10 Address Format 10
IN01.1, IN501
INT-NGA-CTRY-CODE
NGA_CTRY_CODE
Alpha 2IN01.1, IN501
INT-ISO-CTRY-CODE
ISO_CTRY_CODE
Alpha 3IN01.1, IN501
INT-CHK-DIG-TYPE
CHK_DIG_TYPE
Alpha 10IN01.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
INTSET1COUNTRY-CODEPrimaryAC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +22 more (list truncated in source)

Programs

Updated by (2)

Referenced by (1537)