Table 3 Payment Terms
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;}