TXVATRPTDT – No description in the Lawson data dictionary

System: Tax (TX)
Prefix: TVD
Primary key: COMPANY, VAT-RPT-ID, COUNTRY-CODE, VAT-SEQ-NBR, VAT-BOX-NBR, SUM-SEQ-NBR
Fields: 7
Updated by: 2 programs
Referenced by: 1 program

TXVATRPTDT is a Lawson Tax table (prefix TVD); no description in the lawson data dictionary. It is indexed by COMPANY, VAT-RPT-ID, COUNTRY-CODE, VAT-SEQ-NBR, VAT-BOX-NBR, SUM-SEQ-NBR (TVDSET1). It is related 1:1 to TXVATRPTLN. It is updated by TX06.1 and TX06.4 and referenced by TX120. The table has 7 fields, 1 index and 1 documented relation.

About TXVATRPTDT

No description in the Lawson data dictionary.

Fields (7)

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

Field / column	Type	Description & values	Updated by
`TVD-COMPANY` PK COMPANY	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.4
`TVD-VAT-RPT-ID` PK VAT_RPT_ID	Alpha 10	The VAT Report ID for which a VAT report is generated.	TX06.4
`TVD-COUNTRY-CODE` PK COUNTRY_CODE	Alpha 2	The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).	TX06.4
`TVD-VAT-SEQ-NBR` PK VAT_SEQ_NBR	Numeric 3	The sequence number of the line on the report for which these tax codes are to be used.	TX06.4
`TVD-VAT-BOX-NBR` PK VAT_BOX_NBR	Alpha 3	The box number on the VAT report next to the line on which information from this line will be entered.	TX06.4
`TVD-SUM-SEQ-NBR` PK SUM_SEQ_NBR	Numeric 3	The sequence number of the line on the report for which these tax codes are to be used.	TX06.4
`TVD-SUMMARY-FLAG` SUMMARY_FLAG	Alpha 1	Defines if add on cost is printed in summary or at a detail level on the Lawson Purchase Order document.	TX06.4

Indexes (1)

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
`TVDSET1`	`COMPANY`, `VAT-RPT-ID`, `COUNTRY-CODE`, `VAT-SEQ-NBR`, `VAT-BOX-NBR`, `SUM-SEQ-NBR`	Primary		TX06.1, TX06.4, TX120

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Txvatrptln	TXVATRPTLN	Required		`TVD-COMPANY` → `TVL-COMPANY`, `TVD-VAT-RPT-ID` → `TVL-VAT-RPT-ID`, `TVD-COUNTRY-CODE` → `TVL-COUNTRY-CODE`, `TVD-VAT-SEQ-NBR` → `TVL-VAT-SEQ-NBR`

TXVATRPTDT – No description in the Lawson data dictionary

About TXVATRPTDT

Fields (7)

Indexes (1)

Relations

One to one (1) — lookups and parents

Programs

Updated by (2)

Referenced by (1)