Other table in Microsoft Dynamics 365 Business Central. 39 fields, 9 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Bank Account No., Statement No., Statement Line No., Statement Type.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 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 | |
| 7 | Statement Amount | Decimal | Normal | |
| 8 | Difference | Decimal | Normal | |
| 9 | Applied Amount | Decimal | Normal | |
| 11 | Applied Entries | Integer | Normal | |
| 12 | Value Date | Date | Normal | |
| 13 | Ready for Application | Boolean | Normal | |
| 14 | Check No. | Code | Normal | |
| 15 | Related-Party Name | Text | Normal | |
| 16 | Additional Transaction Info | Text | Normal | |
| 17 | Data Exch. Entry No. | Integer | Normal | → Data Exch. #1220 |
| 18 | Data Exch. Line No. | Integer | Normal | |
| 20 | Statement Type PK | Option | Normal | |
| 21 | Account Type | Option | Normal | |
| 22 | Account No. | Code | Normal | |
| 23 | Transaction Text | Text | Normal | |
| 24 | Related-Party Bank Acc. No. | Text | Normal | |
| 25 | Related-Party Address | Text | Normal | |
| 26 | Related-Party City | Text | Normal | |
| 27 | Payment Reference | Code | Normal | |
| 31 | Shortcut Dimension 1 Code | Code | Normal | → Dimension Value #349 |
| 32 | Shortcut Dimension 2 Code | Code | Normal | → Dimension Value #349 |
| 50 | Match Confidence ⚡ FLOW | Option | FlowField | |
| 51 | Match Quality ⚡ FLOW | Integer | FlowField | |
| 60 | Sorting Order | Integer | Normal | |
| 61 | Parent Line No. | Integer | Normal | |
| 70 | Transaction ID | Text | Normal | |
| 480 | Dimension Set ID | Integer | Normal | → Dimension Set Entry #480 |
| 10500 | Reconciled | Boolean | 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 |
Tables referenced by fields on the Bank Acc. Reconciliation Line table through TableRelation properties.