Table 8015 Usage Data Supplier Reference

Subscription Billing, Microsoft.SubscriptionBilling

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

namespace Microsoft.SubscriptionBilling;table 8015 "Usage Data Supplier Reference"{    Caption = 'Usage Data Supplier Reference';    DataClassification = CustomerContent;    LookupPageId = "Usage Data Supp. References";    DrillDownPageId = "Usage Data Supp. References";    fields    {        field(1; "Entry No."; Integer)        {            AutoIncrement = true;            Caption = 'Entry No.';        }        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; "Type"; Enum "Usage Data Reference Type")        {            Caption = 'Type';        }        field(5; "Supplier Reference"; Text[80])        {            Caption = 'Supplier Reference';            trigger OnValidate()            begin                "Supplier Reference" := LowerCase("Supplier Reference");            end;        }    }    keys    {        key(PK; "Entry No.")        {            Clustered = true;        }        key(Key2; "Supplier No.", "Supplier Reference", Type)        {        }    }    fieldgroups    {        fieldgroup(DropDown; "Entry No.", "Supplier No.", "Supplier Description", "Supplier Reference", Type)        {        }    }    internal procedure CreateSupplierReference(SupplierNo: Code[20]; SupplierReference: Text[80]; ReferenceType: Enum "Usage Data Reference Type")    begin        if Rec.FindSupplierReference(SupplierNo, SupplierReference, ReferenceType) then begin            Rec.Reset();            exit;        end;        Rec."Entry No." := 0;        Rec."Supplier No." := SupplierNo;        Rec.Validate("Supplier Reference", SupplierReference);        Rec.Type := ReferenceType;        Rec.Insert(false);        Rec.Reset();    end;    internal procedure FindSupplierReference(SupplierNo: Code[20]; SupplierReference: Text[80]; ReferenceType: Enum "Usage Data Reference Type"): Boolean    begin        Rec.FilterUsageDataSupplierReference(SupplierNo, SupplierReference, ReferenceType);        exit(Rec.FindFirst());    end;    internal procedure FilterUsageDataSupplierReference(SupplierNo: Code[20]; SupplierReference: Text[80]; ReferenceType: Enum "Usage Data Reference Type")    begin        Rec.SetCurrentKey("Supplier No.", "Supplier Reference", Type);        Rec.SetRange("Supplier No.", SupplierNo);        Rec.SetRange("Supplier Reference", LowerCase(SupplierReference));        Rec.SetRange(Type, ReferenceType);    end;}