Table 300 Reminder/Fin. Charge Entry
src/Layers/W1/BaseApp/Sales/FinanceCharge/ReminderFinChargeEntry.Table.al244 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.Sales.FinanceCharge;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Foundation.Navigate;using Microsoft.Sales.Customer;using Microsoft.Sales.Receivables;using Microsoft.Sales.Reminder;using Microsoft.Utilities;using System.Security.AccessControl;/// <summary>/// Stores entries tracking issued reminders and finance charge memos for customer ledger entries./// </summary>table 300 "Reminder/Fin. Charge Entry"{ Caption = 'Reminder/Fin. Charge Entry'; DrillDownPageID = "Reminder/Fin. Charge Entries"; LookupPageID = "Reminder/Fin. Charge Entries"; DataClassification = CustomerContent; fields { /// <summary> /// Specifies the unique sequential number assigned to this reminder or finance charge entry. /// </summary> field(1; "Entry No."; Integer) { Caption = 'Entry No.'; ToolTip = 'Specifies the number of the entry, as assigned from the specified number series when the entry was created.'; NotBlank = true; } /// <summary> /// Specifies whether this entry is for a reminder or a finance charge memo. /// </summary> field(2; Type; Enum "Reminder/Fin.ChargeEntry Type") { Caption = 'Type'; ToolTip = 'Specifies whether the entry comes from a reminder or a finance charge memo.'; } /// <summary> /// Specifies the document number of the issued reminder or finance charge memo. /// </summary> field(3; "No."; Code[20]) { Caption = 'No.'; ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.'; TableRelation = if (Type = const(Reminder)) "Issued Reminder Header" else if (Type = const("Finance Charge Memo")) "Issued Fin. Charge Memo Header"; } /// <summary> /// Specifies the reminder level that was applied when the reminder was issued. /// </summary> field(4; "Reminder Level"; Integer) { Caption = 'Reminder Level'; ToolTip = 'Specifies the reminder level if the Type field contains Reminder.'; } /// <summary> /// Specifies the date when the reminder or finance charge memo was posted. /// </summary> field(5; "Posting Date"; Date) { Caption = 'Posting Date'; ToolTip = 'Specifies the posting date of the reminder or finance charge memo.'; } /// <summary> /// Specifies the date of the reminder or finance charge memo document. /// </summary> field(6; "Document Date"; Date) { Caption = 'Document Date'; } /// <summary> /// Indicates whether interest was posted to the general ledger for this entry. /// </summary> field(7; "Interest Posted"; Boolean) { Caption = 'Interest Posted'; ToolTip = 'Specifies whether or not interest was posted to the customer account and a general ledger account when the reminder or finance charge memo was issued.'; } /// <summary> /// Specifies the interest amount that was charged on the customer ledger entry. /// </summary> field(8; "Interest Amount"; Decimal) { AutoFormatExpression = GetCurrencyCode(); AutoFormatType = 1; Caption = 'Interest Amount'; } /// <summary> /// Specifies the customer ledger entry number that this reminder or finance charge relates to. /// </summary> field(9; "Customer Entry No."; Integer) { Caption = 'Customer Entry No.'; ToolTip = 'Specifies the number of the customer ledger entry on the reminder line or finance charge memo line.'; TableRelation = "Cust. Ledger Entry"; } /// <summary> /// Specifies the document type of the original customer ledger entry, such as invoice or credit memo. /// </summary> field(10; "Document Type"; Enum "Gen. Journal Document Type") { Caption = 'Document Type'; ToolTip = 'Specifies the document type of the customer entry on the reminder line or finance charge memo line.'; } /// <summary> /// Specifies the document number of the original customer ledger entry. /// </summary> field(11; "Document No."; Code[20]) { Caption = 'Document No.'; ToolTip = 'Specifies the document number of the customer entry on the reminder line or finance charge memo line.'; } /// <summary> /// Specifies the remaining amount on the customer ledger entry at the time the reminder or finance charge was issued. /// </summary> field(12; "Remaining Amount"; Decimal) { AutoFormatExpression = GetCurrencyCode(); AutoFormatType = 1; Caption = 'Remaining Amount'; ToolTip = 'Specifies the remaining amount of the customer ledger entry this reminder or finance charge memo entry is for.'; } /// <summary> /// Specifies the customer number associated with this reminder or finance charge entry. /// </summary> field(13; "Customer No."; Code[20]) { Caption = 'Customer No.'; TableRelation = Customer; } /// <summary> /// Specifies the user who created the reminder or finance charge memo. /// </summary> field(14; "User ID"; Code[50]) { Caption = 'User ID'; DataClassification = EndUserIdentifiableInformation; TableRelation = User."User Name"; } /// <summary> /// Specifies the due date of the original customer ledger entry. /// </summary> field(15; "Due Date"; Date) { Caption = 'Due Date'; } /// <summary> /// Indicates whether this entry has been canceled, typically through a reversal or credit memo. /// </summary> field(50; Canceled; Boolean) { Caption = 'Canceled'; ToolTip = 'Specifies if the issued reminder or finance charge has been canceled.'; DataClassification = SystemMetadata; } } keys { key(Key1; "Entry No.") { Clustered = true; } key(Key2; "Customer No.") { } key(Key3; "Customer Entry No.", Type) { } key(Key4; Type, "No.") { } key(Key5; "Document No.", "Posting Date") { } } fieldgroups { } /// <summary> /// Opens the Navigate page to show all related ledger entries for this reminder or finance charge entry. /// </summary> procedure Navigate() var NavigatePage: Page Navigate; begin NavigatePage.SetDoc("Posting Date", "No."); NavigatePage.SetRec(Rec); NavigatePage.Run(); end; local procedure GetCurrencyCode(): Code[10] var CustLedgEntry: Record "Cust. Ledger Entry"; CurrencyCode: Code[10]; IsHandled: Boolean; begin OnBeforeGetCurrencyCode(Rec, CurrencyCode, IsHandled); if IsHandled then exit(CurrencyCode); if "Customer Entry No." = CustLedgEntry."Entry No." then exit(CustLedgEntry."Currency Code"); if CustLedgEntry.Get("Customer Entry No.") then exit(CustLedgEntry."Currency Code"); exit(''); end; /// <summary> /// Retrieves the highest entry number in the reminder or finance charge entry table. /// </summary> /// <returns>The last entry number, or 0 if no entries exist.</returns> [InherentPermissions(PermissionObjectType::TableData, Database::"Reminder/Fin. Charge Entry", 'r')] procedure GetLastEntryNo(): Integer; var FindRecordManagement: Codeunit "Find Record Management"; begin exit(FindRecordManagement.GetLastEntryIntFieldValue(Rec, FieldNo("Entry No."))) end; /// <summary> /// Raised before the currency code is retrieved from the customer ledger entry. /// </summary> /// <param name="ReminderFinChargeEntry">Specifies the reminder or finance charge entry record.</param> /// <param name="CurrencyCode">Specifies the currency code that can be set.</param> /// <param name="IsHandled">Set to true to skip the default currency code retrieval.</param> [IntegrationEvent(false, false)] local procedure OnBeforeGetCurrencyCode(ReminderFinChargeEntry: Record "Reminder/Fin. Charge Entry"; var CurrencyCode: Code[10]; var IsHandled: Boolean) begin end;}