|
|
TXVATRPTLN FILE
VAT Report lines
REFERENCED BY
TX120
UPDATED BY
TX06.1 TX06.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TVL-COMPANY Numeric 4 TX06.1 TX06.2
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.
TVL-VAT-RPT-ID Alpha 10 TX06.1 TX06.2
Element: Vat Rpt Id The VAT Report ID for which a VAT report
is generated.
TVL-COUNTRY-CODE Alpha 2 TX06.1 TX06.2
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
TVL-VAT-SEQ-NBR Numeric 3 TX06.1 TX06.2
Element: Vat Seq Nbr The sequence number of the line on the
report for which these tax codes are to
be used.
TVL-VAT-BOX-NBR Alpha 3 TX06.1 TX06.2
Element: Vat Box Nbr The box number on the VAT report next to
the line on which information from this
line will be entered.
TVL-DESCRIPTION Alpha 30 (Lower Case) TX06.1
Element: Description This field displays the description.
TVL-SOURCE Alpha 1 TX06.1
Element: Source The source of the transaction. Input or
output. Input transactions are Accounts
Payable. Output transactions are
Accounts Receivable.
TVL-TAX-USG-IND Alpha 1 TX06.1
Element: Tax Usg Ind Indicates whether the information for
this line is to be obtained based on the
tax code or the tax usage code on the
TXTAXTRANS record.
TVL-INV-CRD-IND Alpha 1 TX06.1
Element: Inv Crd Ind Specified whether the transaction on
which the tax was entered as an invoice
or a credit memo.
I = Invoice
C = Credit Memo
TVL-GDS-SVCS-IND Alpha 1 TX06.1
Element: Gds Svcs Ind Goods and services indicator.
TVL-VAT-TYPE Alpha 1 TX06.1
Element: Vat Type Specifies the type of transaction the
tax code is used for.
D = Domestic
E = Intra EEC
X = Export
I = Import
TVL-CALC-TAX-IND Alpha 1 TX06.1
Element: Calc Tax Ind Cumulate tax indicator indicates whether
this report line whould include the sum
of the tax values for al tax
transactions that meet the criteria
Y
N
TVL-CALC-BASE-IND Alpha 1 TX06.1
Element: Calc Base Ind Cumulate base indicator indicates if
this report line should include the sum
of the base values for all tax
transactions.
Y
N
TVL-PRINT-DTL-IND Alpha 1 TX06.1
Element: Print Dtl Ind Print detail line indicates whether the
report should include detail information
for this line. If "Y", print detail
when the report is generated.
Y
N
TVL-STATUS Alpha 1 TX06.1
Element: Active Status The status of the account. If Inactive,
no posting can be done to the account.
TXVATRPTLN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TVLSET1 COMPANY TX06.1 TX06.2
VAT-RPT-ID TX06.4 TX120
COUNTRY-CODE
VAT-SEQ-NBR
TXVATRPTLN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Vatrpt Codes TXVATRPTCD
TVL-COMPANY -> TVC-COMPANY
TVL-VAT-RPT-ID -> TVC-VAT-RPT-ID
TVL-COUNTRY-CODE -> TVC-COUNTRY-CODE
TVL-VAT-SEQ-NBR -> TVC-VAT-SEQ-NBR
TVC-TAX-USAGE-CD
Vatsales Codes TXVATESLCD
TVL-COMPANY -> TVS-COMPANY
TVL-VAT-RPT-ID -> TVS-VAT-RPT-ID
TVL-COUNTRY-CODE -> TVS-COUNTRY-CODE
TVS-TAX-CODE
|
