Diagrams


Table

Tax Group

DynamicsDocs.comTax Group«Table 321»Tax GroupCode [PK,NN]Description«Table 1301»Item TemplateKey [PK]Code [NN]Template Name [NN]Base Unit of MeasureType; [Inventory,Service]Inventory Posting GroupItem Disc. GroupAllow Invoice Disc.Price/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Indirect Cost %Price Includes VATGen. Prod. Posting GroupAutomatic Ext. TextsTax Group CodeVAT Prod. Posting GroupItem Category CodeService Item GroupWarehouse Class Code«Table 156»ResourceNo. [PK]Type; [Person,Machine]NameSearch NameName 2AddressAddress 2CitySocial Security No.Job TitleEducationContract ClassEmployment DateResource Group No.Global Dimension 1 CodeGlobal Dimension 2 CodeBase Unit of MeasureDirect Unit CostIndirect Cost %Unit CostProfit %Price/Profit Calculation; [Profit=Pric...Unit PriceVendor No.Last Date ModifiedCommentBlockedDate FilterUnit of Measure FilterCapacityQty. on Order [Job]...«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 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....«Table 221»Gen. Jnl. AllocationJournal Template Name [PK]Journal Batch Name [PK]Journal Line No. [PK]Line No. [PK]Account No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeAllocation QuantityAllocation %AmountGen. Posting Type; [,Purchase,Sale]Gen. Bus. Posting GroupGen. Prod. Posting GroupVAT Calculation Type; [Normal VAT,Reve...VAT AmountVAT %Account NameTax Area CodeTax LiableTax Group CodeUse TaxVAT Bus. Posting GroupVAT Prod. Posting GroupAdditional-Currency AmountDimension Set ID«Table 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«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 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 326»Tax SetupPrimary Key [PK]Auto. Create Tax DetailsNon-Taxable Tax Group CodeTax Account [Sales]Tax Account [Purchases]Unreal. Tax Acc. [Sales]Unreal. Tax Acc. [Purchases]Reverse Charge [Purchases]Unreal. Rev. Charge [Purch.]«Table 376»G/L Account (Analysis View)No. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Account Source; [G/L Account,Cash Flow...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 ModifiedCash Flow Forecast FilterDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudgeted at DateConsol. Debit Acc.Consol. Credit Acc....«Table 5800»Item ChargeNo. [PK,NN]DescriptionGen. Prod. Posting GroupTax Group CodeVAT Prod. Posting GroupSearch DescriptionGlobal Dimension 1 CodeGlobal Dimension 2 Code<Tax Group Code><Tax Group Code><Tax Group Code><Tax Group Code><Tax Group Code><Tax Group Filter><Tax Group Code><Non-Taxable Tax Group Code><Tax Group Code><Tax Group Code><Account No.><Tax Account (Sales)><Tax Account (Purchases)><Unreal. Tax Acc. (Sales)><Unreal. Tax Acc. (Purchases)><Reverse Charge (Purchases)><Unreal. Rev. Charge (Purch.)><Tax Account (Sales)><Tax Account (Purchases)><Unreal. Tax Acc. (Sales)><Unreal. Tax Acc. (Purchases)><Reverse Charge (Purchases)><Unreal. Rev. Charge (Purch.)><No.><Alternative Item No.><Report-to Jurisdiction><Tax Jurisdiction 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 Text30

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Deferral Post. Buffer Tax Group Code 1..n
Detailed CV Ledg. Entry Buffer Tax Group Code 1..n
FA Ledger Entry Tax Group Code 1..n
Finance Charge Memo Line Tax Group Code 1..n
G/L Account Tax Group Code 1..n
G/L Account (Analysis View) Tax Group Code 1..n
G/L Entry Tax Group Code 1..n
Gen. Jnl. Allocation Tax Group Code 1..n
Gen. Journal Line Bal. Tax Group Code 1..n
Invoice Post. Buffer Tax Group Code 1..n
Issued Fin. Charge Memo Line Tax Group Code 1..n
Issued Reminder Line Tax Group Code 1..n
Item Tax Group Code 1..n
Item Charge Tax Group Code 1..n
Item Template Tax Group Code 1..n
Maintenance Ledger Entry Tax Group Code 1..n
Prepayment Inv. Line Buffer Tax Group Code 1..n
Purch. Cr. Memo Line Tax Group Code 1..n
Purch. Inv. Line Tax Group Code 1..n
Purch. Rcpt. Line Tax Group Code 1..n
Purchase Line Prepayment Tax Group Code 1..n
Purchase Line Archive Prepayment Tax Group Code 1..n
Reminder Line Tax Group Code 1..n
Resource Tax Group Code 1..n
Return Receipt Line Tax Group Code 1..n
Return Shipment Line Tax Group Code 1..n
Sales Cr.Memo Line Tax Group Code 1..n
Sales Invoice Line Tax Group Code 1..n
Sales Line Prepayment Tax Group Code 1..n
Sales Line Archive Prepayment Tax Group Code 1..n
Sales Shipment Line Tax Group Code 1..n
Service Cr.Memo Line Tax Group Code 1..n
Service Invoice Line Tax Group Code 1..n
Service Line Tax Group Code 1..n
Service Shipment Line Tax Group Code 1..n
Standard General Journal Line Bal. Tax Group Code 1..n
Tax Detail Tax Group Code 1..n
Tax Jurisdiction Tax Group Filter 1..n
Tax Setup Non-Taxable Tax Group Code 1..n
VAT Amount Line Tax Group Code 1..n
VAT Entry Tax Group Used 1..n