Diagrams


Table

Bank Account

DynamicsDocs.comBank Account«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 1207»Direct Debit CollectionNo. [PK]IdentifierCreated Date-TimeCreated by UserStatus; [New,Canceled,File Created,Pos...No. of TransfersTo Bank Account No.To Bank Account NameMessage IDPartner Type; [,Company,Person]«Table 1226»Payment Export DataEntry No. [PK]Data Exch Entry No.Line No.Data Exch. Line Def CodeGeneral Journal TemplateGeneral Journal Batch NameGeneral Journal Line No.Sender Bank Name - Data Conv.Sender Bank NameSender Bank Account CodeSender Bank Account No.Sender Bank Account CurrencySender Bank Country/RegionSender Bank BICSender Bank Clearing Std.Sender Bank Clearing CodeSender Bank AddressSender Bank CitySender Bank Post CodeRecipient NameRecipient AddressRecipient CityRecipient Post CodeRecipient Country/Region CodeRecipient Email AddressRecipient IDRecipient Bank Clearing Std.Recipient Bank Clearing CodeRecipient Reg. No.Recipient Acc. No.Recipient Bank Acc. No....«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 1299»Payment Matching DetailsBank Account No. [PK]Statement No. [PK]Statement Line No. [PK]Statement Type; [Bank Reconciliation,P...Line No. [PK]Message«Table 1625»Office Contact AssociationsContact No. [PK]Business Relation CodeAssociated Table; [,Customer,Vendor,Ba...No.Business Relation DescriptionContact NameType; [Company,Contact Person] [PK]«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 275»Bank Account StatementBank Account No. [PK,NN]Statement No. [PK,NN]Statement Ending BalanceStatement DateBalance Last Statement«Table 289»Payment MethodCode [PK,NN]DescriptionBal. Account Type; [G/L Account,Bank A...Bal. Account No.Direct DebitDirect Debit Pmt. Terms CodePmt. Export Line DefinitionBank Data Conversion Pmt. TypeUse for InvoicingLast Modified Date TimeId«Table 5054»Contact Business RelationContact No. [PK,NN]Business Relation Code [PK,NN]Link to Table; [,Customer,Vendor,Bank...No.Business Relation DescriptionContact Name«Table 777»Online Bank Acc. LinkNo. [PK]Online Bank Account IDOnline Bank IDAutomatic Logon PossibleNameCurrency CodeContactBank Account No.Temp Linked Bank Account No.ProviderId«Table 980»Payment Registration SetupUser ID [PK]Journal Template NameJournal Batch NameBal. Account Type; [,G/L Account,Bank...Bal. Account No.Use this Account as Def.Auto Fill Date Received«Table 277»Bank Account Posting GroupCode [PK,NN]G/L Bank Account No.«Table 1200»Bank Export/Import SetupCode [PK,NN]NameDirection; [Export,Import,Export-Posit...Processing Codeunit IDProcessing Codeunit NameProcessing XMLport IDProcessing XMLport NameData Exch. Def. CodeData Exch. Def. NamePreserve Non-Latin CharactersCheck Export CodeunitCheck Export Codeunit Name«Table 1280»Bank Clearing StandardCode [PK]Description<Bank Acc. Posting Group><Bank Statement Import Format><SEPA Direct Debit Exp. Format><Payment Export Format><Positive Pay Export Code><Bank Clearing Standard><To Bank Account No.><Sender Bank Account Code><Bank Account No.><Account No.><Bank Account No.><No.><Bank Account No.><Bank Account No.><Bal. Account No.><No.><No.><Bal. Account No.><Sender Bank Clearing Std.><Recipient Bank Clearing Std.><Statement No.><Statement No.>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 No. Code20
2 Name Text50
3 Search Name Code50
4 Name 2 Text50
5 Address Text50
6 Address 2 Text50
7 City Text30
8 Contact Text50
9 Phone No. Text30 [Phone No.]
10 Telex No. Text20
13 Bank Account No. Text30
14 Transit No. Text20
15 Territory Code Code10
16 Global Dimension 1 Code Code20
17 Global Dimension 2 Code Code20
18 Chain Name Code10
20 Min. Balance Decimal
21 Bank Acc. Posting Group Code20
22 Currency Code Code10
24 Language Code Code10
26 Statistics Group Integer
29 Our Contact Code Code20
35 Country/Region Code Code10
37 Amount Decimal
38 Comment Boolean Editable: No
FlowField
39 Blocked Boolean
41 Last Statement No. Code20
42 Last Payment Statement No. Code20
54 Last Date Modified Date Editable: No
55 Date Filter Date FlowFilter
56 Global Dimension 1 Filter Code20 FlowFilter
57 Global Dimension 2 Filter Code20 FlowFilter
58 Balance Decimal Editable: No
FlowField
59 Balance (LCY) Decimal Editable: No
FlowField
60 Net Change Decimal Editable: No
FlowField
61 Net Change (LCY) Decimal Editable: No
FlowField
62 Total on Checks Decimal Editable: No
FlowField
84 Fax No. Text30
85 Telex Answer Back Text20
89 Picture BLOB [Bitmap]
91 Post Code Code20
92 County Text30
93 Last Check No. Code20
94 Balance Last Statement Decimal
95 Balance at Date Decimal Editable: No
FlowField
96 Balance at Date (LCY) Decimal Editable: No
FlowField
97 Debit Amount Decimal BlankZero: Yes
Editable: No
FlowField
98 Credit Amount Decimal BlankZero: Yes
Editable: No
FlowField
99 Debit Amount (LCY) Decimal BlankZero: Yes
Editable: No
FlowField
100 Credit Amount (LCY) Decimal BlankZero: Yes
Editable: No
FlowField
101 Bank Branch No. Text20
102 E-Mail Text80 [E-Mail]
103 Home Page Text80 [URL]
107 No. Series Code20 Editable: No
108 Check Report ID Integer
109 Check Report Name Text250 Editable: No
FlowField
110 IBAN Code50
111 SWIFT Code Code20
113 Bank Statement Import Format Code20
115 Credit Transfer Msg. Nos. Code20
116 Direct Debit Msg. Nos. Code20
117 SEPA Direct Debit Exp. Format Code20
121 Bank Stmt. Service Record ID RecordID
123 Transaction Import Timespan Integer
124 Automatic Stmt. Import Enabled Boolean
140 Image Media [Person]
170 Creditor No. Code35
1210 Payment Export Format Code20
1211 Bank Clearing Code Text50
1212 Bank Clearing Standard Text50
1213 Bank Name - Data Conversion Text50
1250 Match Tolerance Type Option
1251 Match Tolerance Value Decimal (0:5)
1260 Positive Pay Export Code Code20

Keys

# Fields
0 No. Clustered: Yes
1 Search Name
2 Bank Acc. Posting Group
3 Currency Code
4 Country/Region Code

Table Relations To Other Tables

Field Related Table Related Field
Check Report ID AllObjWithCaption Object ID 1..n
Bank Acc. Posting Group Bank Account Posting Group Code 1..n
Bank Clearing Standard Bank Clearing Standard Code 1..n
Positive Pay Export Code Bank Export/Import Setup Code 1..n
Country/Region Code Country/Region Code 1..n
Currency Code Currency Code 1..n
Global Dimension 2 Filter Dimension Value Code 1..n
Language Code Language Code 1..n
Direct Debit Msg. Nos. No. Series Code 1..n
Our Contact Code Salesperson/Purchaser Code 1..n
Territory Code Territory Code 1..n

Table Relations From Other Tables

From Table From Field
Applied Payment Entry Account No. 1..n
Bank Acc. Reconciliation Bank Account No. 1..n
Bank Acc. Reconciliation Line Account No. 1..n
Bank Account Ledger Entry Bal. Account No. 1..n
Bank Account Statement Bank Account No. 1..n
Bank Account Statement Line Bank Account No. 1..n
CV Ledger Entry Buffer Bal. Account No. 1..n
Check Ledger Entry Bal. Account No. 1..n
Comment Line No. 1..n
Contact Business Relation No. 1..n
Credit Transfer Register From Bank Account No. 1..n
Cust. Ledger Entry Bal. Account No. 1..n
Default Dimension No. 1..n
Direct Debit Collection To Bank Account No. 1..n
Employee Ledger Entry Bal. Account No. 1..n
FA Ledger Entry Bal. Account No. 1..n
G/L Entry Source No. 1..n
Gen. Journal Batch Bal. Account No. 1..n
Gen. Journal Line Source No. 1..n
Gen. Journal Template Bal. Account No. 1..n
Maintenance Ledger Entry Bal. Account No. 1..n
Office Contact Associations No. 1..n
Online Bank Acc. Link No. 1..1
Payment Application Proposal Account No. 1..n
Payment Export Data Sender Bank Account Code 1..n
Payment Matching Details Bank Account No. 1..n
Payment Method Bal. Account No. 1..n
Payment Registration Buffer Bal. Account No. 1..n
Payment Registration Setup Bal. Account No. 1..n
Positive Pay Entry Bank Account No. 1..n
Positive Pay Entry Detail Bank Account No. 1..n
Posted Payment Recon. Hdr Bank Account No. 1..n
Posted Payment Recon. Line Account No. 1..n
Purch. Cr. Memo Hdr. Bal. Account No. 1..n
Purch. Inv. Header Bal. Account No. 1..n
Purch. Rcpt. Header Bal. Account No. 1..n
Purchase Header Bal. Account No. 1..n
Purchase Header Archive Bal. Account No. 1..n
Return Receipt Header Bal. Account No. 1..n
Return Shipment Header Bal. Account No. 1..n
Reversal Entry Bal. Account No. 1..n
Sales Cr.Memo Header Bal. Account No. 1..n
Sales Header Bal. Account No. 1..n
Sales Header Archive Bal. Account No. 1..n
Sales Invoice Header Bal. Account No. 1..n
Sales Shipment Header Bal. Account No. 1..n
Service Cr.Memo Header Bal. Account No. 1..n
Service Header Bal. Account No. 1..n
Service Invoice Header Bal. Account No. 1..n
Service Shipment Header Bal. Account No. 1..n
Standard General Journal Line Source No. 1..n
Text-to-Account Mapping Bal. Source No. 1..n
Vendor Ledger Entry Bal. Account No. 1..n