Bank Account #270

Other table in Microsoft Dynamics 365 Business Central. 87 fields, 2 records in Cronus demo.

Bank Account stores each bank account record in Business Central — account number, currency, bank details, and posting group. It is referenced by payment journals, bank reconciliations, and cash management workflows.

COMMON USE CASES

Bank account master data
Payment journal bank selection
Bank reconciliation setup
Multi-currency banking
Cash management and reporting

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: No..

All fields (87)

Bank Account — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	No. PK	Code	Normal
2	Name	Text	Normal
3	Search Name	Code	Normal
4	Name 2	Text	Normal
5	Address	Text	Normal
6	Address 2	Text	Normal
7	City	Text	Normal
8	Contact	Text	Normal
9	Phone No.	Text	Normal
10	Telex No.	Text	Normal
13	Bank Account No.	Text	Normal
14	Transit No.	Text	Normal
15	Territory Code	Code	Normal	→ Territory #286
16	Global Dimension 1 Code	Code	Normal	→ Dimension Value #349
17	Global Dimension 2 Code	Code	Normal	→ Dimension Value #349
18	Chain Name	Code	Normal
20	Min. Balance	Decimal	Normal
21	Bank Acc. Posting Group	Code	Normal	→ Bank Account Posting Group #277
22	Currency Code	Code	Normal	→ Currency #4
24	Language Code	Code	Normal	→ Language #8
25	Format Region	Text	Normal
26	Statistics Group	Integer	Normal
29	Our Contact Code	Code	Normal	→ Salesperson/Purchaser #13
35	Country/Region Code	Code	Normal	→ Country/Region #9
37	Amount	Decimal	Normal
38	Comment ⚡ FLOW	Boolean	FlowField
39	Blocked	Boolean	Normal
41	Last Statement No.	Code	Normal
42	Last Payment Statement No.	Code	Normal
43	Payment Reconciliation No. Series	Code	Normal	→ No. Series #308
54	Last Date Modified	Date	Normal
55	Date Filter	Date	FlowFilter
56	Global Dimension 1 Filter	Code	FlowFilter	→ Dimension Value #349
57	Global Dimension 2 Filter	Code	FlowFilter	→ Dimension Value #349
58	Balance ⚡ FLOW	Decimal	FlowField
59	Balance (LCY) ⚡ FLOW	Decimal	FlowField
60	Net Change ⚡ FLOW	Decimal	FlowField
61	Net Change (LCY) ⚡ FLOW	Decimal	FlowField
62	Total on Checks ⚡ FLOW	Decimal	FlowField
70	Use as Default for Currency	Boolean	Normal
84	Fax No.	Text	Normal
85	Telex Answer Back	Text	Normal
91	Post Code	Code	Normal
92	County	Text	Normal
93	Last Check No.	Code	Normal
94	Balance Last Statement	Decimal	Normal
95	Balance at Date ⚡ FLOW	Decimal	FlowField
96	Balance at Date (LCY) ⚡ FLOW	Decimal	FlowField
97	Debit Amount ⚡ FLOW	Decimal	FlowField
98	Credit Amount ⚡ FLOW	Decimal	FlowField
99	Debit Amount (LCY) ⚡ FLOW	Decimal	FlowField
100	Credit Amount (LCY) ⚡ FLOW	Decimal	FlowField
101	Bank Branch No.	Text	Normal
102	Email	Text	Normal
103	Home Page	Text	Normal
107	No. Series	Code	Normal	→ No. Series #308
108	Check Report ID	Integer	Normal
109	Check Report Name ⚡ FLOW	Text	FlowField
110	IBAN	Code	Normal
111	SWIFT Code	Code	Normal	→ SWIFT Code #1210
113	Bank Statement Import Format	Code	Normal	→ Bank Export/Import Setup #1200
115	Credit Transfer Msg. Nos.	Code	Normal	→ No. Series #308
116	Direct Debit Msg. Nos.	Code	Normal	→ No. Series #308
117	SEPA Direct Debit Exp. Format	Code	Normal	→ Bank Export/Import Setup #1200
121	Bank Stmt. Service Record ID	RecordID	Normal
123	Transaction Import Timespan	Integer	Normal
124	Automatic Stmt. Import Enabled	Boolean	Normal
130	Enable for Intercompany transactions	Boolean	Normal
140	Image	Media	Normal
170	Creditor No.	Code	Normal
1210	Payment Export Format	Code	Normal	→ Bank Export/Import Setup #1200
1211	Bank Clearing Code	Text	Normal
1212	Bank Clearing Standard	Text	Normal	→ Bank Clearing Standard #1280
1250	Match Tolerance Type	Option	Normal
1251	Match Tolerance Value	Decimal	Normal
1252	Disable Automatic Payment Matching	Boolean	Normal
1253	Disable Bank Reconciliation Optimization	Boolean	Normal
1260	Positive Pay Export Code	Code	Normal	→ Bank Export/Import Setup #1200
1280	Check Transmitted	Boolean	Normal
5061	Mobile Phone No.	Text	Normal
20100	Bank Name	Text	Normal	→ AMC Bank Banks #20100
20101	Bank file Name	Text	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal