Table 6108 E-Doc. Vendor Assign. History
src/Apps/W1/EDocument/App/src/Processing/Import/Purchase/History/EDocVendorAssignHistory.Table.al76 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.EServices.EDocument.Processing.Import.Purchase;using Microsoft.Purchases.History;using Microsoft.Purchases.Vendor;/// <summary>/// This table stores historical vendor information from received e-documents and the posted document they ended up in. When new e-documents are received, the information in this table can be leveraged to for example assign the same vendor to the e-document./// </summary>table 6108 "E-Doc. Vendor Assign. History"{ Caption = 'E-Document Vendor Assignment History'; DataClassification = CustomerContent; InherentEntitlements = RIMDX; InherentPermissions = RIMDX; Access = Internal; ReplicateData = false; fields { field(1; "Entry No."; Integer) { Caption = 'Entry No.'; DataClassification = SystemMetadata; Editable = false; AutoIncrement = true; } field(2; "Vendor Company Name"; Text[250]) { Caption = 'Vendor Company Name'; DataClassification = CustomerContent; } field(3; "Vendor Address"; Text[250]) { Caption = 'Vendor Address'; DataClassification = CustomerContent; } field(4; "Vendor VAT Id"; Text[100]) { Caption = 'Vendor VAT Id'; DataClassification = CustomerContent; } field(5; "Vendor GLN"; Text[13]) { Caption = 'Vendor GLN'; DataClassification = CustomerContent; } field(20; "Purch. Inv. Header SystemId"; Guid) { Caption = 'Purchase Inv. Header SystemId'; DataClassification = SystemMetadata; Editable = false; TableRelation = "Purch. Inv. Header".SystemId; } field(21; "Vendor No From Purch. Header"; Code[20]) { Caption = 'Vendor No From Purch. Header'; FieldClass = FlowField; CalcFormula = lookup("Purch. Inv. Header"."Buy-from Vendor No." where(SystemId = field("Purch. Inv. Header SystemId"))); TableRelation = Vendor."No."; } } keys { key(Key1; "Entry No.") { Clustered = true; } key(Key2; "Vendor VAT Id", "Vendor GLN", "Vendor Address", "Vendor Company Name") { } }}