TXVATRPTCD – VAT Report codes

System
Tax (TX)
Prefix
TVC
Primary key
COMPANY, VAT-RPT-ID, COUNTRY-CODE, VAT-SEQ-NBR, TAX-USAGE-CD
Fields
5
Updated by
2 programs
Referenced by
1 program

TXVATRPTCD is the VAT Report codes table in Lawson Tax (prefix TVC). It is indexed by COMPANY, VAT-RPT-ID, COUNTRY-CODE, VAT-SEQ-NBR, TAX-USAGE-CD (TVCSET1). It is updated by TX06.1 and TX06.2 and referenced by TX120. The table has 5 fields, 1 index and 0 documented relations.

About TXVATRPTCD

No description in the Lawson data dictionary.

Fields (5)

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

Field / columnTypeDescription & valuesUpdated by
TVC-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.2
TVC-VAT-RPT-ID PK
VAT_RPT_ID		Alpha 10The VAT Report ID for which a VAT report is generated.TX06.2
TVC-COUNTRY-CODE PK
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).TX06.2
TVC-VAT-SEQ-NBR PK
VAT_SEQ_NBR		Numeric 3The sequence number of the line on the report for which these tax codes are to be used.TX06.2
TVC-TAX-USAGE-CD PK
TAX_USAGE_CD		Alpha 10The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required.TX06.2

Indexes (1)

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

IndexKeysFlagsConditionUsed in
TVCSET1COMPANY, VAT-RPT-ID, COUNTRY-CODE, VAT-SEQ-NBR, TAX-USAGE-CDPrimaryTX06.1, TX06.2, TX120

Programs

Updated by (2)

Referenced by (1)