Table 5476 Sales Invoice Line Aggregate

Base Application, Microsoft.Integration.Entity

src/Layers/W1/BaseApp/Integration/Entity/SalesInvoiceLineAggregate.Table.al548 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.Integration.Entity;using Microsoft.Finance.Currency;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.SalesTax;using Microsoft.Finance.VAT.Setup;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;using Microsoft.Projects.Resources.Resource;using Microsoft.Sales.Document;using Microsoft.Sales.History;table 5476 "Sales Invoice Line Aggregate"{    Caption = 'Sales Invoice Line Aggregate';    TableType = Temporary;    ReplicateData = false;    DataClassification = CustomerContent;    fields    {        field(4; "Line No."; Integer)        {            Caption = 'Line No.';        }        field(5; Type; Enum "Sales Line Type")        {            Caption = 'Type';            trigger OnValidate()            begin                "API Type" := Type;            end;        }        field(6; "No."; Code[20])        {            Caption = 'No.';        }        field(7; "Location Code"; Code[10])        {            Caption = 'Location Code';            TableRelation = Location where("Use As In-Transit" = const(false));        }        field(10; "Shipment Date"; Date)        {            Caption = 'Shipment Date';        }        field(11; Description; Text[100])        {            Caption = 'Description';        }        field(12; "Description 2"; Text[50])        {            Caption = 'Description 2';        }        field(15; Quantity; Decimal)        {            AutoFormatType = 0;            Caption = 'Quantity';            DecimalPlaces = 0 : 5;        }        field(17; "Qty. to Invoice"; Decimal)        {            AutoFormatType = 0;            Caption = 'Qty. to Invoice';            DecimalPlaces = 0 : 5;        }        field(18; "Qty. to Ship"; Decimal)        {            AutoFormatType = 0;            AccessByPermission = TableData "Sales Shipment Header" = R;            Caption = 'Qty. to Ship';            DecimalPlaces = 0 : 5;        }        field(22; "Unit Price"; Decimal)        {            AutoFormatExpression = Rec."Currency Code";            AutoFormatType = 2;            Caption = 'Unit Price';        }        field(25; "VAT %"; Decimal)        {            AutoFormatType = 0;            Caption = 'VAT %';            DecimalPlaces = 0 : 5;        }        field(27; "Line Discount %"; Decimal)        {            AutoFormatType = 0;            Caption = 'Line Discount %';            DecimalPlaces = 0 : 5;            MaxValue = 100;            MinValue = 0;        }        field(28; "Line Discount Amount"; Decimal)        {            AutoFormatExpression = Rec."Currency Code";            AutoFormatType = 1;            Caption = 'Line Discount Amount';        }        field(29; Amount; Decimal)        {            AutoFormatExpression = Rec."Currency Code";            AutoFormatType = 1;            Caption = 'Amount';        }        field(30; "Amount Including VAT"; Decimal)        {            AutoFormatExpression = Rec."Currency Code";            AutoFormatType = 1;            Caption = 'Amount Including VAT';        }        field(60; "Quantity Shipped"; Decimal)        {            AutoFormatType = 0;            AccessByPermission = TableData "Sales Shipment Header" = R;            Caption = 'Quantity Shipped';            DecimalPlaces = 0 : 5;            Editable = false;        }        field(61; "Quantity Invoiced"; Decimal)        {            AutoFormatType = 0;            Caption = 'Quantity Invoiced';            DecimalPlaces = 0 : 5;            Editable = false;        }        field(69; "Inv. Discount Amount"; Decimal)        {            AutoFormatExpression = Rec."Currency Code";            AutoFormatType = 1;            Caption = 'Inv. Discount Amount';            Editable = false;        }        field(87; "Tax Group Code"; Code[20])        {            Caption = 'Tax Group Code';            TableRelation = "Tax Group";        }        field(90; "VAT Prod. Posting Group"; Code[20])        {            Caption = 'VAT Prod. Posting Group';            TableRelation = "VAT Product Posting Group";        }        field(91; "Currency Code"; Code[10])        {            Caption = 'Currency Code';            TableRelation = Currency;        }        field(99; "VAT Base Amount"; Decimal)        {            AutoFormatExpression = Rec."Currency Code";            AutoFormatType = 1;            Caption = 'VAT Base Amount';        }        field(103; "Line Amount"; Decimal)        {            AutoFormatExpression = Rec."Currency Code";            AutoFormatType = 1;            Caption = 'Line Amount';        }        field(180; "Line Discount Calculation"; Option)        {            Caption = 'Line Discount Calculation';            OptionCaption = 'None,%,Amount';            OptionMembers = "None","%",Amount;            trigger OnValidate()            begin                UpdateLineDiscounts();            end;        }        field(5402; "Variant Code"; Code[10])        {            Caption = 'Variant Code';            TableRelation = if (Type = const(Item)) "Item Variant".Code where("Item No." = field("No."));        }        field(5407; "Unit of Measure Code"; Code[10])        {            Caption = 'Unit of Measure Code';            TableRelation = if (Type = const(Item),                                "No." = filter(<> '')) "Item Unit of Measure".Code where("Item No." = field("No."))            else            if (Type = const(Resource),                                         "No." = filter(<> '')) "Resource Unit of Measure".Code where("Resource No." = field("No."))            else            "Unit of Measure";        }        field(8000; "Document Id"; Guid)        {            Caption = 'Document Id';        }        field(8001; Id; Text[50])        {            Caption = 'Id';        }        field(8002; "Variant Id"; Guid)        {            Caption = 'Variant Id';            TableRelation = if (Type = const(Item)) "Item Variant".SystemId where("Item No." = field("No."));            trigger OnValidate()            begin                UpdateVariantCode();            end;        }        field(9020; "Tax Code"; Code[50])        {            Caption = 'Tax Code';        }        field(9021; "Tax Amount"; Decimal)        {            AutoFormatExpression = Rec."Currency Code";            AutoFormatType = 1;            Caption = 'Tax Amount';        }        field(9022; "Discount Applied Before Tax"; Boolean)        {            Caption = 'Discount Applied Before Tax';        }        field(9029; "API Type"; Enum "Invoice Line Agg. Line Type")        {            Caption = 'API Type';            trigger OnValidate()            begin                Type := "API Type";            end;        }        field(9030; "Item Id"; Guid)        {            Caption = 'Item Id';            TableRelation = Item.SystemId;            trigger OnValidate()            begin                Validate(Type, Type::Item);                UpdateNo();            end;        }        field(9031; "Account Id"; Guid)        {            Caption = 'Account Id';            TableRelation = "G/L Account".SystemId;            trigger OnValidate()            begin                Validate(Type, Type::"G/L Account");                UpdateNo();            end;        }        field(9032; "Unit of Measure Id"; Guid)        {            Caption = 'Unit of Measure Id';            TableRelation = "Unit of Measure".SystemId;            trigger OnValidate()            begin                UpdateUnitOfMeasureCode();            end;        }        field(9039; "Line Tax Amount"; Decimal)        {            AutoFormatExpression = Rec."Currency Code";            AutoFormatType = 1;            Caption = 'Line Tax Amount';        }        field(9040; "Line Amount Including Tax"; Decimal)        {            AutoFormatExpression = Rec."Currency Code";            AutoFormatType = 1;            Caption = 'Line Amount Including Tax';        }        field(9041; "Line Amount Excluding Tax"; Decimal)        {            AutoFormatExpression = Rec."Currency Code";            AutoFormatType = 1;            Caption = 'Line Amount Excluding Tax';        }        field(9042; "Prices Including Tax"; Boolean)        {            Caption = 'Prices Including Tax';        }        field(9043; "Inv. Discount Amount Excl. VAT"; Decimal)        {            AutoFormatExpression = Rec."Currency Code";            AutoFormatType = 1;            Caption = 'Inv. Discount Amount Excl. VAT';        }        field(9044; "Tax Id"; Guid)        {            Caption = 'Tax Id';            trigger OnValidate()            var                TempTaxGroupBuffer: Record "Tax Group Buffer" temporary;            begin                TempTaxGroupBuffer.GetCodesFromTaxGroupId("Tax Id", "Tax Group Code", "VAT Prod. Posting Group");            end;        }        field(9050; "Line Discount Value"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = Rec."Currency Code";            Caption = 'Line Discount Value';            trigger OnValidate()            begin                UpdateLineDiscounts();            end;        }        field(9070; "Location Id"; Guid)        {            Caption = 'Location Id';            TableRelation = Location.SystemId;            trigger OnValidate()            begin                UpdateLocationCode();            end;        }    }    keys    {        key(Key1; "Document Id", "Line No.")        {            Clustered = true;        }        key(Key2; Id)        {        }    }    fieldgroups    {    }    trigger OnInsert()    begin        UpdateCalculatedFields();    end;    trigger OnModify()    begin        UpdateCalculatedFields();    end;    trigger OnRename()    begin        UpdateCalculatedFields();    end;    var        LineDiscountPctMustBePositiveErr: Label 'Line discount percentage must be positive.', Locked = true;        LineDiscountPctMustBeBelowHundredErr: Label 'Line discount percentage must be below 100.', Locked = true;        LineDiscountAmtMustBePositiveErr: Label 'Line discount amount must be positive.', Locked = true;    procedure UpdateItemId()    var        Item: Record Item;    begin        if ("No." = '') or (Type <> Type::Item) then begin            Clear("Item Id");            exit;        end;        if not Item.Get("No.") then            exit;        "Item Id" := Item.SystemId;    end;    procedure UpdateAccountId()    var        GLAccount: Record "G/L Account";    begin        if ("No." = '') or (Type <> Type::"G/L Account") then begin            Clear("Account Id");            exit;        end;        if not GLAccount.Get("No.") then            exit;        "Account Id" := GLAccount.SystemId;    end;    procedure UpdateNo()    var        Item: Record Item;        GLAccount: Record "G/L Account";    begin        case Type of            Type::Item:                begin                    if not Item.GetBySystemId("Item Id") then                        exit;                    "No." := Item."No.";                end;            Type::"G/L Account":                begin                    if not GLAccount.GetBySystemId("Account Id") then                        exit;                    "No." := GLAccount."No.";                end;        end;    end;    local procedure UpdateCalculatedFields()    begin        UpdateReferencedRecordIds();        "API Type" := Type;    end;    procedure UpdateReferencedRecordIds()    begin        UpdateItemId();        UpdateAccountId();        UpdateUnitOfMeasureId();        UpdateLocationId();    end;    local procedure UpdateUnitOfMeasureId()    var        UnitOfMeasure: Record "Unit of Measure";    begin        Clear("Unit of Measure Id");        if "Unit of Measure Code" = '' then            exit;        if not UnitOfMeasure.Get("Unit of Measure Code") then            exit;        "Unit of Measure Id" := UnitOfMeasure.SystemId;    end;    local procedure UpdateLocationId()    var        Location: Record Location;    begin        Clear("Location Id");        if "Location Code" = '' then            exit;        if not Location.Get("Location Code") then            exit;        "Location Id" := Location.SystemId;    end;    local procedure UpdateUnitOfMeasureCode()    var        UnitOfMeasure: Record "Unit of Measure";    begin        if IsNullGuid("Unit of Measure Id") then begin            Validate("Unit of Measure Code", '');            exit;        end;        UnitOfMeasure.GetBySystemId("Unit of Measure Id");        "Unit of Measure Code" := UnitOfMeasure.Code;    end;    local procedure UpdateLocationCode()    var        Location: Record Location;    begin        if IsNullGuid("Location Id") then begin            Validate("Location Code", '');            exit;        end;        Location.GetBySystemId("Location Id");        "Location Code" := Location.Code;    end;    local procedure UpdateVariantCode()    var        ItemVariant: Record "Item Variant";    begin        if IsNullGuid("Variant Id") then begin            Validate("Variant Code", '');            exit;        end;        if ItemVariant.GetBySystemId("Variant Id") then            "Variant Code" := ItemVariant.Code;    end;    procedure UpdateLineDiscounts()    var        Currency: Record Currency;        LineAmount: Decimal;    begin        if "Currency Code" = '' then            Currency.InitRoundingPrecision();        case "Line Discount Calculation" of            "Line Discount Calculation"::"%":                begin                    "Line Discount %" := "Line Discount Value";                    "Line Discount Amount" :=                      Round(                        Round(Quantity * "Unit Price", Currency."Amount Rounding Precision") *                        "Line Discount %" / 100, Currency."Amount Rounding Precision");                end;            "Line Discount Calculation"::Amount, "Line Discount Calculation"::None:                begin                    "Line Discount Amount" := "Line Discount Value";                    LineAmount := Quantity * "Unit Price";                    if LineAmount <> 0 then                        "Line Discount %" :=                          Round("Line Discount Amount" / Round(LineAmount, Currency."Amount Rounding Precision") * 100, 0.00001)                end;        end;        if "Line Discount %" < 0 then            Error(LineDiscountPctMustBePositiveErr);        if "Line Discount %" > 100 then            Error(LineDiscountPctMustBeBelowHundredErr);        if "Line Discount Amount" < 0 then            Error(LineDiscountAmtMustBePositiveErr);    end;    procedure SetDiscountValue()    begin        case "Line Discount Calculation" of            "Line Discount Calculation"::"%":                "Line Discount Value" := "Line Discount %";            "Line Discount Calculation"::Amount, "Line Discount Calculation"::None:                begin                    "Line Discount Calculation" := "Line Discount Calculation"::Amount;                    "Line Discount Value" := "Line Discount Amount";                end;        end;    end;}