Table 5873 Compare Cost Shares Buffer

Base Application, Microsoft.Inventory.BOM

src/Layers/W1/BaseApp/Inventory/BOM/CompareCostSharesBuffer.Table.al136 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.BOM;using Microsoft.Inventory.Item;using Microsoft.Projects.Resources.Resource;table 5873 "Compare Cost Shares Buffer"{    Caption = 'Compare Cost Shares Buffer';    ReplicateData = false;    TableType = Temporary;    DataClassification = SystemMetadata;    fields    {        field(1; Indentation; Integer)        {            Caption = 'Indentation';        }        field(2; Type; Enum "BOM Type")        {            Caption = 'Type';        }        field(3; "No."; Code[20])        {            Caption = 'No.';            TableRelation = if (Type = const(Item)) Item            else            if (Type = const(Resource)) Resource;        }        field(4; Description; Text[100])        {            Caption = 'Description';        }        field(5; "Is Leaf"; Boolean)        {            Caption = 'Is Leaf';        }        field(6; "Item 1 Qty. per Top Item"; Decimal)        {            AutoFormatType = 0;            Caption = 'Item 1 Qty. per Top Item';            DecimalPlaces = 0 : 5;        }        field(7; "Item 2 Qty. per Top Item"; Decimal)        {            AutoFormatType = 0;            Caption = 'Item 2 Qty. per Top Item';            DecimalPlaces = 0 : 5;        }        field(8; "Item 1 Unit Cost"; Decimal)        {            AutoFormatType = 2;            AutoFormatExpression = '';            Caption = 'Item 1 Unit Cost';        }        field(9; "Item 2 Unit Cost"; Decimal)        {            AutoFormatType = 2;            AutoFormatExpression = '';            Caption = 'Item 2 Unit Cost';            DataClassification = SystemMetadata;        }        field(10; "Item 1 Total Cost"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            Caption = 'Item 1 Total Cost';            DecimalPlaces = 2 : 5;        }        field(11; "Item 2 Total Cost"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            Caption = 'Item 2 Total Cost';            DecimalPlaces = 2 : 5;        }        field(12; "Difference Cost"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            Caption = 'Difference Cost';            DecimalPlaces = 2 : 5;        }    }    keys    {        key(Key1; Indentation, Type, "No.")        {            Clustered = true;        }    }    fieldgroups    {    }    procedure TransferFromBOMBuffer(var TempBOMBuffer: Record "BOM Buffer" temporary; TransferToItem1: Boolean)    begin        if not Get(TempBOMBuffer.Indentation, TempBOMBuffer.Type, TempBOMBuffer."No.") then begin            Init();            Indentation := TempBOMBuffer.Indentation;            Type := TempBOMBuffer.Type;            "No." := TempBOMBuffer."No.";            Description := TempBOMBuffer.Description;            "Is Leaf" := TempBOMBuffer."Is Leaf";            Insert(true);        end;        if TransferToItem1 then begin            "Item 1 Qty. per Top Item" += TempBOMBuffer."Qty. per Top Item";            "Item 1 Total Cost" += TempBOMBuffer."Total Cost";            if "Item 1 Qty. per Top Item" <> 0 then                "Item 1 Unit Cost" := Round("Item 1 Total Cost" / "Item 1 Qty. per Top Item", 0.00001);        end else begin            "Item 2 Qty. per Top Item" += TempBOMBuffer."Qty. per Top Item";            "Item 2 Total Cost" += TempBOMBuffer."Total Cost";            if "Item 2 Qty. per Top Item" <> 0 then                "Item 2 Unit Cost" := Round("Item 2 Total Cost" / "Item 2 Qty. per Top Item", 0.00001);        end;        "Difference Cost" := "Item 1 Total Cost" - "Item 2 Total Cost";        OnTransferFromBOMBuffer(Rec, TempBOMBuffer);        Modify(true);    end;    [IntegrationEvent(false, false)]    local procedure OnTransferFromBOMBuffer(var CompareCostSharesBuffer: Record "Compare Cost Shares Buffer"; BOMBuffer: Record "BOM Buffer" temporary)    begin    end;}