Check Ledger Entry #272

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

31
Fields
0
Records
1
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: Entry No..

All fields (31)

Check Ledger Entry — FIELDS
NO.FIELDTYPECLASSRELATION
1 Entry No. PK Integer Normal
2 Bank Account No. Code Normal → Bank Account #270
3 Bank Account Ledger Entry No. Integer Normal → Bank Account Ledger Entry #271
4 Posting Date Date Normal
5 Document Type Option Normal
6 Document No. Code Normal
7 Description Text Normal
8 Amount Decimal Normal
9 Check Date Date Normal
10 Check No. Code Normal
11 Check Type Option Normal
12 Bank Payment Type Option Normal
13 Entry Status Option Normal
14 Original Entry Status Option Normal
15 Bal. Account Type Option Normal
16 Bal. Account No. Code Normal
17 Open Boolean Normal
18 Statement Status Option Normal
19 Statement No. Code Normal → Bank Acc. Reconciliation Line #274
20 Statement Line No. Integer Normal → Bank Acc. Reconciliation Line #274
21 User ID Code Normal
22 External Document No. Code Normal
23 Data Exch. Entry No. Integer Normal → Data Exch. #1220
24 Data Exch. Voided Entry No. Integer Normal → Data Exch. #1220
25 Positive Pay Exported Boolean Normal
27 SystemId to Print GUID 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

Related tables (5)

Tables referenced by fields on the Check Ledger Entry table through TableRelation properties.

Bank Account
#270 · Other · via Bank Account No.
Bank Account Ledger Entry
#271 · Ledger Entries · via Bank Account Ledger Entry No.
Bank Acc. Reconciliation Line
#274 · Other · via Statement No., Statement Line No.
Data Exch.
#1220 · Other · via Data Exch. Entry No., Data Exch. Voided Entry No.