TXVATRPT FILE
VAT Report definitions
REFERENCED BY
TX120 TX130
UPDATED BY
TX06.1 TX06.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TVR-COMPANY Numeric 4 TX06.1 TX06.3
Company The company number represents an
established company and is entered on
all function codes.
TVR-VAT-RPT-ID Alpha 10 TX06.1 TX06.3
Vat Rpt Id The VAT Report ID for which a VAT report
is generated.
TVR-COUNTRY-CODE Alpha 2 TX06.1 TX06.3
Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
TVR-DESCRIPTION Alpha 30 (Lower Case) TX06.1
Description This field displays the description.
TXVATRPT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TVRSET1 COMPANY TX06.1 TX06.3
VAT-RPT-ID TX120 TX130
COUNTRY-CODE
TVRSET2 COMPANY
VAT-RPT-ID
TXVATRPT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Instctrycd INSTCTRYCD Required
TVR-COUNTRY-CODE -> INT-COUNTRY-CODE (INTSET1)
Txcompany TXCOMPANY Required
TVR-COMPANY -> TXC-COMPANY
TXVATRPT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|
