VAT Report lines
REFERENCED BY
TX120 |
TX06.1 | TX06.2 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
TVL-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. |
|
||
TVL-VAT-RPT-ID Element: Vat Rpt Id | Alpha 10 The VAT Report ID for which a VAT report is generated. |
|
||
TVL-COUNTRY-CODE Element: Country Code | Alpha 2 The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). |
|
||
TVL-VAT-SEQ-NBR Element: Vat Seq Nbr | Numeric 3 The sequence number of the line on the report for which these tax codes are to be used. |
|
||
TVL-VAT-BOX-NBR Element: Vat Box Nbr | Alpha 3 The box number on the VAT report next to the line on which information from this line will be entered. |
|
||
TVL-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
||
TVL-SOURCE Element: Source | Alpha 1 The source of the transaction. Input or output. Input transactions are Accounts Payable. Output transactions are Accounts Receivable. |
|
||
TVL-TAX-USG-IND Element: Tax Usg Ind | Alpha 1 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 Element: Inv Crd Ind | Alpha 1 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 Element: Gds Svcs Ind | Alpha 1 Goods and services indicator. |
|
||
TVL-VAT-TYPE Element: Vat Type | Alpha 1 Specifies the type of transaction the tax code is used for. D = Domestic E = Intra EEC X = Export I = Import |
|
||
TVL-CALC-TAX-IND Element: Calc Tax Ind | Alpha 1 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 Element: Calc Base Ind | Alpha 1 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 Element: Print Dtl Ind | Alpha 1 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 Element: Active Status | Alpha 1 The status of the account. If Inactive, no posting can be done to the account. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
TVLSET1 |
COMPANY VAT-RPT-ID COUNTRY-CODE VAT-SEQ-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Vatrpt Codes | TXVATRPTCD |
| |||||||||||||||
Vatsales Codes | TXVATESLCD |
|
All trademarks and registered trademarks are the property of their
respective owners.