Codeunit 8025 Import And Process Usage Data

Subscription Billing, Microsoft.SubscriptionBilling

src/Apps/W1/Subscription Billing/App/Usage Based Billing/Codeunits/ImportAndProcessUsageData.Codeunit.al129 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.SubscriptionBilling;using Microsoft.Inventory.Item.Catalog;codeunit 8025 "Import And Process Usage Data"{    TableNo = "Usage Data Import";    SingleInstance = true;    var        UsageDataProcessing: Interface "Usage Data Processing";    trigger OnRun()    var        UsageDataSupplier: Record "Usage Data Supplier";    begin        UsageDataSupplier.Get(Rec."Supplier No.");        UsageDataProcessing := UsageDataSupplier.Type;        case Rec."Processing Step" of            Enum::"Processing Step"::"Create Imported Lines":                UsageDataProcessing.ImportUsageData(Rec);            Enum::"Processing Step"::"Process Imported Lines":                UsageDataProcessing.ProcessUsageData(Rec);        end;    end;    procedure CreateUsageDataCustomer(CustomerId: Text[80]; UsageDataSupplierReference: Record "Usage Data Supplier Reference"; SupplierNo: Code[20])    var        UsageDataCustomer: Record "Usage Data Supp. Customer";    begin        UsageDataCustomer.SetRange("Supplier No.", SupplierNo);        UsageDataCustomer.SetRange("Supplier Reference", CustomerId);        if UsageDataCustomer.IsEmpty() then begin            UsageDataCustomer.Init();            UsageDataCustomer."Entry No." := 0;            UsageDataCustomer.Validate("Supplier No.", SupplierNo);            UsageDataCustomer.Validate("Supplier Reference", CustomerId);            UsageDataSupplierReference.CreateSupplierReference(UsageDataCustomer."Supplier No.", UsageDataCustomer."Supplier Reference", Enum::"Usage Data Reference Type"::Customer);            UsageDataCustomer."Supplier Reference Entry No." := UsageDataSupplierReference."Entry No.";            UsageDataCustomer.Insert(true);        end;    end;    procedure CreateUsageDataSubscription(SubscriptionID: Text[80]; CustomerID: Text[80]; ProductID: Text[80]; ProductName: Text[100]; Unit: Text[80];                                                    Quantity: Decimal; SubscriptionStartDate: Date; SubscriptionEndDate: Date;                                                    UsageDataSupplierReference: Record "Usage Data Supplier Reference"; SupplierNo: Code[20])    var        UsageDataSubscription: Record "Usage Data Supp. Subscription";        UsageDataCustomer: Record "Usage Data Supp. Customer";    begin        if UsageDataSubscription.FindForSupplierReference(SupplierNo, SubscriptionID) then begin            UsageDataCustomer.SetRange("Supplier No.", SupplierNo);            UsageDataCustomer.SetRange("Supplier Reference", CustomerID);            if UsageDataCustomer.FindFirst() then begin                UsageDataSubscription.Validate("Customer No.", UsageDataCustomer."Customer No.");                UsageDataSubscription.Modify(true);            end;        end else begin            UsageDataSubscription.Init();            UsageDataSubscription."Entry No." := 0;            UsageDataSubscription.Validate("Supplier No.", SupplierNo);            UsageDataSubscription.Validate("Supplier Reference", SubscriptionID);            UsageDataSubscription.Validate("Customer ID", CustomerID);            UsageDataSubscription.Validate("Product ID", ProductID);            UsageDataSubscription.Validate("Product Name", ProductName);            UsageDataSubscription.Validate("Unit Type", Unit);            UsageDataSubscription.Validate(Quantity, Quantity);            UsageDataSubscription.Validate("Start Date", SubscriptionStartDate);            UsageDataSubscription.Validate("End Date", SubscriptionEndDate);            UsageDataSupplierReference.CreateSupplierReference(SupplierNo, UsageDataSubscription."Supplier Reference", Enum::"Usage Data Reference Type"::Subscription);            UsageDataSubscription."Supplier Reference Entry No." := UsageDataSupplierReference."Entry No.";            if UsageDataSubscription."Product ID" <> '' then                UsageDataSupplierReference.CreateSupplierReference(SupplierNo, UsageDataSubscription."Product ID", Enum::"Usage Data Reference Type"::Product);            UsageDataSubscription.Insert(true);        end;    end;    procedure GetServiceCommitmentForSubscription(SupplierNo: Code[20]; SubscriptionReference: Text[80]; var ServiceCommitment: Record "Subscription Line"): Boolean    var        UsageDataSupplierReference: Record "Usage Data Supplier Reference";    begin        UsageDataSupplierReference.FilterUsageDataSupplierReference(SupplierNo, SubscriptionReference, Enum::"Usage Data Reference Type"::Subscription);        if not UsageDataSupplierReference.FindFirst() then            exit;        ServiceCommitment.Reset();        ServiceCommitment.SetCurrentKey(ServiceCommitment."Subscription Line Start Date");        ServiceCommitment.SetRange("Supplier Reference Entry No.", UsageDataSupplierReference."Entry No.");        ServiceCommitment.SetRange(Partner, Enum::"Service Partner"::Vendor);        ServiceCommitment.SetRange("Subscription Line End Date", 0D);        if ServiceCommitment.IsEmpty() then            ServiceCommitment.SetRange("Subscription Line End Date");        if ServiceCommitment.IsEmpty() then            ServiceCommitment.SetRange(Partner);        exit(ServiceCommitment.FindLast());    end;    internal procedure AvailableServiceObjectExist(var UsageDataImport: Record "Usage Data Import"; SubscriptionID: Text[80]): Boolean    var        UsageDataSubscription: Record "Usage Data Supp. Subscription";        UsageDataSupplier: Record "Usage Data Supplier";        UsageDataSupplierReference: Record "Usage Data Supplier Reference";        ItemReference: Record "Item Reference";        SubscriptionLineWithoutReference: Record "Subscription Line";        SubscriptionLineWithReference: Record "Subscription Line";    begin        if not UsageDataSupplier.Get(UsageDataImport."Supplier No.") then            exit(false);        if not UsageDataSubscription.FindForSupplierReference(UsageDataImport."Supplier No.", SubscriptionID) then            exit(false);        if not UsageDataSupplierReference.FindSupplierReference(UsageDataImport."Supplier No.", UsageDataSubscription."Product ID", Enum::"Usage Data Reference Type"::Product) then            exit(false);        if not ItemReference.FindForVendorAndSupplierReference(UsageDataSupplier."Vendor No.", UsageDataSupplierReference."Entry No.") then            exit(false);        SubscriptionLineWithoutReference.SetRange("Source Type", Enum::"Service Object Type"::Item);        SubscriptionLineWithoutReference.SetRange("Source No.", ItemReference."Item No.");        SubscriptionLineWithoutReference.SetRange("Supplier Reference Entry No.", 0);        SubscriptionLineWithReference.SetRange("Source Type", Enum::"Service Object Type"::Item);        SubscriptionLineWithReference.SetRange("Source No.", ItemReference."Item No.");        SubscriptionLineWithReference.SetFilter("Supplier Reference Entry No.", '<>0');        exit(not SubscriptionLineWithoutReference.IsEmpty() and SubscriptionLineWithReference.IsEmpty());    end;}