Diagrams


Table

VAT Posting Setup

DynamicsDocs.comVAT Posting Setup«Table 325»VAT Posting SetupVAT Bus. Posting Group [PK]VAT Prod. Posting Group [PK]VAT Calculation Type; [Normal VAT,Reve...VAT %Unrealized VAT Type; [,Percentage,Firs...Adjust for Payment DiscountSales VAT AccountSales VAT Unreal. AccountPurchase VAT AccountPurch. VAT Unreal. AccountReverse Chrg. VAT Acc.Reverse Chrg. VAT Unreal. Acc.VAT IdentifierEU ServiceVAT Clause CodeCertificate of Supply RequiredTax CategoryDescriptionUsed in Ledger Entries«Table 323»VAT Business Posting GroupCode [PK,NN]DescriptionLast Modified Date TimeId«Table 324»VAT Product Posting GroupCode [PK,NN]DescriptionIdLast Modified DateTime«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Modified Date TimeLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc....«Table 560»VAT ClauseCode [PK,NN]DescriptionDescription 2Last Modified DateTimeId<VAT Bus. Posting Group><VAT Prod. Posting Group><Sales VAT Account><Sales VAT Unreal. Account><Purchase VAT Account><Purch. VAT Unreal. Account><Reverse Chrg. VAT Acc.><Reverse Chrg. VAT Unreal. Acc.><VAT Clause Code><VAT Bus. Posting Group><VAT Prod. Posting Group>

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) Code20
2 VAT Prod. Posting Group (VAT Prod. Posting Group) Code20
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) Code20
14 EU Service (EU Service) Boolean
15 VAT Clause Code (VAT Clause Code) Code20
16 Certificate of Supply Required (Certificate of Supply Required) Boolean
17 Tax Category (Tax Category) Code10
20 Description (Description) Text50
40 Used in Ledger Entries (Used in Ledger Entries) Integer Editable: No
FlowField

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