Table 3 Payment Terms

Base Application, Microsoft.Foundation.PaymentTerms

src/Layers/W1/BaseApp/Foundation/PaymentTerms/PaymentTerms.Table.al159 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.Foundation.PaymentTerms;using Microsoft.Integration.Dataverse;using System.Globalization;table 3 "Payment Terms"{    Caption = 'Payment Terms';    DataCaptionFields = "Code", Description;    LookupPageID = "Payment Terms";    DataClassification = CustomerContent;    fields    {        field(1; "Code"; Code[10])        {            Caption = 'Code';            ToolTip = 'Specifies a code to identify this set of payment terms.';            NotBlank = true;        }        field(2; "Due Date Calculation"; DateFormula)        {            Caption = 'Due Date Calculation';            ToolTip = 'Specifies a formula that determines how to calculate the due date, for example, when you create an invoice.';        }        field(3; "Discount Date Calculation"; DateFormula)        {            Caption = 'Discount Date Calculation';            ToolTip = 'Specifies the date formula if the payment terms include a possible payment discount.';        }        field(4; "Discount %"; Decimal)        {            AutoFormatType = 0;            Caption = 'Discount %';            ToolTip = 'Specifies the percentage of the invoice amount (amount including VAT is the default setting) that will constitute a possible payment discount.';            DecimalPlaces = 0 : 5;            MaxValue = 100;            MinValue = 0;        }        field(5; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies an explanation of the payment terms.';        }        field(6; "Calc. Pmt. Disc. on Cr. Memos"; Boolean)        {            Caption = 'Calc. Pmt. Disc. on Cr. Memos';            ToolTip = 'Specifies that a payment discount, cash discount, cash discount date, and due date are calculated on credit memos with these payment terms.';        }        field(8; "Last Modified Date Time"; DateTime)        {            Caption = 'Last Modified Date Time';            Editable = false;        }#if not CLEANSCHEMA26        field(720; "Coupled to CRM"; Boolean)        {            Caption = 'Coupled to Dataverse';            Editable = false;            ObsoleteReason = 'Replaced by page control Coupled to Dataverse';            ObsoleteState = Removed;            ObsoleteTag = '26.0';        }#endif    }    keys    {        key(Key1; "Code")        {            Clustered = true;        }    }    fieldgroups    {        fieldgroup(DropDown; "Code", Description, "Due Date Calculation")        {        }        fieldgroup(Brick; "Code", Description, "Due Date Calculation")        {        }    }    trigger OnDelete()    var        PaymentTermsTranslation: Record "Payment Term Translation";    begin        PaymentTermsTranslation.SetRange("Payment Term", Code);        PaymentTermsTranslation.DeleteAll();    end;    trigger OnInsert()    begin        SetLastModifiedDateTime();    end;    trigger OnModify()    begin        SetLastModifiedDateTime();    end;    trigger OnRename()    var        CRMSyncHelper: Codeunit "CRM Synch. Helper";    begin        SetLastModifiedDateTime();        CRMSyncHelper.UpdateCDSOptionMapping(xRec.RecordId(), RecordId());    end;    local procedure SetLastModifiedDateTime()    begin        "Last Modified Date Time" := CurrentDateTime;    end;    procedure TranslateDescription(var PaymentTerms: Record "Payment Terms"; Language: Code[10])    var        PaymentTermsTranslation: Record "Payment Term Translation";    begin        if PaymentTermsTranslation.Get(PaymentTerms.Code, Language) then            PaymentTerms.Description := PaymentTermsTranslation.Description;        OnAfterTranslateDescription(PaymentTerms, Language);    end;    procedure GetDescriptionInCurrentLanguageFullLength(): Text[100]    var        PaymentTermTranslation: Record "Payment Term Translation";        Language: Codeunit Language;    begin        if PaymentTermTranslation.Get(Code, Language.GetUserLanguageCode()) then            exit(PaymentTermTranslation.Description);        exit(Description);    end;    procedure UsePaymentDiscount(): Boolean    var        PaymentTerms: Record "Payment Terms";    begin        PaymentTerms.SetFilter("Discount %", '<>%1', 0);        exit(not PaymentTerms.IsEmpty);    end;    [Scope('OnPrem')]    procedure GetDueDateCalculation(var DueDateCalculation: DateFormula)    begin        DueDateCalculation := "Due Date Calculation";    end;    [IntegrationEvent(false, false)]    local procedure OnAfterTranslateDescription(var PaymentTerms: Record "Payment Terms"; Language: Code[10])    begin    end;}