Table 8054 Sub. Package Line Template

Subscription Billing, Microsoft.SubscriptionBilling

src/Apps/W1/Subscription Billing/App/Service Commitments/Tables/SubPackageLineTemplate.Table.al169 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.SubscriptionBilling;using Microsoft.Inventory.Item;table 8054 "Sub. Package Line Template"{    Caption = 'Subscription Package Line Template';    DataClassification = CustomerContent;    DrillDownPageId = "Service Commitment Templates";    LookupPageId = "Service Commitment Templates";    fields    {        field(1; Code; Code[20])        {            Caption = 'Code';            NotBlank = true;        }        field(2; Description; Text[100])        {            Caption = 'Description';        }        field(3; "Invoicing via"; Enum "Invoicing Via")        {            Caption = 'Invoicing via';            InitValue = Contract;            trigger OnValidate()            begin                if "Invoicing via" = "Invoicing via"::Sales then begin                    "Invoicing Item No." := '';                    "Create Contract Deferrals" := "Create Contract Deferrals"::No;                end else                    "Create Contract Deferrals" := "Create Contract Deferrals"::"Contract-dependent";                ErrorIfInvoicingViaIsNotContractForDiscount();            end;        }        field(4; "Invoicing Item No."; Code[20])        {            Caption = 'Invoicing Item No.';            TableRelation = Item."No." where("Subscription Option" = const("Invoicing Item"));            trigger OnValidate()            begin                if "Invoicing via" = "Invoicing via"::Sales then                    Error(InvoicingItemNoErr);                ErrorIfInvoicingItemIsNotServiceCommitmentItemForDiscount();            end;        }        field(5; "Calculation Base Type"; Enum "Calculation Base Type")        {            Caption = 'Calculation Base Type';        }        field(6; "Calculation Base %"; Decimal)        {            Caption = 'Calculation Base %';            MinValue = 0;            DecimalPlaces = 0 : 5;            AutoFormatType = 0;        }        field(7; "Billing Base Period"; DateFormula)        {            Caption = 'Billing Base Period';            trigger OnValidate()            begin                DateFormulaManagement.ErrorIfDateFormulaNegative("Billing Base Period");            end;        }        field(8; Discount; Boolean)        {            Caption = 'Discount';            trigger OnValidate()            begin                ErrorIfInvoicingViaIsNotContractForDiscount();                ErrorIfInvoicingItemIsNotServiceCommitmentItemForDiscount();                ErrorIfDiscountUsedWithUsageBasedBilling();            end;        }        field(40; "Create Contract Deferrals"; Enum "Create Contract Deferrals")        {            Caption = 'Create Contract Deferrals';        }        field(8000; "Usage Based Billing"; Boolean)        {            Caption = 'Usage Based Billing';            DataClassification = CustomerContent;            trigger OnValidate()            begin                if Rec."Usage Based Billing" then begin                    Rec.TestField("Invoicing via", Enum::"Invoicing Via"::Contract);                    Rec.TestField(Discount, false);                    if Rec."Usage Based Pricing" = "Usage Based Pricing"::None then                        Rec.Validate("Usage Based Pricing", "Usage Based Pricing"::"Usage Quantity");                end else                    Validate("Usage Based Pricing", "Usage Based Pricing"::None);                ErrorIfDiscountUsedWithUsageBasedBilling();            end;        }        field(8001; "Usage Based Pricing"; Enum "Usage Based Pricing")        {            Caption = 'Usage Based Pricing';            DataClassification = CustomerContent;            trigger OnValidate()            begin                if Rec."Usage Based Pricing" <> Enum::"Usage Based Pricing"::None then begin                    Rec.TestField("Invoicing via", Enum::"Invoicing Via"::Contract);                    Validate("Usage Based Billing", true);                    if Rec."Usage Based Pricing" <> Enum::"Usage Based Pricing"::"Unit Cost Surcharge" then                        Validate("Pricing Unit Cost Surcharge %", 0);                end                else begin                    "Usage Based Billing" := false;                    "Pricing Unit Cost Surcharge %" := 0;                end;            end;        }        field(8002; "Pricing Unit Cost Surcharge %"; Decimal)        {            Caption = 'Pricing Unit Cost Surcharge %';            DataClassification = CustomerContent;            AutoFormatType = 0;            DecimalPlaces = 0 : 5;        }    }    keys    {        key(PK; Code)        {            Clustered = true;        }    }    local procedure ErrorIfInvoicingViaIsNotContractForDiscount()    begin        if not Rec.Discount then            exit;        if Rec."Invoicing via" <> Enum::"Invoicing Via"::Contract then            Error(DiscountCanBeInvoicedViaContractErr);    end;    local procedure ErrorIfInvoicingItemIsNotServiceCommitmentItemForDiscount()    var        Item: Record Item;    begin        if not Rec.Discount then            exit;        if not Item.Get(Rec."Invoicing Item No.") then            exit;        if Item."Subscription Option" <> Enum::"Item Service Commitment Type"::"Service Commitment Item" then            Error(DiscountCannotBeAssignedErr);    end;    local procedure ErrorIfDiscountUsedWithUsageBasedBilling()    begin        if Rec.Discount then            if Rec."Usage Based Billing" then                Error(RecurringDiscountCannotBeGrantedErr);    end;    var        DateFormulaManagement: Codeunit "Date Formula Management";        DiscountCannotBeAssignedErr: Label 'Subscription Package Lines, which are discounts, can only be assigned to Subscription Items.';        InvoicingItemNoErr: Label 'Subscription Lines for a sales document are not invoiced. No value may be entered in the Invoicing Item No..';        RecurringDiscountCannotBeGrantedErr: Label 'Recurring discounts cannot be granted in conjunction with Usage Based Billing';        DiscountCanBeInvoicedViaContractErr: Label 'Recurring discounts can only be granted for Invoicing via Contract.';}