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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#TVL-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.1, TX06.2
#TVL-VAT-RPT-ID PK
VAT_RPT_ID		Alpha 10The VAT Report ID for which a VAT report is generated.TX06.1, TX06.2
#TVL-COUNTRY-CODE PK
COUNTRY_CODE		Alpha 2The 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 3The 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 3The 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 1The 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 1Indicates 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 1Specified 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 1Goods and services indicator.TX06.1
#TVL-VAT-TYPE
VAT_TYPE		Alpha 1Specifies 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 1Cumulate tax indicator indicates whether this report line whould include the sum of the tax values for al tax transactions that meet the criteria Y NTX06.1
#TVL-CALC-BASE-IND
CALC_BASE_IND		Alpha 1Cumulate base indicator indicates if this report line should include the sum of the base values for all tax transactions. Y NTX06.1
#TVL-PRINT-DTL-IND
PRINT_DTL_IND		Alpha 1Print detail line indicates whether the report should include detail information for this line. If "Y", print detail when the report is generated. Y NTX06.1
#TVL-STATUS
STATUS		Alpha 1The status of the account. If Inactive, no posting can be done to the account.TX06.1

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TVLSET1
  1. COMPANY
  2. VAT-RPT-ID
  3. COUNTRY-CODE
  4. VAT-SEQ-NBR
PrimaryTX06.1, TX06.2, TX06.4, TX120

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
TXVATRPTCDTXVATESLCDTXVATRPTLN

One to many (2) — child tables

RelationTableRulesConditionField map
Vatrpt CodesTXVATRPTCD
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 CodesTXVATESLCD
TVL-COMPANY→TVS-COMPANY
TVL-VAT-RPT-ID→TVS-VAT-RPT-ID
TVL-COUNTRY-CODE→TVS-COUNTRY-CODE
—→TVS-TAX-CODE

Programs

Updated by (2)

Referenced by (1)