Table 1295 Posted Payment Recon. Hdr
src/Layers/W1/BaseApp/Bank/Reconciliation/PostedPaymentReconHdr.Table.al142 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.Bank.Reconciliation;using Microsoft.Bank.BankAccount;/// <summary>/// Stores header information for posted payment reconciliations./// Maintains completed reconciliation summary data for audit and reporting purposes./// </summary>table 1295 "Posted Payment Recon. Hdr"{ Caption = 'Posted Payment Recon. Hdr'; DataCaptionFields = "Bank Account No.", "Statement No."; LookupPageID = "Bank Acc. Reconciliation List"; DataClassification = CustomerContent; fields { /// <summary> /// Bank account identifier for the posted reconciliation. /// </summary> field(1; "Bank Account No."; Code[20]) { Caption = 'Bank Account No.'; ToolTip = 'Specifies the number of the bank account that the posted payment was processed for.'; NotBlank = true; TableRelation = "Bank Account"; } /// <summary> /// Statement number for the posted reconciliation. /// </summary> field(2; "Statement No."; Code[20]) { Caption = 'Statement No.'; ToolTip = 'Specifies the number of the bank statement that contained the line that represented the posted payment.'; NotBlank = true; } /// <summary> /// Ending balance from the bank statement. /// </summary> field(3; "Statement Ending Balance"; Decimal) { AutoFormatExpression = GetCurrencyCode(); AutoFormatType = 1; Caption = 'Statement Ending Balance'; } /// <summary> /// Date of the bank statement. /// </summary> field(4; "Statement Date"; Date) { Caption = 'Statement Date'; } /// <summary> /// Stored bank statement file or data. /// </summary> field(6; "Bank Statement"; BLOB) { Caption = 'Bank Statement'; } field(10; "Is Reconciled"; Boolean) { Caption = 'Is Reconciled'; FieldClass = FlowField; CalcFormula = exist("Posted Payment Recon. Line" where("Bank Account No." = field("Bank Account No."), "Statement No." = field("Statement No."), Reconciled = const(true))); } /// <summary> /// Indicates whether this posted payment reconciliation has been reversed. /// </summary> field(11; "Is Reversed"; Boolean) { Caption = 'Is Reversed'; } /// <summary> /// Specifies the G/L Register number where the posted payment reconciliation entries were recorded. /// </summary> field(12; "G/L Register No."; Integer) { Caption = 'G/L Register No.'; } /// <summary> /// Indicates whether entries were found with the associated G/L Register. /// </summary> field(13; "Entries found with G/L Reg."; Boolean) { Caption = 'Entries found with G/L Register'; } } keys { key(Key1; "Bank Account No.", "Statement No.") { Clustered = true; } } fieldgroups { } var IgnoreConfirmOnDelete: Boolean; procedure SetIgnoreConfirmOnDelete(Value: Boolean) begin IgnoreConfirmOnDelete := Value; end; trigger OnDelete() begin if not IgnoreConfirmOnDelete then if not Confirm(HasBankEntriesQst, false, "Bank Account No.", "Statement No.") then Error(''); CODEUNIT.Run(CODEUNIT::"BankPaymentApplLines-Delete", Rec); end; var#pragma warning disable AA0470 HasBankEntriesQst: Label 'One or more bank account ledger entries in bank account %1 have been reconciled for bank account statement %2, and contain information about the bank statement. These bank ledger entries will not be modified if you delete bank account statement %2.\\Do you want to continue?';#pragma warning restore AA0470 local procedure GetCurrencyCode(): Code[10] var BankAcc2: Record "Bank Account"; begin if "Bank Account No." = BankAcc2."No." then exit(BankAcc2."Currency Code"); if BankAcc2.Get("Bank Account No.") then exit(BankAcc2."Currency Code"); exit(''); end;}