Table 8012 Usage Data Supp. Customer
src/Apps/W1/Subscription Billing/App/Usage Based Billing/Tables/UsageDataSuppCustomer.Table.al143 lines, Copyright (c) Microsoft Corporation. MIT
namespace Microsoft.SubscriptionBilling;using Microsoft.Sales.Customer;using System.Globalization;table 8012 "Usage Data Supp. Customer"{ Caption = 'Usage Data Supplier Customer'; DataClassification = CustomerContent; LookupPageId = "Usage Data Customers"; DrillDownPageId = "Usage Data Customers"; 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; "Customer No."; Code[20]) { Caption = 'Customer No.'; TableRelation = Customer; trigger OnValidate() var UsageDataSupplierReference: Record "Usage Data Supplier Reference"; UsageDataSubscription: Record "Usage Data Supp. Subscription"; begin if "Customer No." <> '' then if "Supplier Reference" <> '' then begin UsageDataSupplierReference.CreateSupplierReference("Supplier No.", "Supplier Reference", "Usage Data Reference Type"::Customer); UsageDataSubscription.SetRange("Supplier No.", Rec."Supplier No."); UsageDataSubscription.SetRange("Customer Id", Rec."Supplier Reference"); if not UsageDataSubscription.IsEmpty() then if Confirm(StrSubstNo(UpdateUsageDataSubscriptionQst, Rec.FieldCaption("Customer No."), UsageDataSubscription.TableCaption), true) then UsageDataSubscription.ModifyAll("Customer No.", "Customer No."); end; end; } field(5; "Customer Name"; Text[100]) { Caption = 'Customer Name'; FieldClass = FlowField; CalcFormula = lookup(Customer.Name where("No." = field("Customer No."))); Editable = false; } field(6; "E-mail"; Text[80]) { Caption = 'E-mail'; } field(7; Domain; Text[80]) { Caption = 'Domain'; } field(8; Culture; Text[20]) { Caption = 'Culture'; trigger OnLookup() var Language: Record Language; LanguageCU: Codeunit Language; DotNet_CultureInfo: Codeunit DotNet_CultureInfo; begin if Culture <> '' then begin DotNet_CultureInfo.GetCultureInfoByName(Culture); Language.Get(DotNet_CultureInfo.ThreeLetterWindowsLanguageName()); end; if Page.RunModal(0, Language) = Action::LookupOK then Rec.Validate(Culture, LanguageCU.GetCultureName(Language."Windows Language ID")); end; } field(9; "Supplier Reference Entry No."; Integer) { Caption = 'Supplier Reference Entry No.'; TableRelation = "Usage Data Supplier Reference"; trigger OnValidate() var UsageDataSupplierReference: Record "Usage Data Supplier Reference"; begin if "Supplier Reference Entry No." = 0 then exit; UsageDataSupplierReference.Get("Supplier Reference Entry No."); "Supplier Reference" := UsageDataSupplierReference."Supplier Reference"; end; } field(10; "Supplier Reference"; Text[80]) { Caption = 'Supplier Reference'; trigger OnValidate() var UsageDataSupplierReference: Record "Usage Data Supplier Reference"; begin if "Supplier Reference" = '' then exit; UsageDataSupplierReference.FindSupplierReference("Supplier No.", "Supplier Reference", UsageDataSupplierReference.Type::Customer); "Supplier Reference Entry No." := UsageDataSupplierReference."Entry No."; end; } field(11; "Tenant ID"; Text[36]) { Caption = 'Tenant ID'; } field(12; "Customer ID"; Text[80]) { Caption = 'Customer ID'; } field(13; "Customer Description"; Text[100]) { Caption = 'Customer Description'; } field(14; "Processing Status"; Enum "Processing Status") { Caption = 'Processing Status'; Editable = false; } } keys { key(PK; "Entry No.") { Clustered = true; } } var UpdateUsageDataSubscriptionQst: Label 'Do you want to update %1 in %2?', Comment = '%1 = Customer No., %2 = Table Caption';}