Table 20560 Subcontractor WIP Ledger Entry
src/Apps/W1/Subcontracting/App/src/WIPItem/SubcontractorWIPLedgerEntry.Table.al250 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.Manufacturing.Subcontracting;using Microsoft.Foundation.NoSeries;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;using Microsoft.Manufacturing.Document;using Microsoft.Manufacturing.Routing;using Microsoft.Manufacturing.WorkCenter;table 20560 "Subcontractor WIP Ledger Entry"{ AllowInCustomizations = AsReadOnly; Caption = 'Subcontractor WIP Ledger Entry'; DataClassification = CustomerContent; DrillDownPageId = "Subc. WIP Ledger Entries"; LookupPageId = "Subc. WIP Ledger Entries"; fields { field(1; "Entry No."; Integer) { Caption = 'Entry No.'; DataClassification = CustomerContent; ToolTip = 'Specifies the number of the Subcontractor WIP Ledger Entry.'; } field(2; "Item No."; Code[20]) { Caption = 'Item No.'; DataClassification = CustomerContent; TableRelation = Item; ToolTip = 'Specifies the item number.'; } field(3; "Variant Code"; Code[10]) { Caption = 'Variant Code'; DataClassification = CustomerContent; TableRelation = "Item Variant".Code where("Item No." = field("Item No.")); ToolTip = 'Specifies the variant code.'; } field(4; "Location Code"; Code[10]) { Caption = 'Location Code'; DataClassification = CustomerContent; TableRelation = Location; ToolTip = 'Specifies the location where the WIP quantity is tracked.'; } field(5; "Posting Date"; Date) { Caption = 'Posting Date'; DataClassification = CustomerContent; ToolTip = 'Specifies the date when the WIP ledger entry was posted.'; } field(6; "Entry Type"; Enum "WIP Ledger Entry Type") { Caption = 'Entry Type'; DataClassification = CustomerContent; ToolTip = 'Specifies which type of transaction that the entry is created from.'; } field(7; "Quantity (Base)"; Decimal) { AutoFormatType = 0; Caption = 'Quantity (Base)'; DataClassification = CustomerContent; DecimalPlaces = 0 : 5; ToolTip = 'Specifies the WIP quantity in base unit of measure'; } field(8; "Base Unit of Measure"; Code[10]) { Caption = 'Base Unit of Measure'; DataClassification = CustomerContent; TableRelation = "Item Unit of Measure".Code where("Item No." = field("Item No.")); ToolTip = 'Specifies the base unit of measure of the item.'; } field(9; "Document Type"; Enum "WIP Document Type") { Caption = 'Document Type'; DataClassification = CustomerContent; ToolTip = 'Specifies the document type that created this entry.'; } field(10; "Document No."; Code[20]) { Caption = 'Document No.'; DataClassification = CustomerContent; ToolTip = 'Specifies the document number.'; } field(11; "Document Line No."; Integer) { Caption = 'Document Line No.'; DataClassification = CustomerContent; ToolTip = 'Specifies the document line number.'; } field(12; "Prod. Order Status"; Enum "Production Order Status") { Caption = 'Prod. Order Status'; DataClassification = CustomerContent; ToolTip = 'Specifies the production order status.'; } field(13; "Prod. Order No."; Code[20]) { Caption = 'Prod. Order No.'; DataClassification = CustomerContent; TableRelation = "Production Order"."No." where(Status = field("Prod. Order Status")); ToolTip = 'Specifies the production order number.'; } field(14; "Prod. Order Line No."; Integer) { Caption = 'Prod. Order Line No.'; DataClassification = CustomerContent; TableRelation = "Prod. Order Line"."Line No." where(Status = field("Prod. Order Status"), "Prod. Order No." = field("Prod. Order No.")); ToolTip = 'Specifies the production order line number.'; } field(15; "Routing No."; Code[20]) { Caption = 'Routing No.'; DataClassification = CustomerContent; TableRelation = "Routing Header"; ToolTip = 'Specifies the routing number.'; } field(16; "Routing Reference No."; Integer) { Caption = 'Routing Reference No.'; DataClassification = CustomerContent; TableRelation = "Prod. Order Routing Line"."Routing Reference No." where(Status = field("Prod. Order Status"), "Prod. Order No." = field("Prod. Order No."), "Routing No." = field("Routing No.")); ToolTip = 'Specifies the routing reference number.'; } field(17; "Operation No."; Code[10]) { Caption = 'Operation No.'; DataClassification = CustomerContent; TableRelation = "Prod. Order Routing Line"."Operation No." where(Status = field("Prod. Order Status"), "Prod. Order No." = field("Prod. Order No."), "Routing No." = field("Routing No.")); ToolTip = 'Specifies the operation number.'; } field(18; "Work Center No."; Code[20]) { Caption = 'Work Center No.'; DataClassification = CustomerContent; TableRelation = "Work Center"; ToolTip = 'Specifies the work center number.'; } field(19; Description; Text[100]) { Caption = 'Description'; DataClassification = CustomerContent; ToolTip = 'Specifies a description for the WIP ledger entry.'; } field(20; "Description 2"; Text[50]) { Caption = 'Description 2'; DataClassification = CustomerContent; ToolTip = 'Specifies description 2 for the WIP ledger entry.'; } field(21; "In Transit"; Boolean) { Caption = 'In Transit'; DataClassification = CustomerContent; ToolTip = 'Specifies whether the WIP quantity is currently in transit.'; } } keys { key(PK; "Entry No.") { Clustered = true; } key(Key2; "Item No.", "Variant Code", "Location Code") { IncludedFields = "Quantity (Base)"; } key(Key3; "Prod. Order No.", "Prod. Order Status", "Prod. Order Line No.", "Routing Reference No.", "Routing No.", "Operation No.", "Location Code") { IncludedFields = "Quantity (Base)"; } key(Key4; "Prod. Order No.", "Prod. Order Status", "Prod. Order Line No.", "Routing Reference No.", "Routing No.", "Operation No.", "Location Code", "Item No.", "Variant Code") { IncludedFields = "Quantity (Base)"; } key(Key5; "Document No.", "Posting Date") { } }#if not CLEAN29 var#pragma warning disable AL0432 SubcFeatureFlagHandler: Codeunit "Subc. Feature Flag Handler";#pragma warning restore AL0432#endif /// <summary> /// Filters the record set to WIP entries for the given production order. /// When SetKey is true, the sort key is aligned to Key3 before applying the filters. /// </summary> procedure SetProductionOrderFilter(ProductionOrder: Record "Production Order"; SetKey: Boolean) begin#if not CLEAN29#pragma warning disable AL0432 if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432 exit;#endif if SetKey then SetCurrentKey("Prod. Order No.", "Prod. Order Status", "Prod. Order Line No.", "Routing Reference No.", "Routing No.", "Operation No.", "Location Code"); SetRange("Prod. Order No.", ProductionOrder."No."); SetRange("Prod. Order Status", ProductionOrder.Status); end; /// <summary> /// Filters the record set to WIP entries for the given prod. order routing line. /// When SetKey is true, the sort key is aligned to Key3 before applying the filters. /// </summary> procedure SetProductionOrderRoutingFilter(ProdOrderRoutingLine: Record "Prod. Order Routing Line"; SetKey: Boolean) begin#if not CLEAN29#pragma warning disable AL0432 if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432 exit;#endif if SetKey then SetCurrentKey("Prod. Order No.", "Prod. Order Status", "Prod. Order Line No.", "Routing Reference No.", "Routing No.", "Operation No.", "Location Code"); SetRange("Prod. Order No.", ProdOrderRoutingLine."Prod. Order No."); SetRange("Prod. Order Status", ProdOrderRoutingLine.Status); SetRange("Routing Reference No.", ProdOrderRoutingLine."Routing Reference No."); SetRange("Routing No.", ProdOrderRoutingLine."Routing No."); SetRange("Operation No.", ProdOrderRoutingLine."Operation No."); end; /// <summary> /// Gets the next entry number for the Subcontractor WIP Ledger Entry table. /// </summary> /// <returns>The next entry number.</returns> procedure GetNextEntryNo(): Integer var SequenceNoMgt: Codeunit "Sequence No. Mgt."; begin#if not CLEAN29#pragma warning disable AL0432 if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432 exit(0);#endif exit(SequenceNoMgt.GetNextSeqNo(DATABASE::"Subcontractor WIP Ledger Entry")); end;}