TXVATESLCD – VAT EC Sales codes

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

TXVATESLCD is the VAT EC Sales codes table in Lawson Tax (prefix TVS). It is indexed by COMPANY, VAT-RPT-ID, COUNTRY-CODE, TAX-CODE (TVSSET1); alternate indexes: TVSSET2. It is updated by TX06.1 and TX06.3 and referenced by TX130. The table has 4 fields, 2 indexes and 0 documented relations.

About TXVATESLCD

No description in the Lawson data dictionary.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
TVS-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.3
TVS-VAT-RPT-ID PK
VAT_RPT_ID		Alpha 10The VAT Report ID for which a VAT report is generated.TX06.3
TVS-COUNTRY-CODE PK
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).TX06.3
TVS-TAX-CODE PK
TAX_CODE		Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.TX06.3

Indexes (2)

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

IndexKeysFlagsConditionUsed in
TVSSET1COMPANY, VAT-RPT-ID, COUNTRY-CODE, TAX-CODEPrimaryTX06.1, TX06.3, TX130
TVSSET2COMPANY, VAT-RPT-ID, TAX-CODE—

Programs

Updated by (2)

Referenced by (1)