Table 6103 E-Document Service
src/Apps/W1/EDocument/App/src/Service/EDocumentService.Table.al440 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;using Microsoft.eServices.EDocument.Integration;using Microsoft.eServices.EDocument.Integration.Interfaces;using Microsoft.eServices.EDocument.Processing.Import;using Microsoft.Finance.GeneralLedger.Journal;table 6103 "E-Document Service"{ LookupPageId = "E-Document Services"; DrillDownPageId = "E-Document Services"; DataClassification = CustomerContent; fields { field(1; "Code"; Code[20]) { Caption = 'Code'; NotBlank = true; DataClassification = SystemMetadata; } field(2; Description; Text[250]) { Caption = 'Description'; } field(3; "Document Format"; Enum "E-Document Format") { Caption = 'Document Format'; DataClassification = SystemMetadata; }#if not CLEANSCHEMA29#pragma warning disable AL0432 field(4; "Service Integration"; Enum "E-Document Integration")#pragma warning restore AL0432 { Caption = 'Service Integration'; DataClassification = SystemMetadata; ObsoleteReason = 'Use Service Integration V2 integration enum instead';#if CLEAN26 ObsoleteState = Removed; ObsoleteTag = '29.0';#else ObsoleteState = Pending; ObsoleteTag = '26.0'; trigger OnValidate() var ConsentManagerDefaultImpl: Codeunit "Consent Manager Default Impl."; begin if (xRec."Service Integration" = xRec."Service Integration"::"No Integration") and (Rec."Service Integration" <> xRec."Service Integration") then if not ConsentManagerDefaultImpl.ObtainPrivacyConsent() then Rec."Service Integration" := xRec."Service Integration"; end;#endif }#endif field(5; "Use Batch Processing"; Boolean) { Caption = 'Use Batch Processing'; DataClassification = SystemMetadata; trigger OnValidate() begin EDocumentBackgroundJobs.HandleRecurrentBatchJob(Rec); end; } field(6; "Update Order"; Boolean) { Caption = 'Update Order'; } field(7; "Create Journal Lines"; Boolean) { Caption = 'Create Journal Lines'; DataClassification = SystemMetadata; } field(8; "Validate Receiving Company"; Boolean) { Caption = 'Validate Receiving Company'; InitValue = true; DataClassification = SystemMetadata; } field(9; "Resolve Unit Of Measure"; Boolean) { Caption = 'Resolve Unit Of Measure'; InitValue = true; DataClassification = SystemMetadata; } field(10; "Lookup Item Reference"; Boolean) { Caption = 'Lookup Item Reference'; InitValue = true; DataClassification = SystemMetadata; } field(11; "Lookup Item GTIN"; Boolean) { Caption = 'Lookup Item GTIN'; InitValue = true; DataClassification = SystemMetadata; } field(12; "Lookup Account Mapping"; Boolean) { Caption = 'Lookup Account Mapping'; InitValue = true; DataClassification = SystemMetadata; } field(13; "Validate Line Discount"; Boolean) { Caption = 'Validate Line Discount'; InitValue = true; DataClassification = SystemMetadata; } field(14; "Apply Invoice Discount"; Boolean) { Caption = 'Apply Invoice Discount'; InitValue = true; DataClassification = SystemMetadata; } field(15; "Verify Totals"; Boolean) { Caption = 'Verify Totals'; InitValue = true; DataClassification = SystemMetadata; } field(16; "General Journal Template Name"; Code[10]) { Caption = 'General Journal Template Name'; TableRelation = "Gen. Journal Template"; trigger OnValidate() var GenJournalTemplate: Record "Gen. Journal Template"; xGenJournalTemplate: Record "Gen. Journal Template"; begin if "General Journal Template Name" = '' then begin "General Journal Batch Name" := ''; exit; end; GenJournalTemplate.Get("General Journal Template Name"); if not (GenJournalTemplate.Type in [GenJournalTemplate.Type::General, GenJournalTemplate.Type::Purchases, GenJournalTemplate.Type::Payments, GenJournalTemplate.Type::Sales, GenJournalTemplate.Type::"Cash Receipts"]) then Error( TemplateTypeErr, GenJournalTemplate.Type::General, GenJournalTemplate.Type::Purchases, GenJournalTemplate.Type::Payments, GenJournalTemplate.Type::Sales, GenJournalTemplate.Type::"Cash Receipts"); if xRec."General Journal Template Name" <> '' then if xGenJournalTemplate.Get(xRec."General Journal Template Name") then; if GenJournalTemplate.Type <> xGenJournalTemplate.Type then "General Journal Batch Name" := ''; end; } field(17; "General Journal Batch Name"; Code[10]) { Caption = 'General Journal Batch Name'; TableRelation = "Gen. Journal Batch".Name where("Journal Template Name" = field("General Journal Template Name")); DataClassification = SystemMetadata; trigger OnValidate() var GenJournalBatch: Record "Gen. Journal Batch"; begin if "General Journal Batch Name" <> '' then TestField("General Journal Template Name"); GenJournalBatch.Get("General Journal Template Name", "General Journal Batch Name"); GenJournalBatch.TestField(Recurring, false); end; } field(18; "Auto Import"; Boolean) { Caption = 'Auto Import'; DataClassification = SystemMetadata; InitValue = false; trigger OnValidate() begin EDocumentBackgroundJobs.HandleRecurrentImportJob(Rec); end; } field(19; "Import Start Time"; Time) { Caption = 'Import Start Time'; DataClassification = SystemMetadata; NotBlank = true; InitValue = 0T; trigger OnValidate() begin EDocumentBackgroundJobs.HandleRecurrentImportJob(Rec); end; } field(20; "Import Minutes between runs"; Integer) { Caption = 'Minutes between runs'; DataClassification = SystemMetadata; InitValue = 1440; trigger OnValidate() begin EDocumentBackgroundJobs.HandleRecurrentImportJob(Rec); end; } field(21; "Batch Mode"; Enum "E-Document Batch Mode") { Caption = 'Batch Mode'; DataClassification = SystemMetadata; } field(22; "Batch Threshold"; Integer) { Caption = 'Batch Threshold'; MinValue = 1; DataClassification = SystemMetadata; } field(23; "Batch Start Time"; Time) { Caption = 'Start Time'; DataClassification = SystemMetadata; NotBlank = true; InitValue = 0T; } field(24; "Batch Minutes between runs"; Integer) { Caption = 'Minutes between runs'; DataClassification = SystemMetadata; InitValue = 1440; } field(25; "Batch Recurrent Job Id"; Guid) { Caption = 'Batch Recurrent Job Id'; DataClassification = SystemMetadata; } field(26; "Import Recurrent Job Id"; Guid) { Caption = 'Batch Recurrent Job Id'; DataClassification = SystemMetadata; } field(27; "Service Integration V2"; Enum "Service Integration") { Caption = 'Service Integration V2'; ToolTip = 'Specifies the integration for sending documents to the service.'; DataClassification = SystemMetadata; trigger OnValidate() var ConsentManager: Interface IConsentManager; begin if (xRec."Service Integration V2" = xRec."Service Integration V2"::"No Integration") and (Rec."Service Integration V2" <> xRec."Service Integration V2") then begin ConsentManager := Rec."Service Integration V2"; if not ConsentManager.ObtainPrivacyConsent() then Rec."Service Integration V2" := xRec."Service Integration V2"; end; end; }#if not CLEANSCHEMA26 field(29; "E-Document Structured Format"; Integer) { Caption = 'Structured Data Format'; ToolTip = 'Specifies the format of the structured data.'; DataClassification = SystemMetadata; ObsoleteReason = 'Use the "Read into Draft Impl." field instead.'; ObsoleteState = Removed; ObsoleteTag = '26.0'; }#endif field(31; "Import Process"; Enum "E-Document Import Process") { Caption = 'Import Process'; DataClassification = SystemMetadata; InitValue = "Version 2.0"; ToolTip = 'Specifies the import process for the document.'; } field(32; "Automatic Import Processing"; Enum "E-Doc. Automatic Processing") { Caption = 'Automatic processing'; ToolTip = 'Specifies if the processing of a document should start automatically after it is imported.'; DataClassification = SystemMetadata; } field(33; "Read into Draft Impl."; Enum "E-Doc. Read into Draft") { Caption = 'Read into Draft'; ToolTip = 'Specifies how the inbound structured e-document should be read into a draft document.'; DataClassification = SystemMetadata; } field(40; "Embed PDF in export"; Boolean) { Caption = 'Embed document PDF to export'; ToolTip = 'Specifies whether you want to automatically create a PDF based on Report Selection, as a background process, and embed it into the E-Document export file when posting the document.'; DataClassification = SystemMetadata; } field(41; "Export Eligibility Evaluator"; Enum "Export Eligibility Evaluator") { Caption = 'Export Eligibility Evaluator'; ToolTip = 'Specifies the evaluator that determines if a document is eligible for export via this service.'; DataClassification = SystemMetadata; } field(42; "Item Charge E-Invoice Mapping"; Enum "Item Charge E-Invoice Mapping") { Caption = 'Item Charge Mapping'; ToolTip = 'Specifies how item charges on posted documents are represented in the e-documents that this service exports. Automatic classifies each item charge based on its assignment to invoice lines. Document Level Allowance/Charge exports every item charge as an allowance or charge of the whole document. Invoice Line Allowance/Charge exports it as an allowance or charge of the invoice line it is assigned to. Invoice Line with Unit Code exports it as a separate invoice line with a unit code. An item charge with its own E-Invoice Mapping overrides this setting.'; DataClassification = SystemMetadata; } #region [60-80] are reserved for purchase draft document settings. field(60; "Verify Purch. Total Amounts"; Boolean) { Caption = 'Verify purchase invoice total amounts'; ToolTip = 'Specifies whether the document totals of the purchase document should be verified.'; InitValue = true; DataClassification = SystemMetadata; } field(61; "Processing Customizations"; Enum "E-Doc. Proc. Customizations") { Caption = 'Processing customizations'; ToolTip = 'Specifies the customizations for the processing of e-documents processed the service.'; DataClassification = SystemMetadata; } #endregion [60-80] are reserved for purchase draft document settings. } keys { key(Key1; Code) { Clustered = true; } } trigger OnDelete() var EDocServiceSupportedType: Record "E-Doc. Service Supported Type"; EDocBackgroundJobs: Codeunit "E-Document Background Jobs"; EDocumentWorkflowProcesssing: Codeunit "E-Document WorkFlow Processing"; begin if EDocumentWorkflowProcesssing.IsServiceUsedInActiveWorkflow(Rec) then Error(ServiceInActiveFlowErr); EDocServiceSupportedType.SetRange("E-Document Service Code", Rec.Code); EDocServiceSupportedType.DeleteAll(); EDocBackgroundJobs.RemoveJob(Rec."Batch Recurrent Job Id"); EDocBackgroundJobs.RemoveJob(Rec."Import Recurrent Job Id"); end; [InherentPermissions(PermissionObjectType::TableData, Database::"E-Document Service", 'I')] internal procedure GetPDFReaderService() var EDocServiceSupportedType: Record "E-Doc. Service Supported Type"; begin if Rec.Get(AzureDocumentIntelligenceTok) then exit; Rec.Init(); Rec.Code := AzureDocumentIntelligenceTok; Rec."Import Process" := "Import Process"::"Version 2.0"; Rec.Description := AzureDocumentIntelligenceServiceTxt; Rec."Automatic Import Processing" := "E-Doc. Automatic Processing"::No; Rec."Verify Purch. Total Amounts" := true; Rec.Insert(true); EDocServiceSupportedType.InsertDefaultIfMissing(Rec.Code, "E-Document Type"::"Purchase Invoice", "E-Doc. Supp. Type Direction"::Incoming); EDocServiceSupportedType.InsertDefaultIfMissing(Rec.Code, "E-Document Type"::"Purchase Credit Memo", "E-Doc. Supp. Type Direction"::Incoming); end; internal procedure IsAutomaticProcessingEnabled(): Boolean begin exit(Rec."Automatic Import Processing" = Enum::"E-Doc. Automatic Processing"::Yes); end; internal procedure GetImportProcessVersion(): Enum "E-Document Import Process" begin exit(Rec."Import Process"); end; internal procedure LastEDocumentLog(EDocumentServiceStatus: Enum "E-Document Service Status") EDocumentLog: Record "E-Document Log"; begin EDocumentLog.SetRange("Service Code", Rec.Code); EDocumentLog.SetRange(Status, EDocumentServiceStatus); EDocumentLog.SetCurrentKey("Entry No."); if EDocumentLog.FindLast() then; end; internal procedure GetDefaultImportParameters() EDocImportParameters: Record "E-Doc. Import Parameters" begin if Rec."Import Process" = "Import Process"::"Version 1.0" then begin EDocImportParameters."Step to Run" := "Import E-Document Steps"::"Finish draft"; EDocImportParameters."Create Document V1 Behavior" := IsAutomaticProcessingEnabled(); end else if IsAutomaticProcessingEnabled() then EDocImportParameters."Step to Run" := "Import E-Document Steps"::"Finish draft" else begin EDocImportParameters."Step to Run / Desired Status" := EDocImportParameters."Step to Run / Desired Status"::"Desired E-Document Status"; EDocImportParameters."Desired E-Document Status" := EDocImportParameters."Desired E-Document Status"::Unprocessed; end; EDocImportParameters."Processing Customizations" := Rec."Processing Customizations"; end; internal procedure ToString(): Text begin#if not CLEAN26#pragma warning disable AL0432 exit(StrSubstNo(EDocStringLbl, SystemId, "Document Format", "Service Integration", "Use Batch Processing", "Batch Mode"));#pragma warning restore AL0432#else exit(StrSubstNo(EDocStringLbl, SystemId, "Document Format", "Service Integration V2", "Use Batch Processing", "Batch Mode"));#endif end; /// <summary> /// Gets the default file extension for the e-document service. /// </summary> /// <returns>The default file extension (e.g., '.xml'). Can be overridden via OnAfterGetDefaultFileExtension event.</returns> procedure GetDefaultFileExtension() FileExtension: Text var XMLFileTypeTok: Label '.xml', Locked = true; begin FileExtension := XMLFileTypeTok; OnAfterGetDefaultFileExtension(Rec, FileExtension); end; /// <summary> /// Integration event that allows subscribers to override the default file extension for the e-document service. /// </summary> /// <param name="EDocumentService">The E-Document Service record.</param> /// <param name="FileExtension">The file extension to be used. By default, it is set to '.xml'.</param> [IntegrationEvent(false, false)] local procedure OnAfterGetDefaultFileExtension(EDocumentService: Record "E-Document Service"; var FileExtension: Text) begin end; var EDocumentBackgroundJobs: Codeunit "E-Document Background Jobs"; AzureDocumentIntelligenceTok: Label 'MSEOCADI', Locked = true; AzureDocumentIntelligenceServiceTxt: Label 'E-Document PDF Service - Process pdfs with Azure Document Intelligence'; EDocStringLbl: Label '%1,%2,%3,%4,%5', Locked = true; TemplateTypeErr: Label 'Only General Journal Templates of type %1, %2, %3, %4, or %5 are allowed.', Comment = '%1 - General, %2 - Purchases, %3 - Payments, %4 - Sales, %5 - Cash, %6 - Receipts'; ServiceInActiveFlowErr: Label 'The service is used in an active workflow. You cannot delete it.';}