Diagrams


Table

Payable Vendor Ledger Entry

DynamicsDocs.comPayable Vendor Ledger Entry«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 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 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 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]...<Vendor No.><Vendor Ledg. Entry No.><Currency Code><Currency Code><Currency Filter><Vendor Filter><Pay-to Vendor No.><Vendor No.><Buy-from Vendor No.><Bal. Account No.><Currency Code><Closed by Currency Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.>

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

Fields

# Name Type
1 Priority Integer
2 Vendor No. Code20
3 Entry No. Integer
4 Vendor Ledg. Entry No. Integer
5 Amount Decimal
6 Amount (LCY) Decimal
7 Currency Code Code10
8 Positive Boolean
9 Future Boolean

Keys

# Fields
0 Priority,Vendor No.,Currency Code,Positive,Future,Entry No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Currency Code Currency Code 1..n
Vendor No. Vendor No. 1..n
Vendor Ledg. Entry No. Vendor Ledger Entry Entry No. 1..n

Table Relations From Other Tables

From Table From Field