Codeunit 6408 E-Doc. PEPPOL DX Post-Mapping

E-Document Core, Microsoft.eServices.EDocument.Processing.Import

src/Apps/W1/EDocument/App/src/Processing/Import/StructureReceivedEDocument/EDocPEPPOLDXPostMapping.Codeunit.al229 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;using Microsoft.eServices.EDocument;using Microsoft.eServices.EDocument.Processing.Import.Purchase;using System.IO;/// <summary>/// Post-Mapping codeunit for PEPPOL BIS 3.0 Data Exchange import./// Registered as PostMappingCodeunit on the header DataExchMapping in the V2 definitions./// Runs inside ProcessDataExchange after the DataHandlingCodeunit (1214) has populated/// Intermediate Data Import. Handles two things://////   1. Compound header fields (schemeID:value endpoint identifier) that cannot be///      expressed as a declarative field mapping.//////   2. Document-level AllowanceCharge elements (PEPPOLCHARGELINES line def): writes///      them directly into Intermediate Data Import with Record Nos. above the existing///      invoice/credit-note lines, so the generic MapIntermediateToLines bridge picks///      them up in the correct order./// </summary>codeunit 6408 "E-Doc. PEPPOL DX Post-Mapping"{    Access = Internal;    InherentEntitlements = X;    InherentPermissions = X;    TableNo = "Data Exch.";    trigger OnRun()    var        EDocument: Record "E-Document";        EDocumentPurchaseHeader: Record "E-Document Purchase Header";        EDocumentRecordId: RecordId;    begin        EDocumentRecordId := Rec."Related Record";        EDocument := EDocumentRecordId.GetRecord();        EDocumentPurchaseHeader.GetFromEDocument(EDocument);        BuildEndpointIdentifiers(Rec, EDocumentPurchaseHeader);        EDocumentPurchaseHeader.Modify();        WriteChargeLinesToIntermediate(Rec);    end;    #region Endpoint Identifiers    local procedure BuildEndpointIdentifiers(DataExch: Record "Data Exch."; var EDocumentPurchaseHeader: Record "E-Document Purchase Header")    var        DataExchField: Record "Data Exch. Field";        DataExchColumnDef: Record "Data Exch. Column Def";        EndpointValue: Text;        EndpointScheme: Text;        ValueColNo: Integer;        SchemeColNo: Integer;    begin        DataExchColumnDef.SetRange("Data Exch. Def Code", DataExch."Data Exch. Def Code");        DataExchColumnDef.SetRange(Name, 'CustomerEndpointID');        if DataExchColumnDef.FindFirst() then            ValueColNo := DataExchColumnDef."Column No.";        DataExchColumnDef.SetRange(Name, 'CustomerEndpointSchemeID');        if DataExchColumnDef.FindFirst() then            SchemeColNo := DataExchColumnDef."Column No.";        if (ValueColNo = 0) or (SchemeColNo = 0) then            exit;        DataExchField.SetRange("Data Exch. No.", DataExch."Entry No.");        DataExchField.SetRange("Column No.", ValueColNo);        if DataExchField.FindFirst() then            EndpointValue := DataExchField.Value;        DataExchField.SetRange("Column No.", SchemeColNo);        if DataExchField.FindFirst() then            EndpointScheme := DataExchField.Value;        if (EndpointValue <> '') and (EndpointScheme <> '') then            EDocumentPurchaseHeader."Customer Company Id" :=                CopyStr(EndpointScheme + ':' + EndpointValue, 1, MaxStrLen(EDocumentPurchaseHeader."Customer Company Id"));    end;    #endregion Endpoint Identifiers    #region Charge Lines via Intermediate    /// <summary>    /// Reads PEPPOLCHARGELINES Data Exch. Field records and writes charge line data    /// into Intermediate Data Import (Table ID 6101) with Record Nos. above the existing    /// invoice/credit-note lines. The generic MapIntermediateToLines bridge then processes    /// them in Record No. order, placing charge lines after invoice lines.    /// </summary>    local procedure WriteChargeLinesToIntermediate(DataExch: Record "Data Exch.")    var        DataExchField: Record "Data Exch. Field";        DataExchColumnDef: Record "Data Exch. Column Def";        IntermediateDataImport: Record "Intermediate Data Import";        DescColNo: Integer;        AmountColNo: Integer;        VATRateColNo: Integer;        CurrencyColNo: Integer;        IndicatorColNo: Integer;        ParentRecordNo: Integer;        NextRecordNo: Integer;        CurrLineNo: Integer;        IsCharge: Boolean;        Description: Text[100];        Amount: Text[250];        VATRate: Text[250];        CurrencyCode: Text[250];    begin        DataExchColumnDef.SetRange("Data Exch. Def Code", DataExch."Data Exch. Def Code");        DataExchColumnDef.SetRange("Data Exch. Line Def Code", ChargeLineDefCodeTok);        DataExchColumnDef.SetRange(Name, 'ChargeDescription');        if DataExchColumnDef.FindFirst() then DescColNo := DataExchColumnDef."Column No.";        DataExchColumnDef.SetRange(Name, 'ChargeAmount');        if DataExchColumnDef.FindFirst() then AmountColNo := DataExchColumnDef."Column No.";        DataExchColumnDef.SetRange(Name, 'ChargeVATRate');        if DataExchColumnDef.FindFirst() then VATRateColNo := DataExchColumnDef."Column No.";        DataExchColumnDef.SetRange(Name, 'ChargeCurrencyCode');        if DataExchColumnDef.FindFirst() then CurrencyColNo := DataExchColumnDef."Column No.";        DataExchColumnDef.SetRange(Name, 'ChargeIndicator');        if DataExchColumnDef.FindFirst() then IndicatorColNo := DataExchColumnDef."Column No.";        if DescColNo = 0 then            exit;        // Find the header's intermediate Record No. to use as Parent Record No. for lines.        IntermediateDataImport.SetRange("Data Exch. No.", DataExch."Entry No.");        IntermediateDataImport.SetRange("Table ID", Database::"E-Document Purchase Header");        IntermediateDataImport.SetRange("Parent Record No.", 0);        if not IntermediateDataImport.FindFirst() then            exit;        ParentRecordNo := IntermediateDataImport."Record No.";        // Start charge lines after all existing purchase line intermediate records.        IntermediateDataImport.SetRange("Table ID", Database::"E-Document Purchase Line");        IntermediateDataImport.SetRange("Parent Record No.");        if IntermediateDataImport.FindLast() then            NextRecordNo := IntermediateDataImport."Record No." + 1        else            NextRecordNo := 1;        DataExchField.SetRange("Data Exch. No.", DataExch."Entry No.");        DataExchField.SetRange("Data Exch. Line Def Code", ChargeLineDefCodeTok);        DataExchField.SetCurrentKey("Line No.", "Column No.");        if not DataExchField.FindSet() then            exit;        CurrLineNo := -1;        IsCharge := false;        repeat            if CurrLineNo <> DataExchField."Line No." then begin                if (CurrLineNo <> -1) and IsCharge then                    InsertChargeLineIntermediate(DataExch."Entry No.", NextRecordNo, ParentRecordNo,                        Description, Amount, VATRate, CurrencyCode);                CurrLineNo := DataExchField."Line No.";                IsCharge := false;                Clear(Description);                Clear(Amount);                Clear(VATRate);                Clear(CurrencyCode);            end;            case DataExchField."Column No." of                DescColNo:                    Description := CopyStr(DataExchField.Value, 1, MaxStrLen(Description));                AmountColNo:                    Amount := DataExchField.Value;                VATRateColNo:                    VATRate := DataExchField.Value;                CurrencyColNo:                    CurrencyCode := DataExchField.Value;                IndicatorColNo:                    IsCharge := LowerCase(DataExchField.Value) = 'true';            end;        until DataExchField.Next() = 0;        if (CurrLineNo <> -1) and IsCharge then            InsertChargeLineIntermediate(DataExch."Entry No.", NextRecordNo, ParentRecordNo,                Description, Amount, VATRate, CurrencyCode);    end;    local procedure InsertChargeLineIntermediate(DataExchNo: Integer; var NextRecordNo: Integer; ParentRecordNo: Integer; Description: Text[100]; Amount: Text[250]; VATRate: Text[250]; CurrencyCode: Text[250])    var        EDocumentPurchaseLine: Record "E-Document Purchase Line";    begin        InsertIntermediateField(DataExchNo, NextRecordNo, ParentRecordNo,            EDocumentPurchaseLine.FieldNo(Quantity), '1');        if Description <> '' then            InsertIntermediateField(DataExchNo, NextRecordNo, ParentRecordNo,                EDocumentPurchaseLine.FieldNo(Description), Description);        if Amount <> '' then begin            InsertIntermediateField(DataExchNo, NextRecordNo, ParentRecordNo,                EDocumentPurchaseLine.FieldNo("Unit Price"), Amount);            InsertIntermediateField(DataExchNo, NextRecordNo, ParentRecordNo,                EDocumentPurchaseLine.FieldNo("Sub Total"), Amount);        end;        if VATRate <> '' then            InsertIntermediateField(DataExchNo, NextRecordNo, ParentRecordNo,                EDocumentPurchaseLine.FieldNo("VAT Rate"), VATRate);        if CurrencyCode <> '' then            InsertIntermediateField(DataExchNo, NextRecordNo, ParentRecordNo,                EDocumentPurchaseLine.FieldNo("Currency Code"), CurrencyCode);        NextRecordNo += 1;    end;    local procedure InsertIntermediateField(DataExchNo: Integer; RecordNo: Integer; ParentRecordNo: Integer; FieldId: Integer; Value: Text)    var        IntermediateDataImport: Record "Intermediate Data Import";    begin        IntermediateDataImport.Init();        IntermediateDataImport.Validate("Data Exch. No.", DataExchNo);        IntermediateDataImport.Validate("Table ID", Database::"E-Document Purchase Line");        IntermediateDataImport.Validate("Record No.", RecordNo);        IntermediateDataImport.Validate("Field ID", FieldId);        IntermediateDataImport.Validate("Parent Record No.", ParentRecordNo);        IntermediateDataImport.SetValueWithoutModifying(Value);        IntermediateDataImport.Insert(true);    end;    #endregion Charge Lines via Intermediate    var        ChargeLineDefCodeTok: Label 'PEPPOLCHARGELINES', Locked = true;}