TXVATRPT

VAT EC Sales list Tax Codes

REFERENCED BY
TX130 TX120


UPDATED BY
TX06.1 TX06.3

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TVR-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.1 TX06.3
TVR-VAT-RPT-ID
Element: Vat Rpt Id		Alpha 10
The VAT Report ID for which a VAT report is generated.
TX06.1 TX06.3
TVR-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.1 TX06.3
TVR-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
This field displays the description.
TX06.1


TXVATRPT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TVRSET1 COMPANY
VAT-RPT-ID
COUNTRY-CODE
TX06.1 TX06.3
TX06.4 TX130
TVRSET2 COMPANY
VAT-RPT-ID
TX120


TXVATRPT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Instctrycd INSTCTRYCD Required
TVR-COUNTRY-CODE->INT-COUNTRY-CODE
Txcompany TXCOMPANY Required
TVR-COMPANY->TXC-COMPANY


TXVATRPT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Vatrpt Lines TXVATRPTLN
TVR-COMPANY->TVL-COMPANY
TVR-VAT-RPT-ID->TVL-VAT-RPT-ID
TVR-COUNTRY-CODE->TVL-COUNTRY-CODE
  TVL-VAT-SEQ-NBR

File created: Thu Jun 09 02:33:19 2016

Home
Contact Us



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