Diagrams


Table

VAT Business Posting Group

DynamicsDocs.comVAT Business Posting Group«Table 323»VAT Business Posting GroupCode [PK,NN]Description«Table 1300»Mini Customer TemplateKey [PK]Code [NN]Template Name [NN]CityDocument Sending ProfileCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodePayment Terms CodeFin. Charge Terms CodeCustomer Disc. GroupCountry/Region CodePrint StatementsPayment Method CodeApplication Method; [Manual,Apply to O...Prices Including VATGen. Bus. Posting GroupPost CodeCountyReminder Terms CodeVAT Bus. Posting GroupBlock Payment ToleranceAllow Line Disc.«Table 1303»Mini Vendor TemplateKey [PK]Code [NN]Template Name [NN]CityVendor Posting GroupCurrency CodeLanguage CodePayment Terms CodeFin. Charge Terms CodeInvoice Disc. CodeCountry/Region CodePayment Method CodeApplication Method; [Manual,Apply to O...Prices Including VATGen. Bus. Posting GroupPost CodeCountyVAT Bus. Posting GroupBlock Payment Tolerance«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 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«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 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. 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 311»Sales & Receivables SetupPrimary Key [PK]Discount Posting; [No Discounts,Invoic...Credit Warnings; [Both Warnings,Credit...Stockout WarningShipment on InvoiceInvoice RoundingExt. Doc. No. MandatoryCustomer Nos.Quote Nos.Order Nos.Invoice Nos.Posted Invoice Nos.Credit Memo Nos.Posted Credit Memo Nos.Posted Shipment Nos.Reminder Nos.Issued Reminder Nos.Fin. Chrg. Memo Nos.Issued Fin. Chrg. M. Nos.Posted Prepmt. Inv. Nos.Posted Prepmt. Cr. Memo Nos.Blanket Order Nos.Calc. Inv. DiscountAppln. between Currencies; [None,EMU,A...Copy Comments Blanket to OrderCopy Comments Order to InvoiceCopy Comments Order to Shpt.Allow VAT DifferenceCalc. Inv. Disc. per VAT IDLogo Position on Documents; [No Logo,L...Check Prepmt. when Posting...«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 5105»Customer TemplateCode [PK,NN]DescriptionTerritory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeCustomer Posting GroupCurrency CodeCustomer Price GroupPayment Terms CodeShipment Method CodeInvoice Disc. CodeCustomer Disc. GroupCountry/Region CodePayment Method CodeGen. Bus. Posting GroupVAT Bus. Posting GroupAllow Line Disc.«Table 6»Customer Price GroupCode [PK,NN]Price Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]DescriptionAllow Line Disc.«Table 7002»Sales PriceItem No. [PK,NN]Sales Code [PK]Currency Code [PK]Starting Date [PK]Unit PricePrice Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]Sales Type; [Customer,Customer Price G...Minimum Quantity [PK]Ending DateUnit of Measure Code [PK]Variant Code [PK]Allow Line Disc.«Table 7023»Sales Price WorksheetItem No. [PK,NN]Sales Code [PK]Currency Code [PK]Starting Date [PK]Current Unit PriceNew Unit PricePrice Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]Sales Type; [Customer,Customer Price G...Minimum Quantity [PK]Ending Date [PK]Item DescriptionSales DescriptionUnit of Measure Code [PK]Variant Code [PK]Allow Line Disc.<VAT Bus. Posting Group><VAT Bus. Posting Group><VAT Bus. Posting Group><VAT Bus. Posting Group><VAT Bus. Posting Group><VAT Bus. Posting Group><Def. VAT Bus. Posting Group><VAT Bus. Posting Gr. (Price)><VAT Bus. Posting Gr. (Price)><VAT Bus. Posting Group><VAT Bus. Posting Group><VAT Bus. Posting Group><VAT Bus. Posting Gr. (Price)><VAT Bus. Posting Gr. (Price)><VAT Bus. Posting Gr. (Price)><Customer Price Group><Gen. Bus. Posting Group><Invoice Disc. Code><Gen. Bus. Posting Group><Gen. Bus. Posting Group><Account No.><Freight G/L Acc. 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.><Customer Price Group><Bill-to Customer No.><Gen. Bus. Posting Group><Sales Code><Sales Code><Gen. Bus. Posting Group><Pay-to Vendor No.><Gen. Bus. Posting Group><Vendor No.><Gen. Bus. Posting Group><Gen. Bus. Posting Group><Alternative Item No.><Item No.><Item No.><Customer Price Group><Sales Code><Sales 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
Customer VAT Bus. Posting Group 1..n
Customer Price Group VAT Bus. Posting Gr. (Price) 1..n
Customer Template VAT Bus. Posting Group 1..n
Deferral Post. Buffer VAT Bus. Posting Group 1..n
Detailed CV Ledg. Entry Buffer VAT Bus. Posting Group 1..n
Detailed Cust. Ledg. Entry VAT Bus. Posting Group 1..n
Detailed Vendor Ledg. Entry VAT Bus. Posting Group 1..n
FA Ledger Entry VAT Bus. Posting Group 1..n
Finance Charge Memo Header VAT Bus. Posting Group 1..n
G/L Account VAT Bus. Posting Group 1..n
G/L Account (Analysis View) VAT Bus. Posting Group 1..n
G/L Entry VAT Bus. Posting Group 1..n
Gen. Business Posting Group Def. VAT Bus. Posting Group 1..n
Gen. Jnl. Allocation VAT Bus. Posting Group 1..n
Gen. Journal Line Bal. VAT Bus. Posting Group 1..n
Invoice Post. Buffer VAT Bus. Posting Group 1..n
Issued Fin. Charge Memo Header VAT Bus. Posting Group 1..n
Issued Reminder Header VAT Bus. Posting Group 1..n
Item VAT Bus. Posting Gr. (Price) 1..n
Maintenance Ledger Entry VAT Bus. Posting Group 1..n
Mini Customer Template VAT Bus. Posting Group 1..n
Mini Vendor Template VAT Bus. Posting Group 1..n
Prepayment Inv. Line Buffer VAT Bus. Posting Group 1..n
Purch. Cr. Memo Hdr. VAT Bus. Posting Group 1..n
Purch. Cr. Memo Line VAT Bus. Posting Group 1..n
Purch. Inv. Header VAT Bus. Posting Group 1..n
Purch. Inv. Line VAT Bus. Posting Group 1..n
Purch. Rcpt. Header VAT Bus. Posting Group 1..n
Purch. Rcpt. Line VAT Bus. Posting Group 1..n
Purchase Header VAT Bus. Posting Group 1..n
Purchase Header Archive VAT Bus. Posting Group 1..n
Purchase Line VAT Bus. Posting Group 1..n
Purchase Line Archive VAT Bus. Posting Group 1..n
Reminder Header VAT Bus. Posting Group 1..n
Return Receipt Header VAT Bus. Posting Group 1..n
Return Receipt Line VAT Bus. Posting Group 1..n
Return Shipment Header VAT Bus. Posting Group 1..n
Return Shipment Line VAT Bus. Posting Group 1..n
Sales & Receivables Setup VAT Bus. Posting Gr. (Price) 1..n
Sales Cr.Memo Header VAT Bus. Posting Group 1..n
Sales Cr.Memo Line VAT Bus. Posting Group 1..n
Sales Header VAT Bus. Posting Group 1..n
Sales Header Archive VAT Bus. Posting Group 1..n
Sales Invoice Header VAT Bus. Posting Group 1..n
Sales Invoice Line VAT Bus. Posting Group 1..n
Sales Line VAT Bus. Posting Group 1..n
Sales Line Archive VAT Bus. Posting Group 1..n
Sales Price VAT Bus. Posting Gr. (Price) 1..n
Sales Price Worksheet VAT Bus. Posting Gr. (Price) 1..n
Sales Price and Line Disc Buff VAT Bus. Posting Gr. (Price) 1..n
Sales Shipment Header VAT Bus. Posting Group 1..n
Sales Shipment Line VAT Bus. Posting Group 1..n
Service Cr.Memo Header VAT Bus. Posting Group 1..n
Service Cr.Memo Line VAT Bus. Posting Group 1..n
Service Header VAT Bus. Posting Group 1..n
Service Invoice Header VAT Bus. Posting Group 1..n
Service Invoice Line VAT Bus. Posting Group 1..n
Service Line VAT Bus. Posting Group 1..n
Service Shipment Header VAT Bus. Posting Group 1..n
Service Shipment Line VAT Bus. Posting Group 1..n
Standard General Journal Line Bal. VAT Bus. Posting Group 1..n
VAT Entry VAT Bus. Posting Group 1..n
VAT Posting Setup VAT Bus. Posting Group 1..n
VAT Report Line VAT Bus. Posting Group 1..n
VAT Statement Line VAT Bus. Posting Group 1..n
Vendor VAT Bus. Posting Group 1..n