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 IDIdLast Modified Date Time«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><Currency Id><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. (Vendor No.) Code20
2 Currency Code (Currency Code) Code10
3 Vendor Ledg. Entry No. (Vendor Ledg. Entry No.) Integer
4 Dimension Entry No. (Dimension Entry No.) Integer
5 Global Dimension 1 Code (Global Dimension 1 Code) Code20
6 Global Dimension 2 Code (Global Dimension 2 Code) Code20
7 Document No. (Document No.) Code20
8 Amount (Amount) Decimal
9 Vendor Ledg. Entry Doc. Type (Vendor Ledg. Entry Doc. Type) Option
10 Vendor Ledg. Entry Doc. No. (Vendor Ledg. Entry Doc. No.) Code20
170 Creditor No. (Creditor No.) Code20 [Numeric:Yes]
171 Payment Reference (Payment Reference) Code50 [Numeric:Yes]
172 Payment Method Code (Payment Method Code) Code10
173 Applies-to Ext. Doc. No. (Applies-to Ext. Doc. No.) Code35
290 Exported to Payment File (Exported to Payment File) Boolean Editable: No
480 Dimension Set ID (Dimension Set ID) Integer Editable: No

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field