---
title: "Table 1226 Payment Export Data"
author: "Jonas Paprotka"
url: https://jonas-paprotka.de/ref/table/1226-payment-export-data/
type: table
id: 1226
name: "Payment Export Data"
app: "Base Application"
namespace: Microsoft.Bank.Payment
versions: "17-28"
build: 28.5.54151.54365
source: "https://jonas-paprotka.de/ref/table/1226-payment-export-data/source/29/"
checked: 2026-09-20
subject: "Microsoft Dynamics 365 Business Central"
license: "Content © 2026 Jonas Paprotka. Quote freely with attribution and a link."
---

# Table 1226 Payment Export Data

Jonas Paprotka, https://jonas-paprotka.de/ref/table/1226-payment-export-data/

| | |
| --- | --- |
| App | Base Application |
| Namespace | Microsoft.Bank.Payment |
| Versions | 17-28 |
| Source file | Bank/Payment/PaymentExportData.Table.al |

## Fields

| Id | Name | Type | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| 1 | Entry No. | Integer | 17-28 | - | - |
| 2 | Data Exch Entry No. | Integer | 17-28 | - | - |
| 3 | Line No. | Integer | 17-28 | - | - |
| 4 | Data Exch. Line Def Code | Code[20] | 17-28 | - | - |
| 5 | General Journal Template | Code[10] | 17-28 | - | - |
| 6 | General Journal Batch Name | Code[10] | 17-28 | - | - |
| 7 | General Journal Line No. | Integer | 17-28 | - | - |
| 28 | Sender Bank Name - Data Conv. | Text[50] | 17-28 | - | - |
| 29 | Sender Bank Name | Text[100] | 17-28 | - | - |
| 30 | Sender Bank Account Code | Code[20] | 17-28 | - | - |
| 31 | Sender Bank Account No. | Text[50] | 17-28 | - | - |
| 32 | Sender Bank Account Currency | Code[10] | 17-28 | - | - |
| 33 | Sender Bank Country/Region | Code[10] | 17-28 | - | - |
| 34 | Sender Bank BIC | Code[35] | 17-28 | - | - |
| 35 | Sender Bank Clearing Std. | Text[50] | 17-28 | - | - |
| 36 | Sender Bank Clearing Code | Text[50] | 17-28 | - | - |
| 37 | Sender Bank Address | Text[100] | 17-28 | - | - |
| 38 | Sender Bank City | Text[50] | 17-28 | - | - |
| 39 | Sender Bank Post Code | Code[20] | 17-28 | - | - |
| 40 | Recipient Name | Text[100] | 17-28 | - | - |
| 41 | Recipient Address | Text[100] | 17-28 | - | - |
| 42 | Recipient City | Text[50] | 17-28 | - | - |
| 43 | Recipient Post Code | Code[20] | 17-28 | - | - |
| 44 | Recipient Country/Region Code | Code[10] | 17-28 | - | - |
| 45 | Recipient Email Address | Text[80] | 17-28 | - | - |
| 46 | Recipient ID | Code[20] | 17-28 | - | - |
| 48 | Recipient Bank Clearing Std. | Text[50] | 17-28 | - | - |
| 49 | Recipient Bank Clearing Code | Text[50] | 17-28 | - | - |
| 50 | Recipient Reg. No. | Code[20] | 17-28 | - | - |
| 51 | Recipient Acc. No. | Code[30] | 17-28 | - | - |
| 52 | Recipient Bank Acc. No. | Text[50] | 17-28 | - | - |
| 53 | Recipient Bank BIC | Code[35] | 17-28 | - | - |
| 54 | Recipient Bank Name | Text[100] | 17-28 | - | - |
| 55 | Recipient Bank Address | Text[100] | 17-28 | - | - |
| 56 | Recipient Bank City | Text[50] | 17-28 | - | - |
| 57 | Recipient Bank Country/Region | Code[10] | 17-28 | - | - |
| 58 | Recipient Creditor No. | Code[20] | 17-28 | - | - |
| 59 | Recipient Bank Post Code | Code[20] | 17-28 | - | - |
| 60 | Message Type | Code[1] | 17-28 | - | - |
| 61 | Letter to Sender | Code[1] | 17-28 | - | - |
| 63 | Recipient Acknowledgement | Code[1] | 17-28 | - | - |
| 64 | Short Advice | Text[35] | 17-28 | - | - |
| 65 | Message to Recipient 1 | Text[140] | 17-28 | - | - |
| 66 | Message to Recipient 2 | Text[140] | 17-28 | - | - |
| 80 | Amount | Decimal | 17-28 | - | - |
| 81 | Currency Code | Code[10] | 17-28 | - | - |
| 82 | Transfer Date | Date | 17-28 | - | - |
| 83 | Transfer Type | Code[1] | 17-28 | - | - |
| 84 | Payment Type | Text[50] | 17-28 | - | - |
| 85 | Document No. | Code[20] | 17-28 | - | - |
| 87 | Recipient Reference | Code[35] | 17-28 | - | - |
| 88 | Payment Reference | Code[50] | 17-28 | - | - |
| 89 | Invoice Amount | Decimal | 17-28 | - | - |
| 90 | Invoice Date | Date | 17-28 | - | - |
| 91 | Recipient County | Text[30] | 17-28 | - | - |
| 92 | Recipient Bank County | Text[30] | 17-28 | - | - |
| 93 | Sender Bank County | Text[30] | 17-28 | - | - |
| 94 | Sender Reg. No. | Text[50] | 24-28 | - | - |
| 100 | Payment Information ID | Text[50] | 17-28 | - | - |
| 101 | End-to-End ID | Text[50] | 17-28 | - | - |
| 102 | Message ID | Text[35] | 17-28 | - | - |
| 103 | SEPA Instruction Priority | Option | 17-28 | - | - |
| 104 | SEPA Instruction Priority Text | Code[4] | 17-28 | - | - |
| 105 | SEPA Payment Method | Option | 17-28 | - | - |
| 106 | SEPA Payment Method Text | Code[3] | 17-28 | - | - |
| 107 | SEPA Batch Booking | Boolean | 17-28 | - | - |
| 108 | SEPA Charge Bearer | Option | 17-28 | - | - |
| 109 | SEPA Charge Bearer Text | Code[4] | 17-28 | - | - |
| 120 | SEPA Direct Debit Mandate ID | Code[35] | 17-28 | - | - |
| 121 | SEPA Direct Debit Seq. Type | Option | 17-28 | - | - |
| 122 | SEPA Direct Debit Seq. Text | Code[4] | 17-28 | - | - |
| 123 | SEPA DD Mandate Signed Date | Date | 17-28 | - | - |
| 124 | SEPA Partner Type | Enum Partner Type | 17-28 | - | - |
| 125 | SEPA Partner Type Text | Code[4] | 17-28 | - | - |
| 130 | Importing Code | Code[10] | 17-28 | - | - |
| 131 | Importing Date | Date | 17-28 | - | - |
| 132 | Importing Description | Text[250] | 17-28 | - | - |
| 133 | Costs Distribution | Text[30] | 17-28 | - | - |
| 134 | Message Structure | Text[30] | 17-28 | - | - |
| 135 | Own Address Info. | Text[30] | 17-28 | - | - |
| 170 | Creditor No. | Code[35] | 17-28 | - | - |
| 171 | Transit No. | Code[35] | 17-28 | - | - |
| 173 | Applies-to Ext. Doc. No. | Code[35] | 17-28 | - | - |
| 200 | Format Command | Code[4] | 17-28 | - | - |
| 201 | Format Remittance Info Type | Code[1] | 17-28 | - | - |
| 220 | Format Payment Type | Code[2] | 17-28 | - | - |
| 221 | Format Expense Code | Code[1] | 17-28 | - | - |
| 222 | Format Text Code | Code[3] | 17-28 | - | - |
| 283 | Format Form Type | Code[2] | 17-28 | - | - |

## Keys

| Name | Fields | Versions |
| --- | --- | --- |
| Key1, clustered | Entry No. | 17-28 |

## Procedures

| Name | Parameters | Returns | Access | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- | --- |
| InitData | (var Record Gen. Journal Line) | - | public | 17-28 | - | - |
| AddRemittanceText | (Text[140]) | - | public | 17-28 | - | - |
| GetRemittanceTexts | (var Record Payment Export Remittance Text) | - | public | 17-28 | - | - |
| AddGenJnlLineErrorText | (Record Gen. Journal Line, Text) | - | public | 17-28 | - | - |
| SetPreserveNonLatinCharacters | (Boolean) | - | public | 17-28 | - | - |
| GetPreserveNonLatinCharacters | () | Boolean | public | 17-28 | - | - |
| CompanyInformationConvertToLatin | (var Record Company Information) | - | public | 17-28 | - | - |
| SetCustomerAsRecipient | (var Record Customer, var Record Customer Bank Account) | - | public | 17-28 | - | - |
| SetVendorAsRecipient | (var Record Vendor, var Record Vendor Bank Account) | - | public | 17-28 | - | - |
| SetEmployeeAsRecipient | (var Record Employee) | - | public | 17-28 | - | - |
| SetBankAsSenderBank | (Record Bank Account) | - | public | 17-28 | - | - |
| SetCreditorIdentifier | (Record Bank Account) | - | public | 17-28 | - | - |
| SetCreditTransferIDs | (Code[20]) | - | public | 17-28 | - | - |
| IsFieldBlank | (Integer) | Boolean | public | 17-28 | - | - |
| GetOrganizationID | () | Text | public | 23-28 | - | - |
| GetSenderCreditorNo | () | Text | public | 24-28 | - | - |
| SetBankAsRecipient | (var Record Bank Account) | - | public | 24-28 | - | - |

## Events

| Kind | Name | Parameters | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| Integration event | OnAfterSetBankAsSenderBank | (Record Bank Account) | 17-28 | - | - |
| Integration event | OnAfterSetCustomerAsRecipient | (var Record Payment Export Data, var Record Customer, var Record Customer Bank Account) | 17-28 | - | - |
| Integration event | OnAfterSetEmployeeAsRecipient | (Record Employee) | 17-28 | - | - |
| Integration event | OnAfterSetVendorAsRecipient | (var Record Payment Export Data, var Record Vendor, var Record Vendor Bank Account) | 17-28 | - | - |
| Integration event | OnAfterGetSenderCreditorNo | (Record Payment Export Data, var Text) | 24-28 | - | - |
| Integration event | OnAfterSetBankAsRecipient | (var Record Payment Export Data, var Record Bank Account) | 24-28 | - | - |

## Source

Symbols: Microsoft.BaseApplication.symbols.437dbf0e-84ff-417a-965d-ed2bb9650972, https://dynamicssmb2.pkgs.visualstudio.com/DynamicsBCPublicFeeds/_packaging/MSSymbols/nuget/v3/index.json, highest build per major on 2026-09-20.
AL source 29: https://github.com/microsoft/BCApps, MIT, releases/29.x at a66254c3b8b5bb1cea290dc8f9d097aec4381153.

Jonas Paprotka, 2026-09-20.