Table 764 Fin. Report Excel Template, source in 29

Source29

src/Layers/W1/BaseApp/Finance/FinancialReports/FinReportExcelTemplate.Table.al77 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 Microsoft.Finance.FinancialReports;

/// <summary>
/// Stores Excel template layouts for financial report export formatting.
/// Enables custom Excel output layouts for financial reports with reusable templates.
/// </summary>
table 764 "Fin. Report Excel Template"
{
    Caption = 'Financial Report Excel Layout';
    DataClassification = CustomerContent;
    LookupPageId = "Fin. Report Excel Templates";

    fields
    {
        /// <summary>
        /// Financial report name linked to Excel template for export formatting.
        /// </summary>
        field(1; "Financial Report Name"; Code[10])
        {
            Caption = 'Financial Report Name';
            DataClassification = CustomerContent;
            NotBlank = true;
            TableRelation = "Financial Report";
            ToolTip = 'Specifies the name of the financial report.';
        }
        /// <summary>
        /// Unique code identifying the Excel template within financial report.
        /// </summary>
        field(2; Code; Code[50])
        {
            Caption = 'Code';
            DataClassification = CustomerContent;
            NotBlank = true;
            ToolTip = 'Specifies the code of the layout.';
        }
        /// <summary>
        /// Description of Excel template layout for user identification and selection.
        /// </summary>
        field(3; Description; Text[100])
        {
            Caption = 'Description';
            DataClassification = CustomerContent;
            ToolTip = 'Specifies a description of the Excel Layout to help users understand what the layout does.';

        }
        /// <summary>
        /// Excel template file stored as BLOB for financial report export formatting.
        /// </summary>
        field(4; Template; Blob)
        {
            Caption = 'Layout';
            DataClassification = CustomerContent;
            ToolTip = 'Specifies the Excel layout file.';
        }
        /// <summary>
        /// File name for Excel export output when using this template layout.
        /// </summary>
        field(5; "File Name"; Text[250])
        {
            Caption = 'File Name';
            DataClassification = CustomerContent;
            ToolTip = 'Specifies the file name of the layout when exported. If not specified the financial report name will be used instead.';
        }
    }

    keys
    {
        key(PK; "Financial Report Name", Code)
        {
            Clustered = true;
        }
    }
}