Table 380 Detailed Vendor Ledg. Entry
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;}