Table 380 Detailed Vendor Ledg. Entry

Base Application, Microsoft.Purchases.Payables

src/Layers/W1/BaseApp/Purchases/Payables/DetailedVendorLedgEntry.Table.al414 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.Purchases.Payables;using Microsoft.Finance.Currency;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Finance.GeneralLedger.Ledger;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Finance.ReceivablesPayables;using Microsoft.Finance.SalesTax;using Microsoft.Finance.VAT.Setup;using Microsoft.Foundation.AuditCodes;using Microsoft.Purchases.Vendor;using Microsoft.Utilities;using System.Security.AccessControl;using System.Security.User;table 380 "Detailed Vendor Ledg. Entry"{    Caption = 'Detailed Vendor Ledg. Entry';    DataCaptionFields = "Vendor No.";    DrillDownPageID = "Detailed Vendor Ledg. Entries";    LookupPageID = "Detailed Vendor Ledg. Entries";    Permissions = TableData "Detailed Vendor Ledg. Entry" = m;    DataClassification = CustomerContent;    fields    {        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.';        }        field(2; "Vendor Ledger Entry No."; Integer)        {            Caption = 'Vendor Ledger Entry No.';            ToolTip = 'Specifies the entry number of the vendor ledger entry that the detailed vendor ledger entry line was created for.';            TableRelation = "Vendor Ledger Entry";        }        field(3; "Entry Type"; Enum "Detailed CV Ledger Entry Type")        {            Caption = 'Entry Type';            ToolTip = 'Specifies the entry type of the detailed vendor ledger entry.';        }        field(4; "Posting Date"; Date)        {            Caption = 'Posting Date';            ToolTip = 'Specifies the posting date of the detailed vendor ledger entry.';        }        field(5; "Document Type"; Enum "Gen. Journal Document Type")        {            Caption = 'Document Type';            ToolTip = 'Specifies the document type of the detailed vendor ledger entry.';        }        field(6; "Document No."; Code[20])        {            Caption = 'Document No.';            ToolTip = 'Specifies the document number of the transaction that created the entry.';        }        field(7; Amount; Decimal)        {            AutoFormatExpression = Rec."Currency Code";            AutoFormatType = 1;            Caption = 'Amount';            ToolTip = 'Specifies the amount of the detailed vendor ledger entry.';        }        field(8; "Amount (LCY)"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            Caption = 'Amount (LCY)';        }        field(9; "Vendor No."; Code[20])        {            Caption = 'Vendor No.';            ToolTip = 'Specifies the number of the vendor account to which the entry is posted.';            TableRelation = Vendor;        }        field(10; "Currency Code"; Code[10])        {            Caption = 'Currency Code';            ToolTip = 'Specifies the code for the currency if the amount is in a foreign currency.';            TableRelation = Currency;        }        field(11; "User ID"; Code[50])        {            Caption = 'User ID';            ToolTip = 'Specifies the ID of the user who posted the entry, to be used, for example, in the change log.';            DataClassification = EndUserIdentifiableInformation;            TableRelation = User."User Name";            ValidateTableRelation = false;            trigger OnValidate()            var                UserSelection: Codeunit "User Selection";            begin                UserSelection.ValidateUserName("User ID");            end;        }        field(12; "Source Code"; Code[10])        {            Caption = 'Source Code';            ToolTip = 'Specifies the source code that specifies where the entry was created.';            TableRelation = "Source Code";        }        field(13; "Transaction No."; Integer)        {            Caption = 'Transaction No.';            TableRelation = "G/L Transaction";            ToolTip = 'Specifies the transaction number that groups related G/L entries from the same posting.';        }        field(14; "Journal Batch Name"; Code[10])        {            Caption = 'Journal Batch Name';        }        field(15; "Reason Code"; Code[10])        {            Caption = 'Reason Code';            ToolTip = 'Specifies the reason code, a supplementary source code that enables you to trace the entry.';            TableRelation = "Reason Code";        }        field(16; "Debit Amount"; Decimal)        {            AutoFormatExpression = Rec."Currency Code";            AutoFormatType = 1;            BlankZero = true;            Caption = 'Debit Amount';            ToolTip = 'Specifies the total of the ledger entries that represent debits.';        }        field(17; "Credit Amount"; Decimal)        {            AutoFormatExpression = Rec."Currency Code";            AutoFormatType = 1;            BlankZero = true;            Caption = 'Credit Amount';            ToolTip = 'Specifies the total of the ledger entries that represent credits.';        }        field(18; "Debit Amount (LCY)"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            BlankZero = true;            Caption = 'Debit Amount (LCY)';        }        field(19; "Credit Amount (LCY)"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            BlankZero = true;            Caption = 'Credit Amount (LCY)';        }        field(20; "Initial Entry Due Date"; Date)        {            Caption = 'Initial Entry Due Date';            ToolTip = 'Specifies the date on which the initial entry is due for payment.';        }        field(21; "Initial Entry Global Dim. 1"; Code[20])        {            Caption = 'Initial Entry Global Dim. 1';            ToolTip = 'Specifies the Global Dimension 1 code of the initial vendor ledger entry.';            TableRelation = "Dimension Value".Code where("Global Dimension No." = const(1));        }        field(22; "Initial Entry Global Dim. 2"; Code[20])        {            Caption = 'Initial Entry Global Dim. 2';            ToolTip = 'Specifies the Global Dimension 2 code of the initial vendor ledger entry.';            TableRelation = "Dimension Value".Code where("Global Dimension No." = const(2));        }        field(24; "Gen. Bus. Posting Group"; Code[20])        {            Caption = 'Gen. Bus. Posting Group';            TableRelation = "Gen. Business Posting Group";        }        field(25; "Gen. Prod. Posting Group"; Code[20])        {            Caption = 'Gen. Prod. Posting Group';            TableRelation = "Gen. Product Posting Group";        }        field(29; "Use Tax"; Boolean)        {            Caption = 'Use Tax';        }        field(30; "VAT Bus. Posting Group"; Code[20])        {            Caption = 'VAT Bus. Posting Group';            TableRelation = "VAT Business Posting Group";        }        field(31; "VAT Prod. Posting Group"; Code[20])        {            Caption = 'VAT Prod. Posting Group';            TableRelation = "VAT Product Posting Group";        }        field(35; "Initial Document Type"; Enum "Gen. Journal Document Type")        {            Caption = 'Initial Document Type';            ToolTip = 'Specifies the document type that the initial vendor ledger entry was created with.';        }        field(36; "Applied Vend. Ledger Entry No."; Integer)        {            Caption = 'Applied Vend. Ledger Entry No.';        }        field(37; Unapplied; Boolean)        {            Caption = 'Unapplied';            ToolTip = 'Specifies whether the entry has been unapplied (undone) from the Unapply Vendor Entries window by the entry no. shown in the Unapplied by Entry No. field.';        }        field(38; "Unapplied by Entry No."; Integer)        {            Caption = 'Unapplied by Entry No.';            ToolTip = 'Specifies the number of the correcting entry, if the original entry has been unapplied (undone) from the Unapply Vendor Entries window.';            TableRelation = "Detailed Vendor Ledg. Entry";        }        field(39; "Remaining Pmt. Disc. Possible"; Decimal)        {            AutoFormatExpression = Rec."Currency Code";            AutoFormatType = 1;            Caption = 'Remaining Pmt. Disc. Possible';        }        field(40; "Max. Payment Tolerance"; Decimal)        {            AutoFormatExpression = Rec."Currency Code";            AutoFormatType = 1;            Caption = 'Max. Payment Tolerance';        }        field(41; "Tax Jurisdiction Code"; Code[10])        {            Caption = 'Tax Jurisdiction Code';            Editable = false;            TableRelation = "Tax Jurisdiction";        }        field(42; "Application No."; Integer)        {            Caption = 'Application No.';            Editable = false;        }        field(43; "Ledger Entry Amount"; Boolean)        {            Caption = 'Ledger Entry Amount';            Editable = false;        }        field(44; "Posting Group"; Code[20])        {            Caption = 'Vendor Posting Group';            ToolTip = 'Specifies the vendor''s market type to link business transactions to.';            Editable = false;            TableRelation = "Vendor Posting Group";        }        field(45; "Exch. Rate Adjmt. Reg. No."; Integer)        {            Caption = 'Exch. Rate Adjmt. Reg. No.';            Editable = false;            TableRelation = "Exch. Rate Adjmt. Reg.";        }        field(95; "G/L Register No."; Integer)        {            Caption = 'G/L Register No.';            Editable = false;            TableRelation = "G/L Register";            ToolTip = 'Specifies the G/L register number that groups related G/L entries from the same posting.';        }        field(7000004; "Excluded from calculation"; Boolean)        {            Caption = 'Excluded from calculation';            Editable = false;        }    }    keys    {        key(Key1; "Entry No.")        {            Clustered = true;        }        key(Key2; "Vendor No.", "Currency Code", "Excluded from calculation")        {            SumIndexFields = Amount, "Amount (LCY)";        }        key(Key3; "Vendor Ledger Entry No.", "Entry Type", "Posting Date")        {            IncludedFields = Amount, "Amount (LCY)";        }        key(Key4; "Vendor Ledger Entry No.", "Ledger Entry Amount", "Posting Date", "Excluded from calculation")        {            IncludedFields = "Currency Code", Amount, "Amount (LCY)", "Debit Amount", "Credit Amount", "Debit Amount (LCY)", "Credit Amount (LCY)";        }        key(Key5; "Initial Document Type", "Entry Type", "Vendor No.", "Currency Code", "Initial Entry Global Dim. 1", "Initial Entry Global Dim. 2", "Posting Date")        {            IncludedFields = Amount, "Amount (LCY)";        }        key(Key6; "Vendor No.", "Currency Code", "Initial Entry Global Dim. 1", "Initial Entry Global Dim. 2", "Initial Entry Due Date", "Posting Date", "Excluded from calculation")        {            IncludedFields = Amount, "Amount (LCY)";        }        key(Key7; "Document No.", "Document Type", "Posting Date")        {        }        key(Key8; "Applied Vend. Ledger Entry No.", "Entry Type")        {        }        key(Key9; "Transaction No.", "Vendor No.", "Entry Type")        {        }        key(Key10; "Application No.", "Vendor No.", "Entry Type")        {        }        key(Key11; "Initial Document Type", "Initial Entry Due Date")        {            SumIndexFields = "Amount (LCY)";        }        key(Key12; "Vendor No.", "Entry Type", "Posting Date")        {            IncludedFields = Amount, "Amount (LCY)", "Debit Amount", "Credit Amount", "Debit Amount (LCY)", "Credit Amount (LCY)";        }    }    fieldgroups    {        fieldgroup(DropDown; "Entry No.", "Vendor Ledger Entry No.", "Vendor No.", "Posting Date", "Document Type", "Document No.")        {        }    }    trigger OnInsert()    begin        SetLedgerEntryAmount();    end;    [InherentPermissions(PermissionObjectType::TableData, Database::"Detailed Vendor Ledg. Entry", 'r')]    procedure GetLastEntryNo(): Integer;    var        FindRecordManagement: Codeunit "Find Record Management";    begin        exit(FindRecordManagement.GetLastEntryIntFieldValue(Rec, FieldNo("Entry No.")))    end;    procedure UpdateDebitCredit(Correction: Boolean)    begin        if ((Amount > 0) or ("Amount (LCY)" > 0)) and not Correction or           ((Amount < 0) or ("Amount (LCY)" < 0)) and Correction        then begin            "Debit Amount" := Amount;            "Credit Amount" := 0;            "Debit Amount (LCY)" := "Amount (LCY)";            "Credit Amount (LCY)" := 0;        end else begin            "Debit Amount" := 0;            "Credit Amount" := -Amount;            "Debit Amount (LCY)" := 0;            "Credit Amount (LCY)" := -"Amount (LCY)";        end;        OnAfterUpdateDebitCredit(rec, Correction);    end;    procedure SetZeroTransNo(TransactionNo: Integer)    var        DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry";        ApplicationNo: Integer;    begin        DetailedVendorLedgEntry.SetCurrentKey("Transaction No.");        DetailedVendorLedgEntry.SetRange("Transaction No.", TransactionNo);        if DetailedVendorLedgEntry.FindSet(true) then begin            ApplicationNo := DetailedVendorLedgEntry."Entry No.";            repeat                DetailedVendorLedgEntry."Transaction No." := 0;                DetailedVendorLedgEntry."Application No." := ApplicationNo;                OnSetZeroTransNoOnBeforeDetailedVendorLedgEntryModify(DetailedVendorLedgEntry);                DetailedVendorLedgEntry.Modify();            until DetailedVendorLedgEntry.Next() = 0;        end;    end;    local procedure SetLedgerEntryAmount()    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeSetLedgerEntryAmount(Rec, IsHandled);        if IsHandled then            exit;        "Ledger Entry Amount" :=          not (("Entry Type" = "Entry Type"::Application) or ("Entry Type" = "Entry Type"::"Appln. Rounding"));    end;    procedure GetUnrealizedGainLossAmount(EntryNo: Integer): Decimal    begin        SetCurrentKey("Vendor Ledger Entry No.", "Entry Type");        SetRange("Vendor Ledger Entry No.", EntryNo);        SetRange("Entry Type", "Entry Type"::"Unrealized Loss", "Entry Type"::"Unrealized Gain");        CalcSums("Amount (LCY)");        exit("Amount (LCY)");    end;    [IntegrationEvent(false, false)]    local procedure OnAfterUpdateDebitCredit(var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry"; Correction: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeSetLedgerEntryAmount(var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnSetZeroTransNoOnBeforeDetailedVendorLedgEntryModify(var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry")    begin    end;}