Diagrams

Table

VAT Entry

DynamicsDocs.comVAT Entry«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 179»Reversal EntryLine No. [PK]Entry Type; [,G/L Account,Customer,Ven...Entry No.G/L Register No.Source CodeJournal Batch NameTransaction No.Source Type; [,Customer,Vendor,Bank Ac...Source No.Currency CodeDescriptionAmountDebit AmountCredit AmountAmount [LCY]Debit Amount [LCY]Credit Amount [LCY]VAT AmountPosting DateDocument Type; [,Payment,Invoice,Credi...Document No.Account No.Account NameBal. Account Type; [G/L Account,Custom...Bal. Account No.FA Posting Category; [,Disposal,Bal. D...FA Posting Type; [,Acquisition Cost,De...Reversal Type; [Transaction,Register]«Table 253»G/L Entry - VAT Entry LinkG/L Entry No. [PK]VAT Entry No. [PK]«Table 45»G/L RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch NameFrom VAT Entry No.To VAT Entry No.Reversed«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«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 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 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«Table 230»Source CodeCode [PK,NN]Description«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 9»Country/RegionCode [PK,NN]NameEU Country/Region CodeIntrastat CodeAddress Format; [Post Code+City,City+P...Contact Address Format; [First,After C...VAT Scheme«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 318»Tax AreaCode [PK,NN]Description«Table 321»Tax GroupCode [PK,NN]Description«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 323»VAT Business Posting GroupCode [PK,NN]Description«Table 324»VAT Product Posting GroupCode [PK,NN]Description«Table 224»Order AddressVendor No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Country/Region CodeLast Date ModifiedFax No.Telex Answer BackPost CodeCountyE-MailHome Page«Table 222»Ship-to AddressCustomer No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Shipment Method CodeShipping Agent CodePlace of ExportCountry/Region CodeLast Date ModifiedLocation CodeFax No.Telex Answer BackPost CodeCountyE-MailHome PageTax Area CodeTax LiableShipping Agent Service CodeService Zone Code<Gen. Bus. Posting Group><Gen. Prod. Posting Group><Bill-to/Pay-to No.><Bill-to/Pay-to No.><User ID><Source Code><Reason Code><Closed by Entry No.><Unrealized VAT Entry No.><Reversed by Entry No.><Reversed Entry No.><Country/Region Code><No. Series><Tax Area Code><Tax Group Code><Tax Group Used><Tax Jurisdiction Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Ship-to/Order Address Code><Ship-to/Order Address Code><Entry No.><VAT Entry No.><From VAT Entry No.><To VAT Entry No.><G/L Register No.><Source Code><Source No.><Bal. Account No.><Source No.><Bal. Account No.><Source Code><User ID><Def. VAT Bus. Posting Group><Gen. Bus. Posting Group><Gen. Bus. Posting Group><Def. VAT Prod. Posting Group><Country/Region Code><Pay-to Vendor No.><No. Series><Tax Area Code><VAT Bus. Posting Group><Vendor No.><Country/Region Code><Bill-to Customer No.><No. Series><Tax Area Code><VAT Bus. Posting Group><Ship-to Filter><Customer No.><Country/Region Code><Country/Region Code><Tax Area Code><Tax Group Filter><Report-to Jurisdiction>

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

Fields

# Name Type
1 Entry No. (Entry No.) Integer Editable: No
2 Gen. Bus. Posting Group (Gen. Bus. Posting Group) Code10 Editable: No
3 Gen. Prod. Posting Group (Gen. Prod. Posting Group) Code10 Editable: No
4 Posting Date (Posting Date) Date Editable: No
5 Document No. (Document No.) Code20 Editable: No
6 Document Type (Document Type) Option Editable: No
7 Type (Type) Option Editable: No
8 Base (Base) Decimal Editable: No
9 Amount (Amount) Decimal Editable: No
10 VAT Calculation Type (VAT Calculation Type) Option Editable: No
12 Bill-to/Pay-to No. (Bill-to/Pay-to No.) Code20
13 EU 3-Party Trade (EU 3-Party Trade) Boolean
14 User ID (User ID) Code50 Editable: No
15 Source Code (Source Code) Code10 Editable: No
16 Reason Code (Reason Code) Code10 Editable: No
17 Closed by Entry No. (Closed by Entry No.) Integer Editable: No
18 Closed (Closed) Boolean Editable: No
19 Country/Region Code (Country/Region Code) Code10
20 Internal Ref. No. (Internal Ref. No.) Text30 Editable: No
21 Transaction No. (Transaction No.) Integer Editable: No
22 Unrealized Amount (Unrealized Amount) Decimal Editable: No
23 Unrealized Base (Unrealized Base) Decimal Editable: No
24 Remaining Unrealized Amount (Remaining Unrealized Amount) Decimal Editable: No
25 Remaining Unrealized Base (Remaining Unrealized Base) Decimal Editable: No
26 External Document No. (External Document No.) Code35 Editable: No
28 No. Series (No. Series) Code10 Editable: No
29 Tax Area Code (Tax Area Code) Code20 Editable: No
30 Tax Liable (Tax Liable) Boolean Editable: No
31 Tax Group Code (Tax Group Code) Code10 Editable: No
32 Use Tax (Use Tax) Boolean Editable: No
33 Tax Jurisdiction Code (Tax Jurisdiction Code) Code10 Editable: No
34 Tax Group Used (Tax Group Used) Code10 Editable: No
35 Tax Type (Tax Type) Option Editable: No
36 Tax on Tax (Tax on Tax) Boolean Editable: No
37 Sales Tax Connection No. (Sales Tax Connection No.) Integer Editable: No
38 Unrealized VAT Entry No. (Unrealized VAT Entry No.) Integer Editable: No
39 VAT Bus. Posting Group (VAT Bus. Posting Group) Code10 Editable: No
40 VAT Prod. Posting Group (VAT Prod. Posting Group) Code10 Editable: No
43 Additional-Currency Amount (Additional-Currency Amount) Decimal Editable: No
44 Additional-Currency Base (Additional-Currency Base) Decimal Editable: No
45 Add.-Currency Unrealized Amt. (Add.-Currency Unrealized Amt.) Decimal Editable: No
46 Add.-Currency Unrealized Base (Add.-Currency Unrealized Base) Decimal Editable: No
48 VAT Base Discount % (VAT Base Discount %) Decimal (0:5) Editable: No
49 Add.-Curr. Rem. Unreal. Amount (Add.-Curr. Rem. Unreal. Amount) Decimal Editable: No
50 Add.-Curr. Rem. Unreal. Base (Add.-Curr. Rem. Unreal. Base) Decimal Editable: No
51 VAT Difference (VAT Difference) Decimal Editable: No
52 Add.-Curr. VAT Difference (Add.-Curr. VAT Difference) Decimal Editable: No
53 Ship-to/Order Address Code (Ship-to/Order Address Code) Code10
54 Document Date (Document Date) Date Editable: No
55 VAT Registration No. (VAT Registration No.) Text20
56 Reversed (Reversed) Boolean
57 Reversed by Entry No. (Reversed by Entry No.) Integer BlankZero: Yes
58 Reversed Entry No. (Reversed Entry No.) Integer BlankZero: Yes
59 EU Service (EU Service) Boolean Editable: No

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Type,Closed,VAT Bus. Posting Group,VAT Prod. Posting Group,Posting Date (Type,Closed,VAT Bus. Posting Group,VAT Prod. Posting Group,Posting Date)
2 Type,Closed,Tax Jurisdiction Code,Use Tax,Posting Date (Type,Closed,Tax Jurisdiction Code,Use Tax,Posting Date)
3 Type,Country/Region Code,VAT Registration No.,VAT Bus. Posting Group,VAT Prod. Posting Group,Posting Date (Type,Country/Region Code,VAT Registration No.,VAT Bus. Posting Group,VAT Prod. Posting Group,Posting Date)
4 Document No.,Posting Date (Document No.,Posting Date)
5 Transaction No. (Transaction No.)
6 Tax Jurisdiction Code,Tax Group Used,Tax Type,Use Tax,Posting Date (Tax Jurisdiction Code,Tax Group Used,Tax Type,Use Tax,Posting Date)
7 Type,Bill-to/Pay-to No.,Transaction No. (Type,Bill-to/Pay-to No.,Transaction No.) MaintainSQLIndex: No
8 Document Date (Document Date)

Table Relations To Other Tables

Field Related Table Related Field
Country/Region Code (Country/Region Code) Country/Region Code (Code) 1..n
Bill-to/Pay-to No. (Bill-to/Pay-to No.) Customer No. (No.) 1..n
Gen. Bus. Posting Group (Gen. Bus. Posting Group) Gen. Business Posting Group Code (Code) 1..n
Gen. Prod. Posting Group (Gen. Prod. Posting Group) Gen. Product Posting Group Code (Code) 1..n
No. Series (No. Series) No. Series Code (Code) 1..n
Ship-to/Order Address Code (Ship-to/Order Address Code) Order Address Code (Code) 1..n
Reason Code (Reason Code) Reason Code Code (Code) 1..n
Ship-to/Order Address Code (Ship-to/Order Address Code) Ship-to Address Code (Code) 1..n
Source Code (Source Code) Source Code Code (Code) 1..n
Tax Area Code (Tax Area Code) Tax Area Code (Code) 1..n
Tax Group Used (Tax Group Used) Tax Group Code (Code) 1..n
Tax Jurisdiction Code (Tax Jurisdiction Code) Tax Jurisdiction Code (Code) 1..n
User ID (User ID) User User Name (User Name) 1..n
VAT Bus. Posting Group (VAT Bus. Posting Group) VAT Business Posting Group Code (Code) 1..n
Reversed Entry No. (Reversed Entry No.) VAT Entry Entry No. (Entry No.) 1..n
VAT Prod. Posting Group (VAT Prod. Posting Group) VAT Product Posting Group Code (Code) 1..n
Bill-to/Pay-to No. (Bill-to/Pay-to No.) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field
G/L Entry - VAT Entry Link VAT Entry No. (VAT Entry No.) 1..n
G/L Register To VAT Entry No. (To VAT Entry No.) 1..n
Reversal Entry Entry No. (Entry No.) 1..n
VAT Entry Reversed Entry No. (Reversed Entry No.) 1..n