Diagrams

Table

Check Ledger Entry

DynamicsDocs.comCheck Ledger Entry«Table 272»Check Ledger EntryEntry No. [PK]Bank Account No.Bank Account Ledger Entry No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionAmountCheck DateCheck No.Check Type; [Total Check,Partial Check...Bank Payment Type; [,Computer Check,Ma...Entry Status; [,Printed,Voided,Posted,...Original Entry Status; [,Printed,Voide...Bal. Account Type; [G/L Account,Custom...Bal. Account No.OpenStatement Status; [Open,Bank Acc. Entr...Statement No.Statement Line No.User IDExternal Document No.Data Exch. Entry No.Data Exch. Voided Entry No.Positive Pay ExportedRecord ID to Print«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 271»Bank Account Ledger EntryEntry No. [PK]Bank Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeAmountRemaining AmountAmount [LCY]Bank Acc. Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeOur Contact CodeUser IDSource CodeOpenPositiveClosed by Entry No.Closed at DateJournal Batch NameReason CodeBal. Account Type; [G/L Account,Custom...Bal. Account No.Transaction No.Statement Status; [Open,Bank Acc. Entr...Statement No.Statement Line No.Debit AmountCredit AmountDebit Amount [LCY]...«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 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 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 274»Bank Acc. Reconciliation LineBank Account No. [PK]Statement No. [PK]Statement Line No. [PK]Document No.Transaction DateDescriptionStatement AmountDifferenceApplied AmountType; [Bank Account Ledger Entry,Check...Applied EntriesValue DateReady for ApplicationCheck No.Related-Party NameAdditional Transaction InfoData Exch. Entry No.Data Exch. Line No.Statement Type; [Bank Reconciliation,P...Account Type; [G/L Account,Customer,Ve...Account No.Transaction TextRelated-Party Bank Acc. No.Related-Party AddressRelated-Party CityShortcut Dimension 1 CodeShortcut Dimension 2 CodeMatch Confidence; [None,Low,Medium,Hig...Match QualitySorting OrderParent Line No....«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 1220»Data Exch.Entry No. [PK]File NameFile ContentData Exch. Def CodeData Exch. Line Def CodeTable FiltersIncoming Entry No.Related Record<Bank Account No.><Bal. Account No.><Bank Account Ledger Entry No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Statement No.><Statement Line No.><User ID><Data Exch. Entry No.><Data Exch. Voided Entry No.><Bank Account No.><Bal. Account No.><Bank Account No.><Account No.><User ID><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Statement No.><Statement Line No.><Account No.><Bill-to Customer No.><Account No.><Pay-to Vendor No.><Account No.><Vendor No.><Maintenance Vendor No.><Component of Main Asset><Account No.><Data Exch. Entry No.>

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 Bank Account No. (Bank Account No.) Code20
3 Bank Account Ledger Entry No. (Bank Account Ledger Entry No.) Integer
4 Posting Date (Posting Date) Date
5 Document Type (Document Type) Option
6 Document No. (Document No.) Code20
7 Description (Description) Text50
8 Amount (Amount) Decimal
9 Check Date (Check Date) Date
10 Check No. (Check No.) Code20
11 Check Type (Check Type) Option
12 Bank Payment Type (Bank Payment Type) Option
13 Entry Status (Entry Status) Option
14 Original Entry Status (Original Entry Status) Option
15 Bal. Account Type (Bal. Account Type) Option
16 Bal. Account No. (Bal. Account No.) Code20
17 Open (Open) Boolean
18 Statement Status (Statement Status) Option
19 Statement No. (Statement No.) Code20
20 Statement Line No. (Statement Line No.) Integer
21 User ID (User ID) Code50
22 External Document No. (External Document No.) Code35
23 Data Exch. Entry No. (Data Exch. Entry No.) Integer Editable: No
24 Data Exch. Voided Entry No. (Data Exch. Voided Entry No.) Integer Editable: No
25 Positive Pay Exported (Positive Pay Exported) Boolean
26 Record ID to Print (Record ID to Print) RecordID

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Bank Account No.,Check Date (Bank Account No.,Check Date)
2 Bank Account No.,Entry Status,Check No. (Bank Account No.,Entry Status,Check No.)
3 Bank Account Ledger Entry No. (Bank Account Ledger Entry No.)
4 Bank Account No.,Open (Bank Account No.,Open)
5 Document No.,Posting Date (Document No.,Posting Date)

Table Relations To Other Tables

Field Related Table Related Field
Statement Line No. (Statement Line No.) Bank Acc. Reconciliation Line Statement Line No. (Statement Line No.) 1..n
Bal. Account No. (Bal. Account No.) Bank Account No. (No.) 1..n
Bank Account Ledger Entry No. (Bank Account Ledger Entry No.) Bank Account Ledger Entry Entry No. (Entry No.) 1..n
Bal. Account No. (Bal. Account No.) Customer No. (No.) 1..n
Data Exch. Voided Entry No. (Data Exch. Voided Entry No.) Data Exch. Entry No. (Entry No.) 1..n
Bal. Account No. (Bal. Account No.) Fixed Asset No. (No.) 1..n
Bal. Account No. (Bal. Account No.) G/L Account No. (No.) 1..n
User ID (User ID) User User Name (User Name) 1..n
Bal. Account No. (Bal. Account No.) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field