Diagrams


Table

VAT Product Posting Group

DynamicsDocs.comVAT Product Posting Group«Table 324»VAT Product Posting GroupCode [PK,NN]Description«Table 1301»Mini 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. TextsVAT Prod. Posting Group«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 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 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 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«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 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 Category«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 551»VAT Rate Change ConversionType; [VAT Prod. Posting Group,Gen. Pr...From Code [PK,NN]To Code [NN]Converted Date«Table 5722»Item CategoryCode [PK,NN]DescriptionDef. Gen. Prod. Posting GroupDef. Inventory Posting GroupDef. Tax Group CodeDef. Costing Method; [FIFO,LIFO,Specif...Def. VAT Prod. Posting Group«Table 5800»Item ChargeNo. [PK,NN]DescriptionGen. Prod. Posting GroupTax Group CodeVAT Prod. Posting GroupSearch DescriptionGlobal Dimension 1 CodeGlobal Dimension 2 Code<VAT Prod. Posting Group><VAT Prod. Posting Group><VAT Prod. Posting Group><VAT Prod. Posting Group><Def. VAT Prod. Posting Group><VAT Prod. Posting Group><VAT Prod. Posting Group><VAT Prod. Posting Group><From Code><To Code><Def. VAT Prod. Posting Group><VAT Prod. Posting Group><Gen. Prod. Posting Group><Gen. Prod. Posting Group><Gen. Prod. Posting Group><Account No.><Sales VAT Account><Sales VAT Unreal. Account><Purchase VAT Account><Purch. VAT Unreal. Account><Reverse Chrg. VAT Acc.><Reverse Chrg. VAT Unreal. Acc.><No.><Gen. Prod. Posting Group><Gen. Prod. Posting Group><Gen. Prod. Posting Group><From Code><To Code><Def. Gen. Prod. Posting Group><Gen. Prod. Posting Group><Alternative Item No.><Item Category 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

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 VAT Prod. Posting Group 1..n
Detailed CV Ledg. Entry Buffer VAT Prod. Posting Group 1..n
Detailed Cust. Ledg. Entry VAT Prod. Posting Group 1..n
Detailed Vendor Ledg. Entry VAT Prod. Posting Group 1..n
FA Ledger Entry VAT Prod. Posting Group 1..n
Finance Charge Memo Line VAT Prod. Posting Group 1..n
G/L Account VAT Prod. Posting Group 1..n
G/L Account (Analysis View) VAT Prod. Posting Group 1..n
G/L Entry VAT Prod. Posting Group 1..n
Gen. Jnl. Allocation VAT Prod. Posting Group 1..n
Gen. Journal Line Bal. VAT Prod. Posting Group 1..n
Gen. Product Posting Group Def. VAT Prod. Posting Group 1..n
Invoice Post. Buffer VAT Prod. Posting Group 1..n
Issued Fin. Charge Memo Line VAT Prod. Posting Group 1..n
Issued Reminder Line VAT Prod. Posting Group 1..n
Item VAT Prod. Posting Group 1..n
Item Category Def. VAT Prod. Posting Group 1..n
Item Charge VAT Prod. Posting Group 1..n
Maintenance Ledger Entry VAT Prod. Posting Group 1..n
Mini Item Template VAT Prod. Posting Group 1..n
Prepayment Inv. Line Buffer VAT Prod. Posting Group 1..n
Purch. Cr. Memo Line VAT Prod. Posting Group 1..n
Purch. Inv. Line VAT Prod. Posting Group 1..n
Purch. Rcpt. Line VAT Prod. Posting Group 1..n
Purchase Line VAT Prod. Posting Group 1..n
Purchase Line Archive VAT Prod. Posting Group 1..n
Reminder Line VAT Prod. Posting Group 1..n
Resource VAT Prod. Posting Group 1..n
Return Receipt Line VAT Prod. Posting Group 1..n
Return Shipment Line VAT Prod. Posting Group 1..n
Sales Cr.Memo Line VAT Prod. Posting Group 1..n
Sales Invoice Line VAT Prod. Posting Group 1..n
Sales Line VAT Prod. Posting Group 1..n
Sales Line Archive VAT Prod. Posting Group 1..n
Sales Shipment Line VAT Prod. Posting Group 1..n
Service Cr.Memo Line VAT Prod. Posting Group 1..n
Service Invoice Line VAT Prod. Posting Group 1..n
Service Line VAT Prod. Posting Group 1..n
Service Shipment Line VAT Prod. Posting Group 1..n
Standard General Journal Line Bal. VAT Prod. Posting Group 1..n
VAT Entry VAT Prod. Posting Group 1..n
VAT Posting Setup VAT Prod. Posting Group 1..n
VAT Rate Change Conversion To Code 1..n
VAT Report Line VAT Prod. Posting Group 1..n
VAT Statement Line VAT Prod. Posting Group 1..n