Table 454 Approval Entry
src/Layers/W1/BaseApp/OtherCapabilities/Approvals/ApprovalEntry.Table.al499 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace System.Automation;using Microsoft.CRM.Team;using Microsoft.Finance.Currency;using Microsoft.Purchases.Document;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using Microsoft.Utilities;using System.Environment.Configuration;using System.Reflection;using System.Security.AccessControl;using System.Security.User;table 454 "Approval Entry"{ Caption = 'Approval Entry'; ReplicateData = true; DataClassification = CustomerContent; fields { field(1; "Table ID"; Integer) { Caption = 'Table ID'; } field(2; "Document Type"; Enum "Approval Document Type") { Caption = 'Document Type'; } field(3; "Document No."; Code[20]) { Caption = 'Document No.'; } field(4; "Sequence No."; Integer) { Caption = 'Sequence No.'; } field(5; "Approval Code"; Code[20]) { Caption = 'Approval Code'; } field(6; "Sender ID"; Code[50]) { Caption = 'Sender ID'; DataClassification = EndUserIdentifiableInformation; TableRelation = User."User Name"; } field(7; "Salespers./Purch. Code"; Code[20]) { Caption = 'Salespers./Purch. Code'; } field(8; "Approver ID"; Code[50]) { Caption = 'Approver ID'; DataClassification = EndUserIdentifiableInformation; TableRelation = User."User Name"; } field(9; Status; Enum "Approval Status") { Caption = 'Status'; trigger OnValidate() begin if (xRec.Status = Status::Created) and (Status = Status::Open) then "Date-Time Sent for Approval" := CreateDateTime(Today, Time); if not (Status in [Status::Created, Status::Open]) then DeleteWorkflowEventQueue(); end; } field(10; "Date-Time Sent for Approval"; DateTime) { Caption = 'Date-Time Sent for Approval'; } field(11; "Last Date-Time Modified"; DateTime) { Caption = 'Last Date-Time Modified'; } field(12; "Last Modified By User ID"; Code[50]) { Caption = 'Last Modified By User ID'; DataClassification = EndUserIdentifiableInformation; TableRelation = User."User Name"; } field(13; Comment; Boolean) { CalcFormula = exist("Approval Comment Line" where("Table ID" = field("Table ID"), "Record ID to Approve" = field("Record ID to Approve"), "Workflow Step Instance ID" = field("Workflow Step Instance ID"))); Caption = 'Comment'; Editable = false; FieldClass = FlowField; } field(14; "Due Date"; Date) { Caption = 'Approval Due Date'; } field(15; Amount; Decimal) { AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 1; Caption = 'Amount'; } field(16; "Amount (LCY)"; Decimal) { AutoFormatType = 1; AutoFormatExpression = ''; Caption = 'Amount (LCY)'; } field(17; "Currency Code"; Code[10]) { Caption = 'Currency Code'; TableRelation = Currency; } field(18; "Approval Type"; Enum "Workflow Approval Type") { Caption = 'Approval Type'; } field(19; "Limit Type"; Enum "Workflow Approval Limit Type") { Caption = 'Limit Type'; } field(20; "Available Credit Limit (LCY)"; Decimal) { Caption = 'Available Credit Limit (LCY)'; AutoFormatType = 1; AutoFormatExpression = ''; } field(21; "Pending Approvals"; Integer) { CalcFormula = count("Approval Entry" where("Record ID to Approve" = field("Record ID to Approve"), Status = filter(Created | Open), "Workflow Step Instance ID" = field("Workflow Step Instance ID"))); Caption = 'Pending Approvals'; FieldClass = FlowField; } field(22; "Record ID to Approve"; RecordID) { Caption = 'Record ID to Approve'; DataClassification = CustomerContent; } field(23; "Delegation Date Formula"; DateFormula) { Caption = 'Delegation Date Formula'; } field(26; "Number of Approved Requests"; Integer) { CalcFormula = count("Approval Entry" where("Record ID to Approve" = field("Record ID to Approve"), Status = filter(Approved), "Workflow Step Instance ID" = field("Workflow Step Instance ID"))); Caption = 'Number of Approved Requests'; FieldClass = FlowField; } field(27; "Number of Rejected Requests"; Integer) { CalcFormula = count("Approval Entry" where("Record ID to Approve" = field("Record ID to Approve"), Status = filter(Rejected), "Workflow Step Instance ID" = field("Workflow Step Instance ID"))); Caption = 'Number of Rejected Requests'; FieldClass = FlowField; } field(29; "Entry No."; Integer) { AutoIncrement = true; Caption = 'Entry No.'; } field(30; "Workflow Step Instance ID"; Guid) { Caption = 'Workflow Step Instance ID'; } field(31; "Related to Change"; Boolean) { CalcFormula = exist("Workflow - Record Change" where("Workflow Step Instance ID" = field("Workflow Step Instance ID"), "Record ID" = field("Record ID to Approve"))); Caption = 'Related to Change'; FieldClass = FlowField; } field(32; "Approver Full Name"; Text[80]) { Caption = 'Approver Full Name'; CalcFormula = lookup(User."Full Name" where("User Name" = field("Approver ID"))); FieldClass = FlowField; } field(33; "Sender Full Name"; Text[80]) { Caption = 'Sender Full Name'; CalcFormula = lookup(User."Full Name" where("User Name" = field("Sender ID"))); FieldClass = FlowField; } field(34; "Salespers./Purch. Name"; Text[80]) { Caption = 'Salespers./Purch. Full Name'; CalcFormula = lookup("Salesperson/Purchaser".Name where("Code" = field("Salespers./Purch. Code"))); FieldClass = FlowField; } } keys { key(Key1; "Entry No.") { Clustered = true; } key(Key2; "Record ID to Approve", "Workflow Step Instance ID", "Sequence No.") { } key(Key3; "Table ID", "Document Type", "Document No.", "Sequence No.", "Record ID to Approve") { } key(Key4; "Approver ID", Status, "Due Date", "Date-Time Sent for Approval") { } key(Key5; "Sender ID") { IncludedFields = Status; } key(Key6; "Due Date") { } key(Key7; "Table ID", "Record ID to Approve", Status, "Workflow Step Instance ID", "Sequence No.") { IncludedFields = "Approver ID"; } key(Key8; "Table ID", "Document Type", "Document No.", "Date-Time Sent for Approval") { } } fieldgroups { } trigger OnDelete() var NotificationEntry: Record "Notification Entry"; begin // Make sure there is a Key on the filters NotificationEntry.ReadIsolation(IsolationLevel::ReadUncommitted); NotificationEntry.SetRange(Type, NotificationEntry.Type::Approval); NotificationEntry.SetRange("Triggered By Record", RecordId); if not NotificationEntry.IsEmpty() then NotificationEntry.DeleteAll(true); DeleteWorkflowEventQueue(); end; trigger OnModify() begin "Last Date-Time Modified" := CreateDateTime(Today, Time); "Last Modified By User ID" := UserId; end; var PageManagement: Codeunit "Page Management"; RecNotExistTxt: Label 'The record does not exist.'; ChangeRecordDetailsTxt: Label '; %1 changed from %2 to %3', Comment = 'Prefix = Record information %1 = field caption %2 = old value %3 = new value. Example: Customer 123455; Credit Limit changed from 100.00 to 200.00'; local procedure DeleteWorkflowEventQueue() var WorkflowEventQueue: Record "Workflow Event Queue"; begin WorkflowEventQueue.SetRange("Record ID", Rec.RecordId); WorkflowEventQueue.DeleteAll(); end; [InherentPermissions(PermissionObjectType::TableData, Database::"Approval Entry", 'r')] procedure GetLastEntryNo(): Integer; var FindRecordManagement: Codeunit "Find Record Management"; begin exit(FindRecordManagement.GetLastEntryIntFieldValue(Rec, FieldNo("Entry No."))) end; procedure ShowRecord() var RecRef: RecordRef; IsHandled: Boolean; begin IsHandled := false; OnBeforeShowRecord(Rec, IsHandled); if IsHandled then exit; if not RecRef.Get("Record ID to Approve") then exit; RecRef.SetRecFilter(); PageManagement.PageRun(RecRef); end; procedure RecordCaption() Result: Text var AllObjWithCaption: Record AllObjWithCaption; [SecurityFiltering(SecurityFilter::Filtered)] RecRef: RecordRef; PageNo: Integer; IsHandled: Boolean; begin IsHandled := false; OnBeforeRecordCaption(Rec, Result, IsHandled); if IsHandled then exit(Result); if not RecRef.Get("Record ID to Approve") then exit(RecNotExistTxt); PageNo := PageManagement.GetPageID(RecRef); if PageNo = 0 then exit; AllObjWithCaption.Get(AllObjWithCaption."Object Type"::Page, PageNo); exit(StrSubstNo('%1 %2', AllObjWithCaption."Object Caption", "Document No.")); end; procedure RecordDetails() Details: Text var SalesHeader: Record "Sales Header"; PurchHeader: Record "Purchase Header"; [SecurityFiltering(SecurityFilter::Filtered)] RecRef: RecordRef; ChangeRecordDetails: Text; IsHandled: Boolean; begin IsHandled := false; OnBeforeRecordDetails(Rec, Details, IsHandled); if IsHandled then exit(Details); if not GetRecordToApprove(RecRef) then exit(RecNotExistTxt); ChangeRecordDetails := GetChangeRecordDetails(); case RecRef.Number of Database::"Sales Header": begin RecRef.SetTable(SalesHeader); SalesHeader.CalcFields(Amount); Details := StrSubstNo( '%1 ; %2: %3', SalesHeader."Sell-to Customer Name", SalesHeader.FieldCaption(Amount), SalesHeader.Amount); end; Database::"Purchase Header": begin RecRef.SetTable(PurchHeader); PurchHeader.CalcFields(Amount); Details := StrSubstNo( '%1 ; %2: %3', PurchHeader."Buy-from Vendor Name", PurchHeader.FieldCaption(Amount), Rec.Amount); end; else Details := Format("Record ID to Approve", 0, 1) + ChangeRecordDetails; end; OnAfterGetRecordDetails(RecRef, ChangeRecordDetails, Details); end; local procedure GetRecordToApprove(var RecRef: RecordRef) Result: Boolean begin Result := RecRef.Get("Record ID to Approve"); OnAfterGetRecordToApprove(Rec, RecRef, Result); end; procedure IsOverdue(): Boolean begin exit((Status in [Status::Created, Status::Open]) and ("Due Date" < Today)); end; procedure GetCustVendorDetails(var CustVendorNo: Code[20]; var CustVendorName: Text[100]) var PurchaseHeader: Record "Purchase Header"; SalesHeader: Record "Sales Header"; Customer: Record Customer; Vendor: Record Vendor; RecRef: RecordRef; begin if not RecRef.Get("Record ID to Approve") then exit; case "Table ID" of Database::"Purchase Header": begin RecRef.SetTable(PurchaseHeader); CustVendorNo := PurchaseHeader."Pay-to Vendor No."; CustVendorName := PurchaseHeader."Pay-to Name"; end; Database::"Sales Header": begin RecRef.SetTable(SalesHeader); CustVendorNo := SalesHeader."Bill-to Customer No."; CustVendorName := SalesHeader."Bill-to Name"; end; Database::Customer: begin RecRef.SetTable(Customer); CustVendorNo := Customer."No."; CustVendorName := Customer.Name; end; Database::Vendor: begin RecRef.SetTable(Vendor); CustVendorNo := Vendor."No."; CustVendorName := Vendor.Name; end; else end; OnAfterGetCustVendorDetails(Rec, CustVendorNo, CustVendorName); end; procedure GetChangeRecordDetails() ChangeDetails: Text var WorkflowRecordChange: Record "Workflow - Record Change"; OldValue: Text; NewValue: Text; begin WorkflowRecordChange.SetRange("Record ID", "Record ID to Approve"); WorkflowRecordChange.SetRange("Workflow Step Instance ID", "Workflow Step Instance ID"); if WorkflowRecordChange.FindSet() then repeat WorkflowRecordChange.CalcFields("Field Caption"); NewValue := WorkflowRecordChange.GetFormattedNewValue(true); OldValue := WorkflowRecordChange.GetFormattedOldValue(true); ChangeDetails += StrSubstNo(ChangeRecordDetailsTxt, WorkflowRecordChange."Field Caption", OldValue, NewValue); until WorkflowRecordChange.Next() = 0; end; procedure CanCurrentUserEdit(): Boolean var UserSetup: Record "User Setup"; begin if not UserSetup.Get(UserId) then exit(false); exit((UserSetup."User ID" in ["Sender ID", "Approver ID"]) or UserSetup."Approval Administrator"); end; procedure MarkAllWhereUserisApproverOrSender() var UserSetup: Record "User Setup"; IsHandled: Boolean; begin if UserSetup.Get(UserId) and UserSetup."Approval Administrator" then exit; IsHandled := false; OnBeforeMarkAllWhereUserisApproverOrSender(Rec, IsHandled); if IsHandled then exit; FilterGroup(-1); // Used to support the cross-column search SetRange("Approver ID", UserId); SetRange("Sender ID", UserId); if FindSet() then repeat Mark(true); until Next() = 0; MarkedOnly(true); FilterGroup(0); end; [IntegrationEvent(true, false)] local procedure OnAfterGetRecordDetails(RecRef: RecordRef; ChangeRecordDetails: Text; var Details: Text) begin end; [IntegrationEvent(false, false)] local procedure OnAfterGetRecordToApprove(ApprovalEntry: Record "Approval Entry"; var RecRef: RecordRef; var Result: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterGetCustVendorDetails(var ApprovalEntry: Record "Approval Entry"; var CustVendorNo: Code[20]; var CustVendorName: Text[100]) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeMarkAllWhereUserisApproverOrSender(var ApprovalEntry: Record "Approval Entry"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeShowRecord(var ApprovalEntry: Record "Approval Entry"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeRecordDetails(var ApprovalEntry: Record "Approval Entry"; var Details: Text; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeRecordCaption(var ApprovalEntry: Record "Approval Entry"; var Result: Text; var IsHandled: Boolean) begin end;}