Diagrams


Table

VAT Amount Line

Fields

# Name Type
1 VAT % (VAT %) Decimal (0:5) Editable: No
2 VAT Base (VAT Base) Decimal Editable: No
3 VAT Amount (VAT Amount) Decimal
4 Amount Including VAT (Amount Including VAT) Decimal Editable: No
5 VAT Identifier (VAT Identifier) Code10 Editable: No
6 Line Amount (Line Amount) Decimal Editable: No
7 Inv. Disc. Base Amount (Inv. Disc. Base Amount) Decimal Editable: No
8 Invoice Discount Amount (Invoice Discount Amount) Decimal
9 VAT Calculation Type (VAT Calculation Type) Option Editable: No
10 Tax Group Code (Tax Group Code) Code10 Editable: No
11 Quantity (Quantity) Decimal (0:5) Editable: No
12 Modified (Modified) Boolean
13 Use Tax (Use Tax) Boolean
14 Calculated VAT Amount (Calculated VAT Amount) Decimal Editable: No
15 VAT Difference (VAT Difference) Decimal Editable: No
16 Positive (Positive) Boolean
17 Includes Prepayment (Includes Prepayment) Boolean
18 VAT Clause Code (VAT Clause Code) Code10
19 Tax Category (Tax Category) Code10

Keys

# Fields
0 VAT Identifier,VAT Calculation Type,Tax Group Code,Use Tax,Positive (VAT Identifier,VAT Calculation Type,Tax Group Code,Use Tax,Positive) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Tax Group Code (Tax Group Code) Tax Group Code (Code) 1..n
VAT Clause Code (VAT Clause Code) VAT Clause Code (Code) 1..n

Table Relations From Other Tables

From Table From Field