Diagrams


Table

Tax Jurisdiction

DynamicsDocs.comTax Jurisdiction«Table 320»Tax JurisdictionCode [PK,NN]DescriptionTax Account [Sales]Tax Account [Purchases]Report-to JurisdictionDate FilterTax Group FilterUnreal. Tax Acc. [Sales]Unreal. Tax Acc. [Purchases]Reverse Charge [Purchases]Unreal. Rev. Charge [Purch.]Unrealized VAT Type; [,Percentage,Firs...Calculate Tax on TaxAdjust for Payment Discount«Table 254»VAT EntryEntry No. [PK]Gen. Bus. Posting GroupGen. Prod. Posting GroupPosting DateDocument No.Document Type; [,Payment,Invoice,Credi...Type; [,Purchase,Sale,Settlement]BaseAmountVAT Calculation Type; [Normal VAT,Reve...Bill-to/Pay-to No.EU 3-Party TradeUser IDSource CodeReason CodeClosed by Entry No.ClosedCountry/Region CodeInternal Ref. No.Transaction No.Unrealized AmountUnrealized BaseRemaining Unrealized AmountRemaining Unrealized BaseExternal Document No.No. SeriesTax Area CodeTax LiableTax Group CodeUse TaxTax Jurisdiction Code...«Table 256»VAT Statement LineStatement Template Name [PK]Statement Name [PK]Line No. [PK]Row No.DescriptionType; [Account Totaling,VAT Entry Tota...Account TotalingGen. Posting Type; [,Purchase,Sale,Set...VAT Bus. Posting GroupVAT Prod. Posting GroupRow TotalingAmount Type; [,Amount,Base,Unrealized...Calculate with; [Sign,Opposite Sign]PrintPrint with; [Sign,Opposite Sign]Date FilterNew PageTax Jurisdiction CodeUse Tax«Table 319»Tax Area LineTax Area [PK]Tax Jurisdiction Code [PK,NN]Jurisdiction DescriptionCalculation Order«Table 322»Tax DetailTax Jurisdiction Code [PK,NN]Tax Group Code [PK]Tax Type; [Sales Tax,Excise Tax] [PK]Maximum Amount/Qty.Tax Below MaximumTax Above MaximumEffective Date [PK]Calculate Tax on Tax«Table 379»Detailed Cust. Ledg. EntryEntry No. [PK]Cust. Ledger Entry No.Entry Type; [,Initial Entry,Applicatio...Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.AmountAmount [LCY]Customer No.Currency CodeUser IDSource CodeTransaction No.Journal Batch NameReason CodeDebit AmountCredit AmountDebit Amount [LCY]Credit Amount [LCY]Initial Entry Due DateInitial Entry Global Dim. 1Initial Entry Global Dim. 2Gen. Bus. Posting GroupGen. Prod. Posting GroupUse TaxVAT Bus. Posting GroupVAT Prod. Posting GroupInitial Document Type; [,Payment,Invoi...Applied Cust. Ledger Entry No.UnappliedUnapplied by Entry No....«Table 380»Detailed Vendor Ledg. EntryEntry No. [PK]Vendor Ledger Entry No.Entry Type; [,Initial Entry,Applicatio...Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.AmountAmount [LCY]Vendor No.Currency CodeUser IDSource CodeTransaction No.Journal Batch NameReason CodeDebit AmountCredit AmountDebit Amount [LCY]Credit Amount [LCY]Initial Entry Due DateInitial Entry Global Dim. 1Initial Entry Global Dim. 2Gen. Bus. Posting GroupGen. Prod. Posting GroupUse TaxVAT Bus. Posting GroupVAT Prod. Posting GroupInitial Document Type; [,Payment,Invoi...Applied Vend. Ledger Entry No.UnappliedUnapplied by Entry No....«Table 383»Detailed CV Ledg. Entry BufferEntry No. [PK]CV Ledger Entry No.Entry Type; [,Initial Entry,Applicatio...Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.AmountAmount [LCY]CV No.Currency CodeUser IDSource CodeTransaction No.Journal Batch NameReason CodeDebit AmountCredit AmountDebit Amount [LCY]Credit Amount [LCY]Initial Entry Due DateInitial Entry Global Dim. 1Initial Entry Global Dim. 2Gen. Posting Type; [,Purchase,Sale,Set...Gen. Bus. Posting GroupGen. Prod. Posting GroupTax Area CodeTax LiableTax Group CodeUse TaxVAT Bus. Posting GroupVAT Prod. Posting Group...«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeIncome/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc.Business Unit Filter...«Table 321»Tax GroupCode [PK,NN]Description<Tax Account (Sales)><Tax Account (Purchases)><Unreal. Tax Acc. (Sales)><Unreal. Tax Acc. (Purchases)><Reverse Charge (Purchases)><Unreal. Rev. Charge (Purch.)><Report-to Jurisdiction><Tax Group Filter><Tax Jurisdiction Code><Tax Jurisdiction Code><Tax Jurisdiction Code><Tax Jurisdiction Code><Tax Jurisdiction Code><Tax Jurisdiction Code><Tax Jurisdiction Code><Closed by Entry No.><Unrealized VAT Entry No.><Reversed by Entry No.><Reversed Entry No.><Tax Group Code><Tax Group Used><Tax Group Code><Unapplied by Entry No.><Unapplied by Entry No.><Tax Group Code><Tax Group Code>

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

Fields

# Name Type
1 Code (Code) Code10 NotBlank: Yes
2 Description (Description) Text50
3 Tax Account (Sales) (Tax Account (Sales)) Code20
4 Tax Account (Purchases) (Tax Account (Purchases)) Code20
5 Report-to Jurisdiction (Report-to Jurisdiction) Code10
6 Date Filter (Date Filter) Date FlowFilter
7 Tax Group Filter (Tax Group Filter) Code10 FlowFilter
8 Unreal. Tax Acc. (Sales) (Unreal. Tax Acc. (Sales)) Code20
9 Unreal. Tax Acc. (Purchases) (Unreal. Tax Acc. (Purchases)) Code20
10 Reverse Charge (Purchases) (Reverse Charge (Purchases)) Code20
11 Unreal. Rev. Charge (Purch.) (Unreal. Rev. Charge (Purch.)) Code20
12 Unrealized VAT Type (Unrealized VAT Type) Option
13 Calculate Tax on Tax (Calculate Tax on Tax) Boolean
14 Adjust for Payment Discount (Adjust for Payment Discount) Boolean

Keys

# Fields
0 Code (Code) Clustered: Yes
1 Report-to Jurisdiction (Report-to Jurisdiction)

Table Relations To Other Tables

Field Related Table Related Field
Unreal. Rev. Charge (Purch.) (Unreal. Rev. Charge (Purch.)) G/L Account No. (No.) 1..n
Tax Group Filter (Tax Group Filter) Tax Group Code (Code) 1..n
Report-to Jurisdiction (Report-to Jurisdiction) Tax Jurisdiction Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Detailed CV Ledg. Entry Buffer Tax Jurisdiction Code (Tax Jurisdiction Code) 1..n
Detailed Cust. Ledg. Entry Tax Jurisdiction Code (Tax Jurisdiction Code) 1..n
Detailed Vendor Ledg. Entry Tax Jurisdiction Code (Tax Jurisdiction Code) 1..n
Tax Area Line Tax Jurisdiction Code (Tax Jurisdiction Code) 1..n
Tax Detail Tax Jurisdiction Code (Tax Jurisdiction Code) 1..n
Tax Jurisdiction Report-to Jurisdiction (Report-to Jurisdiction) 1..n
VAT Entry Tax Jurisdiction Code (Tax Jurisdiction Code) 1..n
VAT Statement Line Tax Jurisdiction Code (Tax Jurisdiction Code) 1..n