Table 8018 Usage Data Generic Import

Subscription Billing, Microsoft.SubscriptionBilling

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

namespace Microsoft.SubscriptionBilling;using Microsoft.Finance.GeneralLedger.Setup;using System.IO;table 8018 "Usage Data Generic Import"{    Caption = 'Usage Data Generic Import';    DataClassification = CustomerContent;    LookupPageId = "Usage Data Generic Import";    DrillDownPageId = "Usage Data Generic Import";    fields    {        field(1; "Entry No."; Integer)        {            AutoIncrement = true;            Caption = 'Entry No.';        }        field(2; "Usage Data Import Entry No."; Integer)        {            Caption = 'Usage Data Import Entry No.';            TableRelation = "Usage Data Import";        }        field(3; "Processing Status"; Enum "Processing Status")        {            Caption = 'Processing Status';            Editable = false;            trigger OnValidate()            begin                if "Processing Status" = "Processing Status"::None then                    SetReason('');            end;        }        field(4; "Reason Preview"; Text[80])        {            Caption = 'Reason';            Editable = false;            trigger OnLookup()            begin                ShowReason();            end;        }        field(5; Reason; Blob)        {            Caption = 'Reason';            Compressed = false;        }        field(6; "Subscription Header No."; Code[20])        {            Caption = 'Subscription No.';            TableRelation = "Subscription Header";            Editable = false;        }        field(7; "Customer ID"; Text[80])        {            Caption = 'Customer ID';            TableRelation = "Usage Data Supplier Reference"."Supplier Reference";            ValidateTableRelation = false;            trigger OnLookup()            var                UsageDataImport: Record "Usage Data Import";                UsageDataSupplierReference: Record "Usage Data Supplier Reference";                UsageDataSupplier: Record "Usage Data Supplier";            begin                UsageDataImport.SetRange("Entry No.", "Usage Data Import Entry No.");                if UsageDataImport.FindFirst() then                    if UsageDataSupplier.Get(UsageDataImport."Supplier No.") then begin                        UsageDataSupplierReference.SetRange(Type, UsageDataSupplierReference.Type::Customer);                        UsageDataSupplierReference.SetRange("Supplier No.", UsageDataSupplier."No.");                        if Page.RunModal(0, UsageDataSupplierReference) = Action::LookupOK then                            Validate("Customer ID", UsageDataSupplierReference."Supplier Reference");                    end;            end;            trigger OnValidate()            var                UsageDataImport: Record "Usage Data Import";                UsageDataCustomer: Record "Usage Data Supp. Customer";            begin                if "Customer ID" = '' then                    exit;                if UsageDataImport.Get("Usage Data Import Entry No.") then begin                    UsageDataCustomer.SetRange("Supplier No.", UsageDataImport."Supplier No.");                    UsageDataCustomer.SetRange("Supplier Reference", "Customer ID");                    if UsageDataCustomer.FindFirst() then                        "Customer Name" := UsageDataCustomer."Customer Name";                end;            end;        }        field(8; "Customer Name"; Text[250])        {            Caption = 'Customer Name';            trigger OnLookup()            var                UsageDataImport: Record "Usage Data Import";                UsageDataCustomer: Record "Usage Data Supp. Customer";            begin                UsageDataImport.Get("Usage Data Import Entry No.");                UsageDataCustomer.SetRange("Supplier No.", UsageDataImport."Supplier No.");                if Page.RunModal(0, UsageDataCustomer) = Action::LookupOK then                    Validate("Customer ID", UsageDataCustomer."Supplier Reference");            end;            trigger OnValidate()            var                UsageDataCustomer: Record "Usage Data Supp. Customer";                UsageDataImport: Record "Usage Data Import";            begin                if "Customer Name" = '' then begin                    Validate("Customer ID", '');                    exit;                end;                UsageDataImport.Get("Usage Data Import Entry No.");                UsageDataCustomer.SetRange("Supplier No.", UsageDataImport."Supplier No.");                UsageDataCustomer.SetFilter("Customer Name", '%1', '@' + Rec."Customer Name" + '*');                if UsageDataCustomer.FindFirst() then                    Validate("Customer ID", UsageDataCustomer."Supplier Reference");            end;        }        field(9; "Invoice ID"; Text[36])        {            Caption = 'Invoice ID';        }        field(10; "Supp. Subscription ID"; Text[80])        {            Caption = 'Supplier Subscription Id';            trigger OnLookup()            var                UsageDataImport: Record "Usage Data Import";                UsageDataSubscription: Record "Usage Data Supp. Subscription";            begin                UsageDataImport.Get("Usage Data Import Entry No.");                UsageDataSubscription.SetRange("Supplier No.", UsageDataImport."Supplier No.");                if Page.RunModal(0, UsageDataSubscription) = Action::LookupOK then                    Validate("Supp. Subscription ID", UsageDataSubscription."Supplier Reference");            end;            trigger OnValidate()            var                UsageDataImport: Record "Usage Data Import";                UsageDataSubscription: Record "Usage Data Supp. Subscription";            begin                if "Supp. Subscription ID" = '' then                    exit;                if UsageDataImport.Get("Usage Data Import Entry No.") then                    if UsageDataSubscription.FindForSupplierReference(UsageDataImport."Supplier No.", "Supp. Subscription ID") then begin                        if Rec."Supp. Subscription Name" = '' then                            Rec."Supp. Subscription Name" := UsageDataSubscription."Customer Name";                        if Rec."Product ID" = '' then                            Rec."Product ID" := UsageDataSubscription."Product ID";                        if Rec."Product Name" = '' then                            Rec."Product Name" := UsageDataSubscription."Product Name";                        if (Rec.Quantity = 0) and (CurrFieldNo <> 0) then                            Rec.Quantity := UsageDataSubscription.Quantity;                    end;            end;        }        field(11; "Supp. Subscription Name"; Text[250])        {            Caption = 'Supplier Subscription Name';            trigger OnLookup()            var                UsageDataImport: Record "Usage Data Import";                UsageDataSubscription: Record "Usage Data Supp. Subscription";            begin                UsageDataImport.Get("Usage Data Import Entry No.");                UsageDataSubscription.SetRange("Supplier No.", UsageDataImport."Supplier No.");                if Page.RunModal(0, UsageDataSubscription) = Action::LookupOK then                    Validate("Supp. Subscription ID", UsageDataSubscription."Supplier Reference");            end;        }        field(12; "Supp. Subscription Description"; Text[250])        {            Caption = 'Supplier Subscription Description';        }        field(13; "Supp. Subscription Start Date"; Date)        {            Caption = 'Supplier Subscription Start Date';        }        field(14; "Supp. Subscription End Date"; Date)        {            Caption = 'Supplier Subscription End Date';        }        field(15; "Billing Period Start Date"; Date)        {            Caption = 'Billing Period Start Date';        }        field(16; "Billing Period End Date"; Date)        {            Caption = 'Billing Period End Date';        }        field(17; "Product ID"; Text[80])        {            Caption = 'Product Id';        }        field(18; "Product Name"; Text[100])        {            Caption = 'Product Name';        }        field(19; Cost; Decimal)        {            AutoFormatType = 2;            AutoFormatExpression = GetCurrencyCode();            Caption = 'Unit Cost';        }        field(20; Price; Decimal)        {            AutoFormatType = 2;            AutoFormatExpression = GetCurrencyCode();            Caption = 'Unit Price';        }        field(21; Quantity; Decimal)        {            Caption = 'Quantity';            AutoFormatType = 0;            DecimalPlaces = 0 : 5;        }        field(22; Discount; Decimal)        {            Caption = 'Discount';            DecimalPlaces = 0 : 6;            AutoFormatType = 1;            AutoFormatExpression = GetCurrencyCode();        }        field(23; Tax; Decimal)        {            Caption = 'Tax';            DecimalPlaces = 0 : 6;            AutoFormatType = 1;            AutoFormatExpression = GetCurrencyCode();        }        field(24; Amount; Decimal)        {            Caption = 'Amount';            DecimalPlaces = 0 : 6;            AutoFormatType = 2;            AutoFormatExpression = GetCurrencyCode();        }        field(25; Currency; Text[10])        {            Caption = 'Currency';        }        field(26; Unit; Text[30])        {            Caption = 'Unit';        }        field(27; "Cost Amount"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = GetCurrencyCode();            Caption = 'Cost Amount';        }        field(30; "Service Object Availability"; Enum "Service Object Availability")        {            Caption = 'Subscription Availability';            Editable = false;        }        field(50; Text1; Text[80])        {            Caption = 'Text1';        }        field(51; Text2; Text[80])        {            Caption = 'Text2';        }        field(52; Text3; Text[80])        {            Caption = 'Text3';        }        field(53; Decimal1; Decimal)        {            Caption = 'Decimal1';            AutoFormatType = 0;        }        field(54; Decimal2; Decimal)        {            Caption = 'Decimal2';            AutoFormatType = 0;        }        field(55; Decimal3; Decimal)        {            Caption = 'Decimal3';            AutoFormatType = 0;        }        field(1220; "Data Exch. Entry No."; Integer)        {            Caption = 'Data Exch. Entry No.';            Editable = false;            TableRelation = "Data Exch.";        }    }    keys    {        key(PK; "Entry No.")        {            Clustered = true;        }        key(Key2; "Usage Data Import Entry No.", "Processing Status")        {        }    }    trigger OnInsert()    var        UsageDataImportEntryNo: Integer;    begin        if Evaluate(UsageDataImportEntryNo, GetFilter("Usage Data Import Entry No.")) then            "Usage Data Import Entry No." := UsageDataImportEntryNo;    end;    trigger OnModify()    begin        InitRecord();    end;    internal procedure InitFromUsageDataImport(UsageDataImport: Record "Usage Data Import")    begin        Init();        "Entry No." := 0;        "Usage Data Import Entry No." := UsageDataImport."Entry No.";    end;    local procedure InitRecord()    var        UsageDataSupplier: Record "Usage Data Supplier";        UsageDataImport: Record "Usage Data Import";        UsageDataCustomer: Record "Usage Data Supp. Customer";    begin        UsageDataImport.SetRange("Entry No.", "Usage Data Import Entry No.");        if UsageDataImport.FindFirst() then            if UsageDataSupplier.Get(UsageDataImport."Supplier No.") then                if ("Customer ID" = '') or ("Customer Name" = '') then begin                    UsageDataCustomer.Reset();                    UsageDataCustomer.SetRange("Supplier No.", UsageDataSupplier."No.");                    if UsageDataCustomer.FindFirst() then begin                        if "Customer ID" = '' then                            "Customer ID" := UsageDataCustomer."Supplier Reference";                        if "Customer Name" = '' then                            "Customer Name" := UsageDataCustomer."Customer Name";                    end;                end;    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 ShowReason()    var        TextManagement: Codeunit "Text Management";        RRef: RecordRef;    begin        CalcFields(Reason);        RRef.GetTable(Rec);        TextManagement.ShowFieldText(RRef, FieldNo(Reason));    end;    internal procedure GetCurrencyCode(): Code[10]    var        GLSetup: Record "General Ledger Setup";    begin        GLSetup.Get();        if UpperCase(Rec.Currency) <> GLSetup."LCY Code" then            exit(Rec.Currency);    end;    internal procedure GetNextEntryNo(): Integer    var        UsageDataGenericImport: Record "Usage Data Generic Import";    begin        if UsageDataGenericImport.FindLast() then;        exit(UsageDataGenericImport."Entry No." + 1);    end;}