Table 7136 Item Budget Buffer
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 { }}