Table 5997 Standard Service Line

Base Application, Microsoft.Service.Document

src/Layers/W1/BaseApp/Service/Document/StandardServiceLine.Table.al388 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.Service.Document;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Foundation.AuditCodes;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Item;using Microsoft.Projects.Resources.Resource;using Microsoft.Service.Pricing;using Microsoft.Utilities;table 5997 "Standard Service Line"{    Caption = 'Standard Service Line';    DataClassification = CustomerContent;    fields    {        field(1; "Standard Service Code"; Code[10])        {            Caption = 'Standard Service Code';            Editable = false;            TableRelation = "Standard Service Code";        }        field(2; "Line No."; Integer)        {            Caption = 'Line No.';            Editable = false;        }        field(3; Type; Enum "Service Line Type")        {            Caption = 'Type';            ToolTip = 'Specifies the type, item, resource, cost, or g/l account associated with the standard service line.';            trigger OnValidate()            var                OldType: Enum "Service Line Type";            begin                OldType := Type;                Init();                Type := OldType;            end;        }        field(4; "No."; Code[20])        {            Caption = 'No.';            ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.';            TableRelation = if (Type = const(" ")) "Standard Text"            else            if (Type = const(Item)) Item where(Blocked = const(false), "Service Blocked" = const(false))            else            if (Type = const(Resource)) Resource            else            if (Type = const(Cost)) "Service Cost"            else            if (Type = const("G/L Account")) "G/L Account";            trigger OnValidate()            var                StdTxt: Record "Standard Text";                GLAcc: Record "G/L Account";                Item: Record Item;                Res: Record Resource;                ServCost: Record "Service Cost";            begin                if "No." <> xRec."No." then begin                    Quantity := 0;                    "Amount Excl. VAT" := 0;                    "Unit of Measure Code" := '';                    Description := '';                    if "No." = '' then                        exit;                    StdServCode.Get("Standard Service Code");                    case Type of                        Type::" ":                            begin                                StdTxt.Get("No.");                                Description := StdTxt.Description;                            end;                        Type::Item:                            begin                                Item.Get("No.");                                if Item.Type = Item.Type::Inventory then                                    Item.TestField("Inventory Posting Group");                                Item.TestField("Gen. Prod. Posting Group");                                Description := Item.Description;                                "Unit of Measure Code" := Item."Sales Unit of Measure";                                "Variant Code" := '';                            end;                        Type::Resource:                            begin                                Res.Get("No.");                                Res.CheckResourcePrivacyBlocked(false);                                Res.TestField(Blocked, false);                                Res.TestField("Gen. Prod. Posting Group");                                Description := Res.Name;                                "Unit of Measure Code" := Res."Base Unit of Measure";                            end;                        Type::Cost:                            begin                                ServCost.Get("No.");                                GLAcc.Get(ServCost."Account No.");                                GLAcc.TestField("Gen. Prod. Posting Group");                                Description := ServCost.Description;                                Quantity := ServCost."Default Quantity";                                "Unit of Measure Code" := ServCost."Unit of Measure Code";                            end;                        Type::"G/L Account":                            begin                                GLAcc.Get("No.");                                GLAcc.CheckGLAcc();                                GLAcc.TestField("Direct Posting", true);                                Description := GLAcc.Name;                            end;                    end;                end;                CreateDimFromDefaultDim();            end;        }        field(5; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies a description of this entry.';        }        field(6; Quantity; Decimal)        {            AutoFormatType = 0;            BlankZero = true;            Caption = 'Quantity';            ToolTip = 'Specifies the number of item units, resource hours, or costs on the line.';            DecimalPlaces = 0 : 5;            trigger OnValidate()            begin                TestField(Type);                TestField("No.");                if Quantity < 0 then                    FieldError(Quantity, Text002);            end;        }        field(7; "Amount Excl. VAT"; Decimal)        {            AutoFormatExpression = GetCurrency();            AutoFormatType = 2;            BlankZero = true;            Caption = 'Amount Excl. VAT';            ToolTip = 'Specifies the net amount for this standard service line.';            trigger OnValidate()            begin                if Type <> Type::"G/L Account" then                    FieldError(Type, StrSubstNo(Text001, Type));            end;        }        field(8; "Unit of Measure Code"; Code[10])        {            Caption = 'Unit of Measure Code';            ToolTip = 'Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted.';            TableRelation = if (Type = const(Item)) "Item Unit of Measure".Code where("Item No." = field("No."))            else            if (Type = const(Resource)) "Resource Unit of Measure".Code where("Resource No." = field("No."))            else            "Unit of Measure";            trigger OnValidate()            begin                TestField(Type);            end;        }        field(9; "Shortcut Dimension 1 Code"; Code[20])        {            CaptionClass = '1,2,1';            Caption = 'Shortcut Dimension 1 Code';            ToolTip = 'Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window.';            TableRelation = "Dimension Value".Code where("Global Dimension No." = const(1),                                                          Blocked = const(false));            trigger OnValidate()            begin                Rec.ValidateShortcutDimCode(1, "Shortcut Dimension 1 Code");            end;        }        field(10; "Shortcut Dimension 2 Code"; Code[20])        {            CaptionClass = '1,2,2';            Caption = 'Shortcut Dimension 2 Code';            ToolTip = 'Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window.';            TableRelation = "Dimension Value".Code where("Global Dimension No." = const(2),                                                          Blocked = const(false));            trigger OnValidate()            begin                Rec.ValidateShortcutDimCode(2, "Shortcut Dimension 2 Code");            end;        }        field(11; "Variant Code"; Code[10])        {            Caption = 'Variant Code';            ToolTip = 'Specifies the variant of the item on the line.';            TableRelation = if (Type = const(Item)) "Item Variant".Code where("Item No." = field("No."), Blocked = const(false), "Service Blocked" = const(false));            trigger OnValidate()            var                Item: Record Item;                ItemVariant: Record "Item Variant";            begin                if Rec."Variant Code" = '' then begin                    if Type = Type::Item then begin                        Item.Get("No.");                        Description := Item.Description;                    end;                    exit;                end;                TestField(Type, Type::Item);                ItemVariant.SetLoadFields(Description);                ItemVariant.Get("No.", "Variant Code");                Description := ItemVariant.Description;            end;        }        field(480; "Dimension Set ID"; Integer)        {            Caption = 'Dimension Set ID';            Editable = false;            TableRelation = "Dimension Set Entry";            trigger OnLookup()            begin                Rec.ShowDimensions();            end;            trigger OnValidate()            begin                DimMgt.UpdateGlobalDimFromDimSetID("Dimension Set ID", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code");            end;        }    }    keys    {        key(Key1; "Standard Service Code", "Line No.")        {            Clustered = true;        }    }    fieldgroups    {    }    trigger OnInsert()    begin        LockTable();        StdServCode.Get("Standard Service Code");    end;    trigger OnRename()    begin        Error(Text000, TableCaption);    end;    var        StdServCode: Record "Standard Service Code";        DimMgt: Codeunit DimensionManagement;#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label 'You cannot rename a %1.';        Text001: Label 'must not be %1';#pragma warning restore AA0470        Text002: Label 'must be positive';#pragma warning restore AA0074    procedure EmptyLine(): Boolean    begin        exit(("No." = '') and (Quantity = 0))    end;    procedure InsertLine(): Boolean    begin        exit((Type = Type::" ") or not EmptyLine());    end;    local procedure GetCurrency(): Code[10]    begin        if StdServCode.Get("Standard Service Code") then            exit(StdServCode."Currency Code");        exit('');    end;    procedure ShowDimensions()    begin        "Dimension Set ID" :=          DimMgt.EditDimensionSet(            Rec, "Dimension Set ID", StrSubstNo('%1 %2 %3', TableCaption(), "No.", "Line No."),            "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code");        Modify();    end;    procedure ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])    begin        OnBeforeValidateShortcutDimCode(Rec, xRec, FieldNumber, ShortcutDimCode);        DimMgt.ValidateShortcutDimValues(FieldNumber, ShortcutDimCode, "Dimension Set ID");        OnAfterValidateShortcutDimCode(Rec, xRec, FieldNumber, ShortcutDimCode);    end;    procedure LookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeLookupShortcutDimCode(Rec, xRec, FieldNumber, ShortcutDimCode, IsHandled);        if IsHandled then            exit;        DimMgt.LookupDimValueCode(FieldNumber, ShortcutDimCode);        DimMgt.ValidateShortcutDimValues(FieldNumber, ShortcutDimCode, "Dimension Set ID");    end;    procedure ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])    begin        DimMgt.GetShortcutDimensions(Rec."Dimension Set ID", ShortcutDimCode);    end;    procedure CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])    var        SourceCodeSetup: Record "Source Code Setup";    begin        SourceCodeSetup.Get();        "Shortcut Dimension 1 Code" := '';        "Shortcut Dimension 2 Code" := '';        "Dimension Set ID" :=          DimMgt.GetRecDefaultDimID(            Rec, CurrFieldNo, DefaultDimSource, SourceCodeSetup."Service Management",            "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code", 0, 0);        OnAfterCreateDim(Rec, DefaultDimSource);    end;    procedure CreateDimFromDefaultDim()    var        DefaultDimSource: List of [Dictionary of [Integer, Code[20]]];    begin        InitDefaultDimensionSources(DefaultDimSource);        CreateDim(DefaultDimSource);    end;    local procedure InitDefaultDimensionSources(var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])    var        ServDimMgt: Codeunit "Serv. Dimension Management";    begin        DimMgt.AddDimSource(DefaultDimSource, ServDimMgt.ServiceLineTypeToTableID(Rec.Type), Rec."No.");        OnAfterInitDefaultDimensionSources(Rec, DefaultDimSource);    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInitDefaultDimensionSources(var StandardServiceLine: Record "Standard Service Line"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCreateDim(var StandardServiceLine: Record "Standard Service Line"; DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeLookupShortcutDimCode(var StandardServiceLine: Record "Standard Service Line"; var xStandardServiceLine: Record "Standard Service Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20]; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterValidateShortcutDimCode(var StandardServiceLine: Record "Standard Service Line"; var xStandardServiceLine: Record "Standard Service Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeValidateShortcutDimCode(var StandardServiceLine: Record "Standard Service Line"; var xStandardServiceLine: Record "Standard Service Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])    begin    end;}