Table 298 Issued Reminder Line
src/Layers/W1/BaseApp/Sales/Reminder/IssuedReminderLine.Table.al405 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.Reminder;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Finance.SalesTax;using Microsoft.Finance.VAT.Clause;using Microsoft.Finance.VAT.Setup;using Microsoft.Foundation.Enums;using Microsoft.Sales.Receivables;using Microsoft.Utilities;/// <summary>/// Stores individual line items on an issued reminder document including posted entries, text, and fees./// </summary>table 298 "Issued Reminder Line"{ Caption = 'Issued Reminder Line'; DataClassification = CustomerContent; fields { /// <summary> /// Specifies the issued reminder document to which this line belongs. /// </summary> field(1; "Reminder No."; Code[20]) { Caption = 'Reminder No.'; TableRelation = "Issued Reminder Header"; } /// <summary> /// Specifies the sequential line number within the issued reminder document. /// </summary> field(2; "Line No."; Integer) { Caption = 'Line No.'; } /// <summary> /// Specifies the line number to which this line is attached, such as for extended text. /// </summary> field(3; "Attached to Line No."; Integer) { Caption = 'Attached to Line No.'; TableRelation = "Issued Reminder Line"."Line No." where("Reminder No." = field("Reminder No.")); } /// <summary> /// Specifies the type of content on this line: customer ledger entry, G/L account, text, or line fee. /// </summary> field(4; Type; Enum "Reminder Source Type") { Caption = 'Type'; ToolTip = 'Specifies the line type.'; } /// <summary> /// Specifies the customer ledger entry number that this line references. /// </summary> field(5; "Entry No."; Integer) { BlankZero = true; Caption = 'Entry No.'; TableRelation = "Cust. Ledger Entry"; trigger OnLookup() begin LookupCustomerLedgerEntry(FieldNo("Entry No.")); end; } /// <summary> /// Specifies how many times the customer has been reminded about this entry. /// </summary> field(6; "No. of Reminders"; Integer) { Caption = 'No. of Reminders'; ToolTip = 'Specifies a number that indicates the reminder level.'; } /// <summary> /// Specifies the posting date of the original document that was reminded. /// </summary> field(7; "Posting Date"; Date) { Caption = 'Posting Date'; ToolTip = 'Specifies the posting date of the customer ledger entry that this reminder line is for.'; } /// <summary> /// Specifies the document date of the original document that was reminded. /// </summary> field(8; "Document Date"; Date) { Caption = 'Document Date'; ToolTip = 'Specifies the date when the related document was created.'; } /// <summary> /// Specifies the due date of the original document that was reminded. /// </summary> field(9; "Due Date"; Date) { Caption = 'Due Date'; ToolTip = 'Specifies the due date of the customer ledger entry this reminder line is for.'; } /// <summary> /// Specifies the document type of the original 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 ledger entry this reminder line is for.'; } /// <summary> /// Specifies the document number of the original entry that was reminded. /// </summary> field(11; "Document No."; Code[20]) { Caption = 'Document No.'; ToolTip = 'Specifies the document number of the customer ledger entry this reminder line is for.'; trigger OnLookup() begin LookupDocNo(); end; } /// <summary> /// Specifies a description of the issued reminder line content. /// </summary> field(12; Description; Text[100]) { Caption = 'Description'; ToolTip = 'Specifies an entry description, based on the contents of the Type field.'; } /// <summary> /// Specifies the original amount of the document that was reminded. /// </summary> field(13; "Original Amount"; Decimal) { AutoFormatExpression = GetCurrencyCodeFromHeader(); AutoFormatType = 1; BlankZero = true; Caption = 'Original Amount'; ToolTip = 'Specifies the original amount of the customer ledger entry that this reminder line is for.'; } /// <summary> /// Specifies the amount that was still owed on the document when the reminder was issued. /// </summary> field(14; "Remaining Amount"; Decimal) { AutoFormatExpression = GetCurrencyCodeFromHeader(); AutoFormatType = 1; BlankZero = true; Caption = 'Remaining Amount'; ToolTip = 'Specifies the remaining amount of the customer ledger entry this reminder line is for.'; } /// <summary> /// Specifies the number of the G/L account, standard text, or fee account for this line. /// </summary> field(15; "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(" ")) "Standard Text" else if (Type = const("G/L Account")) "G/L Account" else if (Type = const("Line Fee")) "G/L Account"; } /// <summary> /// Specifies the fee or interest amount that was charged on this line. /// </summary> field(16; Amount; Decimal) { AutoFormatExpression = GetCurrencyCodeFromHeader(); AutoFormatType = 1; BlankZero = true; Caption = 'Amount'; ToolTip = 'Specifies the amount in the currency of the reminder.'; } /// <summary> /// Specifies the interest rate percentage that was used to calculate finance charges. /// </summary> field(17; "Interest Rate"; Decimal) { AutoFormatType = 0; BlankZero = true; Caption = 'Interest Rate'; DecimalPlaces = 0 : 5; } /// <summary> /// Specifies the general product posting group used for VAT and cost allocation. /// </summary> field(18; "Gen. Prod. Posting Group"; Code[20]) { Caption = 'Gen. Prod. Posting Group'; TableRelation = "Gen. Product Posting Group"; } /// <summary> /// Specifies the VAT percentage that was applied to this line. /// </summary> field(19; "VAT %"; Decimal) { AutoFormatType = 0; Caption = 'VAT %'; DecimalPlaces = 0 : 5; } /// <summary> /// Specifies how VAT was calculated for this line. /// </summary> field(20; "VAT Calculation Type"; Enum "Tax Calculation Type") { Caption = 'VAT Calculation Type'; } /// <summary> /// Specifies the VAT amount that was calculated for this line. /// </summary> field(21; "VAT Amount"; Decimal) { AutoFormatExpression = GetCurrencyCodeFromHeader(); AutoFormatType = 1; Caption = 'VAT Amount'; ToolTip = 'Specifies the VAT amount in the currency of the reminder.'; } /// <summary> /// Specifies the tax group code for sales tax calculation. /// </summary> field(22; "Tax Group Code"; Code[20]) { Caption = 'Tax Group Code'; TableRelation = "Tax Group"; } /// <summary> /// Specifies the VAT product posting group that was used for this line. /// </summary> field(23; "VAT Prod. Posting Group"; Code[20]) { Caption = 'VAT Prod. Posting Group'; TableRelation = "VAT Product Posting Group"; } /// <summary> /// Specifies the VAT identifier for reporting and grouping VAT entries. /// </summary> field(24; "VAT Identifier"; Code[20]) { Caption = 'VAT Identifier'; Editable = false; } /// <summary> /// Specifies the purpose of the line, such as beginning text, reminder line, or additional fee. /// </summary> field(25; "Line Type"; Enum "Reminder Line Type") { Caption = 'Line Type'; } /// <summary> /// Specifies a VAT clause code for special VAT treatments that appeared on the document. /// </summary> field(26; "VAT Clause Code"; Code[20]) { Caption = 'VAT Clause Code'; TableRelation = "VAT Clause"; } /// <summary> /// Specifies the document type that the line fee applied to. /// </summary> field(27; "Applies-To Document Type"; Enum "Gen. Journal Document Type") { Caption = 'Applies-To Document Type'; ToolTip = 'Specifies the type of the posted document that this document or journal line will be applied to when you post, for example to register payment.'; } /// <summary> /// Specifies the document number that the line fee applied to. /// </summary> field(28; "Applies-To Document No."; Code[20]) { Caption = 'Applies-To Document No.'; ToolTip = 'Specifies the number of the posted document that this document or journal line will be applied to when you post, for example to register payment.'; trigger OnLookup() begin if Type <> Type::"Line Fee" then exit; IssuedReminderHeader.Get("Reminder No."); CustLedgEntry.SetCurrentKey("Customer No."); CustLedgEntry.SetRange("Customer No.", IssuedReminderHeader."Customer No."); CustLedgEntry.SetRange("Document Type", "Applies-To Document Type"); CustLedgEntry.SetRange("Document No.", "Applies-To Document No."); if CustLedgEntry.FindLast() then; PAGE.RunModal(0, CustLedgEntry); end; } /// <summary> /// Indicates whether this line contains detailed interest rate calculation information. /// </summary> field(30; "Detailed Interest Rates Entry"; Boolean) { Caption = 'Detailed Interest Rates Entry'; } /// <summary> /// Indicates whether this issued reminder line has been canceled. /// </summary> field(50; Canceled; Boolean) { Caption = 'Canceled'; DataClassification = SystemMetadata; } /// <summary> /// Indicates whether this line was automatically created by the system during reminder generation. /// </summary> field(101; "System-Created Entry"; Boolean) { Caption = 'System-Created Entry'; Editable = false; } } keys { key(Key1; "Reminder No.", "Line No.") { Clustered = true; } key(Key2; "Reminder No.", Type, "Line Type", "Detailed Interest Rates Entry") { MaintainSQLIndex = false; SumIndexFields = Amount, "VAT Amount", "Remaining Amount"; } key(Key3; "Reminder No.", "Detailed Interest Rates Entry") { SumIndexFields = Amount, "VAT Amount", "Remaining Amount"; } key(Key4; "Reminder No.", Type) { SumIndexFields = "VAT Amount"; } } fieldgroups { } var IssuedReminderHeader: Record "Issued Reminder Header"; CustLedgEntry: Record "Cust. Ledger Entry"; /// <summary> /// Gets the currency code from the associated issued reminder header. /// </summary> /// <returns>The currency code from the header, or empty string if not found.</returns> procedure GetCurrencyCodeFromHeader(): Code[10] var IssuedReminderHeader: Record "Issued Reminder Header"; begin if "Reminder No." = IssuedReminderHeader."No." then exit(IssuedReminderHeader."Currency Code"); if IssuedReminderHeader.Get("Reminder No.") then exit(IssuedReminderHeader."Currency Code"); exit(''); end; /// <summary> /// Opens a lookup page to view the customer ledger entry associated with this line's document number. /// </summary> procedure LookupDocNo() var IsHandled: Boolean; begin OnBeforeLookupDocNo(Rec, IsHandled); if IsHandled then exit; LookupCustomerLedgerEntry(FieldNo("Document No.")); end; local procedure LookupCustomerLedgerEntry(CalledByFieldNo: Integer) begin if Type <> Type::"Customer Ledger Entry" then exit; IssuedReminderHeader.Get("Reminder No."); SetCustLedgEntryFilter(CustLedgEntry, IssuedReminderHeader, CalledByFieldNo); if CustLedgEntry.Get("Entry No.") then; PAGE.RunModal(0, CustLedgEntry); end; local procedure SetCustLedgEntryFilter(var CustLedgEntry: Record "Cust. Ledger Entry"; IssuedReminderHeader: Record "Issued Reminder Header"; CalledByFieldNo: Integer) begin CustLedgEntry.SetCurrentKey("Customer No."); CustLedgEntry.SetRange("Customer No.", IssuedReminderHeader."Customer No."); OnAfterSetCustLedgEntryFilter(CustLedgEntry, Rec, CalledByFieldNo); end; [IntegrationEvent(false, false)] local procedure OnBeforeLookupDocNo(var IssuedReminderLine: Record "Issued Reminder Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterSetCustLedgEntryFilter(var CustLedgEntry: Record "Cust. Ledger Entry"; var IssuedReminderLine: Record "Issued Reminder Line"; CalledByFieldNo: Integer) begin end;}