Table extension 979 Asm. Whse. Worksheet Line

Jonas Paprotka, Base Application 28.5.54151.54365, checked 2026-09-20

App: Base Application
Namespace: Microsoft.Warehouse.Worksheet
Versions: 27-28
Extends: Whse. Worksheet Line

Versions1718192021222324252627 28

Source29

Source in 29

src/Layers/W1/BaseApp/Assembly/Warehouse/Worksheet/AsmWhseWorksheetLine.TableExt.al26 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.Warehouse.Worksheet;

using Microsoft.Assembly.Document;

tableextension 979 "Asm. Whse. Worksheet Line" extends "Whse. Worksheet Line"
{
    fields
    {
        modify("Whse. Document No.")
        {
            TableRelation = if ("Whse. Document Type" = const(Assembly)) "Assembly Header"."No." where("Document Type" = const(Order),
                                                                                                       "No." = field("Whse. Document No."));
        }
        modify("Whse. Document Line No.")
        {
            TableRelation = if ("Whse. Document Type" = const(Assembly)) "Assembly Line"."Line No." where("Document Type" = const(Order),
                                                                                                           "Document No." = field("Whse. Document No."),
                                                                                                           "Line No." = field("Whse. Document Line No."));
        }
    }
}