Diagrams

Table

Bank Account Ledger Entry

DynamicsDocs.comBank Account Ledger Entry«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 1293»Payment Application ProposalBank Account No. [PK]Statement No. [PK]Statement Line No. [PK]Statement Type; [Bank Reconciliation,P...Account Type; [G/L Account,Customer,Ve...Account No. [PK]Applies-to Entry No. [PK]Applied AmountAppliedApplied Pmt. DiscountQualityPosting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeDue DateExternal Document No.Match Confidence; [None,Low,Medium,Hig...Pmt. Disc. Due DateRemaining Pmt. Disc. PossiblePmt. Disc. Tolerance DateApplied Amt. Incl. DiscountRemaining AmountRemaining Amt. Incl. DiscountType; [Bank Account Ledger Entry,Check...Sorting OrderStmt To Rem. Amount Difference«Table 1294»Applied Payment EntryBank Account No. [PK]Statement No. [PK]Statement Line No. [PK]Statement Type; [Bank Reconciliation,P...Account Type; [G/L Account,Customer,Ve...Account No. [PK]Applies-to Entry No. [PK]Applied AmountApplied Pmt. DiscountQualityPosting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeDue DateExternal Document No.Match Confidence; [None,Low,Medium,Hig...«Table 179»Reversal EntryLine No. [PK]Entry Type; [,G/L Account,Customer,Ven...Entry No.G/L Register No.Source CodeJournal Batch NameTransaction No.Source Type; [,Customer,Vendor,Bank Ac...Source No.Currency CodeDescriptionAmountDebit AmountCredit AmountAmount [LCY]Debit Amount [LCY]Credit Amount [LCY]VAT AmountPosting DateDocument Type; [,Payment,Invoice,Credi...Document No.Account No.Account NameBal. Account Type; [G/L Account,Custom...Bal. Account No.FA Posting Category; [,Disposal,Bal. D...FA Posting Type; [,Acquisition Cost,De...Reversal Type; [Transaction,Register]«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 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 277»Bank Account Posting GroupCode [PK,NN]G/L Bank Account 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 13»Salesperson/PurchaserCode [PK,NN]NameCommission %ImageGlobal Dimension 1 CodeGlobal Dimension 2 CodeE-MailPhone No.Next To-do DateNo. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterNo. of InteractionsCost [LCY]Duration [Min.]Job TitleAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterAvg. Estimated Value [LCY]Avg.Calcd. Current Value [LCY]Contact FilterContact Company FilterCampaign FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTo-do Status Filter; [Not Started,In P......«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 230»Source CodeCode [PK,NN]Description«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«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 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Bank Account No.><Bal. Account No.><Currency Code><Bank Acc. Posting Group><Global Dimension 1 Code><Global Dimension 2 Code><Our Contact Code><User ID><Source Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Reason Code><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Statement No.><Statement Line No.><Dimension Set ID><Applies-to Entry No.><Applies-to Entry No.><Entry No.><Bank Account Ledger Entry No.><Bank Account No.><Account No.><Account No.><Account No.><Account No.><Account No.><Currency Code><Bank Account No.><Account No.><Account No.><Account No.><Account No.><Account No.><Currency Code><Source Code><Source No.><Bal. Account No.><Source No.><Bal. Account No.><Source No.><Bal. Account No.><Source No.><Bal. Account No.><Currency Code><Bal. Account No.><Bank Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Statement No.><Statement Line No.><User ID><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Bank Acc. Posting Group><Currency Code><Our Contact Code><Bank Account No.><Account No.><Unrealized Gains Acc.><Realized Gains Acc.><Unrealized Losses Acc.><Realized Losses Acc.><Realized G/L Gains Account><Realized G/L Losses Account><Residual Gains Account><Residual Losses Account><Conv. LCY Rndg. Debit Acc.><Conv. LCY Rndg. Credit Acc.><Customer Filter><Currency Code><Currency Filter><Vendor Filter><Currency Code><Currency Filter><Global Dimension 1 Filter><Global Dimension 2 Filter><G/L Bank Account No.><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Dimension Value Code><Global Dimension 1 Code><Global Dimension 2 Code><Salesperson Code><Purchaser Code><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.><Dimension Set ID>

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
3 Bank Account No. (Bank Account No.) Code20
4 Posting Date (Posting Date) Date
5 Document Type (Document Type) Option
6 Document No. (Document No.) Code20
7 Description (Description) Text50
11 Currency Code (Currency Code) Code10
13 Amount (Amount) Decimal
14 Remaining Amount (Remaining Amount) Decimal
17 Amount (LCY) (Amount (LCY)) Decimal
22 Bank Acc. Posting Group (Bank Acc. Posting Group) Code10
23 Global Dimension 1 Code (Global Dimension 1 Code) Code20
24 Global Dimension 2 Code (Global Dimension 2 Code) Code20
25 Our Contact Code (Our Contact Code) Code10
27 User ID (User ID) Code50
28 Source Code (Source Code) Code10
36 Open (Open) Boolean
43 Positive (Positive) Boolean
44 Closed by Entry No. (Closed by Entry No.) Integer
45 Closed at Date (Closed at Date) Date
49 Journal Batch Name (Journal Batch Name) Code10
50 Reason Code (Reason Code) Code10
51 Bal. Account Type (Bal. Account Type) Option
52 Bal. Account No. (Bal. Account No.) Code20
53 Transaction No. (Transaction No.) Integer
55 Statement Status (Statement Status) Option
56 Statement No. (Statement No.) Code20
57 Statement Line No. (Statement Line No.) Integer
58 Debit Amount (Debit Amount) Decimal BlankZero: Yes
59 Credit Amount (Credit Amount) Decimal BlankZero: Yes
60 Debit Amount (LCY) (Debit Amount (LCY)) Decimal BlankZero: Yes
61 Credit Amount (LCY) (Credit Amount (LCY)) Decimal BlankZero: Yes
62 Document Date (Document Date) Date [ClosingDates:Yes]
63 External Document No. (External Document No.) Code35
64 Reversed (Reversed) Boolean
65 Reversed by Entry No. (Reversed by Entry No.) Integer BlankZero: Yes
66 Reversed Entry No. (Reversed Entry No.) Integer BlankZero: Yes
70 Check Ledger Entries (Check Ledger Entries) Integer FlowField
480 Dimension Set ID (Dimension Set ID) Integer Editable: No

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Bank Account No.,Posting Date (Bank Account No.,Posting Date)
2 Bank Account No.,Open (Bank Account No.,Open)
3 Document Type,Bank Account No.,Posting Date (Document Type,Bank Account No.,Posting Date) MaintainSQLIndex: No
4 Document No.,Posting Date (Document No.,Posting Date)
5 Transaction No. (Transaction No.)
6 Bank Account No.,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date (Bank Account No.,Global Dimension 1 Code,Global Dimension 2 Code,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
Reversed Entry No. (Reversed Entry No.) Bank Account Ledger Entry Entry No. (Entry No.) 1..n
Bank Acc. Posting Group (Bank Acc. Posting Group) Bank Account Posting Group Code (Code) 1..n
Currency Code (Currency Code) Currency Code (Code) 1..n
Bal. Account No. (Bal. Account No.) Customer No. (No.) 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
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
Reason Code (Reason Code) Reason Code Code (Code) 1..n
Our Contact Code (Our Contact Code) Salesperson/Purchaser Code (Code) 1..n
Source Code (Source Code) Source Code Code (Code) 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
Applied Payment Entry Applies-to Entry No. (Applies-to Entry No.) 1..n
Bank Account Ledger Entry Reversed Entry No. (Reversed Entry No.) 1..n
Check Ledger Entry Bank Account Ledger Entry No. (Bank Account Ledger Entry No.) 1..n
Payment Application Proposal Applies-to Entry No. (Applies-to Entry No.) 1..n
Reversal Entry Entry No. (Entry No.) 1..n