INSTPORTS – No description in the Lawson data dictionary

System
Tax (TX)
Prefix
INX
Primary key
COUNTRY-CODE, PORT-CD
Fields
3
Updated by
1 program
Referenced by
230 programs

INSTPORTS is a Lawson Tax table (prefix INX); no description in the lawson data dictionary. It is indexed by COUNTRY-CODE, PORT-CD (INXSET1). It is updated by IN04.1 and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 222 more. The table has 3 fields, 1 index and 0 documented relations.

About INSTPORTS

No description in the Lawson data dictionary.

Fields (3)

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

Field / columnTypeDescription & valuesUpdated by
INX-COUNTRY-CODE PK
COUNTRY_CODE
Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).IN04.1
INX-PORT-CD PK
PORT_CD
Alpha 5The Intrastat port code. Must be define in IN04.1 (Port Maintenance)IN04.1
INX-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field displays the description.IN04.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
INXSET1COUNTRY-CODE, PORT-CDPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Programs

Updated by (1)

Referenced by (230)