Table 8070 Subscription Billing Cue
src/Apps/W1/Subscription Billing/App/Base/Tables/SubscriptionBillingCue.Table.al169 lines, Copyright (c) Microsoft Corporation. MIT
namespace Microsoft.SubscriptionBilling;using Microsoft.Projects.Project.Job;using Microsoft.Purchases.Document;using Microsoft.Sales.Document;using System.Reflection;table 8070 "Subscription Billing Cue"{ Caption = 'Subscription Billing Activities Cue'; fields { field(1; "Primary Key"; Code[10]) { DataClassification = CustomerContent; Caption = 'Primary Key'; } field(2; "Cust. Sub. Contr. Invoices"; Integer) { CalcFormula = count("Sales Header" where("Document Type" = filter(Invoice), "Recurring Billing" = filter(true))); Caption = 'Customer Subscription Contract Invoices'; Editable = false; FieldClass = FlowField; } field(3; "Cust. Sub. Contr. Credit Memos"; Integer) { CalcFormula = count("Sales Header" where("Document Type" = filter("Credit Memo"), "Recurring Billing" = filter(true))); Caption = 'Customer Subscription Contract Credit Memos'; Editable = false; FieldClass = FlowField; } field(4; "Vend. Sub. Contr. Invoices"; Integer) { CalcFormula = count("Purchase Header" where("Document Type" = filter(Invoice), "Recurring Billing" = filter(true))); Caption = 'Vendor Subscription Contract Invoices'; Editable = false; FieldClass = FlowField; } field(5; "Vend. Contr. Credit Memos"; Integer) { CalcFormula = count("Purchase Header" where("Document Type" = filter("Credit Memo"), "Recurring Billing" = filter(true))); Caption = 'Vendor Subscription Contract Credit Memos'; Editable = false; FieldClass = FlowField; } field(6; "Sub. L. wo Cust. Sub. Contract"; Integer) { CalcFormula = count("Subscription Line" where("Invoicing via" = filter(Contract), "Subscription Contract No." = filter(''), Partner = filter(Customer))); Caption = 'Subscription Lines wo Customer Subscription Contract'; Editable = false; FieldClass = FlowField; } field(7; "Sub. L. wo Vend. Sub. Contract"; Integer) { CalcFormula = count("Subscription Line" where("Invoicing via" = filter(Contract), "Subscription Contract No." = filter(''), Partner = filter(Vendor))); Caption = 'Subscription Lines wo Vendor Subscription Contract'; Editable = false; FieldClass = FlowField; } field(8; "Jobs Over Budget"; Integer) { CalcFormula = count(Job where("Over Budget" = filter(= true))); Caption = 'Projects Over Budget'; Editable = false; FieldClass = FlowField; } field(9; "Revenue current Month"; Decimal) { AutoFormatExpression = GetAmountFormat(); AutoFormatType = 11; Caption = 'Revenue Current Month'; FieldClass = Normal; DataClassification = CustomerContent; } field(10; "Cost current Month"; Decimal) { AutoFormatExpression = GetAmountFormat(); AutoFormatType = 11; Caption = 'Cost Current Month'; FieldClass = Normal; DataClassification = CustomerContent; } field(11; "Revenue previous Month"; Decimal) { AutoFormatExpression = GetAmountFormat(); AutoFormatType = 11; Caption = 'Revenue Previous Month'; FieldClass = Normal; DataClassification = CustomerContent; } field(12; "Cost previous Month"; Decimal) { AutoFormatExpression = GetAmountFormat(); AutoFormatType = 11; Caption = 'Cost Previous Month'; FieldClass = Normal; DataClassification = CustomerContent; } field(13; "Last Updated On"; DateTime) { Caption = 'Last Updated On'; Editable = false; DataClassification = SystemMetadata; } field(20; "Date Filter"; Date) { Caption = 'Date Filter'; Editable = false; FieldClass = FlowFilter; }#if not CLEANSCHEMA30 field(21; "Job No. Filter"; Code[20]) { Caption = 'Date Filter'; Editable = false; FieldClass = FlowFilter; ObsoleteReason = 'Removed as projects are not relevant in context of Subscription Billing';#if not CLEAN27 ObsoleteState = Pending; ObsoleteTag = '28.0';#else ObsoleteState = Removed; ObsoleteTag = '31.0';#endif }#endif field(22; Overdue; Integer) { Caption = 'Overdue'; Editable = false; DataClassification = CustomerContent; } field(23; "Not Invoiced"; Integer) { CalcFormula = count("Billing Line" where("Document No." = filter(''))); Caption = 'Not invoiced'; Editable = false; FieldClass = FlowField; } field(30; "Errors Automated Billing"; Integer) { CalcFormula = count("Contract Billing Err. Log"); Caption = 'Errors Automated Contract Billing'; ToolTip = 'Specifies the number of errors that occurred during the automated contract billing process.'; Editable = false; FieldClass = FlowField; } } keys { key(SK1; "Primary Key") { Clustered = true; } } local procedure GetAmountFormat(): Text var TypeHelper: Codeunit "Type Helper"; begin exit(TypeHelper.GetAmountFormatLCYWithUserLocale()); end;}