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 5223»Detailed Employee Ledger EntryEntry No. [PK]Employee Ledger Entry No.Entry Type; [,Initial Entry,Applicatio...Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.AmountAmount [LCY]Employee No.Currency CodeUser IDSource CodeTransaction No.Journal Batch NameReason CodeDebit AmountCredit AmountDebit Amount [LCY]Credit Amount [LCY]Initial Entry Global Dim. 1Initial Entry Global Dim. 2Initial Document Type; [,Payment,Invoi...Applied Empl. Ledger Entry No.UnappliedUnapplied by Entry No.Application No.Ledger Entry Amount«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 IDIdLast Modified Date Time«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]DescriptionLast Modified Date TimeId«Table 324»VAT Product Posting GroupCode [PK,NN]DescriptionIdLast Modified DateTime«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><Unapplied by Entry No.><Currency Code><User ID><Source Code><Reason Code><Initial Entry Global Dim. 1><Initial Entry Global Dim. 2><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><Currency Id><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. Integer
2 Vendor Ledger Entry No. Integer
3 Entry Type Option
4 Posting Date Date
5 Document Type Option
6 Document No. Code20
7 Amount Decimal
8 Amount (LCY) Decimal
9 Vendor No. Code20
10 Currency Code Code10
11 User ID Code50
12 Source Code Code10
13 Transaction No. Integer
14 Journal Batch Name Code10
15 Reason Code Code10
16 Debit Amount Decimal BlankZero: Yes
17 Credit Amount Decimal BlankZero: Yes
18 Debit Amount (LCY) Decimal BlankZero: Yes
19 Credit Amount (LCY) Decimal BlankZero: Yes
20 Initial Entry Due Date Date
21 Initial Entry Global Dim. 1 Code20
22 Initial Entry Global Dim. 2 Code20
24 Gen. Bus. Posting Group Code20
25 Gen. Prod. Posting Group Code20
29 Use Tax Boolean
30 VAT Bus. Posting Group Code20
31 VAT Prod. Posting Group Code20
35 Initial Document Type Option
36 Applied Vend. Ledger Entry No. Integer
37 Unapplied Boolean
38 Unapplied by Entry No. Integer
39 Remaining Pmt. Disc. Possible Decimal
40 Max. Payment Tolerance Decimal
41 Tax Jurisdiction Code Code10 Editable: No
42 Application No. Integer Editable: No
43 Ledger Entry Amount Boolean Editable: No

Keys

# Fields
0 Entry No. Clustered: Yes
1 Vendor Ledger Entry No.,Posting Date
2 Vendor Ledger Entry No.,Entry Type,Posting Date MaintainSQLIndex: No
3 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 MaintainSIFTIndex: No
5 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
7 Applied Vend. Ledger Entry No.,Entry Type
8 Transaction No.,Vendor No.,Entry Type
9 Application No.,Vendor No.,Entry Type

Table Relations To Other Tables

Field Related Table Related Field
Currency Code Currency Code 1..n
Unapplied by Entry No. Detailed Vendor Ledg. Entry Entry No. 1..n
Initial Entry Global Dim. 2 Dimension Value Code 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
Tax Jurisdiction Code Tax Jurisdiction Code 1..n
User ID User User Name 1..n
VAT Bus. Posting Group VAT Business Posting Group Code 1..n
VAT Prod. Posting Group VAT Product Posting Group Code 1..n
Vendor No. Vendor No. 1..n
Vendor Ledger Entry No. Vendor Ledger Entry Entry No. 1..n

Table Relations From Other Tables

From Table From Field
Detailed Employee Ledger Entry Unapplied by Entry No. 1..n
Detailed Vendor Ledg. Entry Unapplied by Entry No. 1..n