Customer Bank Account #287

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

31
Fields
2
Records
2
Primary key
0
FlowFields
8
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.FIELDTYPECLASSRELATION
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