Ledger Entries table in Microsoft Dynamics 365 Business Central. 52 fields, 8 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Entry No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Entry No. PK | Integer | Normal | |
| 3 | Bank Account No. | Code | Normal | → Bank Account #270 |
| 4 | Posting Date | Date | Normal | |
| 5 | Document Type | Option | Normal | |
| 6 | Document No. | Code | Normal | |
| 7 | Description | Text | Normal | |
| 11 | Currency Code | Code | Normal | → Currency #4 |
| 13 | Amount | Decimal | Normal | |
| 14 | Remaining Amount | Decimal | Normal | |
| 17 | Amount (LCY) | Decimal | Normal | |
| 22 | Bank Acc. Posting Group | Code | Normal | → Bank Account Posting Group #277 |
| 23 | Global Dimension 1 Code | Code | Normal | → Dimension Value #349 |
| 24 | Global Dimension 2 Code | Code | Normal | → Dimension Value #349 |
| 25 | Our Contact Code | Code | Normal | → Salesperson/Purchaser #13 |
| 27 | User ID | Code | Normal | |
| 28 | Source Code | Code | Normal | → Source Code #230 |
| 36 | Open | Boolean | Normal | |
| 43 | Positive | Boolean | Normal | |
| 44 | Closed by Entry No. | Integer | Normal | → Bank Account Ledger Entry #271 |
| 45 | Closed at Date | Date | Normal | |
| 48 | Journal Template Name | Code | Normal | |
| 49 | Journal Batch Name | Code | Normal | |
| 50 | Reason Code | Code | Normal | → Reason Code #231 |
| 51 | Bal. Account Type | Option | Normal | |
| 52 | Bal. Account No. | Code | Normal | |
| 53 | Transaction No. | Integer | Normal | |
| 55 | Statement Status | Option | Normal | |
| 56 | Statement No. | Code | Normal | → Bank Acc. Reconciliation Line #274 |
| 57 | Statement Line No. | Integer | Normal | → Bank Acc. Reconciliation Line #274 |
| 58 | Debit Amount | Decimal | Normal | |
| 59 | Credit Amount | Decimal | Normal | |
| 60 | Debit Amount (LCY) | Decimal | Normal | |
| 61 | Credit Amount (LCY) | Decimal | Normal | |
| 62 | Document Date | Date | Normal | |
| 63 | External Document No. | Code | Normal | |
| 64 | Reversed | Boolean | Normal | |
| 65 | Reversed by Entry No. | Integer | Normal | → Bank Account Ledger Entry #271 |
| 66 | Reversed Entry No. | Integer | Normal | → Bank Account Ledger Entry #271 |
| 67 | Statement Date ⚡ FLOW | Date | FlowField | |
| 70 | Check Ledger Entries ⚡ FLOW | Integer | FlowField | |
| 480 | Dimension Set ID | Integer | Normal | → Dimension Set Entry #480 |
| 481 | Shortcut Dimension 3 Code ⚡ FLOW | Code | FlowField | |
| 482 | Shortcut Dimension 4 Code ⚡ FLOW | Code | FlowField | |
| 483 | Shortcut Dimension 5 Code ⚡ FLOW | Code | FlowField | |
| 484 | Shortcut Dimension 6 Code ⚡ FLOW | Code | FlowField | |
| 485 | Shortcut Dimension 7 Code ⚡ FLOW | Code | FlowField | |
| 486 | Shortcut Dimension 8 Code ⚡ FLOW | Code | FlowField | |
| 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 |
Tables referenced by fields on the Bank Account Ledger Entry table through TableRelation properties.