Table 7114 "Analysis Line"

Base Application · Microsoft.Inventory.Analysis · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Analysis Line
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Analysis Area	Enum “Analysis Area Type”	—	enum Enum 7130 “Analysis Area Type”
2	Analysis Line Template Name	Code[10]	—	TableRelation Table 7112 “Analysis Line Template” (“Analysis Line Template”.Name where(“Analysis Area” = field(“Analysis Area”)))
3	Line No.	Integer	—
4	Row Ref. No. Δ BC28	Code[20]	Specifies a row reference number for the analysis line.
5	Description Δ BC28	Text[100]	Specifies a description for the analysis line.
6	Type Δ BC28	Enum “Analysis Line Type”	Specifies the type of totaling for the analysis line. The type determines which items within the totaling range that you specify in the Range field will be totaled.	enum Enum 7114 “Analysis Line Type”
7	Range Δ BC28	Text[250]	Specifies the number or formula of the type to use to calculate the total for this line.	TableRelation Table 18 “Customer”, Table 23 “Vendor”, Table 27 “Item” (if (Type = const(Item)) Item else if (Type = const(Customer)) Customer else if (Type = const(Vendor)) Vendor else if (Type = const(“Item Group”)) “Dimension Value”.Code where(“Dimension Code” = field(“Group Dimension Code”), Blocked = const(false)) else if (Type = const(“Customer Group”)) “Dimension…)
8	New Page Δ BC28	Boolean	Specifies if you want a page break after the current line when you print the analysis report.
9	Show Δ BC28	Option	Specifies whether you want the analysis line to be included when you print the report.	OptionCaption: Yes,No,If Any Column Not Zero
10	Bold Δ BC28	Boolean	Specifies if you want the amounts on this line to be printed in bold.
11	Italic Δ BC28	Boolean	Specifies if you want the amounts in this line to be printed in italics.
12	Underline Δ BC28	Boolean	Specifies if you want the amounts in this line to be underlined when printed.
13	Show Opposite Sign Δ BC28	Boolean	Specifies if you want sales and negative adjustments to be shown as positive amounts and purchases and positive adjustments to be shown as negative amounts.
14	Source Type Filter	Enum “Analysis Source Type”	—	FlowFilter; enum Enum 7131 “Analysis Source Type”
15	Date Filter	Date	—	FlowFilter
16	Item Budget Filter	Code[10]	—	TableRelation Table 7132 “Item Budget Name” (“Item Budget Name”.Name where(“Analysis Area” = field(“Analysis Area”))); FlowFilter
17	Location Filter	Code[10]	—	TableRelation Table 14 “Location”; FlowFilter
18	Dimension 1 Filter	Code[20]	—	FlowFilter
19	Dimension 2 Filter	Code[20]	—	FlowFilter
20	Dimension 3 Filter	Code[20]	—	FlowFilter
21	Dimension 1 Totaling Δ BC28	Text[80]	Specifies which dimension value amounts will be totaled on this line.
22	Dimension 2 Totaling Δ BC28	Text[80]	Specifies which dimension value amounts will be totaled on this line. If the type on the line is Formula, this field must be blank. Also, if you do not want the amounts on the line to be filtered by dimensions, this field must be blank.
23	Dimension 3 Totaling Δ BC28	Text[80]	Specifies which dimension value amounts will be totaled on this line. If the type on the line is Formula, this field must be blank. Also, if you do not want the amounts on the line to be filtered by dimensions, this field must be blank.
24	Source No. Filter	Code[20]	—	TableRelation Table 18 “Customer”, Table 23 “Vendor”, Table 27 “Item” (if (“Source Type Filter” = const(Customer)) Customer else if (“Source Type Filter” = const(Vendor)) Vendor else if (“Source Type Filter” = const(Item)) Item); FlowFilter
25	Group Dimension Code	Code[20]	—	TableRelation Table 348 “Dimension”
26	Indentation Δ BC28	Integer	Specifies the indentation of the line.

Keys

Key1: Analysis Area, Analysis Line Template Name, Line No. (clustered)

Events published

OnLookupTotalingRangeOnElse(var AnalysisLine: Record "Analysis Line"; var Text: Text; var Result: Boolean) (integration)

Procedures

CheckFormula(Formula: Code[250])
LookupTotalingRange(var Text: Text): Boolean
LookupDimTotalingRange(var Text: Text; GroupDimCode: Code[20]): Boolean
GetCaptionClass(DimNo: Integer): Text[250]

Plus 2 local procedures.

Triggers

OnInsert, OnModify

Relations

drill-down page Page 7115 “Inventory Analysis Lines”
lookup page Page 7115 “Inventory Analysis Lines”
Location Filter: TableRelation Table 14 “Location”
Range: TableRelation Table 18 “Customer” (conditional)
Source No. Filter: TableRelation Table 18 “Customer” (conditional)
Range: TableRelation Table 23 “Vendor” (conditional)
Source No. Filter: TableRelation Table 23 “Vendor” (conditional)
Range: TableRelation Table 27 “Item” (conditional)
Source No. Filter: TableRelation Table 27 “Item” (conditional)
Group Dimension Code: TableRelation Table 348 “Dimension”
Range: TableRelation Table 349 “Dimension Value” (conditional)
Analysis Line Template Name: TableRelation Table 7112 “Analysis Line Template”
Item Budget Filter: TableRelation Table 7132 “Item Budget Name”

Referenced by

1 fields in 1 objects relate to this table (TableRelation or CalcFormula).

Table 771 “Analysis Report Chart Line”: Analysis Line Line No.

Pages and codeunits on this table

Page 7115 “Inventory Analysis Lines” (source table)
Page 7117 “Sales Analysis Report” (source table)
Page 7118 “Purchase Analysis Report” (source table)
Page 7119 “Inventory Analysis Report” (source table)
Page 7120 “Sales Analysis Lines” (source table)
Page 7121 “Purchase Analysis Lines” (source table)
Page 9201 “Inventory Analysis Matrix” (source table)
Page 9205 “Purchase Analysis Matrix” (source table)
Page 9207 “Sales Analysis Matrix” (source table)
Codeunit 7110 “Analysis Report Management” (codeunit runs on it)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Analysis Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Across versions

Neighbourhood 19 connected objects and pages