Table 1296 Posted Payment Recon. Line

Base Application, Microsoft.Bank.Reconciliation

src/Layers/W1/BaseApp/Bank/Reconciliation/PostedPaymentReconLine.Table.al256 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;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.FixedAssets.FixedAsset;using Microsoft.Intercompany.Partner;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using System.IO;/// <summary>/// Stores completed payment reconciliation line details after posting./// Maintains historical record of reconciled transactions for audit and reporting purposes./// </summary>table 1296 "Posted Payment Recon. Line"{    Caption = 'Posted Payment Recon. Line';    PasteIsValid = false;    DataClassification = CustomerContent;    fields    {        /// <summary>        /// Bank account identifier for the reconciliation line.        /// </summary>        field(1; "Bank Account No."; Code[20])        {            Caption = 'Bank Account No.';            TableRelation = "Bank Account";        }        /// <summary>        /// Statement number identifying the posted reconciliation.        /// </summary>        field(2; "Statement No."; Code[20])        {            Caption = 'Statement No.';            TableRelation = "Posted Payment Recon. Hdr"."Statement No." where("Bank Account No." = field("Bank Account No."));        }        /// <summary>        /// Sequential line number within the statement.        /// </summary>        field(3; "Statement Line No."; Integer)        {            Caption = 'Statement Line No.';        }        /// <summary>        /// Document number assigned during reconciliation processing.        /// </summary>        field(4; "Document No."; Code[20])        {            Caption = 'Document No.';        }        /// <summary>        /// Transaction date from the bank statement.        /// </summary>        field(5; "Transaction Date"; Date)        {            Caption = 'Transaction Date';            ToolTip = 'Specifies the date when the payment represented by the journal line was recorded in the bank account.';        }        /// <summary>        /// Transaction description from the bank statement.        /// </summary>        field(6; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies the description of the posted payment.';        }        /// <summary>        /// Amount from the bank statement in bank account currency.        /// </summary>        field(7; "Statement Amount"; Decimal)        {            AutoFormatExpression = GetCurrencyCode();            AutoFormatType = 1;            Caption = 'Statement Amount';            ToolTip = 'Specifies the amount on the bank transaction that represents the posted payment.';        }        /// <summary>        /// Difference between statement amount and applied amount.        /// </summary>        field(8; Difference; Decimal)        {            AutoFormatExpression = GetCurrencyCode();            AutoFormatType = 1;            Caption = 'Difference';            ToolTip = 'Specifies the difference between the amount in the Statement Amount field and the Applied Amount field.';        }        /// <summary>        /// Total amount applied to ledger entries during reconciliation.        /// </summary>        field(9; "Applied Amount"; Decimal)        {            AutoFormatExpression = GetCurrencyCode();            AutoFormatType = 1;            Caption = 'Applied Amount';            ToolTip = 'Specifies the amount that was applied to the related invoice or credit memo before this payment was posted.';            Editable = false;        }        /// <summary>        /// Type of transaction processed during reconciliation.        /// </summary>        field(10; Type; Option)        {            Caption = 'Type';            OptionCaption = 'Bank Account Ledger Entry,Check Ledger Entry,Difference';            OptionMembers = "Bank Account Ledger Entry","Check Ledger Entry",Difference;        }        /// <summary>        /// Number of ledger entries applied to this reconciliation line.        /// </summary>        field(11; "Applied Entries"; Integer)        {            Caption = 'Applied Entries';            ToolTip = 'Specifies which customer or vendor ledger entries were applied in relation to posting the payment.';            Editable = false;        }        /// <summary>        /// Value date for transaction processing and reporting.        /// </summary>        field(12; "Value Date"; Date)        {            Caption = 'Value Date';        }        /// <summary>        /// Check number for check-based transactions.        /// </summary>        field(14; "Check No."; Code[20])        {            Caption = 'Check No.';        }        /// <summary>        /// Name of the related party from the bank statement.        /// </summary>        field(15; "Related-Party Name"; Text[250])        {            Caption = 'Related-Party Name';            ToolTip = 'Specifies information about the customer or vendor that the posted payment was for.';        }        /// <summary>        /// Additional transaction information from the bank statement.        /// </summary>        field(16; "Additional Transaction Info"; Text[100])        {            Caption = 'Additional Transaction Info';            ToolTip = 'Specifies information about the transaction as recorded on the bank statement line.';        }        /// <summary>        /// Reference to data exchange entry for imported transactions.        /// </summary>        field(17; "Data Exch. Entry No."; Integer)        {            Caption = 'Data Exch. Entry No.';            Editable = false;            TableRelation = "Data Exch.";        }        /// <summary>        /// Line number in the data exchange for imported transactions.        /// </summary>        field(18; "Data Exch. Line No."; Integer)        {            Caption = 'Data Exch. Line No.';            Editable = false;        }        /// <summary>        /// Account type for transaction posting.        /// </summary>        field(21; "Account Type"; Enum "Gen. Journal Account Type")        {            Caption = 'Account Type';            ToolTip = 'Specifies the type of the account that the payment was posted to.';        }        /// <summary>        /// Account number for transaction posting.        /// </summary>        field(22; "Account No."; Code[20])        {            Caption = 'Account No.';            ToolTip = 'Specifies the account number that the payment was posted to.';            TableRelation = if ("Account Type" = const("G/L Account")) "G/L Account" where("Account Type" = const(Posting),                                                                                          Blocked = const(false))            else            if ("Account Type" = const(Customer)) Customer            else            if ("Account Type" = const(Vendor)) Vendor            else            if ("Account Type" = const("Bank Account")) "Bank Account"            else            if ("Account Type" = const("Fixed Asset")) "Fixed Asset"            else            if ("Account Type" = const("IC Partner")) "IC Partner";        }        /// <summary>        /// Contains the document numbers of all applied entries, concatenated as text.        /// </summary>        field(23; "Applied Document No."; Text[250])        {            Caption = 'Applied Document No.';            ToolTip = 'Specifies the number of the document that the payment is applied to.';        }        /// <summary>        /// Contains the entry numbers of all applied entries, concatenated as text.        /// </summary>        field(24; "Applied Entry No."; Text[250])        {            Caption = 'Applied Entry No.';        }        /// <summary>        /// Specifies the unique transaction identifier from the bank statement.        /// </summary>        field(70; "Transaction ID"; Text[250])        {            Caption = 'Transaction ID';            ToolTip = 'Specifies the ID of the posted payment reconciliation.';        }        /// <summary>        /// Indicates whether this payment reconciliation line has been reconciled.        /// </summary>        field(71; Reconciled; Boolean)        {            Caption = 'Reconciled';        }    }    keys    {        key(Key1; "Bank Account No.", "Statement No.", "Statement Line No.")        {            Clustered = true;        }    }    fieldgroups    {    }    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;}