Table 186 Exch. Rate Adjmt. Ledg. Entry
src/Layers/W1/BaseApp/Finance/Currency/ExchRateAdjmtLedgEntry.Table.al183 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.Currency;using Microsoft.Bank.BankAccount;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Finance.ReceivablesPayables;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;/// <summary>/// Records exchange rate adjustment entries created during currency revaluation procedures./// Maintains a detailed audit trail of all exchange rate adjustments posted to the system./// </summary>/// <remarks>/// Linked to customer, vendor, and bank account ledger entries through detailed ledger entries./// Provides complete traceability of adjustment amounts and their impact on account balances./// </remarks>table 186 "Exch. Rate Adjmt. Ledg. Entry"{ Caption = 'Exch. Rate Adjmt. Ledger Entry'; DrillDownPageID = "Exch.Rate Adjmt. Ledg.Entries"; LookupPageID = "Exch.Rate Adjmt. Ledg.Entries"; DataClassification = CustomerContent; fields { /// <summary> /// Register number linking this entry to the adjustment posting register. /// </summary> field(1; "Register No."; Integer) { Caption = 'No.'; ToolTip = 'Specifies the register number of the entry.'; } /// <summary> /// Unique sequential entry number for this adjustment ledger entry. /// </summary> field(2; "Entry No."; Integer) { Caption = 'No.'; } /// <summary> /// Account number that was adjusted for exchange rate changes. /// </summary> field(3; "Account No."; Code[20]) { Caption = 'Account No.'; ToolTip = 'Specifies the account number that the entry is linked to.'; TableRelation = if ("Account Type" = const(Customer)) Customer else if ("Account Type" = const(Vendor)) Vendor else if ("Account Type" = const("Bank Account")) "Bank Account"; } /// <summary> /// Date when the exchange rate adjustment was posted. /// </summary> field(4; "Posting Date"; Date) { Caption = 'Posting Date'; ToolTip = 'Specifies the customer entry''s posting date.'; } /// <summary> /// Document type for the adjustment entry. /// </summary> field(5; "Document Type"; Enum "Gen. Journal Document Type") { Caption = 'Document Type'; ToolTip = 'Specifies the document type that the customer entry belongs to.'; } /// <summary> /// Document number for the adjustment entry. /// </summary> field(6; "Document No."; Code[20]) { Caption = 'Document No.'; ToolTip = 'Specifies the entry''s document number.'; } /// <summary> /// Due date from the original transaction being adjusted. /// </summary> field(8; "Due Date"; Date) { Caption = 'Due Date'; ToolTip = 'Specifies the due date on the entry.'; } /// <summary> /// Type of account that was adjusted (Customer, Vendor, Bank Account, etc.). /// </summary> field(9; "Account Type"; Enum "Exch. Rate Adjmt. Account Type") { Caption = 'Account Type'; } /// <summary> /// Name of the account that was adjusted. /// </summary> field(10; "Account Name"; Text[100]) { Caption = 'Account Name'; ToolTip = 'Specifies the account name that the entry is linked to.'; } /// <summary> /// Currency code for the adjustment calculation. /// </summary> field(11; "Currency Code"; Code[10]) { Caption = 'Currency Code'; ToolTip = 'Specifies the currency code for the amount on the line.'; TableRelation = Currency; } /// <summary> /// Exchange rate factor used for the adjustment calculation. /// </summary> field(12; "Currency Factor"; Decimal) { AutoFormatType = 0; Caption = 'Currency Factor'; ToolTip = 'Specifies the currency code for the amount on the line.'; Editable = false; } /// <summary> /// Original amount in foreign currency before adjustment. /// </summary> field(15; "Base Amount"; Decimal) { AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 1; Caption = 'Base Amount'; ToolTip = 'Specifies the amount that remains to be applied to before the entry has been completely applied.'; Editable = false; } /// <summary> /// Original amount in local currency before adjustment. /// </summary> field(16; "Base Amount (LCY)"; Decimal) { AutoFormatExpression = ''; AutoFormatType = 1; Caption = 'Base Amount (LCY)'; Editable = false; } /// <summary> /// Calculated adjustment amount posted to correct exchange rate differences. /// </summary> field(17; "Adjustment Amount"; Decimal) { AutoFormatExpression = ''; AutoFormatType = 1; Caption = 'Adjustment Amount'; ToolTip = 'Specifies the exchange rate adjustment amount for the entry.'; Editable = false; } /// <summary> /// Type of detailed ledger entry this adjustment relates to. /// </summary> field(19; "Detailed Ledger Entry Type"; Enum "Detailed CV Ledger Entry Type") { Caption = 'Entry Type'; } /// <summary> /// Detailed ledger entry number that this adjustment modifies. /// </summary> field(20; "Detailed Ledger Entry No."; Decimal) { AutoFormatType = 0; Caption = 'Detailed Ledger Entry No.'; ToolTip = 'Specifies the number of the detailed customer or vendor ledger entry, related to register ledger entry.'; Editable = false; } } keys { key(Key1; "Register No.", "Entry No.") { Clustered = true; } }}