Diagrams


Table

Vendor Ledger Entry

DynamicsDocs.comVendor Ledger Entry«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 1206»Credit Transfer EntryCredit Transfer Register No. [PK]Entry No. [PK]Account Type; [Customer,Vendor]Account No.Applies-to Entry No.Transfer DateCurrency CodeTransfer AmountTransaction IDCanceledRecipient Bank Acc. No.Message to Recipient«Table 122»Purch. Inv. HeaderBuy-from Vendor No. [NN]No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting GroupCurrency Code...«Table 124»Purch. Cr. Memo Hdr.Buy-from Vendor No. [NN]No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactPosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting GroupCurrency CodeCurrency Factor...«Table 1293»Payment Application ProposalBank Account No. [PK]Statement No. [PK]Statement Line No. [PK]Statement Type; [Bank Reconciliation,P...Account Type; [G/L Account,Customer,Ve...Account No. [PK]Applies-to Entry No. [PK]Applied AmountAppliedApplied Pmt. DiscountQualityPosting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeDue DateExternal Document No.Match Confidence; [None,Low,Medium,Hig...Pmt. Disc. Due DateRemaining Pmt. Disc. PossiblePmt. Disc. Tolerance DateApplied Amt. Incl. DiscountRemaining AmountRemaining Amt. Incl. DiscountType; [Bank Account Ledger Entry,Check...Sorting OrderStmt To Rem. Amount Difference«Table 1294»Applied Payment EntryBank Account No. [PK]Statement No. [PK]Statement Line No. [PK]Statement Type; [Bank Reconciliation,P...Account Type; [G/L Account,Customer,Ve...Account No. [PK]Applies-to Entry No. [PK]Applied AmountApplied Pmt. DiscountQualityPosting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeDue DateExternal Document No.Match Confidence; [None,Low,Medium,Hig...«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 317»Payable Vendor Ledger EntryPriority [PK]Vendor No. [PK]Entry No. [PK]Vendor Ledg. Entry No.AmountAmount [LCY]Currency Code [PK]Positive [PK]Future [PK]«Table 372»Payment BufferVendor No. [PK]Currency Code [PK]Vendor Ledg. Entry No. [PK]Dimension Entry No. [PK]Global Dimension 1 CodeGlobal Dimension 2 CodeDocument No.AmountVendor Ledg. Entry Doc. Type; [,Paymen...Vendor Ledg. Entry Doc. No.Creditor No.Payment ReferencePayment Method CodeApplies-to Ext. Doc. No.Exported to Payment FileDimension Set ID«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 847»Cash Flow Forecast EntryEntry No. [PK]User IDCash Flow Forecast No.Cash Flow DateDocument No.Cash Flow Account No.Source Type; [,Receivables,Payables,Li...DescriptionOverduePayment DiscountAssociated Entry No.Associated Document No.Global Dimension 2 CodeGlobal Dimension 1 CodeRecurring Method; [,Fixed,Variable]Amount [LCY]PositiveSource No.G/L Budget NameDimension Set ID«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 93»Vendor Posting GroupCode [PK,NN]Payables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding AccountDebit Curr. Appln. Rndg. Acc.Credit Curr. Appln. Rndg. Acc.Debit Rounding AccountCredit Rounding AccountPayment Disc. Credit Acc.Payment Tolerance Debit Acc.Payment Tolerance Credit Acc.«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 13»Salesperson/PurchaserCode [PK,NN]NameCommission %ImageGlobal Dimension 1 CodeGlobal Dimension 2 CodeE-MailPhone No.Next To-do DateNo. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterNo. of InteractionsCost [LCY]Duration [Min.]Job TitleAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterAvg. Estimated Value [LCY]Avg.Calcd. Current Value [LCY]Contact FilterContact Company FilterCampaign FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTo-do Status Filter; [Not Started,In P......«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 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc....«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 270»Bank AccountNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Bank Account No.Transit No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameMin. BalanceBank Acc. Posting GroupCurrency CodeLanguage CodeStatistics GroupOur Contact CodeCountry/Region CodeAmountCommentBlockedLast Statement No.Last Payment Statement No.Last Date ModifiedDate FilterGlobal Dimension 1 Filter...«Table 5600»Fixed AssetNo. [PK]DescriptionSearch DescriptionDescription 2FA Class CodeFA Subclass CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeFA Location CodeVendor No.Main Asset/Component; [,Main Asset,Com...Component of Main AssetBudgeted AssetWarranty DateResponsible EmployeeSerial No.Last Date ModifiedInsuredCommentBlockedPictureMaintenance Vendor No.Under MaintenanceNext Service DateInactiveFA Posting Date FilterNo. SeriesFA Posting GroupAcquiredImage...«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 413»IC PartnerCode [PK,NN]NameCurrency CodeInbox Type; [File Location,Database,Em...Inbox DetailsReceivables AccountPayables AccountBlockedCommentCustomer No.Vendor No.Outbound Sales Item No. Type; [Interna...Outbound Purch. Item No. Type; [Intern...Cost Distribution in LCY«Table 289»Payment MethodCode [PK,NN]DescriptionBal. Account Type; [G/L Account,Bank A...Bal. Account No.Direct DebitDirect Debit Pmt. Terms CodePmt. Export Line DefinitionBank Data Conversion Pmt. Type«Table 288»Vendor Bank AccountVendor No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityPost CodeContactPhone No.Telex No.Bank Branch No.Bank Account No.Transit No.Currency CodeCountry/Region CodeCountyFax No.Telex Answer BackLanguage CodeE-MailHome PageIBANSWIFT CodeBank Clearing CodeBank Clearing Standard«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Vendor No.><Buy-from Vendor No.><Bal. Account No.><Currency Code><Closed by Currency Code><Vendor Posting Group><Global Dimension 1 Code><Global Dimension 2 Code><Purchaser Code><User ID><Source Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Reason Code><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><No. Series><IC Partner Code><Payment Method Code><Recipient Bank Account><Dimension Set ID><Applies-to Entry No.><Vendor Ledger Entry No.><Vendor Ledger Entry No.><Applies-to Entry No.><Applies-to Entry No.><Entry No.><Vendor Ledg. Entry No.><Vendor Ledg. Entry No.><Creditor No.><Payment Reference><Payment Method Code><Vendor Ledger Entry No.><Source No.><Account No.><Account No.><Currency Code><Buy-from Vendor No.><Pay-to Vendor No.><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Vendor Posting Group><Currency Code><Purchaser Code><Bal. Account No.><Bal. Account No.><Sell-to Customer No.><Reason Code><Payment Method Code><Pre-Assigned No. Series><No. Series><Order No. Series><Prepayment No. Series><User ID><Source Code><Dimension Set ID><Buy-from Vendor No.><Pay-to Vendor No.><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Vendor Posting Group><Currency Code><Purchaser Code><Bal. Account No.><Bal. Account No.><Sell-to Customer No.><Reason Code><Payment Method Code><Pre-Assigned No. Series><No. Series><Prepmt. Cr. Memo No. Series><Return Order No. Series><User ID><Source Code><Dimension Set ID><Bank Account No.><Account No.><Account No.><Account No.><Account No.><Account No.><Account No.><Currency Code><Bank Account No.><Account No.><Account No.><Account No.><Account No.><Account No.><Account No.><Currency Code><Source Code><Source No.><Bal. Account No.><Source No.><Bal. Account No.><Source No.><Bal. Account No.><Source No.><Bal. Account No.><Currency Code><Bal. Account No.><Vendor No.><Currency Code><Vendor No.><Currency Code><Global Dimension 1 Code><Global Dimension 2 Code><Dimension Set ID><Vendor No.><Currency Code><User ID><Source Code><Reason Code><Initial Entry Global Dim. 1><Initial Entry Global Dim. 2><Unapplied by Entry No.><Global Dimension 2 Code><Global Dimension 1 Code><Source No.><Source No.><Dimension Set ID><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Vendor Posting Group><Currency Code><Currency Filter><Vendor Filter><Purchaser Code><Pay-to Vendor No.><Payment Method Code><No. Series><IC Partner Code><Vendor No.><Preferred Bank Account Code><Vendor No.><Vendor No.><Maintenance Vendor No.><Unrealized Gains Acc.><Realized Gains Acc.><Unrealized Losses Acc.><Realized Losses Acc.><Realized G/L Gains Account><Realized G/L Losses Account><Residual Gains Account><Residual Losses Account><Conv. LCY Rndg. Debit Acc.><Conv. LCY Rndg. Credit Acc.><Customer Filter><Currency Code><Currency Filter><Global Dimension 1 Filter><Global Dimension 2 Filter><Currency Code><Currency Code><Currency Code><Payables Account><Service Charge Acc.><Payment Disc. Debit Acc.><Invoice Rounding Account><Debit Curr. Appln. Rndg. Acc.><Credit Curr. Appln. Rndg. Acc.><Debit Rounding Account><Credit Rounding Account><Payment Disc. Credit Acc.><Payment Tolerance Debit Acc.><Payment Tolerance Credit Acc.><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Dimension Value Code><Global Dimension 1 Code><Global Dimension 2 Code><Salesperson Code><Our Contact Code><Bal. Account No.><Receivables Account><Payables Account><Bill-to Customer No.><Payment Method Code><No. Series><IC Partner Code><Customer No.><No. Series><Credit Transfer Msg. Nos.><Direct Debit Msg. Nos.><Bal. Account No.><Component of Main Asset><No. Series>

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
3 Vendor No. Code20
4 Posting Date Date
5 Document Type Option
6 Document No. Code20
7 Description Text50
11 Currency Code Code10
13 Amount Decimal Editable: No
FlowField
14 Remaining Amount Decimal Editable: No
FlowField
15 Original Amt. (LCY) Decimal Editable: No
FlowField
16 Remaining Amt. (LCY) Decimal Editable: No
FlowField
17 Amount (LCY) Decimal Editable: No
FlowField
18 Purchase (LCY) Decimal
20 Inv. Discount (LCY) Decimal
21 Buy-from Vendor No. Code20
22 Vendor Posting Group Code10
23 Global Dimension 1 Code Code20
24 Global Dimension 2 Code Code20
25 Purchaser Code Code10
27 User ID Code50
28 Source Code Code10
33 On Hold Code3
34 Applies-to Doc. Type Option
35 Applies-to Doc. No. Code20
36 Open Boolean
37 Due Date Date
38 Pmt. Discount Date Date
39 Original Pmt. Disc. Possible Decimal Editable: No
40 Pmt. Disc. Rcd.(LCY) Decimal
43 Positive Boolean
44 Closed by Entry No. Integer
45 Closed at Date Date
46 Closed by Amount Decimal
47 Applies-to ID Code50
49 Journal Batch Name Code10
50 Reason Code Code10
51 Bal. Account Type Option
52 Bal. Account No. Code20
53 Transaction No. Integer
54 Closed by Amount (LCY) Decimal
58 Debit Amount Decimal BlankZero: Yes
Editable: No
FlowField
59 Credit Amount Decimal BlankZero: Yes
Editable: No
FlowField
60 Debit Amount (LCY) Decimal BlankZero: Yes
Editable: No
FlowField
61 Credit Amount (LCY) Decimal BlankZero: Yes
Editable: No
FlowField
62 Document Date Date
63 External Document No. Code35
64 No. Series Code10
65 Closed by Currency Code Code10
66 Closed by Currency Amount Decimal
73 Adjusted Currency Factor Decimal (0:15)
74 Original Currency Factor Decimal (0:15)
75 Original Amount Decimal Editable: No
FlowField
76 Date Filter Date FlowFilter
77 Remaining Pmt. Disc. Possible Decimal
78 Pmt. Disc. Tolerance Date Date
79 Max. Payment Tolerance Decimal
81 Accepted Payment Tolerance Decimal
82 Accepted Pmt. Disc. Tolerance Boolean
83 Pmt. Tolerance (LCY) Decimal
84 Amount to Apply Decimal
85 IC Partner Code Code20
86 Applying Entry Boolean
87 Reversed Boolean
88 Reversed by Entry No. Integer BlankZero: Yes
89 Reversed Entry No. Integer BlankZero: Yes
90 Prepayment Boolean
170 Creditor No. Code20 [Numeric:Yes]
171 Payment Reference Code50 [Numeric:Yes]
172 Payment Method Code Code10
173 Applies-to Ext. Doc. No. Code35
288 Recipient Bank Account Code10
289 Message to Recipient Text140
290 Exported to Payment File Boolean Editable: No
480 Dimension Set ID Integer Editable: No

Keys

# Fields
0 Entry No. Clustered: Yes
1 Vendor No.,Posting Date,Currency Code
2 Vendor No.,Currency Code,Posting Date
3 Document No.
4 External Document No.
5 Vendor No.,Open,Positive,Due Date,Currency Code
6 Open,Due Date
7 Document Type,Vendor No.,Posting Date,Currency Code MaintainSQLIndex: No
MaintainSIFTIndex: No
8 Closed by Entry No.
9 Transaction No.
10 Vendor No.,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date,Currency Code
11 Vendor No.,Open,Global Dimension 1 Code,Global Dimension 2 Code,Positive,Due Date,Currency Code
12 Open,Global Dimension 1 Code,Global Dimension 2 Code,Due Date
13 Document Type,Vendor No.,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date,Currency Code MaintainSQLIndex: No
MaintainSIFTIndex: No
14 Vendor No.,Applies-to ID,Open,Positive,Due Date

Table Relations To Other Tables

Field Related Table Related Field
Bal. Account No. Bank Account No. 1..n
Closed by Currency Code Currency Code 1..n
Bal. Account No. Customer No. 1..n
Dimension Set ID Dimension Set Entry 1..n
Global Dimension 2 Code Dimension Value Code 1..n
Bal. Account No. Fixed Asset No. 1..n
Bal. Account No. G/L Account No. 1..n
IC Partner Code IC Partner Code 1..n
No. Series No. Series Code 1..n
Payment Method Code Payment Method Code 1..n
Reason Code Reason Code Code 1..n
Purchaser Code Salesperson/Purchaser Code 1..n
Source Code Source Code Code 1..n
User ID User User Name 1..n
Bal. Account No. Vendor No. 1..n
Recipient Bank Account Vendor Bank Account Code 1..n
Reversed Entry No. Vendor Ledger Entry Entry No. 1..n
Vendor Posting Group Vendor Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field
Applied Payment Entry Applies-to Entry No. 1..n
Cash Flow Forecast Entry Source No. 1..n
Credit Transfer Entry Applies-to Entry No. 1..n
Detailed Vendor Ledg. Entry Vendor Ledger Entry No. 1..n
Payable Vendor Ledger Entry Vendor Ledg. Entry No. 1..n
Payment Application Proposal Applies-to Entry No. 1..n
Payment Buffer Payment Method Code 1..n
Purch. Cr. Memo Hdr. Vendor Ledger Entry No. 1..n
Purch. Inv. Header Vendor Ledger Entry No. 1..n
Reversal Entry Entry No. 1..n
Vendor Ledger Entry Reversed Entry No. 1..n