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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

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