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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
TVR-COMPANY PKCOMPANY | Numeric 4 | Identifies 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 PKVAT_RPT_ID | Alpha 10 | The VAT Report ID for which a VAT report is generated. | TX06.1, TX06.3 |
TVR-COUNTRY-CODE PKCOUNTRY_CODE | Alpha 2 | The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). | TX06.1, TX06.3 |
TVR-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | TX06.1 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
TVRSET1 | COMPANY, VAT-RPT-ID, COUNTRY-CODE | Primary | TX06.1, TX06.3, TX06.4, TX130 | |
TVRSET2 | COMPANY, VAT-RPT-ID | TX120 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Instctrycd | INSTCTRYCD | Required | TVR-COUNTRY-CODE → INT-COUNTRY-CODE | |
| Txcompany | TXCOMPANY | Required | TVR-COMPANY → TXC-COMPANY |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Vatrpt Lines | TXVATRPTLN | TVR-COMPANY → TVL-COMPANY, TVR-VAT-RPT-ID → TVL-VAT-RPT-ID, TVR-COUNTRY-CODE → TVL-COUNTRY-CODE, TVL-VAT-SEQ-NBR |