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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

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