Diagrams


Table

Payment Buffer

DynamicsDocs.comPayment Buffer«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 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 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 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 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Vendor No.><Currency Code><Vendor Ledg. Entry No.><Creditor No.><Payment Reference><Payment Method Code><Global Dimension 1 Code><Global Dimension 2 Code><Dimension Set ID><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.><Vendor No.><Buy-from Vendor No.><Bal. Account No.><Global Dimension 1 Filter><Global Dimension 2 Filter><Currency Code><Closed by Currency Code><Global Dimension 1 Code><Global Dimension 2 Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Dimension Set ID><Dimension Value Code>

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

Fields

# Name Type
1 Vendor No. Code20
2 Currency Code Code10
3 Vendor Ledg. Entry No. Integer
4 Dimension Entry No. Integer
5 Global Dimension 1 Code Code20
6 Global Dimension 2 Code Code20
7 Document No. Code20
8 Amount Decimal
9 Vendor Ledg. Entry Doc. Type Option
10 Vendor Ledg. Entry Doc. No. Code20
170 Creditor No. Code20 [Numeric:Yes]
171 Payment Reference Code50 [Numeric:Yes]
172 Payment Method Code Code10
173 Applies-to Ext. Doc. No. Code35
290 Exported to Payment File Boolean Editable: No
480 Dimension Set ID Integer Editable: No

Keys

# Fields
0 Vendor No.,Currency Code,Vendor Ledg. Entry No.,Dimension Entry No. Clustered: Yes
1 Document No.

Table Relations To Other Tables

Field Related Table Related Field
Currency Code Currency Code 1..n
Dimension Set ID Dimension Set Entry 1..n
Global Dimension 2 Code Dimension Value Code 1..n
Vendor No. Vendor No. 1..n
Payment Method Code Vendor Ledger Entry Payment Method Code 1..n

Table Relations From Other Tables

From Table From Field