TXVATRPTLN – VAT Report lines

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

TXVATRPTLN is the VAT Report lines table in Lawson Tax (prefix TVL). It is indexed by COMPANY, VAT-RPT-ID, COUNTRY-CODE, VAT-SEQ-NBR (TVLSET1). It is related 1:M to TXVATRPTCD and TXVATESLCD. It is updated by TX06.1 and TX06.2 and referenced by TX120. The table has 15 fields, 1 index and 2 documented relations.

About TXVATRPTLN

No description in the Lawson data dictionary.

Fields (15)

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

Field / column	Type	Description & values	Updated by
`TVL-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.1, TX06.2
`TVL-VAT-RPT-ID` PK VAT_RPT_ID	Alpha 10	The VAT Report ID for which a VAT report is generated.	TX06.1, TX06.2
`TVL-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.1, TX06.2
`TVL-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.1, TX06.2
`TVL-VAT-BOX-NBR` 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.1, TX06.2
`TVL-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field displays the description.	TX06.1
`TVL-SOURCE` SOURCE	Alpha 1	The source of the transaction. Input or output. Input transactions are Accounts Payable. Output transactions are Accounts Receivable.	TX06.1
`TVL-TAX-USG-IND` TAX_USG_IND	Alpha 1	Indicates whether the information for this line is to be obtained based on the tax code or the tax usage code on the TXTAXTRANS record.	TX06.1
`TVL-INV-CRD-IND` INV_CRD_IND	Alpha 1	Specified whether the transaction on which the tax was entered as an invoice or a credit memo. `I` Invoice `C` Credit Memo	TX06.1
`TVL-GDS-SVCS-IND` GDS_SVCS_IND	Alpha 1	Goods and services indicator.	TX06.1
`TVL-VAT-TYPE` VAT_TYPE	Alpha 1	Specifies the type of transaction the tax code is used for. `D` Domestic `E` Intra EEC `X` Export `I` Import	TX06.1
`TVL-CALC-TAX-IND` CALC_TAX_IND	Alpha 1	Cumulate tax indicator indicates whether this report line whould include the sum of the tax values for al tax transactions that meet the criteria Y N	TX06.1
`TVL-CALC-BASE-IND` CALC_BASE_IND	Alpha 1	Cumulate base indicator indicates if this report line should include the sum of the base values for all tax transactions. Y N	TX06.1
`TVL-PRINT-DTL-IND` PRINT_DTL_IND	Alpha 1	Print detail line indicates whether the report should include detail information for this line. If "Y", print detail when the report is generated. Y N	TX06.1
`TVL-STATUS` STATUS	Alpha 1	The status of the account. If Inactive, no posting can be done to the account.	TX06.1

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

Relations

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Vatrpt Codes	TXVATRPTCD			`TVL-COMPANY` → `TVC-COMPANY`, `TVL-VAT-RPT-ID` → `TVC-VAT-RPT-ID`, `TVL-COUNTRY-CODE` → `TVC-COUNTRY-CODE`, `TVL-VAT-SEQ-NBR` → `TVC-VAT-SEQ-NBR`, → `TVC-TAX-USAGE-CD`
Vatsales Codes	TXVATESLCD			`TVL-COMPANY` → `TVS-COMPANY`, `TVL-VAT-RPT-ID` → `TVS-VAT-RPT-ID`, `TVL-COUNTRY-CODE` → `TVS-COUNTRY-CODE`, → `TVS-TAX-CODE`

TXVATRPTLN – VAT Report lines

About TXVATRPTLN

Fields (15)

Indexes (1)

Relations

One to many (2) — child tables

Programs

Updated by (2)

Referenced by (1)