Table extension 99000752 Mfg. Purchase Line Archive
src/Layers/W1/BaseApp/Manufacturing/Purchases/Archive/MfgPurchaseLineArchive.TableExt.al61 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.Purchases.Archive;using Microsoft.Manufacturing.Document;using Microsoft.Manufacturing.Routing;using Microsoft.Manufacturing.WorkCenter;tableextension 99000752 "Mfg. Purchase Line Archive" extends "Purchase Line Archive"{ fields { field(5401; "Prod. Order No."; Code[20]) { Caption = 'Prod. Order No.'; DataClassification = CustomerContent; TableRelation = "Production Order"."No." where(Status = filter(Released | Finished)); ValidateTableRelation = false; } field(99000750; "Routing No."; Code[20]) { Caption = 'Routing No.'; DataClassification = CustomerContent; TableRelation = "Routing Header"; } field(99000751; "Operation No."; Code[10]) { Caption = 'Operation No.'; DataClassification = CustomerContent; TableRelation = "Prod. Order Routing Line"."Operation No." where(Status = const(Released), "Prod. Order No." = field("Prod. Order No."), "Routing No." = field("Routing No.")); } field(99000752; "Work Center No."; Code[20]) { Caption = 'Work Center No.'; DataClassification = CustomerContent; TableRelation = "Work Center"; } field(99000753; Finished; Boolean) { Caption = 'Finished'; DataClassification = CustomerContent; } field(99000754; "Prod. Order Line No."; Integer) { Caption = 'Prod. Order Line No.'; DataClassification = CustomerContent; TableRelation = "Prod. Order Line"."Line No." where(Status = filter(Released ..), "Prod. Order No." = field("Prod. Order No.")); } field(99000759; "Routing Reference No."; Integer) { Caption = 'Routing Reference No.'; DataClassification = CustomerContent; } }}