Table 8013 Usage Data Import

Subscription Billing, Microsoft.SubscriptionBilling

src/Apps/W1/Subscription Billing/App/Usage Based Billing/Tables/UsageDataImport.Table.al442 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.SubscriptionBilling;using System.IO;table 8013 "Usage Data Import"{    Caption = 'Usage Data Import';    DataClassification = CustomerContent;    LookupPageId = "Usage Data Imports";    DrillDownPageId = "Usage Data Imports";    fields    {        field(1; "Entry No."; Integer)        {            Caption = 'Entry No.';            AutoIncrement = true;            Editable = false;        }        field(2; "Supplier No."; Code[20])        {            Caption = 'Supplier No.';            TableRelation = "Usage Data Supplier";        }        field(3; "Supplier Description"; Text[80])        {            Caption = 'Supplier Description';            Editable = false;            FieldClass = FlowField;            CalcFormula = lookup("Usage Data Supplier".Description where("No." = field("Supplier No.")));        }        field(4; Description; Text[80])        {            Caption = 'Description';        }        field(5; "Processing Date"; Date)        {            Caption = 'Processing Date';            Editable = false;        }        field(6; "Processing Step"; Enum "Processing Step")        {            Caption = 'Processing Step';            Editable = false;        }        field(7; "Processing Status"; Enum "Processing Status")        {            Caption = 'Processing Status';            Editable = false;            trigger OnValidate()            begin                if "Processing Status" in ["Processing Status"::None, "Processing Status"::Ok] then                    SetReason('');                if "Processing Status" = "Processing Status"::None then                    "Processing Date" := 0D                else                    "Processing Date" := WorkDate();            end;        }        field(8; "Reason (Preview)"; Text[80])        {            Caption = 'Reason (Preview)';            Editable = false;            trigger OnLookup()            begin                ShowReason();            end;        }        field(9; Reason; Blob)        {            Caption = 'Reason';            Compressed = false;        }        field(10; "No. of Usage Data Blobs"; Integer)        {            Caption = 'No. of Usage Data Blobs';            FieldClass = FlowField;            Editable = false;            CalcFormula = count("Usage Data Blob" where("Usage Data Import Entry No." = field("Entry No.")));        }#if not CLEANSCHEMA32        field(11; "No. of Imported Lines"; Integer)        {            Caption = 'No. of Imported Lines';            FieldClass = FlowField;            Editable = false;            CalcFormula = count("Usage Data Generic Import" where("Usage Data Import Entry No." = field("Entry No.")));#if not CLEAN29            ObsoleteState = Pending;            ObsoleteTag = '29.0';#else            ObsoleteState = Removed;            ObsoleteTag = '32.0';#endif            ObsoleteReason = 'Replaced by GetImportedLineCount in the Usage Data Processing interface.';        }#endif#if not CLEANSCHEMA32        field(12; "No. of Imported Line Errors"; Integer)        {            Caption = 'No. of Imported Line Errors';            FieldClass = FlowField;            Editable = false;            CalcFormula = count("Usage Data Generic Import" where("Usage Data Import Entry No." = field("Entry No."), "Processing Status" = const(Error)));#if not CLEAN29            ObsoleteState = Pending;            ObsoleteTag = '29.0';#else            ObsoleteState = Removed;            ObsoleteTag = '32.0';#endif            ObsoleteReason = 'Replaced by GetImportedLineCount in the Usage Data Processing interface.';        }#endif        field(13; "No. of Usage Data Billing"; Integer)        {            Caption = 'No. of Usage Data Billing';            FieldClass = FlowField;            Editable = false;            CalcFormula = count("Usage Data Billing" where("Usage Data Import Entry No." = field("Entry No.")));        }        field(14; "No. of UD Billing Errors"; Integer)        {            Caption = 'No. of Usage Data Billing Errors';            FieldClass = FlowField;            Editable = false;            CalcFormula = count("Usage Data Billing" where("Usage Data Import Entry No." = field("Entry No."), "Processing Status" = const(Error)));        }    }    keys    {        key(PK; "Entry No.")        {            Clustered = true;        }    }    trigger OnDelete()    var        UsageDataBlob: Record "Usage Data Blob";        UsageDataSupplier: Record "Usage Data Supplier";        UsageDataProcessing: Interface "Usage Data Processing";    begin        CheckAndDeleteUsageDataBilling();        if UsageDataSupplier.Get("Supplier No.") then begin            UsageDataProcessing := UsageDataSupplier.Type;            UsageDataProcessing.DeleteImportedData(Rec);        end;        UsageDataBlob.SetRange("Usage Data Import Entry No.", "Entry No.");        UsageDataBlob.DeleteAll(false);    end;    internal procedure SetStatus(ProcessingStatus: Enum Microsoft.SubscriptionBilling."Processing Status")    begin        Rec.Validate("Processing Status", ProcessingStatus);        Rec.Modify(true);    end;    internal procedure SetReason(ReasonText: Text)    var        TextManagement: Codeunit "Text Management";        RRef: RecordRef;    begin        if ReasonText = '' then begin            Clear("Reason (Preview)");            Clear(Reason);        end else begin            "Reason (Preview)" := CopyStr(ReasonText, 1, MaxStrLen("Reason (Preview)"));            RRef.GetTable(Rec);            TextManagement.WriteBlobText(RRef, FieldNo(Reason), ReasonText);            RRef.SetTable(Rec);        end;    end;    internal procedure DeleteUsageDataBillingLines()    var        UsageDataSupplier: Record "Usage Data Supplier";        UsageDataProcessing: Interface "Usage Data Processing";    begin        OnDeleteUsageDataBillingLines();        if UsageDataSupplier.Get("Supplier No.") then begin            UsageDataProcessing := UsageDataSupplier.Type;            UsageDataProcessing.DeleteImportedData(Rec);        end;        CheckAndDeleteUsageDataBilling();        Rec."Processing Status" := "Processing Status"::None;        Rec."Processing Step" := "Processing Step"::None;        Rec.SetReason('');        Rec.Modify(false);    end;    local procedure CheckAndDeleteUsageDataBilling()    var        UsageDataBilling: Record "Usage Data Billing";    begin        UsageDataBilling.SetRange("Usage Data Import Entry No.", Rec."Entry No.");        UsageDataBilling.SetFilter("Document No.", '<>%1', '');        if not UsageDataBilling.IsEmpty() then            Error(UsageDataBillingWithInvoiceErr);        UsageDataBilling.SetRange("Document No.");        if not UsageDataBilling.IsEmpty() then            UsageDataBilling.DeleteAll(true);    end;    internal procedure SetErrorReason(ErrorText: Text)    begin        Rec.Validate("Processing Status", Enum::"Processing Status"::Error);        Rec.SetReason(ErrorText);    end;    internal procedure UpdateProcessingStatus()    var        UsageDataSupplier: Record "Usage Data Supplier";        UsageDataProcessing: Interface "Usage Data Processing";    begin        UsageDataSupplier.Get(Rec."Supplier No.");        UsageDataProcessing := UsageDataSupplier.Type;        UsageDataProcessing.UpdateImportStatus(Rec);        if Rec."Processing Status" = Enum::"Processing Status"::Error then            exit;        if UsageDataBillingHasErrors() then            Rec.SetErrorReason(UsageDataLinesProcessingErr)        else            Rec.Validate("Processing Status", Enum::"Processing Status"::Ok);        Rec.Modify(false);    end;    local procedure UsageDataBillingHasErrors(): Boolean    var        UsageDataBilling: Record "Usage Data Billing";    begin        UsageDataBilling.SetRange("Usage Data Import Entry No.", Rec."Entry No.");        UsageDataBilling.SetRange("Processing Status", Enum::"Processing Status"::Error);        exit(not UsageDataBilling.IsEmpty());    end;    internal procedure ShowReason()    var        TextManagement: Codeunit "Text Management";        RRef: RecordRef;    begin        CalcFields(Reason);        RRef.GetTable(Rec);        TextManagement.ShowFieldText(RRef, FieldNo(Reason));    end;    internal procedure NewDataImport()    var        SupplierNo: Code[20];    begin        SupplierNo := CopyStr(Rec.GetFilter("Supplier No."), 1, MaxStrLen(SupplierNo));        Rec.Init();        Rec."Entry No." := 0;        if SupplierNo <> '' then            Rec.Validate("Supplier No.", SupplierNo);        Rec.Insert(true);    end;    internal procedure ImportFile()    var        UsageDataBlob: Record "Usage Data Blob";        FileName: Text;        InStream: InStream;    begin        FileName := '';        UploadIntoStream(UsageDataLbl, '', FileManagement.GetToFilterText('CSV files (*.csv)|*.csv|Txt files (*.txt)|*.txt', UsageDataLbl), FileName, InStream);        if FileName = '' then            exit;        if "Entry No." <> 0 then begin            UsageDataBlob.InsertFromUsageDataImport(Rec);            UsageDataBlob.ImportFromFile(InStream, FileName);            Rec.Validate("Processing Status", Rec."Processing Status"::None);            Rec.Modify(false);            Clear(FileName);        end;    end;    internal procedure ProcessUsageDataImport(var UsageDataImport: Record "Usage Data Import"; ProcessingStep: Enum "Processing Step")    var        UsageDataImport2: Record "Usage Data Import";    begin        if UsageDataImport.FindSet(true) then            repeat                if UsageDataImport."Processing Status" = UsageDataImport."Processing Status"::Closed then                    UsageDataImport.FieldError("Processing Status");                UsageDataImport2 := UsageDataImport;                UsageDataImport2."Processing Step" := ProcessingStep;                UsageDataImport2.Modify(false);                Commit();                UsageDataImport2.SetRecFilter();                OnBeforeProcessUsageDataImport(UsageDataImport2, ProcessingStep);                case ProcessingStep of                    "Processing Step"::"Create Imported Lines", "Processing Step"::"Process Imported Lines":                        Codeunit.Run(Codeunit::"Process Usage Data Import", UsageDataImport2);                    "Processing Step"::"Create Usage Data Billing":                        Codeunit.Run(Codeunit::"Create Usage Data Billing", UsageDataImport2);                    "Processing Step"::"Process Usage Data Billing":                        Codeunit.Run(Codeunit::"Process Usage Data Billing", UsageDataImport2);                end;                OnAfterProcessUsageDataImport(UsageDataImport2, ProcessingStep);            until UsageDataImport.Next() = 0;    end;    internal procedure CloseUsageDataImports(var UsageDataImport: Record "Usage Data Import")    begin        if UsageDataImport.FindSet(true) then            repeat                if UsageDataImport."Processing Status" <> Enum::"Processing Status"::Closed then                    UsageDataImport.SetStatus(Enum::"Processing Status"::Closed);            until UsageDataImport.Next() = 0;    end;    internal procedure ReopenUsageDataImports(var UsageDataImport: Record "Usage Data Import")    begin        if UsageDataImport.FindSet(true) then            repeat                if UsageDataImport."Processing Status" = Enum::"Processing Status"::Closed then                    UsageDataImport.UpdateProcessingStatus();            until UsageDataImport.Next() = 0;    end;    internal procedure CollectCustomerContractsAndCreateInvoices(var UsageDataImport: Record "Usage Data Import")    var        CustomerContractFilter: Text;        CustomerContractLineFilter: Text;    begin        UsageDataImport.SetFilter("Processing Status", '<>%1', UsageDataImport."Processing Status"::Error);        if UsageDataImport.FindSet() then            repeat                CollectCustomerContractsAndContractLines(UsageDataImport, CustomerContractFilter, CustomerContractLineFilter);            until UsageDataImport.Next() = 0;        CreateCustomerInvoices(CustomerContractFilter, CustomerContractLineFilter);    end;    internal procedure CollectVendorContractsAndCreateInvoices(var UsageDataImport: Record "Usage Data Import")    var        VendorContractFilter: Text;        VendorContractLineFilter: Text;    begin        UsageDataImport.SetFilter("Processing Status", '<>%1', UsageDataImport."Processing Status"::Error);        if UsageDataImport.FindSet() then            repeat                CollectVendorContractsAndContractLines(UsageDataImport, VendorContractFilter, VendorContractLineFilter);            until UsageDataImport.Next() = 0;        CreateVendorInvoices(VendorContractFilter, VendorContractLineFilter);    end;    local procedure CollectCustomerContractsAndContractLines(UsageDataImport: Record "Usage Data Import"; var CustomerContractFilter: Text; var CustomerContractLineFilter: Text)    var        UsageDataBilling: Record "Usage Data Billing";        TextManagement: Codeunit "Text Management";    begin        UsageDataBilling.SetRange("Usage Data Import Entry No.", UsageDataImport."Entry No.");        UsageDataBilling.SetRange(Partner, "Service Partner"::Customer);        UsageDataBilling.SetRange("Document No.", '');        if UsageDataBilling.FindSet() then            repeat                if UsageDataBilling."Subscription Contract No." <> '' then                    TextManagement.AppendText(CustomerContractFilter, Format(UsageDataBilling."Subscription Contract No."), '|');                TextManagement.AppendText(CustomerContractLineFilter, Format(UsageDataBilling."Subscription Contract Line No."), '|');            until UsageDataBilling.Next() = 0;    end;    local procedure CollectVendorContractsAndContractLines(UsageDataImport: Record "Usage Data Import"; var VendorContractFilter: Text; var VendorContractLineFilter: Text)    var        UsageDataBilling: Record "Usage Data Billing";        TextManagement: Codeunit "Text Management";    begin        UsageDataBilling.SetRange("Usage Data Import Entry No.", UsageDataImport."Entry No.");        UsageDataBilling.SetRange(Partner, "Service Partner"::Vendor);        UsageDataBilling.SetRange("Document No.", '');        if UsageDataBilling.FindSet() then            repeat                if UsageDataBilling."Subscription Contract No." <> '' then                    TextManagement.AppendText(VendorContractFilter, Format(UsageDataBilling."Subscription Contract No."), '|');                TextManagement.AppendText(VendorContractLineFilter, Format(UsageDataBilling."Subscription Contract Line No."), '|');            until UsageDataBilling.Next() = 0;    end;    local procedure CreateCustomerInvoices(CustomerContractFilter: Text; CustomerContractLineFilter: Text)    var        UsageBasedContrSubscribers: Codeunit "Usage Based Contr. Subscribers";    begin        if CustomerContractFilter = '' then            exit;        UsageBasedContrSubscribers.CreateContractInvoicesFromUsageDataImport(Enum::"Service Partner"::Customer, CustomerContractFilter, CustomerContractLineFilter, '');    end;    local procedure CreateVendorInvoices(VendorContractFilter: Text; VendorContractLineFilter: Text)    var        UsageBasedContrSubscribers: Codeunit "Usage Based Contr. Subscribers";    begin        if VendorContractFilter = '' then            exit;        UsageBasedContrSubscribers.CreateContractInvoicesFromUsageDataImport(Enum::"Service Partner"::Vendor, VendorContractFilter, VendorContractLineFilter, '');    end;    internal procedure ShowRelatedDocuments(var UsageDataImport: Record "Usage Data Import"; ServicePartner: Enum "Service Partner"; DocumentType: Option Contract,"Contract Invoices","Posted Contract Invoices")    var        UsageBasedBilling: Record "Usage Data Billing";    begin        if UsageDataImport.Count <> 1 then            Error(OnlyOneRecordCanBeSelectedErr);        if UsageDataImport.FindSet() then            UsageBasedBilling.SetRange("Usage Data Import Entry No.", UsageDataImport."Entry No.");        if UsageBasedBilling.Count = 0 then            Error(UsageBasedBillingDoesNotExistsErr);        UsageBasedBilling.ShowRelatedDocuments(UsageBasedBilling, DocumentType, ServicePartner);    end;    [IntegrationEvent(false, false)]    local procedure OnDeleteUsageDataBillingLines()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeProcessUsageDataImport(var UsageDataImport: Record "Usage Data Import"; ProcessingStep: Enum "Processing Step")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterProcessUsageDataImport(var UsageDataImport: Record "Usage Data Import"; ProcessingStep: Enum "Processing Step")    begin    end;    var        FileManagement: Codeunit "File Management";        UsageDataLbl: Label 'Import Usage Data';        UsageDataBillingWithInvoiceErr: Label 'There are Usage Data Billings which are already in an Invoice.';        OnlyOneRecordCanBeSelectedErr: Label 'You must choose one record.';        UsageBasedBillingDoesNotExistsErr: Label 'Usage Based Billing does not exist.';        UsageDataLinesProcessingErr: Label 'Errors were detected when processing the usage data lines.';}