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 Code20
2 VAT Prod. Posting Group Code20
3 VAT Calculation Type Option
4 VAT % Decimal (0:5)
5 Unrealized VAT Type Option
6 Adjust for Payment Discount Boolean
7 Sales VAT Account Code20
8 Sales VAT Unreal. Account Code20
9 Purchase VAT Account Code20
10 Purch. VAT Unreal. Account Code20
11 Reverse Chrg. VAT Acc. Code20
12 Reverse Chrg. VAT Unreal. Acc. Code20
13 VAT Identifier Code20
14 EU Service Boolean
15 VAT Clause Code Code20
16 Certificate of Supply Required Boolean
17 Tax Category Code10
20 Description Text50
40 Used in Ledger Entries Integer Editable: No
FlowField

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field