Table 7136 Item Budget Buffer

Base Application, Microsoft.Inventory.Analysis

src/Layers/W1/BaseApp/Inventory/Analysis/ItemBudgetBuffer.Table.al126 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.Item;using Microsoft.Inventory.Location;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;table 7136 "Item Budget Buffer"{    Caption = 'Item Budget Buffer';    ReplicateData = false;    DataClassification = CustomerContent;    fields    {        field(1; "Item No."; Code[20])        {            Caption = 'Item No.';            DataClassification = SystemMetadata;            TableRelation = Item;        }        field(2; "Source Type"; Enum "Analysis Source Type")        {            Caption = 'Source Type';            DataClassification = SystemMetadata;        }        field(3; "Source No."; Code[20])        {            Caption = 'Source No.';            DataClassification = SystemMetadata;            TableRelation = if ("Source Type" = const(Customer)) Customer            else            if ("Source Type" = const(Vendor)) Vendor            else            if ("Source Type" = const(Item)) Item;        }        field(4; "Location Code"; Code[10])        {            Caption = 'Location Code';            DataClassification = SystemMetadata;            TableRelation = Location;        }        field(5; "Global Dimension 1 Code"; Code[20])        {            CaptionClass = '1,1,1';            Caption = 'Global Dimension 1 Code';            DataClassification = SystemMetadata;            TableRelation = "Dimension Value".Code where("Global Dimension No." = const(1));        }        field(6; "Global Dimension 2 Code"; Code[20])        {            CaptionClass = '1,1,2';            Caption = 'Global Dimension 2 Code';            DataClassification = SystemMetadata;            TableRelation = "Dimension Value".Code where("Global Dimension No." = const(2));        }        field(7; "Budget Dimension 1 Code"; Code[20])        {            Caption = 'Budget Dimension 1 Code';            DataClassification = SystemMetadata;        }        field(8; "Budget Dimension 2 Code"; Code[20])        {            Caption = 'Budget Dimension 2 Code';            DataClassification = SystemMetadata;        }        field(9; "Budget Dimension 3 Code"; Code[20])        {            Caption = 'Budget Dimension 3 Code';            DataClassification = SystemMetadata;        }        field(10; Date; Date)        {            Caption = 'Date';            DataClassification = SystemMetadata;        }        field(11; Quantity; Decimal)        {            AutoFormatType = 0;            Caption = 'Quantity';            DataClassification = SystemMetadata;            DecimalPlaces = 0 : 5;        }        field(12; "Sales Amount"; Decimal)        {            AutoFormatType = 0;            AutoFormatExpression = '';            Caption = 'Sales Amount';            DataClassification = SystemMetadata;        }        field(13; "Cost Amount"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            Caption = 'Cost Amount';            DataClassification = SystemMetadata;        }        field(480; "Dimension Set ID"; Integer)        {            Caption = 'Dimension Set ID';            DataClassification = SystemMetadata;            Editable = false;            TableRelation = "Dimension Set Entry";        }    }    keys    {        key(Key1; "Item No.", "Source Type", "Source No.", "Location Code", "Global Dimension 1 Code", "Global Dimension 2 Code", "Budget Dimension 1 Code", "Budget Dimension 2 Code", "Budget Dimension 3 Code", Date)        {            Clustered = true;        }    }    fieldgroups    {    }}