Table 5821 Item Statistics Buffer, source in 29
Source29
src/Layers/W1/BaseApp/Inventory/Analysis/ItemStatisticsBuffer.Table.al625 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------
// Copyright (c) Microsoft Corporation. All rights reserved.
// Licensed under the MIT License. See License.txt in the project root for license information.
// ------------------------------------------------------------------------------------------------
namespace Microsoft.Inventory.Analysis;
using Microsoft.Finance.Dimension;
using Microsoft.Foundation.Enums;
using Microsoft.Inventory.Costing;
using Microsoft.Inventory.Item;
using Microsoft.Inventory.Ledger;
using Microsoft.Inventory.Location;
using Microsoft.Purchases.Vendor;
using Microsoft.Sales.Customer;
table 5821 "Item Statistics Buffer"
{
Caption = 'Item Statistics Buffer';
DataCaptionFields = "Code";
ReplicateData = false;
DataClassification = CustomerContent;
fields
{
field(1; "Code"; Code[20])
{
Caption = 'Code';
DataClassification = SystemMetadata;
NotBlank = true;
}
field(2; "Item Filter"; Code[20])
{
Caption = 'Item Filter';
FieldClass = FlowFilter;
TableRelation = Item;
ValidateTableRelation = false;
}
field(3; "Variant Filter"; Code[10])
{
Caption = 'Variant Filter';
FieldClass = FlowFilter;
TableRelation = "Item Variant".Code;
}
field(4; "Location Filter"; Code[10])
{
Caption = 'Location Filter';
FieldClass = FlowFilter;
TableRelation = Location;
}
field(5; "Budget Filter"; Code[10])
{
Caption = 'Budget Filter';
FieldClass = FlowFilter;
TableRelation = "Item Budget Name".Name where("Analysis Area" = field("Analysis Area Filter"));
}
field(6; "Global Dimension 1 Filter"; Code[20])
{
CaptionClass = '1,3,1';
Caption = 'Global Dimension 1 Filter';
FieldClass = FlowFilter;
TableRelation = "Dimension Value".Code where("Global Dimension No." = const(1));
}
field(7; "Global Dimension 2 Filter"; Code[20])
{
CaptionClass = '1,3,2';
Caption = 'Global Dimension 2 Filter';
FieldClass = FlowFilter;
TableRelation = "Dimension Value".Code where("Global Dimension No." = const(2));
}
field(9; "Date Filter"; Date)
{
Caption = 'Date Filter';
ClosingDates = true;
FieldClass = FlowFilter;
}
field(10; "Entry Type Filter"; Enum "Cost Entry Type")
{
Caption = 'Entry Type Filter';
FieldClass = FlowFilter;
}
field(11; "Item Ledger Entry Type Filter"; Enum "Item Ledger Entry Type")
{
Caption = 'Item Ledger Entry Type Filter';
FieldClass = FlowFilter;
}
field(12; "Item Charge No. Filter"; Code[20])
{
Caption = 'Item Charge No. Filter';
FieldClass = FlowFilter;
TableRelation = "Item Charge";
}
field(13; "Source Type Filter"; Enum "Analysis Source Type")
{
Caption = 'Source Type Filter';
FieldClass = FlowFilter;
}
field(14; "Source No. Filter"; Code[20])
{
Caption = 'Source No. Filter';
FieldClass = FlowFilter;
TableRelation = if ("Source Type Filter" = const(Customer)) Customer
else
if ("Source Type Filter" = const(Vendor)) Vendor
else
if ("Source Type Filter" = const(Item)) Item;
ValidateTableRelation = false;
}
field(15; "Invoiced Quantity"; Decimal)
{
AutoFormatType = 0;
CalcFormula = sum("Value Entry"."Invoiced Quantity" where("Item No." = field("Item Filter"),
"Posting Date" = field("Date Filter"),
"Variant Code" = field("Variant Filter"),
"Location Code" = field("Location Filter"),
"Entry Type" = field("Entry Type Filter"),
"Item Ledger Entry Type" = field("Item Ledger Entry Type Filter"),
"Variance Type" = field("Variance Type Filter"),
"Item Charge No." = field("Item Charge No. Filter"),
"Global Dimension 1 Code" = field("Global Dimension 1 Filter"),
"Global Dimension 2 Code" = field("Global Dimension 2 Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter")));
Caption = 'Invoiced Quantity';
DecimalPlaces = 0 : 5;
Editable = false;
FieldClass = FlowField;
}
field(16; "Sales Amount (Actual)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
CalcFormula = sum("Value Entry"."Sales Amount (Actual)" where("Item No." = field("Item Filter"),
"Posting Date" = field("Date Filter"),
"Item Ledger Entry Type" = field("Item Ledger Entry Type Filter"),
"Entry Type" = field("Entry Type Filter"),
"Variance Type" = field("Variance Type Filter"),
"Location Code" = field("Location Filter"),
"Variant Code" = field("Variant Filter"),
"Global Dimension 1 Code" = field("Global Dimension 1 Filter"),
"Global Dimension 2 Code" = field("Global Dimension 2 Filter"),
"Item Charge No." = field("Item Charge No. Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter")));
Caption = 'Sales Amount (Actual)';
Editable = false;
FieldClass = FlowField;
}
field(17; "Cost Amount (Actual)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
CalcFormula = sum("Value Entry"."Cost Amount (Actual)" where("Item No." = field("Item Filter"),
"Posting Date" = field("Date Filter"),
"Item Ledger Entry Type" = field("Item Ledger Entry Type Filter"),
"Entry Type" = field("Entry Type Filter"),
"Variance Type" = field("Variance Type Filter"),
"Location Code" = field("Location Filter"),
"Variant Code" = field("Variant Filter"),
"Global Dimension 1 Code" = field("Global Dimension 1 Filter"),
"Global Dimension 2 Code" = field("Global Dimension 2 Filter"),
"Item Charge No." = field("Item Charge No. Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter")));
Caption = 'Cost Amount (Actual)';
Editable = false;
FieldClass = FlowField;
}
field(18; "Cost Amount (Non-Invtbl.)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
CalcFormula = sum("Value Entry"."Cost Amount (Non-Invtbl.)" where("Item No." = field("Item Filter"),
"Posting Date" = field("Date Filter"),
"Item Ledger Entry Type" = field("Item Ledger Entry Type Filter"),
"Variance Type" = field("Variance Type Filter"),
"Entry Type" = field("Entry Type Filter"),
"Location Code" = field("Location Filter"),
"Variant Code" = field("Variant Filter"),
"Global Dimension 1 Code" = field("Global Dimension 1 Filter"),
"Global Dimension 2 Code" = field("Global Dimension 2 Filter"),
"Item Charge No." = field("Item Charge No. Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter")));
Caption = 'Cost Amount (Non-Invtbl.)';
Editable = false;
FieldClass = FlowField;
}
field(19; "Variance Type Filter"; Enum "Cost Variance Type")
{
Caption = 'Variance Type Filter';
FieldClass = FlowFilter;
}
field(20; "Sales (LCY)"; Integer)
{
Caption = 'Sales (LCY)';
DataClassification = SystemMetadata;
}
field(21; "COGS (LCY)"; Integer)
{
Caption = 'COGS (LCY)';
DataClassification = SystemMetadata;
}
field(22; "Profit (LCY)"; Integer)
{
Caption = 'Profit (LCY)';
DataClassification = SystemMetadata;
}
field(23; "Profit %"; Integer)
{
Caption = 'Profit %';
DataClassification = SystemMetadata;
}
field(24; "Inventoriable Costs"; Integer)
{
Caption = 'Inventoriable Costs';
DataClassification = SystemMetadata;
}
field(25; "Direct Cost (LCY)"; Integer)
{
Caption = 'Direct Cost (LCY)';
DataClassification = SystemMetadata;
}
field(26; "Revaluation (LCY)"; Integer)
{
Caption = 'Revaluation (LCY)';
DataClassification = SystemMetadata;
}
field(27; "Rounding (LCY)"; Integer)
{
Caption = 'Rounding (LCY)';
DataClassification = SystemMetadata;
}
field(28; "Indirect Cost (LCY)"; Integer)
{
Caption = 'Indirect Cost (LCY)';
DataClassification = SystemMetadata;
}
field(29; "Variance (LCY)"; Integer)
{
Caption = 'Variance (LCY)';
DataClassification = SystemMetadata;
}
field(30; "Inventoriable Costs, Total"; Integer)
{
Caption = 'Inventoriable Costs, Total';
DataClassification = SystemMetadata;
}
field(31; "Inventory (LCY)"; Integer)
{
Caption = 'Inventory (LCY)';
DataClassification = SystemMetadata;
}
field(34; "Non-Invtbl. Costs (LCY)"; Integer)
{
Caption = 'Non-Invtbl. Costs (LCY)';
DataClassification = SystemMetadata;
}
field(40; "Line Option"; Enum "Item Statistics Line Option")
{
Caption = 'Line Option';
DataClassification = SystemMetadata;
}
field(41; "Column Option"; Enum "Item Statistics Column Option")
{
Caption = 'Column Option';
DataClassification = SystemMetadata;
}
#pragma warning disable AS0070
field(42; "Analysis Area Filter"; Enum "Analysis Area Type")
{
Caption = 'Analysis Area Filter';
FieldClass = FlowFilter;
}
#pragma warning restore AS0070
field(45; Quantity; Decimal)
{
AutoFormatType = 0;
CalcFormula = sum("Item Ledger Entry".Quantity where("Item No." = field("Item Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter"),
"Posting Date" = field("Date Filter"),
"Entry Type" = field("Item Ledger Entry Type Filter"),
"Location Code" = field("Location Filter"),
"Variant Code" = field("Variant Filter"),
"Global Dimension 1 Code" = field("Global Dimension 1 Filter"),
"Global Dimension 2 Code" = field("Global Dimension 2 Filter")));
Caption = 'Quantity';
DecimalPlaces = 0 : 5;
Editable = false;
FieldClass = FlowField;
}
field(46; "Sales Amount (Expected)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
CalcFormula = sum("Value Entry"."Sales Amount (Expected)" where("Item No." = field("Item Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter"),
"Posting Date" = field("Date Filter"),
"Item Ledger Entry Type" = field("Item Ledger Entry Type Filter"),
"Variance Type" = field("Variance Type Filter"),
"Entry Type" = field("Entry Type Filter"),
"Location Code" = field("Location Filter"),
"Variant Code" = field("Variant Filter"),
"Global Dimension 1 Code" = field("Global Dimension 1 Filter"),
"Global Dimension 2 Code" = field("Global Dimension 2 Filter"),
"Item Charge No." = field("Item Charge No. Filter")));
Caption = 'Sales Amount (Expected)';
Editable = false;
FieldClass = FlowField;
}
field(47; "Cost Amount (Expected)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
CalcFormula = sum("Value Entry"."Cost Amount (Expected)" where("Item No." = field("Item Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter"),
"Posting Date" = field("Date Filter"),
"Item Ledger Entry Type" = field("Item Ledger Entry Type Filter"),
"Variance Type" = field("Variance Type Filter"),
"Entry Type" = field("Entry Type Filter"),
"Location Code" = field("Location Filter"),
"Variant Code" = field("Variant Filter"),
"Global Dimension 1 Code" = field("Global Dimension 1 Filter"),
"Global Dimension 2 Code" = field("Global Dimension 2 Filter"),
"Item Charge No." = field("Item Charge No. Filter")));
Caption = 'Cost Amount (Expected)';
Editable = false;
FieldClass = FlowField;
}
field(50; "Budgeted Quantity"; Decimal)
{
AutoFormatType = 0;
CalcFormula = sum("Item Budget Entry".Quantity where("Analysis Area" = field("Analysis Area Filter"),
"Budget Name" = field("Budget Filter"),
"Item No." = field("Item Filter"),
Date = field("Date Filter"),
"Global Dimension 1 Code" = field("Global Dimension 1 Filter"),
"Global Dimension 2 Code" = field("Global Dimension 2 Filter"),
"Budget Dimension 1 Code" = field("Dimension 1 Filter"),
"Budget Dimension 2 Code" = field("Dimension 2 Filter"),
"Budget Dimension 3 Code" = field("Dimension 3 Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter"),
"Location Code" = field("Location Filter")));
Caption = 'Budgeted Quantity';
DecimalPlaces = 0 : 5;
Editable = false;
FieldClass = FlowField;
}
field(51; "Budgeted Sales Amount"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
CalcFormula = sum("Item Budget Entry"."Sales Amount" where("Analysis Area" = field("Analysis Area Filter"),
"Budget Name" = field("Budget Filter"),
"Item No." = field("Item Filter"),
Date = field("Date Filter"),
"Global Dimension 1 Code" = field("Global Dimension 1 Filter"),
"Global Dimension 2 Code" = field("Global Dimension 2 Filter"),
"Budget Dimension 1 Code" = field("Dimension 1 Filter"),
"Budget Dimension 2 Code" = field("Dimension 2 Filter"),
"Budget Dimension 3 Code" = field("Dimension 3 Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter"),
"Location Code" = field("Location Filter")));
Caption = 'Budgeted Sales Amount';
Editable = false;
FieldClass = FlowField;
}
field(52; "Budgeted Cost Amount"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
CalcFormula = sum("Item Budget Entry"."Cost Amount" where("Analysis Area" = field("Analysis Area Filter"),
"Budget Name" = field("Budget Filter"),
"Item No." = field("Item Filter"),
Date = field("Date Filter"),
"Global Dimension 1 Code" = field("Global Dimension 1 Filter"),
"Global Dimension 2 Code" = field("Global Dimension 2 Filter"),
"Budget Dimension 1 Code" = field("Dimension 1 Filter"),
"Budget Dimension 2 Code" = field("Dimension 2 Filter"),
"Budget Dimension 3 Code" = field("Dimension 3 Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter"),
"Location Code" = field("Location Filter")));
Caption = 'Budgeted Cost Amount';
Editable = false;
FieldClass = FlowField;
}
field(70; "Analysis View Filter"; Code[10])
{
Caption = 'Analysis View Filter';
FieldClass = FlowFilter;
TableRelation = "Item Analysis View".Code where("Analysis Area" = field("Analysis Area Filter"));
}
field(71; "Dimension 1 Filter"; Code[20])
{
Caption = 'Dimension 1 Filter';
FieldClass = FlowFilter;
}
field(72; "Dimension 2 Filter"; Code[20])
{
Caption = 'Dimension 2 Filter';
FieldClass = FlowFilter;
}
field(73; "Dimension 3 Filter"; Code[20])
{
Caption = 'Dimension 3 Filter';
FieldClass = FlowFilter;
}
field(80; "Analysis - Quantity"; Decimal)
{
AutoFormatType = 0;
CalcFormula = sum("Item Analysis View Entry".Quantity where("Analysis Area" = field("Analysis Area Filter"),
"Analysis View Code" = field("Analysis View Filter"),
"Item No." = field("Item Filter"),
"Location Code" = field("Location Filter"),
"Dimension 1 Value Code" = field("Dimension 1 Filter"),
"Dimension 2 Value Code" = field("Dimension 2 Filter"),
"Dimension 3 Value Code" = field("Dimension 3 Filter"),
"Posting Date" = field("Date Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter"),
"Item Ledger Entry Type" = field("Item Ledger Entry Type Filter"),
"Entry Type" = field("Entry Type Filter")));
Caption = 'Analysis - Quantity';
DecimalPlaces = 0 : 5;
Editable = false;
FieldClass = FlowField;
}
field(81; "Analysis - Invoiced Quantity"; Decimal)
{
AutoFormatType = 0;
CalcFormula = sum("Item Analysis View Entry"."Invoiced Quantity" where("Analysis Area" = field("Analysis Area Filter"),
"Analysis View Code" = field("Analysis View Filter"),
"Item No." = field("Item Filter"),
"Location Code" = field("Location Filter"),
"Dimension 1 Value Code" = field("Dimension 1 Filter"),
"Dimension 2 Value Code" = field("Dimension 2 Filter"),
"Dimension 3 Value Code" = field("Dimension 3 Filter"),
"Posting Date" = field("Date Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter"),
"Item Ledger Entry Type" = field("Item Ledger Entry Type Filter"),
"Entry Type" = field("Entry Type Filter")));
Caption = 'Analysis - Invoiced Quantity';
DecimalPlaces = 0 : 5;
Editable = false;
FieldClass = FlowField;
}
field(82; "Analysis - Sales Amt. (Actual)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
CalcFormula = sum("Item Analysis View Entry"."Sales Amount (Actual)" where("Analysis Area" = field("Analysis Area Filter"),
"Analysis View Code" = field("Analysis View Filter"),
"Item No." = field("Item Filter"),
"Location Code" = field("Location Filter"),
"Dimension 1 Value Code" = field("Dimension 1 Filter"),
"Dimension 2 Value Code" = field("Dimension 2 Filter"),
"Dimension 3 Value Code" = field("Dimension 3 Filter"),
"Posting Date" = field("Date Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter"),
"Item Ledger Entry Type" = field("Item Ledger Entry Type Filter"),
"Entry Type" = field("Entry Type Filter")));
Caption = 'Analysis - Sales Amt. (Actual)';
Editable = false;
FieldClass = FlowField;
}
field(83; "Analysis - Sales Amt. (Exp)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
CalcFormula = sum("Item Analysis View Entry"."Sales Amount (Expected)" where("Analysis Area" = field("Analysis Area Filter"),
"Analysis View Code" = field("Analysis View Filter"),
"Item No." = field("Item Filter"),
"Location Code" = field("Location Filter"),
"Dimension 1 Value Code" = field("Dimension 1 Filter"),
"Dimension 2 Value Code" = field("Dimension 2 Filter"),
"Dimension 3 Value Code" = field("Dimension 3 Filter"),
"Posting Date" = field("Date Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter"),
"Item Ledger Entry Type" = field("Item Ledger Entry Type Filter"),
"Entry Type" = field("Entry Type Filter")));
Caption = 'Analysis - Sales Amt. (Exp)';
Editable = false;
FieldClass = FlowField;
}
field(84; "Analysis - Cost Amt. (Actual)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
CalcFormula = sum("Item Analysis View Entry"."Cost Amount (Actual)" where("Analysis Area" = field("Analysis Area Filter"),
"Analysis View Code" = field("Analysis View Filter"),
"Item No." = field("Item Filter"),
"Location Code" = field("Location Filter"),
"Dimension 1 Value Code" = field("Dimension 1 Filter"),
"Dimension 2 Value Code" = field("Dimension 2 Filter"),
"Dimension 3 Value Code" = field("Dimension 3 Filter"),
"Posting Date" = field("Date Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter"),
"Item Ledger Entry Type" = field("Item Ledger Entry Type Filter"),
"Entry Type" = field("Entry Type Filter")));
Caption = 'Analysis - Cost Amt. (Actual)';
Editable = false;
FieldClass = FlowField;
}
field(85; "Analysis - Cost Amt. (Exp)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
CalcFormula = sum("Item Analysis View Entry"."Cost Amount (Expected)" where("Analysis Area" = field("Analysis Area Filter"),
"Analysis View Code" = field("Analysis View Filter"),
"Item No." = field("Item Filter"),
"Location Code" = field("Location Filter"),
"Dimension 1 Value Code" = field("Dimension 1 Filter"),
"Dimension 2 Value Code" = field("Dimension 2 Filter"),
"Dimension 3 Value Code" = field("Dimension 3 Filter"),
"Posting Date" = field("Date Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter"),
"Item Ledger Entry Type" = field("Item Ledger Entry Type Filter"),
"Entry Type" = field("Entry Type Filter")));
Caption = 'Analysis - Cost Amt. (Exp)';
Editable = false;
FieldClass = FlowField;
}
field(86; "Analysis CostAmt.(Non-Invtbl.)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
CalcFormula = sum("Item Analysis View Entry"."Cost Amount (Non-Invtbl.)" where("Analysis Area" = field("Analysis Area Filter"),
"Analysis View Code" = field("Analysis View Filter"),
"Item No." = field("Item Filter"),
"Location Code" = field("Location Filter"),
"Dimension 1 Value Code" = field("Dimension 1 Filter"),
"Dimension 2 Value Code" = field("Dimension 2 Filter"),
"Dimension 3 Value Code" = field("Dimension 3 Filter"),
"Posting Date" = field("Date Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter"),
"Item Ledger Entry Type" = field("Item Ledger Entry Type Filter"),
"Entry Type" = field("Entry Type Filter")));
Caption = 'Analysis CostAmt.(Non-Invtbl.)';
Editable = false;
FieldClass = FlowField;
}
field(91; "Analysis - Budgeted Quantity"; Decimal)
{
AutoFormatType = 0;
CalcFormula = sum("Item Analysis View Budg. Entry".Quantity where("Analysis Area" = field("Analysis Area Filter"),
"Analysis View Code" = field("Analysis View Filter"),
"Budget Name" = field("Budget Filter"),
"Item No." = field("Item Filter"),
"Location Code" = field("Location Filter"),
"Dimension 1 Value Code" = field("Dimension 1 Filter"),
"Dimension 2 Value Code" = field("Dimension 2 Filter"),
"Dimension 3 Value Code" = field("Dimension 3 Filter"),
"Posting Date" = field("Date Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter")));
Caption = 'Analysis - Budgeted Quantity';
DecimalPlaces = 0 : 5;
Editable = false;
FieldClass = FlowField;
}
field(92; "Analysis - Budgeted Sales Amt."; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
CalcFormula = sum("Item Analysis View Budg. Entry"."Sales Amount" where("Analysis Area" = field("Analysis Area Filter"),
"Analysis View Code" = field("Analysis View Filter"),
"Budget Name" = field("Budget Filter"),
"Item No." = field("Item Filter"),
"Location Code" = field("Location Filter"),
"Dimension 1 Value Code" = field("Dimension 1 Filter"),
"Dimension 2 Value Code" = field("Dimension 2 Filter"),
"Dimension 3 Value Code" = field("Dimension 3 Filter"),
"Posting Date" = field("Date Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter")));
Caption = 'Analysis - Budgeted Sales Amt.';
Editable = false;
FieldClass = FlowField;
}
field(93; "Analysis - Budgeted Cost Amt."; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
CalcFormula = sum("Item Analysis View Budg. Entry"."Cost Amount" where("Analysis Area" = field("Analysis Area Filter"),
"Analysis View Code" = field("Analysis View Filter"),
"Budget Name" = field("Budget Filter"),
"Item No." = field("Item Filter"),
"Location Code" = field("Location Filter"),
"Dimension 1 Value Code" = field("Dimension 1 Filter"),
"Dimension 2 Value Code" = field("Dimension 2 Filter"),
"Dimension 3 Value Code" = field("Dimension 3 Filter"),
"Posting Date" = field("Date Filter"),
"Source Type" = field("Source Type Filter"),
"Source No." = field("Source No. Filter")));
Caption = 'Analysis - Budgeted Cost Amt.';
Editable = false;
FieldClass = FlowField;
}
}
keys
{
key(Key1; "Code")
{
Clustered = true;
}
}
fieldgroups
{
}
}