Table extension 905 Asm. Item

Base Application, Microsoft.Inventory.Item

src/Layers/W1/BaseApp/Assembly/Inventory/Item/AsmItem.TableExt.al82 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.Item;using Microsoft.Assembly.Document;using Microsoft.Inventory.Tracking;tableextension 905 "Asm. Item" extends Item{    fields    {        field(929; "Res. Qty. on Assembly Order"; Decimal)        {            AccessByPermission = TableData "Assembly Header" = R;            CalcFormula = sum("Reservation Entry"."Quantity (Base)" where("Item No." = field("No."),                                                                           "Source Type" = const(900),                                                                           "Source Subtype" = const("1"),                                                                           "Reservation Status" = const(Reservation),                                                                           "Location Code" = field("Location Filter"),                                                                           "Variant Code" = field("Variant Filter"),                                                                           "Expected Receipt Date" = field("Date Filter")));            Caption = 'Res. Qty. on Assembly Order';            DecimalPlaces = 0 : 5;            Editable = false;            FieldClass = FlowField;            AutoFormatType = 0;        }        field(930; "Res. Qty. on  Asm. Comp."; Decimal)        {            AccessByPermission = TableData "Assembly Line" = R;            CalcFormula = - sum("Reservation Entry"."Quantity (Base)" where("Item No." = field("No."),                                                                            "Source Type" = const(901),                                                                            "Source Subtype" = const("1"),                                                                            "Reservation Status" = const(Reservation),                                                                            "Location Code" = field("Location Filter"),                                                                            "Variant Code" = field("Variant Filter"),                                                                            "Shipment Date" = field("Date Filter")));            Caption = 'Res. Qty. on  Asm. Comp.';            DecimalPlaces = 0 : 5;            Editable = false;            FieldClass = FlowField;            AutoFormatType = 0;        }        field(977; "Qty. on Assembly Order"; Decimal)        {            CalcFormula = sum("Assembly Header"."Remaining Quantity (Base)" where("Document Type" = const(Order),                                                                                   "Item No." = field("No."),                                                                                   "Shortcut Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                                                   "Shortcut Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                                                   "Location Code" = field("Location Filter"),                                                                                   "Variant Code" = field("Variant Filter"),                                                                                   "Due Date" = field("Date Filter"),                                                                                   "Unit of Measure Code" = field("Unit of Measure Filter")));            Caption = 'Qty. on Assembly Order';            DecimalPlaces = 0 : 5;            Editable = false;            FieldClass = FlowField;            AutoFormatType = 0;        }        field(978; "Qty. on Asm. Component"; Decimal)        {            CalcFormula = sum("Assembly Line"."Remaining Quantity (Base)" where("Document Type" = const(Order),                                                                                 Type = const(Item),                                                                                 "No." = field("No."),                                                                                 "Shortcut Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                                                 "Shortcut Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                                                 "Location Code" = field("Location Filter"),                                                                                 "Variant Code" = field("Variant Filter"),                                                                                 "Due Date" = field("Date Filter"),                                                                                 "Unit of Measure Code" = field("Unit of Measure Filter")));            Caption = 'Qty. on Asm. Component';            DecimalPlaces = 0 : 5;            Editable = false;            FieldClass = FlowField;            AutoFormatType = 0;        }    }}