Table 456 Posted Approval Entry

Base Application, System.Automation

src/Layers/W1/BaseApp/System/Workflow/PostedApprovalEntry.Table.al196 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.Utilities;using System.Security.AccessControl;table 456 "Posted Approval Entry"{    Caption = 'Posted Approval Entry';    DrillDownPageId = "Posted Approval Entries";    LookupPageId = "Posted Approval Entries";    DataClassification = CustomerContent;    fields    {        field(1; "Table ID"; Integer)        {            Caption = 'Table ID';        }        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';        }        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 ID"; Code[50])        {            Caption = 'Last Modified By ID';            DataClassification = EndUserIdentifiableInformation;            TableRelation = User."User Name";        }        field(13; Comment; Boolean)        {            CalcFormula = exist("Posted Approval Comment Line" where("Table ID" = field("Table ID"),                                                                      "Document No." = field("Document No."),                                                                      "Posted Record ID" = field("Posted Record ID")));            Caption = 'Comment';            Editable = false;            FieldClass = FlowField;        }        field(14; "Due Date"; Date)        {            Caption = '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(22; "Posted Record ID"; RecordID)        {            Caption = 'Posted Record ID';            DataClassification = CustomerContent;        }        field(23; "Delegation Date Formula"; DateFormula)        {            Caption = 'Delegation Date Formula';        }        field(26; "Number of Approved Requests"; Integer)        {            Caption = 'Number of Approved Requests';        }        field(27; "Number of Rejected Requests"; Integer)        {            Caption = 'Number of Rejected Requests';        }        field(28; "Iteration No."; Integer)        {            Caption = 'Iteration No.';        }        field(29; "Entry No."; Integer)        {            AutoIncrement = true;            Caption = 'Entry No.';        }        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; "Posted Record ID")        {        }    }    fieldgroups    {    }    trigger OnDelete()    var        PostedApprovalCommentLine: Record "Posted Approval Comment Line";    begin        PostedApprovalCommentLine.SetRange("Posted Record ID", "Posted Record ID");        PostedApprovalCommentLine.DeleteAll();    end;    procedure ShowRecord()    var        PageManagement: Codeunit "Page Management";        RecRef: RecordRef;    begin        if not RecRef.Get("Posted Record ID") then            exit;        RecRef.SetRecFilter();        PageManagement.PageRun(RecRef);    end;}