Table 5488 Trial Balance Entity Buffer
src/Layers/W1/BaseApp/Finance/FinancialReports/TrialBalanceEntityBuffer.Table.al134 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;using Microsoft.Finance.GeneralLedger.Account;/// <summary>/// Buffer table for trial balance data export to external APIs and integrations./// Stores formatted trial balance amounts and account information for entity exposure./// </summary>table 5488 "Trial Balance Entity Buffer"{ Caption = 'Trial Balance Entity Buffer'; ReplicateData = false; DataClassification = CustomerContent; fields { /// <summary> /// G/L account number for trial balance data identification. /// </summary> field(1; "No."; Code[20]) { Caption = 'No.'; ToolTip = 'Specifies the No..'; DataClassification = SystemMetadata; } /// <summary> /// G/L account name for display in trial balance reports and exports. /// </summary> field(2; Name; Text[100]) { Caption = 'Name'; ToolTip = 'Specifies the Name.'; DataClassification = SystemMetadata; } /// <summary> /// Formatted debit amount for net change in the specified period. /// </summary> field(3; "Net Change Debit"; Text[30]) { Caption = 'Net Change Debit'; DataClassification = SystemMetadata; } /// <summary> /// Formatted credit amount for net change in the specified period. /// </summary> field(4; "Net Change Credit"; Text[30]) { Caption = 'Net Change Credit'; DataClassification = SystemMetadata; } /// <summary> /// Formatted debit balance as of the specified date filter. /// </summary> field(5; "Balance at Date Debit"; Text[30]) { Caption = 'Balance at Date Debit'; ToolTip = 'Specifies the Balance at Date Debit Amount.'; DataClassification = SystemMetadata; } /// <summary> /// Formatted credit balance as of the specified date filter. /// </summary> field(6; "Balance at Date Credit"; Text[30]) { Caption = 'Balance at Date Credit'; ToolTip = 'Specifies the Balance at Date Credit Amount.'; DataClassification = SystemMetadata; } /// <summary> /// Date filter applied for balance calculations and period determination. /// </summary> field(7; "Date Filter"; Date) { Caption = 'Date Filter'; ToolTip = 'Specifies the Date Filter.'; DataClassification = SystemMetadata; } /// <summary> /// Formatted total debit amount including opening balance and net change. /// </summary> field(8; "Total Debit"; Text[30]) { Caption = 'Total Debit'; ToolTip = 'Specifies the Total Debit Amount.'; DataClassification = SystemMetadata; } /// <summary> /// Formatted total credit amount including opening balance and net change. /// </summary> field(9; "Total Credit"; Text[30]) { Caption = 'Total Credit'; ToolTip = 'Specifies the Total Credit Amount.'; DataClassification = SystemMetadata; } /// <summary> /// G/L account type determining posting behavior and balance calculation. /// </summary> field(10; "Account Type"; Enum "G/L Account Type") { Caption = 'Account Type'; ToolTip = 'Specifies the Account Type.'; DataClassification = SystemMetadata; } /// <summary> /// System identifier linking buffer record to source G/L account. /// </summary> field(11; "Account Id"; Guid) { Caption = 'Account Id'; ToolTip = 'Specifies the Account Id.'; DataClassification = SystemMetadata; TableRelation = "G/L Account".SystemId; } } keys { key(Key1; "No.") { Clustered = true; } } fieldgroups { }}