Diagrams


Table

VAT Report Header

DynamicsDocs.comVAT Report Header«Table 740»VAT Report HeaderNo. [PK]VAT Report Config. Code; [EC Sales Lis...VAT Report Type; [Standard,Corrective,...Start DateEnd DateStatus; [Open,Released,Submitted,Accep...No. SeriesOriginal Report No.Period Type; [,,Month,Quarter,Year]Period No.Period YearMessage IdStatement Template NameStatement NameVAT Report VersionSubmitted BySubmitted Date«Table 741»VAT Report LineVAT Report No. [PK]Line No. [PK]Gen. 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 TradeSource CodeReason CodeCountry/Region CodeInternal Ref. No.Unrealized AmountUnrealized BaseExternal Document No.VAT Bus. Posting GroupVAT Prod. Posting GroupVAT Registration No.Gen. Bus. Posting GroupRecord Identifier«Table 742»VAT Statement Report LineVAT Report No. [PK]VAT Report Config. Code; [EC Sales Lis...Line No. [PK]Row No.DescriptionBox No.BaseAmount«Table 744»VAT Report Line RelationVAT Report No. [PK]VAT Report Line No. [PK]Line No. [PK]Table No.Entry No.«Table 747»VAT Report ArchiveVAT Report Type; [EC Sales List,VAT Re...VAT Report No. [PK]Submitted BySubmission Message BLOBSubmittion DateResponse Message BLOBResponse Received Date«Table 746»VAT Reports ConfigurationVAT Report Type; [EC Sales List,VAT Re...VAT Report Version [PK]Suggest Lines Codeunit IDSuggest Lines Codeunit CaptionContent Codeunit IDContent Codeunit CaptionSubmission Codeunit IDSubmission Codeunit CaptionResponse Handler Codeunit IDResp. Handler Codeunit CaptionValidate Codeunit IDValidate Codeunit CaptionVAT Statement TemplateVAT Statement Name«Table 255»VAT Statement TemplateName [PK,NN]DescriptionPage IDVAT Statement Report IDPage CaptionVAT Statement Report Caption«Table 257»VAT Statement NameStatement Template Name [PK,NN]Name [PK,NN]DescriptionDate Filter«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<VAT Report Config. Code><VAT Report Version><Statement Template Name><Statement Name><Submitted By><VAT Report No.><VAT Report No.><VAT Report No.><VAT Report No.><VAT Report Line No.><VAT Report Config. Code><Submitted By><VAT Statement Template><VAT Statement Name><Statement Template Name>

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

Fields

# Name Type
1 No. Code20
2 VAT Report Config. Code Option Editable: Yes
3 VAT Report Type Option
4 Start Date Date
5 End Date Date
6 Status Option Editable: No
8 No. Series Code20
9 Original Report No. Code20
10 Period Type Option
11 Period No. Integer
12 Period Year Integer
13 Message Id Text250
14 Statement Template Name Code10
15 Statement Name Code10
16 VAT Report Version Code10
17 Submitted By GUID
18 Submitted Date Date

Keys

# Fields
0 VAT Report Config. Code,No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Submitted By User User Security ID 1..n
VAT Report Version VAT Reports Configuration VAT Report Version 1..n
Statement Name VAT Statement Name Name 1..n
Statement Template Name VAT Statement Template Name 1..n

Table Relations From Other Tables

From Table From Field
VAT Report Archive VAT Report No. 1..n
VAT Report Line VAT Report No. 1..n
VAT Report Line Relation VAT Report No. 1..n
VAT Statement Report Line VAT Report No. 1..n