TXVATRPTDT

REFERENCED BY
TX120


UPDATED BY
TX06.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TVD-COMPANY
Element: 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
Element: Vat Rpt Id
Alpha 10
The VAT Report ID for which a VAT report is generated.
TX06.4
TVD-COUNTRY-CODE
Element: 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
Element: 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
Element: 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
Element: 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-SUMMARY-FLAG
Element: 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


TXVATRPTDT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TVDSET1 COMPANY
VAT-RPT-ID
COUNTRY-CODE
VAT-SEQ-NBR
VAT-BOX-NBR
SUM-SEQ-NBR
TX06.1 TX06.4
TX120


TXVATRPTDT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 11:29:36 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.