|
|
TXVATRPTDT FILE
REFERENCED BY
TX120
UPDATED BY
TX06.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TVD-COMPANY Numeric 4 TX06.4
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.
TVD-VAT-RPT-ID Alpha 10 TX06.4
Element: Vat Rpt Id The VAT Report ID for which a VAT report
is generated.
TVD-COUNTRY-CODE Alpha 2 TX06.4
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
TVD-VAT-SEQ-NBR Numeric 3 TX06.4
Element: Vat Seq Nbr The sequence number of the line on the
report for which these tax codes are to
be used.
TVD-VAT-BOX-NBR Alpha 3 TX06.4
Element: Vat Box Nbr The box number on the VAT report next to
the line on which information from this
line will be entered.
TVD-SUM-SEQ-NBR Numeric 3 TX06.4
Element: Vat Seq Nbr The sequence number of the line on the
report for which these tax codes are to
be used.
TVD-SUMMARY-FLAG Alpha 1 TX06.4
Element: Summary Flag Defines if add on cost is printed in
summary or at a detail level on the
Lawson Purchase Order document.
TXVATRPTDT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TVDSET1 COMPANY TX06.1 TX06.4
VAT-RPT-ID TX120
COUNTRY-CODE
VAT-SEQ-NBR
VAT-BOX-NBR
SUM-SEQ-NBR
TXVATRPTDT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
