Other table in Microsoft Dynamics 365 Business Central. 39 fields, 18 records in Cronus demo.
The Financial Report table (ID 88) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 39 fields, with a primary key of Name, and includes 2 calculated FlowFields. 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: Name.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 2 | Name PK | Code | Normal | |
| 3 | Use Amounts in Additional Currency | Boolean | Normal | |
| 4 | Period Type | Option | Normal | |
| 5 | Show All Lines | Boolean | Normal | |
| 6 | Dimension 1 Filter | Text | Normal | |
| 7 | Dimension 2 Filter | Text | Normal | |
| 8 | Dimension 3 Filter | Text | Normal | |
| 9 | Dimension 4 Filter | Text | Normal | |
| 10 | Cost Center Filter | Text | Normal | |
| 11 | Cost Object Filter | Text | Normal | |
| 12 | Cash Flow Filter | Text | Normal | |
| 13 | G/L Budget Filter | Text | Normal | |
| 14 | Cost Budget Filter | Text | Normal | |
| 15 | Date Filter | Text | Normal | |
| 16 | Default Excel Layout | Code | Normal | → Fin. Report Excel Template #764 |
| 17 | Negative Amount Format | Option | Normal | |
| 18 | Period Type | Option | Normal | |
| 19 | Negative Amount Format | Option | Normal | |
| 50 | Display Title | Text | Normal | |
| 51 | Financial Report Row Group | Code | Normal | → Acc. Schedule Name #84 |
| 52 | Financial Report Column Group | Code | Normal | → Column Layout Name #333 |
| 53 | Internal Description | Text | Normal | |
| 54 | Introductory Paragraph | BLOB | Normal | |
| 55 | Closing Paragraph | BLOB | Normal | |
| 56 | Start Date Filter Formula | DateFormula | Normal | |
| 57 | End Date Filter Formula | DateFormula | Normal | |
| 58 | Date Filter Period Formula | Code | Normal | |
| 59 | Date Filter Period Formula Lang. ID | Integer | Normal | |
| 60 | Logo Position | Option | Normal | |
| 61 | Dimension Perspective | Code | Normal | → Dimension Perspective Name #8363 |
| 62 | Your Last Run ⚡ FLOW | DateTime | FlowField | |
| 63 | Category | Code | Normal | → Financial Report Category #8391 |
| 64 | Status | Code | Normal | → Financial Report Status #8395 |
| 65 | Status Blocked ⚡ FLOW | Boolean | 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 Financial Report table through TableRelation properties.