Bank Acc. Rec. AI Proposal #7250

Other table in Microsoft Dynamics 365 Business Central. 19 fields, 0 records in Cronus demo.

19
Fields
0
Records
5
Primary key
0
FlowFields
9
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Bank Account No., Statement No., Statement Line No., Statement Type, Bank Account Ledger Entry No..

All fields (19)

Bank Acc. Rec. AI Proposal — FIELDS
NO.FIELDTYPECLASSRELATION
1 Bank Account No. PK Code Normal → Bank Account #270
2 Statement No. PK Code Normal → Bank Acc. Reconciliation #273
3 Statement Line No. PK Integer Normal
4 Document No. Code Normal
5 Transaction Date Date Normal
6 Description Text Normal
8 Amount to Apply Decimal Normal
20 Statement Type PK Option Normal
40 G/L Account No. Code Normal → G/L Account #15
41 Bank Account Ledger Entry No. PK Integer Normal → Bank Account Ledger Entry #271
42 Proposal Text Normal
50 Journal Template Name Code Normal → Gen. Journal Template #80
51 Journal Batch Name Code Normal → Gen. Journal Batch #232
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
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 (8)

Tables referenced by fields on the Bank Acc. Rec. AI Proposal table through TableRelation properties.

Bank Account
#270 · Other · via Bank Account No.
Bank Acc. Reconciliation
#273 · Other · via Statement No.
G/L Account
#15 · General Ledger · via G/L Account No.
Bank Account Ledger Entry
#271 · Ledger Entries · via Bank Account Ledger Entry No.
Gen. Journal Template
#80 · Other · via Journal Template Name
Gen. Journal Batch
#232 · Other · via Journal Batch Name
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID