TXVATRPT – VAT EC Sales list Tax Codes

System
Tax (TX)
Prefix
TVR
Primary key
COMPANY, VAT-RPT-ID, COUNTRY-CODE
Fields
4
Updated by
2 programs
Referenced by
2 programs

TXVATRPT is the VAT EC Sales list Tax Codes table in Lawson Tax (prefix TVR). It is indexed by COMPANY, VAT-RPT-ID, COUNTRY-CODE (TVRSET1); alternate indexes: TVRSET2. It is related 1:1 to INSTCTRYCD and TXCOMPANY and 1:M to TXVATRPTLN. It is updated by TX06.1 and TX06.3 and referenced by TX120 and TX130. The table has 4 fields, 2 indexes and 3 documented relations.

About TXVATRPT

No description in the Lawson data dictionary.

Fields (4)

Column = COBOL field name without the TVR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#TVR-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.TX06.1, TX06.3
#TVR-VAT-RPT-ID PK
VAT_RPT_ID		Alpha 10The VAT Report ID for which a VAT report is generated.TX06.1, TX06.3
#TVR-COUNTRY-CODE PK
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).TX06.1, TX06.3
#TVR-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.TX06.1

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TVRSET1
  1. COMPANY
  2. VAT-RPT-ID
  3. COUNTRY-CODE
PrimaryTX06.1, TX06.3, TX06.4, TX130
TVRSET2
  1. COMPANY
  2. VAT-RPT-ID
TX120

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
INSTCTRYCDTXCOMPANYTXVATRPTLNTXVATRPT

One to one (2) — lookups and parents

RelationTableRulesConditionField map
InstctrycdINSTCTRYCDRequired
TVR-COUNTRY-CODE→INT-COUNTRY-CODE
TxcompanyTXCOMPANYRequired
TVR-COMPANY→TXC-COMPANY

One to many (1) — child tables

RelationTableRulesConditionField map
Vatrpt LinesTXVATRPTLN
TVR-COMPANY→TVL-COMPANY
TVR-VAT-RPT-ID→TVL-VAT-RPT-ID
TVR-COUNTRY-CODE→TVL-COUNTRY-CODE
—→TVL-VAT-SEQ-NBR

Programs

Updated by (2)

Referenced by (2)