Other table in Microsoft Dynamics 365 Business Central. 24 fields, 0 records in Cronus demo.
The Analysis Column table (ID 7118) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 24 fields, with a primary key of Analysis Area, Analysis Column Template, 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: Analysis Area, Analysis Column Template, Line No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Analysis Area PK | Option | Normal | |
| 2 | Analysis Column Template PK | Code | Normal | → Analysis Column Template #7116 |
| 3 | Line No. PK | Integer | Normal | |
| 4 | Column No. | Code | Normal | |
| 5 | Column Header | Text | Normal | |
| 6 | Column Type | Option | Normal | |
| 7 | Ledger Entry Type | Option | Normal | |
| 8 | Formula | Code | Normal | |
| 9 | Comparison Date Formula | DateFormula | Normal | |
| 10 | Show Opposite Sign | Boolean | Normal | |
| 11 | Show | Option | Normal | |
| 12 | Rounding Factor | Option | Normal | |
| 13 | Comparison Period Formula | Code | Normal | |
| 14 | Analysis Type Code | Code | Normal | → Analysis Type #7113 |
| 15 | Item Ledger Entry Type Filter | Text | Normal | |
| 16 | Value Entry Type Filter | Text | Normal | |
| 17 | Value Type | Option | Normal | |
| 18 | Invoiced | Boolean | Normal | |
| 30 | Comparison Period Formula LCID | Integer | 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 Analysis Column table through TableRelation properties.