Customer Bank Account #287

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

The Customer Bank Account table (ID 287) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 31 fields, with a primary key of Customer No., Code. Use the reference below to explore every field, data type, and table relation.

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: Customer No., Code.

All fields (31)

Customer Bank Account — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Customer No. PK	Code	Normal	→ Customer #18
2	Code PK	Code	Normal
3	Name	Text	Normal
5	Name 2	Text	Normal
6	Address	Text	Normal
7	Address 2	Text	Normal
8	City	Text	Normal
9	Post Code	Code	Normal
10	Contact	Text	Normal
11	Phone No.	Text	Normal
12	Telex No.	Text	Normal
13	Bank Branch No.	Text	Normal
14	Bank Account No.	Text	Normal
15	Transit No.	Text	Normal
16	Currency Code	Code	Normal	→ Currency #4
17	Country/Region Code	Code	Normal	→ Country/Region #9
18	County	Text	Normal
19	Fax No.	Text	Normal
20	Telex Answer Back	Text	Normal
21	Language Code	Code	Normal	→ Language #8
22	Email	Text	Normal
23	Home Page	Text	Normal
24	IBAN	Code	Normal
25	SWIFT Code	Code	Normal	→ SWIFT Code #1210
1211	Bank Clearing Code	Text	Normal
1212	Bank Clearing Standard	Text	Normal	→ Bank Clearing Standard #1280
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

Related tables (7)

Tables referenced by fields on the Customer Bank Account table through TableRelation properties.

Customer

#18 · Sales · via Customer No.

Currency

#4 · General Ledger · via Currency Code

Country/Region

#9 · General Ledger · via Country/Region Code

Language

#8 · General Ledger · via Language Code

SWIFT Code

#1210 · Other · via SWIFT Code

Bank Clearing Standard

#1280 · Other · via Bank Clearing Standard