|
|
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
Element: Company 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.
TVR-VAT-RPT-ID Alpha 10 TX06.1 TX06.3
Element: Vat Rpt Id The VAT Report ID for which a VAT report
is generated.
TVR-COUNTRY-CODE Alpha 2 TX06.1 TX06.3
Element: 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
Element: 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 TX120
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
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
|
