Diagrams


Table

Bank Acc. Reconciliation

DynamicsDocs.comBank Acc. Reconciliation«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 AmountTotal Unposted Applied AmountTotal DifferenceStatement Type; [Bank Reconciliation,P...Shortcut Dimension 1 CodeShortcut Dimension 2 CodePost Payments OnlyImport Posted Transactions; [,Yes,No]Total Outstd Bank TransactionsTotal Outstd PaymentsTotal Applied Amount PaymentsBank Account Balance [LCY]Total Positive AdjustmentsTotal Negative AdjustmentsTotal Positive DifferenceTotal Negative DifferenceDimension Set ID«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 1296»Posted Payment Recon. LineBank Account No. [PK]Statement No. [PK]Statement Line No. [PK]Document No.Transaction DateDescriptionStatement AmountDifferenceApplied AmountType; [Bank Account Ledger Entry,Check...Applied EntriesValue DateCheck No.Related-Party NameAdditional Transaction InfoData Exch. Entry No.Data Exch. Line No.Account Type; [G/L Account,Customer,Ve...Account No.Applied Document No.Applied Entry No.Transaction IDReconciled«Table 1299»Payment Matching DetailsBank Account No. [PK]Statement No. [PK]Statement Line No. [PK]Statement Type; [Bank Reconciliation,P...Line No. [PK]Message«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 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 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.><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Dimension Set ID><Statement No.><Statement No.><Statement No.><Statement No.><Statement No.><Bank Account No.><Account No.><Bank Account No.><Account No.><Bank Account No.><Account No.><Bank Account No.><Bank Account No.><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><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 NotBlank: Yes
2 Statement No. Code20 NotBlank: Yes
Editable: No
3 Statement Ending Balance Decimal
4 Statement Date Date
5 Balance Last Statement Decimal
6 Bank Statement BLOB
7 Total Balance on Bank Account Decimal Editable: No
FlowField
8 Total Applied Amount Decimal Editable: No
FlowField
9 Total Transaction Amount Decimal Editable: No
FlowField
10 Total Unposted Applied Amount Decimal Editable: No
FlowField
11 Total Difference Decimal Editable: No
FlowField
20 Statement Type Option
21 Shortcut Dimension 1 Code Code20
22 Shortcut Dimension 2 Code Code20
23 Post Payments Only Boolean
24 Import Posted Transactions Option
25 Total Outstd Bank Transactions Decimal Editable: No
FlowField
26 Total Outstd Payments Decimal Editable: No
FlowField
27 Total Applied Amount Payments Decimal Editable: No
FlowField
28 Bank Account Balance (LCY) Decimal Editable: No
FlowField
29 Total Positive Adjustments Decimal Editable: No
FlowField
30 Total Negative Adjustments Decimal Editable: No
FlowField
31 Total Positive Difference Decimal Editable: No
FlowField
32 Total Negative Difference Decimal Editable: No
FlowField
480 Dimension Set ID Integer Editable: No

Keys

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

Table Relations To Other Tables

Field Related Table Related Field
Bank Account No. Bank Account No. 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n

Table Relations From Other Tables

From Table From Field
Applied Payment Entry Statement No. 1..n
Bank Acc. Reconciliation Line Statement No. 1..n
Payment Application Proposal Statement No. 1..n
Payment Matching Details Statement No. 1..n
Posted Payment Recon. Line Statement No. 1..n