Diagrams

Table

Ledger Entry Matching Buffer

DynamicsDocs.comLedger Entry Matching Buffer«Table 1248»Ledger Entry Matching BufferEntry No. [PK]Account Type; [Customer,Vendor,G/L Acc...Account No.Bal. Account Type; [G/L Account,Custom...Bal. Account No.Document Type; [,Payment,Invoice,Credi...Due DatePosting DateDocument No.External Document No.Remaining AmountRemaining Amt. Incl. DiscountPmt. Discount Due Date

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

Fields

# Name Type
1 Entry No. (Entry No.) Integer
2 Account Type (Account Type) Option
3 Account No. (Account No.) Code20
4 Bal. Account Type (Bal. Account Type) Option
5 Bal. Account No. (Bal. Account No.) Code20
8 Document Type (Document Type) Option
9 Due Date (Due Date) Date
10 Posting Date (Posting Date) Date
11 Document No. (Document No.) Code20
12 External Document No. (External Document No.) Code35
20 Remaining Amount (Remaining Amount) Decimal
21 Remaining Amt. Incl. Discount (Remaining Amt. Incl. Discount) Decimal
22 Pmt. Discount Due Date (Pmt. Discount Due Date) Date

Keys

# Fields
0 Entry No.,Account Type (Entry No.,Account Type) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field