Table 1296 Posted Payment Recon. Line
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;}