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 DifferenceCopy VAT Setup to Jnl. LineDimension 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 IDIdLast Modified Date Time«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. (Bank Account No.) Code20 NotBlank: Yes
2 Statement No. (Statement No.) Code20 NotBlank: Yes
Editable: No
3 Statement Ending Balance (Statement Ending Balance) Decimal
4 Statement Date (Statement Date) Date
5 Balance Last Statement (Balance Last Statement) Decimal
6 Bank Statement (Bank Statement) BLOB
7 Total Balance on Bank Account (Total Balance on Bank Account) Decimal Editable: No
FlowField
8 Total Applied Amount (Total Applied Amount) Decimal Editable: No
FlowField
9 Total Transaction Amount (Total Transaction Amount) Decimal Editable: No
FlowField
10 Total Unposted Applied Amount (Total Unposted Applied Amount) Decimal Editable: No
FlowField
11 Total Difference (Total Difference) Decimal Editable: No
FlowField
20 Statement Type (Statement Type) Option
21 Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) Code20
22 Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Code20
23 Post Payments Only (Post Payments Only) Boolean
24 Import Posted Transactions (Import Posted Transactions) Option
25 Total Outstd Bank Transactions (Total Outstd Bank Transactions) Decimal Editable: No
FlowField
26 Total Outstd Payments (Total Outstd Payments) Decimal Editable: No
FlowField
27 Total Applied Amount Payments (Total Applied Amount Payments) Decimal Editable: No
FlowField
28 Bank Account Balance (LCY) (Bank Account Balance (LCY)) Decimal Editable: No
FlowField
29 Total Positive Adjustments (Total Positive Adjustments) Decimal Editable: No
FlowField
30 Total Negative Adjustments (Total Negative Adjustments) Decimal Editable: No
FlowField
31 Total Positive Difference (Total Positive Difference) Decimal Editable: No
FlowField
32 Total Negative Difference (Total Negative Difference) Decimal Editable: No
FlowField
33 Copy VAT Setup to Jnl. Line (Copy VAT Setup to Jnl. Line) Boolean
480 Dimension Set ID (Dimension Set ID) Integer Editable: No

Keys

# Fields
0 Statement Type,Bank Account No.,Statement No. (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.) Bank Account No. (No.) 1..n
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Dimension Value Code (Code) 1..n

Table Relations From Other Tables

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