Table 20500 Subcontractor Price

Subcontracting, Microsoft.Manufacturing.Subcontracting

src/Apps/W1/Subcontracting/App/src/Purchase/SubcontractorPrice.Table.al261 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.Finance.Currency;using Microsoft.Inventory.Item;using Microsoft.Manufacturing.Routing;using Microsoft.Manufacturing.WorkCenter;using Microsoft.Purchases.Vendor;table 20500 "Subcontractor Price"{    Caption = 'Subcontractor Price';    DataClassification = CustomerContent;    DrillDownPageId = "Subcontractor Prices";    LookupPageId = "Subcontractor Prices";    fields    {        field(1; "Vendor No."; Code[20])        {            Caption = 'Vendor No.';            NotBlank = true;            TableRelation = Vendor;            trigger OnValidate()            var                Vendor: Record Vendor;            begin#if not CLEAN29#pragma warning disable AL0432                if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432                    exit;#endif                if Vendor.Get("Vendor No.") then                    "Currency Code" := Vendor."Currency Code";            end;        }        field(2; "Item No."; Code[20])        {            Caption = 'Item No.';            NotBlank = true;            TableRelation = Item;            trigger OnValidate()            begin#if not CLEAN29#pragma warning disable AL0432                if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432                    exit;#endif                if "Item No." <> xRec."Item No." then begin                    "Unit of Measure Code" := '';                    "Variant Code" := '';                end;            end;        }        field(3; "Work Center No."; Code[20])        {            Caption = 'Work Center No.';            NotBlank = true;            TableRelation = "Work Center"."No." where("Subcontractor No." = filter(<> ''));        }        field(4; "Variant Code"; Code[10])        {            Caption = 'Variant Code';            TableRelation = "Item Variant".Code where("Item No." = field("Item No."));        }        field(5; "Standard Task Code"; Code[10])        {            Caption = 'Standard Task Code';            TableRelation = "Standard Task";        }        field(6; "Starting Date"; Date)        {            Caption = 'Starting Date';            trigger OnValidate()            begin#if not CLEAN29#pragma warning disable AL0432                if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432                    exit;#endif                if ("Starting Date" > "Ending Date") and ("Ending Date" <> 0D) then                    Error(InvalidStartingDateErr, FieldCaption("Starting Date"), FieldCaption("Ending Date"));            end;        }        field(7; "Unit of Measure Code"; Code[10])        {            Caption = 'Unit of Measure Code';            TableRelation = "Item Unit of Measure".Code where("Item No." = field("Item No."));        }        field(8; "Minimum Quantity"; Decimal)        {            AutoFormatType = 0;            Caption = 'Minimum Quantity';            DecimalPlaces = 0 : 5;            MinValue = 0;        }        field(9; "Currency Code"; Code[10])        {            Caption = 'Currency Code';            TableRelation = Currency;        }        field(10; "Direct Unit Cost"; Decimal)        {            AutoFormatExpression = "Currency Code";            AutoFormatType = 2;            Caption = 'Direct Unit Cost';            MinValue = 0;        }        field(20; "Minimum Amount"; Decimal)        {            AutoFormatExpression = "Currency Code";            AutoFormatType = 1;            Caption = 'Minimum Amount';            MinValue = 0;        }        field(30; "Ending Date"; Date)        {            Caption = 'Ending Date';            trigger OnValidate()            begin#if not CLEAN29#pragma warning disable AL0432                if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432                    exit;#endif                Validate("Starting Date");            end;        }    }    keys    {        key(PK; "Vendor No.", "Item No.", "Work Center No.", "Variant Code", "Standard Task Code", "Starting Date", "Unit of Measure Code", "Minimum Quantity", "Currency Code")        {            Clustered = true;        }        key(Key01; "Vendor No.", "Item No.", "Starting Date", "Currency Code", "Unit of Measure Code", "Minimum Quantity")        {        }        key(Key02; "Vendor No.", "Item No.", "Work Center No.", "Variant Code", "Unit of Measure Code", "Currency Code")        {        }        key(Key03; "Work Center No.")        {        }        key(Key04; "Item No.")        {        }    }    fieldgroups    {        fieldgroup(Brick; "Work Center No.", "Vendor No.", "Item No.", "Starting Date", "Direct Unit Cost", "Ending Date")        {        }        fieldgroup(DropDown; "Work Center No.", "Vendor No.", "Item No.", "Starting Date", "Direct Unit Cost", "Ending Date")        {        }    }    trigger OnInsert()    begin#if not CLEAN29#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            exit;#endif        TestField("Vendor No.");        TestField("Item No.");    end;    trigger OnRename()    begin#if not CLEAN29#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            exit;#endif        TestField("Vendor No.");        TestField("Item No.");    end;    var#if not CLEAN29#pragma warning disable AL0432        SubcFeatureFlagHandler: Codeunit "Subc. Feature Flag Handler";#pragma warning restore AL0432#endif        InvalidStartingDateErr: Label '%1 cannot be after %2', Comment = '%1=Field Caption for starting date, %2=Field Caption for ending date';    procedure CopySubcontractorPriceToVendorsSubcontractorPrice(var SubcontractorPrice: Record "Subcontractor Price"; VendNo: Code[20]; WorkCenterNo: Code[20])    var        NewSubcontractorPrice: Record "Subcontractor Price";    begin#if not CLEAN29#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            exit;#endif        if SubcontractorPrice.FindSet() then            repeat                NewSubcontractorPrice := SubcontractorPrice;                NewSubcontractorPrice."Vendor No." := VendNo;                NewSubcontractorPrice."Work Center No." := WorkCenterNo;                if NewSubcontractorPrice.Insert() then;            until SubcontractorPrice.Next() = 0;    end;    internal procedure DeletePricesForVendor(VendorNo: Code[20])    begin#if not CLEAN29#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            exit;#endif        SetCurrentKey("Vendor No.");        SetRange("Vendor No.", VendorNo);        if not IsEmpty() then            DeleteAll(true);    end;    internal procedure DeletePricesForWorkCenter(WorkCenterNo: Code[20])    begin#if not CLEAN29#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            exit;#endif        SetCurrentKey("Work Center No.");        SetRange("Work Center No.", WorkCenterNo);        if not IsEmpty() then            DeleteAll(true);    end;    internal procedure DeletePricesForItem(ItemNo: Code[20])    begin#if not CLEAN29#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            exit;#endif        SetCurrentKey("Item No.");        SetRange("Item No.", ItemNo);        if not IsEmpty() then            DeleteAll(true);    end;}