Table "Column Layout"
ID 334
Namespace: Microsoft.Finance.FinancialReports
Properties
| Name | Value |
|---|---|
| Caption | Column Layout |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "Column Layout Name" | Code[10] | |
| "Line No." | Integer | |
| "Column No." | Code[10] | |
| "Column Header" | Text[30] | |
| "Column Type" | Enum Microsoft.Finance.FinancialReports."Column Layout Type" | |
| "Ledger Entry Type" | Enum Microsoft.Finance.FinancialReports."Column Layout Entry Type" | |
| "Amount Type" | Enum Microsoft.Finance.FinancialReports."Account Schedule Amount Type" | |
| Formula | Code[80] | |
| "Comparison Date Formula" | DateFormula | |
| "Show Opposite Sign" | Boolean | |
| Show | Enum Microsoft.Finance.FinancialReports."Column Layout Show" | |
| "Rounding Factor" | Enum Microsoft.Foundation.Enums."Analysis Rounding Factor" | |
| "Show Indented Lines" | Option | |
| "Comparison Period Formula" | Code[20] | |
| "Business Unit Totaling" | Text[80] | |
| "Dimension 1 Totaling" | Text[80] | |
| "Dimension 2 Totaling" | Text[80] | |
| "Dimension 3 Totaling" | Text[80] | |
| "Dimension 4 Totaling" | Text[80] | |
| "Cost Center Totaling" | Text[80] | |
| "Cost Object Totaling" | Text[80] | |
| "Comparison Period Formula LCID" | Integer | |
| "Budget Name" | Code[10] | |
| "Hide Currency Symbol" | Boolean | |
| "Include Date In Header" | Enum Microsoft.Finance.FinancialReports.ColumnHeaderDateType | Specifies how the ending date of the Date Filter applied to the column is displayed on the Column Header. |
| "G/L Account Totaling" | Text[250] | Specifies which G/L accounts will be totaled in this column. |
| "Show in ACY" | Boolean | Specifies whether amounts are shown in the Additional Reporting Currency. |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemRowVersion | BigInteger |
Methods
ParsePeriodFormula
Obsolete
This element will become obsolete from version 27.0. Moved to codeunit Period Formula Parser
[Obsolete(Moved to codeunit Period Formula Parser,27.0)]
procedure ParsePeriodFormula(FormulaExpression: Code[20], var Steps: Integer, var Type: Enum "Period Type", var RangeFromType: Enum "Period Formula Range", var RangeToType: Enum "Period Formula Range", var RangeFromInt: Integer, var RangeToInt: Integer)Parameters
| Name | Type | Description |
|---|---|---|
| FormulaExpression | Code[20] | |
| Steps | Integer | |
| Type | Enum Microsoft.Foundation.Period."Period Type" | |
| RangeFromType | Enum Microsoft.Foundation.Period."Period Formula Range" | |
| RangeToType | Enum Microsoft.Foundation.Period."Period Formula Range" | |
| RangeFromInt | Integer | |
| RangeToInt | Integer |
LookUpDimFilter
procedure LookUpDimFilter(DimNo: Integer, var Text: Text[250]): BooleanParameters
| Name | Type | Description |
|---|---|---|
| DimNo | Integer | |
| Text | Text[250] |
Returns
| Type | Description |
|---|---|
| Boolean |
GetCaptionClass
procedure GetCaptionClass(AnalysisViewDimType: Integer): Text[250]Parameters
| Name | Type | Description |
|---|---|---|
| AnalysisViewDimType | Integer |
Returns
| Type | Description |
|---|---|
| Text[250] |
GetPeriodName
Obsolete
This element will become obsolete from version 27.0. Moved to codeunit Period Formula Parser
[Obsolete(Moved to codeunit Period Formula Parser,27.0)]
procedure GetPeriodName(): Code[10]Returns
| Type | Description |
|---|---|
| Code[10] |
Events
OnBeforeGetCaptionClass
[IntegrationEvent(False,False)]
local procedure OnBeforeGetCaptionClass(var ColumnLayout: Record "Column Layout", ColumnLayoutName: Record "Column Layout Name", AnalysisViewDimType: Integer, var Result: Text[250], var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| ColumnLayout | Table Microsoft.Finance.FinancialReports."Column Layout" | |
| ColumnLayoutName | Table Microsoft.Finance.FinancialReports."Column Layout Name" | |
| AnalysisViewDimType | Integer | |
| Result | Text[250] | |
| IsHandled | Boolean |
OnBeforeLookUpDimFilter
[IntegrationEvent(False,False)]
local procedure OnBeforeLookUpDimFilter(var ColumnLayout: Record "Column Layout", DimNo: Integer, var Text: Text[250], ColumnLayoutName: Record "Column Layout Name", var Result: Boolean, var IsHandled: Boolean, var AnalysisView: Record "Analysis View")Parameters
| Name | Type | Description |
|---|---|---|
| ColumnLayout | Table Microsoft.Finance.FinancialReports."Column Layout" | |
| DimNo | Integer | |
| Text | Text[250] | |
| ColumnLayoutName | Table Microsoft.Finance.FinancialReports."Column Layout Name" | |
| Result | Boolean | |
| IsHandled | Boolean | |
| AnalysisView | Table Microsoft.Finance.Analysis."Analysis View" |