Diagrams


Table

VAT Posting Setup

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 VAT Bus. Posting Group (VAT Bus. Posting Group) Code10
2 VAT Prod. Posting Group (VAT Prod. Posting Group) Code10
3 VAT Calculation Type (VAT Calculation Type) Option
4 VAT % (VAT %) Decimal (0:5)
5 Unrealized VAT Type (Unrealized VAT Type) Option
6 Adjust for Payment Discount (Adjust for Payment Discount) Boolean
7 Sales VAT Account (Sales VAT Account) Code20
8 Sales VAT Unreal. Account (Sales VAT Unreal. Account) Code20
9 Purchase VAT Account (Purchase VAT Account) Code20
10 Purch. VAT Unreal. Account (Purch. VAT Unreal. Account) Code20
11 Reverse Chrg. VAT Acc. (Reverse Chrg. VAT Acc.) Code20
12 Reverse Chrg. VAT Unreal. Acc. (Reverse Chrg. VAT Unreal. Acc.) Code20
13 VAT Identifier (VAT Identifier) Code10
14 EU Service (EU Service) Boolean
15 VAT Clause Code (VAT Clause Code) Code10
16 Certificate of Supply Required (Certificate of Supply Required) Boolean
17 Tax Category (Tax Category) Code10

Keys

# Fields
0 VAT Bus. Posting Group,VAT Prod. Posting Group (VAT Bus. Posting Group,VAT Prod. Posting Group) Clustered: Yes
1 VAT Prod. Posting Group,VAT Bus. Posting Group (VAT Prod. Posting Group,VAT Bus. Posting Group)

Table Relations To Other Tables

Field Related Table Related Field
Reverse Chrg. VAT Unreal. Acc. (Reverse Chrg. VAT Unreal. Acc.) G/L Account No. (No.) 1..n
VAT Bus. Posting Group (VAT Bus. Posting Group) VAT Business Posting Group Code (Code) 1..n
VAT Clause Code (VAT Clause Code) VAT Clause Code (Code) 1..n
VAT Prod. Posting Group (VAT Prod. Posting Group) VAT Product Posting Group Code (Code) 1..n

Table Relations From Other Tables

From Table From Field