Diagrams


Table

Bank Acc. Reconciliation Line

DynamicsDocs.comBank Acc. Reconciliation Line«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 OrderDimension Set ID...«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 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 273»Bank Acc. ReconciliationBank Account No. [PK,NN]Statement No. [PK,NN]Statement Ending BalanceStatement DateBalance Last StatementBank StatementTotal Balance on Bank AccountTotal Applied AmountTotal Transaction AmountStatement Type; [Bank Reconciliation,P...Shortcut Dimension 1 CodeShortcut Dimension 2 CodeDimension Set ID«Table 1220»Data Exch.Entry No. [PK]File NameFile ContentData Exch. Def CodeData Exch. Line Def CodeTable FiltersIncoming Entry No.«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeIncome/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.Business Unit Filter...«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 Group«Table 413»IC PartnerCode [PK,NN]NameCurrency CodeInbox Type; [File Location,Database,E-...Inbox DetailsReceivables AccountPayables AccountBlockedCommentCustomer No.Vendor No.Outbound Sales Item No. Type; [Interna...Outbound Purch. Item No. Type; [Intern...Cost Distribution in LCY«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<Bank Account No.><Account No.><Statement No.><Data Exch. Entry No.><Account No.><Account No.><Account No.><Account No.><Account No.><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Dimension Set ID><Statement No.><Statement Line No.><Statement No.><Statement Line No.><Bank Account No.><Bal. Account No.><Global Dimension 1 Code><Global Dimension 2 Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Dimension Set ID><Bank Account Ledger Entry No.><Bank Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Data Exch. Entry No.><Data Exch. Voided Entry No.><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Bank Account No.><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Dimension Set ID><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Receivables Account><Payables Account><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Bill-to Customer No.><IC Partner Code><Customer No.><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Pay-to Vendor No.><IC Partner Code><Vendor No.><Vendor No.><Maintenance Vendor No.><Global Dimension 1 Code><Global Dimension 2 Code><Component of Main Asset><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 Bank Account No. Code20
2 Statement No. Code20
3 Statement Line No. Integer
4 Document No. Code20
5 Transaction Date Date
6 Description Text50
7 Statement Amount Decimal
8 Difference Decimal
9 Applied Amount Decimal Editable: No
10 Type Option
11 Applied Entries Integer Editable: No
12 Value Date Date
13 Ready for Application Boolean
14 Check No. Code20
15 Related-Party Name Text250
16 Additional Transaction Info Text100
17 Data Exch. Entry No. Integer Editable: No
18 Data Exch. Line No. Integer Editable: No
20 Statement Type Option
21 Account Type Option
22 Account No. Code20
23 Transaction Text Text140
24 Related-Party Bank Acc. No. Text100
25 Related-Party Address Text100
26 Related-Party City Text50
31 Shortcut Dimension 1 Code Code20
32 Shortcut Dimension 2 Code Code20
50 Match Confidence Option Editable: No
FlowField
51 Match Quality Integer Editable: No
FlowField
60 Sorting Order Integer
480 Dimension Set ID Integer Editable: No

Keys

# Fields
0 Statement Type,Bank Account No.,Statement No.,Statement Line No. Clustered: Yes
MaintainSIFTIndex: No

Table Relations To Other Tables

Field Related Table Related Field
Statement No. Bank Acc. Reconciliation Statement No. 1..n
Account No. Bank Account No. 1..n
Account No. Customer No. 1..n
Data Exch. Entry No. Data Exch. Entry No. 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n
Account No. Fixed Asset No. 1..n
Account No. G/L Account 1..n
Account No. IC Partner Code 1..n
Account No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field
Bank Account Ledger Entry Statement Line No. 1..n
Check Ledger Entry Statement Line No. 1..n