Diagrams


Table

VAT Report Line

DynamicsDocs.comVAT Report Line«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 744»VAT Report Line RelationVAT Report No. [PK]VAT Report Line No. [PK]Line No. [PK]Table No.Entry No.«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 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 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 SchemeLast Modified Date TimeId«Table 323»VAT Business Posting GroupCode [PK,NN]DescriptionLast Modified Date TimeId«Table 324»VAT Product Posting GroupCode [PK,NN]DescriptionIdLast Modified DateTime«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default<VAT Report No.><Gen. Prod. Posting Group><Bill-to/Pay-to No.><Bill-to/Pay-to No.><Source Code><Reason Code><Country/Region Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Gen. Bus. Posting Group><VAT Report Line No.><VAT Report No.><Def. VAT Prod. Posting Group><Country/Region Code><Pay-to Vendor No.><Gen. Bus. Posting Group><VAT Bus. Posting Group><Country/Region Code><Bill-to Customer No.><Gen. Bus. Posting Group><VAT Bus. Posting Group><Def. VAT Bus. Posting Group>

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

Fields

# Name Type
1 VAT Report No. Code20 Editable: No
2 Line No. Integer AutoIncrement: Yes
Editable: No
3 Gen. Prod. Posting Group Code20 Editable: No
4 Posting Date Date Editable: No
5 Document No. Code20 Editable: No
6 Document Type Option Editable: No
7 Type Option Editable: No
8 Base Decimal Editable: No
9 Amount Decimal Editable: No
10 VAT Calculation Type Option Editable: No
12 Bill-to/Pay-to No. Code20 Editable: No
13 EU 3-Party Trade Boolean Editable: No
15 Source Code Code10 Editable: No
16 Reason Code Code10 Editable: No
19 Country/Region Code Code10 Editable: No
20 Internal Ref. No. Text30 Editable: No
22 Unrealized Amount Decimal Editable: No
23 Unrealized Base Decimal Editable: No
26 External Document No. Code35 Editable: No
39 VAT Bus. Posting Group Code20 Editable: No
40 VAT Prod. Posting Group Code20 Editable: No
55 VAT Registration No. Text20 Editable: No
56 Gen. Bus. Posting Group Code20 Editable: No
100 Record Identifier Code30 Editable: No

Keys

# Fields
0 VAT Report No.,Line No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Country/Region Code Country/Region Code 1..n
Bill-to/Pay-to No. Customer No. 1..n
Gen. Bus. Posting Group Gen. Business Posting Group Code 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
Reason Code Reason Code Code 1..n
Source Code Source Code Code 1..n
VAT Bus. Posting Group VAT Business Posting Group Code 1..n
VAT Prod. Posting Group VAT Product Posting Group Code 1..n
VAT Report No. VAT Report Header No. 1..n
Bill-to/Pay-to No. Vendor No. 1..n

Table Relations From Other Tables

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