XmlPort 1000 SEPA CT pain.001.001.03

Base Application, Microsoft.Bank.DirectDebit

src/Layers/W1/BaseApp/Bank/DirectDebit/SEPACTpain00100103.XmlPort.al491 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.Bank.DirectDebit;using Microsoft.Bank.Payment;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Foundation.Company;using System.Telemetry;/// <summary>/// XMLPort for exporting SEPA credit transfers in pain.001.001.03 format./// Generates XML files compliant with SEPA Customer Credit Transfer Initiation standard/// for submission to banks for automated payment processing./// </summary>xmlport 1000 "SEPA CT pain.001.001.03"{    Caption = 'SEPA CT pain.001.001.03';    DefaultNamespace = 'urn:iso:std:iso:20022:tech:xsd:pain.001.001.03';    Direction = Export;    Encoding = UTF8;    FormatEvaluate = Xml;    UseDefaultNamespace = true;    schema    {        tableelement("Gen. Journal Line"; "Gen. Journal Line")        {            XmlName = 'Document';            UseTemporary = true;            tableelement(companyinformation; "Company Information")            {                XmlName = 'CstmrCdtTrfInitn';                textelement(GrpHdr)                {                    textelement(messageid)                    {                        XmlName = 'MsgId';                    }                    textelement(createddatetime)                    {                        XmlName = 'CreDtTm';                    }                    textelement(nooftransfers)                    {                        XmlName = 'NbOfTxs';                    }                    textelement(controlsum)                    {                        XmlName = 'CtrlSum';                    }                    textelement(InitgPty)                    {                        fieldelement(Nm; CompanyInformation.Name)                        {                        }                        textelement(initgptypstladr)                        {                            XmlName = 'PstlAdr';                            fieldelement(StrtNm; CompanyInformation.Address)                            {                                trigger OnBeforePassField()                                begin                                    if CompanyInformation.Address = '' then                                        currXMLport.Skip();                                end;                            }                            fieldelement(PstCd; CompanyInformation."Post Code")                            {                                trigger OnBeforePassField()                                begin                                    if CompanyInformation."Post Code" = '' then                                        currXMLport.Skip();                                end;                            }                            fieldelement(TwnNm; CompanyInformation.City)                            {                                trigger OnBeforePassField()                                begin                                    if CompanyInformation.City = '' then                                        currXMLport.Skip();                                end;                            }                            fieldelement(Ctry; CompanyInformation."Country/Region Code")                            {                                trigger OnBeforePassField()                                begin                                    if CompanyInformation."Country/Region Code" = '' then                                        currXMLport.Skip();                                end;                            }                        }                        textelement(initgptyid)                        {                            XmlName = 'Id';                            textelement(initgptyorgid)                            {                                XmlName = 'OrgId';                                textelement(initgptyothrinitgpty)                                {                                    XmlName = 'Othr';                                    fieldelement(Id; CompanyInformation."VAT Registration No.")                                    {                                    }                                }                            }                        }                    }                }                tableelement(paymentexportdatagroup; "Payment Export Data")                {                    XmlName = 'PmtInf';                    UseTemporary = true;                    fieldelement(PmtInfId; PaymentExportDataGroup."Payment Information ID")                    {                    }                    fieldelement(PmtMtd; PaymentExportDataGroup."SEPA Payment Method Text")                    {                    }                    fieldelement(BtchBookg; PaymentExportDataGroup."SEPA Batch Booking")                    {                    }                    fieldelement(NbOfTxs; PaymentExportDataGroup."Line No.")                    {                    }                    fieldelement(CtrlSum; PaymentExportDataGroup.Amount)                    {                    }                    textelement(PmtTpInf)                    {                        fieldelement(InstrPrty; PaymentExportDataGroup."SEPA Instruction Priority Text")                        {                        }                    }                    fieldelement(ReqdExctnDt; PaymentExportDataGroup."Transfer Date")                    {                    }                    textelement(Dbtr)                    {                        fieldelement(Nm; CompanyInformation.Name)                        {                        }                        textelement(dbtrpstladr)                        {                            XmlName = 'PstlAdr';                            fieldelement(StrtNm; CompanyInformation.Address)                            {                                trigger OnBeforePassField()                                begin                                    if CompanyInformation.Address = '' then                                        currXMLport.Skip();                                end;                            }                            fieldelement(PstCd; CompanyInformation."Post Code")                            {                                trigger OnBeforePassField()                                begin                                    if CompanyInformation."Post Code" = '' then                                        currXMLport.Skip();                                end;                            }                            fieldelement(TwnNm; CompanyInformation.City)                            {                                trigger OnBeforePassField()                                begin                                    if CompanyInformation.City = '' then                                        currXMLport.Skip();                                end;                            }                            fieldelement(Ctry; CompanyInformation."Country/Region Code")                            {                                trigger OnBeforePassField()                                begin                                    if CompanyInformation."Country/Region Code" = '' then                                        currXMLport.Skip();                                end;                            }                        }                        textelement(dbtrid)                        {                            XmlName = 'Id';                            textelement(dbtrorgid)                            {                                XmlName = 'OrgId';                                fieldelement(BICOrBEI; PaymentExportDataGroup."Sender Bank BIC")                                {                                }                            }                            trigger OnBeforePassVariable()                            begin                                if PaymentExportDataGroup."Sender Bank BIC" = '' then                                    currXMLport.Skip();                            end;                        }                    }                    textelement(DbtrAcct)                    {                        textelement(dbtracctid)                        {                            XmlName = 'Id';                            fieldelement(IBAN; PaymentExportDataGroup."Sender Bank Account No.")                            {                                MaxOccurs = Once;                                MinOccurs = Once;                            }                        }                    }                    textelement(DbtrAgt)                    {                        textelement(dbtragtfininstnid)                        {                            XmlName = 'FinInstnId';                            fieldelement(BIC; PaymentExportDataGroup."Sender Bank BIC")                            {                                MaxOccurs = Once;                                MinOccurs = Once;                            }                        }                        trigger OnBeforePassVariable()                        begin                            if PaymentExportDataGroup."Sender Bank BIC" = '' then                                currXMLport.Skip();                        end;                    }                    fieldelement(ChrgBr; PaymentExportDataGroup."SEPA Charge Bearer Text")                    {                    }                    tableelement(paymentexportdata; "Payment Export Data")                    {                        LinkFields = "Sender Bank BIC" = field("Sender Bank BIC"), "SEPA Instruction Priority Text" = field("SEPA Instruction Priority Text"), "Transfer Date" = field("Transfer Date"), "SEPA Batch Booking" = field("SEPA Batch Booking"), "SEPA Charge Bearer Text" = field("SEPA Charge Bearer Text");                        LinkTable = PaymentExportDataGroup;                        XmlName = 'CdtTrfTxInf';                        UseTemporary = true;                        textelement(PmtId)                        {                            fieldelement(EndToEndId; PaymentExportData."End-to-End ID")                            {                            }                        }                        textelement(Amt)                        {                            fieldelement(InstdAmt; PaymentExportData.Amount)                            {                                fieldattribute(Ccy; PaymentExportData."Currency Code")                                {                                }                            }                        }                        textelement(CdtrAgt)                        {                            textelement(cdtragtfininstnid)                            {                                XmlName = 'FinInstnId';                                fieldelement(BIC; PaymentExportData."Recipient Bank BIC")                                {                                    FieldValidate = yes;                                }                            }                            trigger OnBeforePassVariable()                            begin                                if PaymentExportData."Recipient Bank BIC" = '' then                                    currXMLport.Skip();                            end;                        }                        textelement(Cdtr)                        {                            fieldelement(Nm; PaymentExportData."Recipient Name")                            {                            }                            textelement(cdtrpstladr)                            {                                XmlName = 'PstlAdr';                                fieldelement(StrtNm; PaymentExportData."Recipient Address")                                {                                    trigger OnBeforePassField()                                    begin                                        if PaymentExportData."Recipient Address" = '' then                                            currXMLport.Skip();                                    end;                                }                                fieldelement(PstCd; PaymentExportData."Recipient Post Code")                                {                                    trigger OnBeforePassField()                                    begin                                        if PaymentExportData."Recipient Post Code" = '' then                                            currXMLport.Skip();                                    end;                                }                                fieldelement(TwnNm; PaymentExportData."Recipient City")                                {                                    trigger OnBeforePassField()                                    begin                                        if PaymentExportData."Recipient City" = '' then                                            currXMLport.Skip();                                    end;                                }                                fieldelement(Ctry; PaymentExportData."Recipient Country/Region Code")                                {                                    trigger OnBeforePassField()                                    begin                                        if PaymentExportData."Recipient Country/Region Code" = '' then                                            currXMLport.Skip();                                    end;                                }                                trigger OnBeforePassVariable()                                begin                                    if (PaymentExportData."Recipient Address" = '') and                                       (PaymentExportData."Recipient Post Code" = '') and                                       (PaymentExportData."Recipient City" = '') and                                       (PaymentExportData."Recipient Country/Region Code" = '')                                    then                                        currXMLport.Skip();                                end;                            }                        }                        textelement(CdtrAcct)                        {                            textelement(cdtracctid)                            {                                XmlName = 'Id';                                fieldelement(IBAN; PaymentExportData."Recipient Bank Acc. No.")                                {                                    FieldValidate = yes;                                    MaxOccurs = Once;                                    MinOccurs = Once;                                }                            }                        }                        textelement(RmtInf)                        {                            MinOccurs = Zero;                            textelement(remittancetext)                            {                                MinOccurs = Zero;                                XmlName = 'Ustrd';                            }                            trigger OnBeforePassVariable()                            var                                SeparatorText: Text;                                IsHandled: Boolean;                            begin                                IsHandled := false;                                OnBeforePassVariableRmtInf(PaymentExportData, RemittanceText, IsHandled);                                if IsHandled then                                    exit;                                RemittanceText := '';                                TempPaymentExportRemittanceText.SetRange("Pmt. Export Data Entry No.", PaymentExportData."Entry No.");                                if not TempPaymentExportRemittanceText.FindSet() then                                    currXMLport.Skip();                                RemittanceText := TempPaymentExportRemittanceText.Text;                                if TempPaymentExportRemittanceText.Next() = 0 then                                    exit;                                SeparatorText := ', ';                                OnSpecifyRemittanceTextSeparatorText(SeparatorText);                                RemittanceText := CopyStr(                                    StrSubstNo('%1%2%3', RemittanceText, SeparatorText, TempPaymentExportRemittanceText.Text), 1, 140);                            end;                        }                    }                }                trigger OnAfterGetRecord()                begin                    if not PaymentExportData.GetPreserveNonLatinCharacters() then                        PaymentExportData.CompanyInformationConvertToLatin(CompanyInformation);                end;            }        }    }    requestpage    {        layout        {        }        actions        {        }    }    trigger OnPreXmlPort()    var        FeatureTelemetry: Codeunit "Feature Telemetry";        SEPACTExportFile: Codeunit "SEPA CT-Export File";    begin        FeatureTelemetry.LogUptake('0000N1X', SEPACTExportFile.FeatureName(), Enum::"Feature Uptake Status"::Used);        FeatureTelemetry.LogUsage('0000N1Y', SEPACTExportFile.FeatureName(), 'XmlPort SEPA CT pain.001.001.03');        InitData();    end;    var        TempPaymentExportRemittanceText: Record "Payment Export Remittance Text" temporary;        NoDataToExportErr: Label 'There is no data to export.', Comment = '%1=Field;%2=Value;%3=Value';    local procedure InitData()    var        SEPACTFillExportBuffer: Codeunit "SEPA CT-Fill Export Buffer";        PaymentGroupNo: Integer;    begin        SEPACTFillExportBuffer.FillExportBuffer("Gen. Journal Line", PaymentExportData);        PaymentExportData.GetRemittanceTexts(TempPaymentExportRemittanceText);        NoOfTransfers := Format(PaymentExportData.Count);        MessageID := PaymentExportData."Message ID";        CreatedDateTime := Format(CurrentDateTime, 19, 9);        PaymentExportData.CalcSums(Amount);        ControlSum := Format(PaymentExportData.Amount, 0, 9);        PaymentExportData.SetCurrentKey(          "Sender Bank BIC", "SEPA Instruction Priority Text", "Transfer Date",          "SEPA Batch Booking", "SEPA Charge Bearer Text");        if not PaymentExportData.FindSet() then            Error(NoDataToExportErr);        InitPmtGroup();        repeat            if IsNewGroup() then begin                InsertPmtGroup(PaymentGroupNo);                InitPmtGroup();            end;            PaymentExportDataGroup."Line No." += 1;            PaymentExportDataGroup.Amount += PaymentExportData.Amount;        until PaymentExportData.Next() = 0;        InsertPmtGroup(PaymentGroupNo);    end;    local procedure IsNewGroup(): Boolean    begin        exit(          (PaymentExportData."Sender Bank BIC" <> PaymentExportDataGroup."Sender Bank BIC") or          (PaymentExportData."SEPA Instruction Priority Text" <> PaymentExportDataGroup."SEPA Instruction Priority Text") or          (PaymentExportData."Transfer Date" <> PaymentExportDataGroup."Transfer Date") or          (PaymentExportData."SEPA Batch Booking" <> PaymentExportDataGroup."SEPA Batch Booking") or          (PaymentExportData."SEPA Charge Bearer Text" <> PaymentExportDataGroup."SEPA Charge Bearer Text"));    end;    local procedure InitPmtGroup()    begin        PaymentExportDataGroup := PaymentExportData;        PaymentExportDataGroup."Line No." := 0; // used for counting transactions within group        PaymentExportDataGroup.Amount := 0; // used for summarizing transactions within group    end;    local procedure InsertPmtGroup(var PaymentGroupNo: Integer)    begin        PaymentGroupNo += 1;        PaymentExportDataGroup."Entry No." := PaymentGroupNo;        PaymentExportDataGroup."Payment Information ID" :=          CopyStr(            StrSubstNo('%1/%2', PaymentExportData."Message ID", PaymentGroupNo),            1, MaxStrLen(PaymentExportDataGroup."Payment Information ID"));        PaymentExportDataGroup.Insert();    end;    [IntegrationEvent(false, false)]    local procedure OnSpecifyRemittanceTextSeparatorText(var SeparatorText: Text)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforePassVariableRmtInf(PaymentExportData: Record "Payment Export Data"; var RemittanceText: Text; var IsHandled: Boolean)    begin    end;}