Diagrams

Table

Detailed Vendor Ledg. Entry

DynamicsDocs.comDetailed Vendor Ledg. Entry«Table 380»Detailed Vendor Ledg. EntryEntry No. [PK]Vendor Ledger Entry No.Entry Type; [,Initial Entry,Applicatio...Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.AmountAmount [LCY]Vendor No.Currency CodeUser IDSource CodeTransaction No.Journal Batch NameReason CodeDebit AmountCredit AmountDebit Amount [LCY]Credit Amount [LCY]Initial Entry Due DateInitial Entry Global Dim. 1Initial Entry Global Dim. 2Gen. Bus. Posting GroupGen. Prod. Posting GroupUse TaxVAT Bus. Posting GroupVAT Prod. Posting GroupInitial Document Type; [,Payment,Invoi...Applied Vend. Ledger Entry No.UnappliedUnapplied by Entry No....«Table 25»Vendor Ledger EntryEntry No. [PK]Vendor No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeAmountRemaining AmountOriginal Amt. [LCY]Remaining Amt. [LCY]Amount [LCY]Purchase [LCY]Inv. Discount [LCY]Buy-from Vendor No.Vendor Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodePurchaser CodeUser IDSource CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.OpenDue DatePmt. Discount DateOriginal Pmt. Disc. PossiblePmt. Disc. Rcd.[LCY]PositiveClosed by Entry No....«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 4»CurrencyCode [PK,NN]Last Date ModifiedLast Date AdjustedUnrealized Gains Acc.Realized Gains Acc.Unrealized Losses Acc.Realized Losses Acc.Invoice Rounding PrecisionInvoice Rounding Type; [Nearest,Up,Dow...Amount Rounding PrecisionUnit-Amount Rounding PrecisionDescriptionAmount Decimal Places [NN]Unit-Amount Decimal Places [NN]Customer FilterVendor FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterCust. Ledg. Entries in FilterCustomer BalanceCustomer Outstanding OrdersCustomer Shipped Not InvoicedCustomer Balance DueVendor Ledg. Entries in FilterVendor BalanceVendor Outstanding OrdersVendor Amt. Rcd. Not InvoicedVendor Balance DueCustomer Balance [LCY]Vendor Balance [LCY]...«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 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID«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 323»VAT Business Posting GroupCode [PK,NN]Description«Table 324»VAT Product Posting 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<Vendor Ledger Entry No.><Vendor No.><Currency Code><User ID><Source Code><Reason Code><Initial Entry Global Dim. 1><Initial Entry Global Dim. 2><Gen. Bus. Posting Group><Gen. Prod. Posting Group><VAT Bus. Posting Group><VAT Prod. Posting Group><Unapplied by Entry No.><Tax Jurisdiction Code><Vendor No.><Buy-from Vendor No.><Bal. Account No.><Currency Code><Closed by Currency Code><Global Dimension 1 Code><Global Dimension 2 Code><User ID><Source Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Reason Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Currency Code><Currency Filter><Vendor Filter><Pay-to Vendor No.><Gen. Bus. Posting Group><VAT Bus. Posting Group><Global Dimension 1 Filter><Global Dimension 2 Filter><Def. VAT Bus. Posting Group><Def. VAT Prod. Posting Group><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
2 Vendor Ledger Entry No. (Vendor Ledger Entry No.) Integer
3 Entry Type (Entry Type) Option
4 Posting Date (Posting Date) Date
5 Document Type (Document Type) Option
6 Document No. (Document No.) Code20
7 Amount (Amount) Decimal
8 Amount (LCY) (Amount (LCY)) Decimal
9 Vendor No. (Vendor No.) Code20
10 Currency Code (Currency Code) Code10
11 User ID (User ID) Code50
12 Source Code (Source Code) Code10
13 Transaction No. (Transaction No.) Integer
14 Journal Batch Name (Journal Batch Name) Code10
15 Reason Code (Reason Code) Code10
16 Debit Amount (Debit Amount) Decimal BlankZero: Yes
17 Credit Amount (Credit Amount) Decimal BlankZero: Yes
18 Debit Amount (LCY) (Debit Amount (LCY)) Decimal BlankZero: Yes
19 Credit Amount (LCY) (Credit Amount (LCY)) Decimal BlankZero: Yes
20 Initial Entry Due Date (Initial Entry Due Date) Date
21 Initial Entry Global Dim. 1 (Initial Entry Global Dim. 1) Code20
22 Initial Entry Global Dim. 2 (Initial Entry Global Dim. 2) Code20
24 Gen. Bus. Posting Group (Gen. Bus. Posting Group) Code10
25 Gen. Prod. Posting Group (Gen. Prod. Posting Group) Code10
29 Use Tax (Use Tax) Boolean
30 VAT Bus. Posting Group (VAT Bus. Posting Group) Code10
31 VAT Prod. Posting Group (VAT Prod. Posting Group) Code10
35 Initial Document Type (Initial Document Type) Option
36 Applied Vend. Ledger Entry No. (Applied Vend. Ledger Entry No.) Integer
37 Unapplied (Unapplied) Boolean
38 Unapplied by Entry No. (Unapplied by Entry No.) Integer
39 Remaining Pmt. Disc. Possible (Remaining Pmt. Disc. Possible) Decimal
40 Max. Payment Tolerance (Max. Payment Tolerance) Decimal
41 Tax Jurisdiction Code (Tax Jurisdiction Code) Code10 Editable: No
42 Application No. (Application No.) Integer Editable: No
43 Ledger Entry Amount (Ledger Entry Amount) Boolean Editable: No

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Vendor Ledger Entry No.,Posting Date (Vendor Ledger Entry No.,Posting Date)
2 Vendor Ledger Entry No.,Entry Type,Posting Date (Vendor Ledger Entry No.,Entry Type,Posting Date) MaintainSQLIndex: No
3 Ledger Entry Amount,Vendor Ledger Entry No.,Posting Date (Ledger Entry Amount,Vendor Ledger Entry No.,Posting Date) MaintainSQLIndex: No
MaintainSIFTIndex: No
4 Initial Document Type,Entry Type,Vendor No.,Currency Code,Initial Entry Global Dim. 1,Initial Entry Global Dim. 2,Posting Date (Initial Document Type,Entry Type,Vendor No.,Currency Code,Initial Entry Global Dim. 1,Initial Entry Global Dim. 2,Posting Date) MaintainSIFTIndex: No
5 Vendor No.,Currency Code,Initial Entry Global Dim. 1,Initial Entry Global Dim. 2,Initial Entry Due Date,Posting Date (Vendor No.,Currency Code,Initial Entry Global Dim. 1,Initial Entry Global Dim. 2,Initial Entry Due Date,Posting Date)
6 Document No.,Document Type,Posting Date (Document No.,Document Type,Posting Date)
7 Applied Vend. Ledger Entry No.,Entry Type (Applied Vend. Ledger Entry No.,Entry Type)
8 Transaction No.,Vendor No.,Entry Type (Transaction No.,Vendor No.,Entry Type)
9 Application No.,Vendor No.,Entry Type (Application No.,Vendor No.,Entry Type)

Table Relations To Other Tables

Field Related Table Related Field
Currency Code (Currency Code) Currency Code (Code) 1..n
Unapplied by Entry No. (Unapplied by Entry No.) Detailed Vendor Ledg. Entry Entry No. (Entry No.) 1..n
Initial Entry Global Dim. 2 (Initial Entry Global Dim. 2) Dimension Value Code (Code) 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
Reason Code (Reason Code) Reason Code Code (Code) 1..n
Source Code (Source Code) Source Code 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
VAT Prod. Posting Group (VAT Prod. Posting Group) VAT Product Posting Group Code (Code) 1..n
Vendor No. (Vendor No.) Vendor No. (No.) 1..n
Vendor Ledger Entry No. (Vendor Ledger Entry No.) Vendor Ledger Entry Entry No. (Entry No.) 1..n

Table Relations From Other Tables

From Table From Field
Detailed Vendor Ledg. Entry Unapplied by Entry No. (Unapplied by Entry No.) 1..n