Table 6220 Sustainability Cue
src/Apps/W1/Sustainability/app/src/RoleCenters/SustainabilityCue.Table.al287 lines, Copyright (c) Microsoft Corporation. MIT
namespace Microsoft.Sustainability.RoleCenters;using Microsoft.Assembly.Document;using Microsoft.EServices.EDocument;using Microsoft.Foundation.Task;using Microsoft.Inventory.Transfer;using Microsoft.Manufacturing.Document;using Microsoft.Purchases.Document;using Microsoft.Purchases.Payables;using Microsoft.Sales.Document;using Microsoft.Sales.Receivables;using Microsoft.Sustainability.Account;using Microsoft.Sustainability.Ledger;using Microsoft.Sustainability.Setup;using System.Automation;table 6220 "Sustainability Cue"{ Caption = 'Sustainability Cue'; DataClassification = CustomerContent; fields { field(1; "Primary Key"; Code[10]) { Caption = 'Primary Key'; }#pragma warning disable AA0232 field(2; "Emission CO2"; Decimal)#pragma warning restore AA0232 { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Emission CO2'; FieldClass = FlowField; CalcFormula = sum("Sustainability Ledger Entry"."Emission CO2" where("Posting Date" = field("Date Filter"), "Emission Scope" = field("Scope Filter"))); } field(3; "Emission CH4"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Emission CH4'; FieldClass = FlowField; CalcFormula = sum("Sustainability Ledger Entry"."Emission CH4" where("Posting Date" = field("Date Filter"), "Emission Scope" = field("Scope Filter"))); } field(4; "Emission N2O"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Emission N2O'; FieldClass = FlowField; CalcFormula = sum("Sustainability Ledger Entry"."Emission N2O" where("Posting Date" = field("Date Filter"), "Emission Scope" = field("Scope Filter"))); } field(6; "Ongoing Purchase Orders"; Integer) { Caption = 'Ongoing Purchase Orders'; FieldClass = FlowField; CalcFormula = count("Purchase Header" where("Document Type" = const(Order), "Sustainability Lines Exist" = const(true))); Editable = false; } field(7; "Ongoing Purchase Invoices"; Integer) { Caption = 'Ongoing Purchase Invoices'; FieldClass = FlowField; CalcFormula = count("Purchase Header" where("Document Type" = const(Invoice), "Sustainability Lines Exist" = const(true))); Editable = false; } field(8; "Purch. Invoices Due Next Week"; Integer) { CalcFormula = count("Vendor Ledger Entry" where("Document Type" = filter(Invoice | "Credit Memo"), "Due Date" = field("Due Next Week Filter"), Open = const(true))); Caption = 'Purch. Invoices Due Next Week'; Editable = false; FieldClass = FlowField; } field(9; "My Incoming Documents"; Integer) { CalcFormula = count("Incoming Document" where(Processed = const(false))); Caption = 'My Incoming Documents'; FieldClass = FlowField; } field(15; "Inc. Doc. Awaiting Verfication"; Integer) { CalcFormula = count("Incoming Document" where("OCR Status" = const("Awaiting Verification"))); Caption = 'Inc. Doc. Awaiting Verfication'; FieldClass = FlowField; } field(20; "Date Filter"; Date) { FieldClass = FlowFilter; Caption = 'Date Filter'; } field(21; "Due Next Week Filter"; Date) { Caption = 'Due Next Week Filter'; FieldClass = FlowFilter; } field(22; "Scope Filter"; Enum "Emission Scope") { Caption = 'Scope Filter'; FieldClass = FlowFilter; } field(23; "Water/Waste Int. Type Filter"; Enum "Water/Waste Intensity Type") { Caption = 'Water/Waste Intensity Type Filter'; FieldClass = FlowFilter; } field(24; "Water Type Filter"; Enum "Water Type") { Caption = 'Water Type Filter'; FieldClass = FlowFilter; } field(25; "User ID Filter"; Code[50]) { Caption = 'User ID Filter'; FieldClass = FlowFilter; } field(29; "Discharged Into Water"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Discharged Into Water'; FieldClass = FlowField; CalcFormula = sum("Sustainability Ledger Entry"."Discharged Into Water" where("Posting Date" = field("Date Filter"), "Water/Waste Intensity Type" = field("Water/Waste Int. Type Filter"), "Water Type" = field("Water Type Filter"))); } field(30; "Water Intensity"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Water Intensity'; FieldClass = FlowField; CalcFormula = sum("Sustainability Ledger Entry"."Water Intensity" where("Posting Date" = field("Date Filter"), "Water/Waste Intensity Type" = field("Water/Waste Int. Type Filter"), "Water Type" = field("Water Type Filter"))); } field(31; "Waste Intensity"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Waste Intensity'; FieldClass = FlowField; CalcFormula = sum("Sustainability Ledger Entry"."Waste Intensity" where("Posting Date" = field("Date Filter"), "Water/Waste Intensity Type" = field("Water/Waste Int. Type Filter"))); } field(32; "Ongoing Sales Orders"; Integer) { Caption = 'Ongoing Sales Orders'; FieldClass = FlowField; CalcFormula = count("Sales Header" where("Document Type" = const(Order), "Sustainability Lines Exist" = const(true))); Editable = false; } field(33; "Ongoing Sales Invoices"; Integer) { Caption = 'Ongoing Sales Invoices'; FieldClass = FlowField; CalcFormula = count("Sales Header" where("Document Type" = const(Invoice), "Sustainability Lines Exist" = const(true))); Editable = false; } field(34; "Sales Invoices Due Next Week"; Integer) { CalcFormula = count("Cust. Ledger Entry" where("Document Type" = filter(Invoice | "Credit Memo"), "Due Date" = field("Due Next Week Filter"), Open = const(true))); Caption = 'Sales Invoices Due Next Week'; Editable = false; FieldClass = FlowField; } field(35; "Released Prod. Orders"; Integer) { Caption = 'Released Prod. Orders'; FieldClass = FlowField; Editable = false; CalcFormula = count("Production Order" where(Status = const(Released), "Creation Date" = field("Date Filter"), "Sustainability Lines Exist" = const(true))); } field(36; "Assembly Orders"; Integer) { Caption = 'Assembly Orders'; FieldClass = FlowField; Editable = false; CalcFormula = count("Assembly Header" where("Document Type" = const(order), "Posting Date" = field("Date Filter"), "Sust. Account No." = filter('<>'''''))); } field(37; "Ongoing Transfer Orders"; Integer) { Caption = 'Ongoing Transfer Orders'; FieldClass = FlowField; CalcFormula = count("Transfer Header" where("Sustainability Lines Exist" = const(true))); Editable = false; } field(38; "Requests to Approve"; Integer) { CalcFormula = count("Approval Entry" where("Approver ID" = field("User ID Filter"), Status = filter(Open))); Caption = 'Requests to Approve'; FieldClass = FlowField; } field(39; "Requests Sent for Approval"; Integer) { CalcFormula = count("Approval Entry" where("Sender ID" = field("User ID Filter"), Status = filter(Open))); Caption = 'Requests Sent for Approval'; FieldClass = FlowField; } field(40; "Pending User Tasks"; Integer) { Caption = 'Pending User Tasks'; } field(41; "Tasks This Month"; Integer) { Caption = 'Tasks This Month'; } field(42; "Overdue User Tasks"; Integer) { Caption = 'Overdue User Tasks'; } field(43; "CO2e Emission"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'CO2e Emission'; FieldClass = FlowField; CalcFormula = sum("Sustainability Ledger Entry"."CO2e Emission" where("Posting Date" = field("Date Filter"))); } field(44; "DateTime Filter"; DateTime) { FieldClass = FlowFilter; Caption = 'DateTime Filter'; } } keys { key(Key1; "Primary Key") { Clustered = true; } } var SustainabilitySetup: Record "Sustainability Setup"; internal procedure GetMyPendingUserTasksThisMonthCount(): Integer var UserTask: Record "User Task"; UserTaskManagement: Codeunit "User Task Management"; begin UserTask.Reset(); UserTaskManagement.SetFiltersToShowMyUserTasks(UserTask, 0); UserTask.SetFilter("Due DateTime", Rec.GetFilter("DateTime Filter")); exit(UserTask.Count); end; internal procedure ShowMyPendingUserTasksThisMonthCount(): Integer var UserTask: Record "User Task"; UserTaskManagement: Codeunit "User Task Management"; UserTaskList: Page "User Task List"; begin UserTask.Reset(); UserTaskManagement.SetFiltersToShowMyUserTasks(UserTask, 0); UserTask.SetFilter("Due DateTime", Rec.GetFilter("DateTime Filter")); UserTaskList.SetTableView(UserTask); UserTaskList.Run(); end; internal procedure GetMyOverDueUserTasksCount(): Integer var UserTask: Record "User Task"; UserTaskManagement: Codeunit "User Task Management"; begin UserTask.Reset(); UserTaskManagement.SetFiltersToShowMyUserTasks(UserTask, 0); UserTask.SetFilter("Due DateTime", '<>%1 & <%2', 0DT, CreateDateTime(WorkDate(), 0T)); exit(UserTask.Count); end; internal procedure ShowMyPendingUserTasksOverDueCount(): Integer var UserTask: Record "User Task"; UserTaskManagement: Codeunit "User Task Management"; UserTaskList: Page "User Task List"; begin UserTask.Reset(); UserTaskManagement.SetFiltersToShowMyUserTasks(UserTask, 0); UserTask.SetFilter("Due DateTime", '<>%1 & <%2', 0DT, CreateDateTime(WorkDate(), 0T)); UserTaskList.SetTableView(UserTask); UserTaskList.Run(); end;}