Other table in Microsoft Dynamics 365 Business Central. 19 fields, 0 records in Cronus demo.
The Bank Account Statement Line table (ID 276) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 19 fields, with a primary key of Bank Account No., Statement No., Statement Line No.. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Bank Account No., Statement No., Statement Line No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Bank Account No. PK | Code | Normal | → Bank Account #270 |
| 2 | Statement No. PK | Code | Normal | → Bank Account Statement #275 |
| 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 | |
| 10 | Type | Option | Normal | |
| 11 | Applied Entries | Integer | Normal | |
| 12 | Value Date | Date | Normal | |
| 14 | Check No. | Code | Normal | |
| 70 | Transaction ID | Text | 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 Account Statement Line table through TableRelation properties.