Table 7154 "Item Analysis View Entry"

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

Properties

Property	Value
Caption	Item Analysis View Entry
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 View Code	Code[10]	—	TableRelation Table 7152 “Item Analysis View” (“Item Analysis View”.Code where(“Analysis Area” = field(“Analysis Area”), Code = field(“Analysis View Code”))); NotBlank
3	Item No. Δ BC28	Code[20]	Specifies the item number to which the item ledger entry in an analysis view entry was posted.	TableRelation Table 27 “Item”
4	Source Type	Enum “Analysis Source Type”	—	enum Enum 7131 “Analysis Source Type”
5	Source No.	Code[20]	—	TableRelation Table 18 “Customer”, Table 23 “Vendor”, Table 27 “Item” (if (“Source Type” = const(Customer)) Customer else if (“Source Type” = const(Vendor)) Vendor else if (“Source Type” = const(Item)) Item)
8	Location Code Δ BC28	Code[10]	Specifies the code of the location to which the item ledger entry in an analysis view entry was posted.	TableRelation Table 14 “Location”
9	Dimension 1 Value Code Δ BC28	Code[20]	Specifies the dimension value you selected for the analysis view dimension that you defined as Dimension 1 on the analysis view card.
10	Dimension 2 Value Code Δ BC28	Code[20]	Specifies the dimension value you selected for the analysis view dimension that you defined as Dimension 2 on the analysis view card.
11	Dimension 3 Value Code Δ BC28	Code[20]	Specifies the dimension value you selected for the analysis view dimension that you defined as Dimension 3 on the analysis view card.
12	Posting Date Δ BC28	Date	Specifies the date when the item ledger entry in an analysis view entry was posted.
13	Entry No.	Integer	—
14	Item Ledger Entry Type Δ BC28	Enum “Item Ledger Entry Type”	Specifies which type of transaction that the entry is created from.	enum Enum 78 “Item Ledger Entry Type”
15	Entry Type Δ BC28	Enum “Cost Entry Type”	Specifies the value entry type for an analysis view entry.	enum Enum 104 “Cost Entry Type”
21	Invoiced Quantity Δ BC28	Decimal	Specifies the sum of the quantity invoiced for the item ledger entries included in the analysis view entry.
22	Sales Amount (Actual) Δ BC28	Decimal	Specifies the sum of the actual sales amounts posted for the item ledger entries included in the analysis view entry. via Page 7153 “Item Analysis View Entries”
23	Cost Amount (Actual) Δ BC28	Decimal	Specifies the sum of the actual cost amounts posted for the item ledger entries included in the analysis view entry. via Page 7153 “Item Analysis View Entries”
24	Cost Amount (Non-Invtbl.) Δ BC28	Decimal	Specifies the sum of the non-inventoriable cost amounts posted for the item ledger entries included in the analysis view entry. via Page 7153 “Item Analysis View Entries”
31	Quantity Δ BC28	Decimal	Specifies the sum of the quantity for the item ledger entries included in the analysis view entry.
32	Sales Amount (Expected) Δ BC28	Decimal	Specifies the sum of the expected sales amounts posted for the item ledger entries, included in the analysis view entry. via Page 7153 “Item Analysis View Entries”
33	Cost Amount (Expected) Δ BC28	Decimal	Specifies the sum of the expected cost amounts posted for the item ledger entries included in the analysis view entry. via Page 7153 “Item Analysis View Entries”

Keys

Key1: Analysis Area, Analysis View Code, Item No., Item Ledger Entry Type, Entry Type, Source Type, Source No., Dimension 1 Value Code, Dimension 2 Value Code, Dimension 3 Value Code, Location Code, Posting Date, Entry No. (clustered)

Procedures

GetCaptionClass(AnalysisViewDimType: Integer): Text[250]

Relations

drill-down page Page 7153 “Item Analysis View Entries”
lookup page Page 7153 “Item Analysis View Entries”
Location Code: TableRelation Table 14 “Location”
Source No.: TableRelation Table 18 “Customer” (conditional)
Source No.: TableRelation Table 23 “Vendor” (conditional)
Item No.: TableRelation Table 27 “Item”
Source No.: TableRelation Table 27 “Item” (conditional)
Analysis View Code: TableRelation Table 7152 “Item Analysis View”

Referenced by

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

Table 5821 “Item Statistics Buffer”: Analysis - Cost Amt. (Actual), Analysis - Cost Amt. (Exp), Analysis - Invoiced Quantity, Analysis - Quantity, Analysis - Sales Amt. (Actual), Analysis - Sales Amt. (Exp), Analysis CostAmt.(Non-Invtbl.)

Pages and codeunits on this table

Page 7153 “Item Analysis View Entries” (source table)

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: "Item Analysis View Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.