---
id: object/table/1226
type: object
title: Table 1226 "Payment Export Data"
summary: Table 1226 "Payment Export Data" in Base Application (Microsoft.Bank.Payment). 89 fields, 17 public procedures, 6 events. Present since at least BC23, still in BC30, changed in BC24, BC27.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "27"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 8f3f3ac445793b73c42176f29d783170ea580b809e81e7dff8784d8648c94989
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Bank/Payment/PaymentExportData.Table.al
    title: src/Layers/W1/BaseApp/Bank/Payment/PaymentExportData.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations:
    - localization/ch
    - localization/it
    - localization/nl
    - localization/no
    - localization/ru
  videos: []
  posts: []
  guidelines: []
  changes:
    - change/bcapps/10799
    - change/bcapps/10136
object_type: table
object_id: 1226
name: Payment Export Data
namespace: Microsoft.Bank.Payment
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "24"
  - "27"
source_major: "29"
obsolete: null
countries:
  - ch
  - it
  - nl
  - "no"
  - ru
ms_search_form_ids: []
counts:
  fields: 89
  procedures: 26
  events: 6
  subscribers: 0
relations:
  out: 10
  referenced_by: 1
  pages: 0
  extended_by: 1
  event_subscribers: 0
  calls: 1
  called_by: 0
  implements: 0
---

# Table 1226 "Payment Export Data"

> Table 1226 "Payment Export Data" in Base Application (Microsoft.Bank.Payment). 89 fields, 17 public procedures, 6 events. Present since at least BC23, still in BC30, changed in BC24, BC27.

Base Application · Microsoft.Bank.Payment · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Bank/Payment/PaymentExportData.Table.al) · facts from BC29

## Properties

| Property | Value |
|---|---|
| Caption | Payment Export Data |
| DataClassification | CustomerContent |

## Fields

Explanation: the field's ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Entry No. | Integer | — | AutoIncrement |
| 2 | Data Exch Entry No. | Integer | — | TableRelation [Table 1220 "Data Exch."](../table/1220.md) (Data Exch.) |
| 3 | Line No. | Integer | — |  |
| 4 | Data Exch. Line Def Code | Code[20] | — |  |
| 5 | General Journal Template | Code[10] | — | TableRelation [Table 80 "Gen. Journal Template"](../table/80.md) (Gen. Journal Template) |
| 6 | General Journal Batch Name | Code[10] | — | TableRelation [Table 232 "Gen. Journal Batch"](../table/232.md) (Gen. Journal Batch) |
| 7 | General Journal Line No. | Integer | — |  |
| 28 | Sender Bank Name - Data Conv. | Text[50] | — |  |
| 29 | Sender Bank Name | Text[100] | — |  |
| 30 | Sender Bank Account Code | Code[20] | — | TableRelation [Table 270 "Bank Account"](../table/270.md) (Bank Account) |
| 31 | Sender Bank Account No. | Text[50] | — |  |
| 32 | Sender Bank Account Currency | Code[10] | — | TableRelation [Table 4 "Currency"](../table/4.md) |
| 33 | Sender Bank Country/Region | Code[10] | — | TableRelation [Table 9 "Country/Region"](../table/9.md) (Country/Region) |
| 34 | Sender Bank BIC | Code[35] | — |  |
| 35 | Sender Bank Clearing Std. | Text[50] | — | TableRelation [Table 1280 "Bank Clearing Standard"](../table/1280.md) (Bank Clearing Standard) |
| 36 | Sender Bank Clearing Code | Text[50] | — |  |
| 37 | Sender Bank Address | Text[100] | — |  |
| 38 | Sender Bank City | Text[50] | — |  |
| 39 | Sender Bank Post Code | Code[20] | — |  |
| 40 | Recipient Name | Text[100] | — | DataClassification EndUserIdentifiableInformation |
| 41 | Recipient Address | Text[100] | — |  |
| 42 | Recipient City | Text[50] | — |  |
| 43 | Recipient Post Code | Code[20] | — |  |
| 44 | Recipient Country/Region Code | Code[10] | — |  |
| 45 | Recipient Email Address | Text[80] | — | DataClassification EndUserIdentifiableInformation |
| 46 | Recipient ID | Code[20] | — |  |
| 48 | Recipient Bank Clearing Std. | Text[50] | — | TableRelation [Table 1280 "Bank Clearing Standard"](../table/1280.md) (Bank Clearing Standard) |
| 49 | Recipient Bank Clearing Code | Text[50] | — |  |
| 50 | Recipient Reg. No. | Code[20] | — |  |
| 51 | Recipient Acc. No. | Code[30] | — |  |
| 52 | Recipient Bank Acc. No. | Text[50] | — |  |
| 53 | Recipient Bank BIC | Code[35] | — |  |
| 54 | Recipient Bank Name | Text[100] | — |  |
| 55 | Recipient Bank Address | Text[100] | — |  |
| 56 | Recipient Bank City | Text[50] | — |  |
| 57 | Recipient Bank Country/Region | Code[10] | — | TableRelation [Table 9 "Country/Region"](../table/9.md) (Country/Region) |
| 58 | Recipient Creditor No. | Code[20] | — |  |
| 59 | Recipient Bank Post Code | Code[20] | — |  |
| 60 | Message Type | Code[1] | — |  |
| 61 | Letter to Sender | Code[1] | — |  |
| 63 | Recipient Acknowledgement | Code[1] | — |  |
| 64 | Short Advice | Text[35] | — |  |
| 65 | Message to Recipient 1 | Text[140] | — |  |
| 66 | Message to Recipient 2 | Text[140] | — |  |
| 80 | Amount | Decimal | — |  |
| 81 | Currency Code | Code[10] | — | TableRelation [Table 4 "Currency"](../table/4.md) |
| 82 | Transfer Date | Date | — |  |
| 83 | Transfer Type | Code[1] | — |  |
| 84 | Payment Type | Text[50] | — |  |
| 85 | Document No. | Code[20] | — |  |
| 87 | Recipient Reference | Code[35] | — |  |
| 88 | Payment Reference | Code[50] | — |  |
| 89 | Invoice Amount | Decimal | — |  |
| 90 | Invoice Date | Date | — |  |
| 91 | Recipient County | Text[30] | — |  |
| 92 | Recipient Bank County | Text[30] | — |  |
| 93 | Sender Bank County | Text[30] | — |  |
| 94 | Sender Reg. No. | Text[50] | Sender Registration No. <small>caption</small> |  |
| 100 | Payment Information ID | Text[50] | — |  |
| 101 | End-to-End ID | Text[50] | — |  |
| 102 | Message ID | Text[35] | — |  |
| 103 | SEPA Instruction Priority | Option | — | OptionCaption: NORMAL,HIGH |
| 104 | SEPA Instruction Priority Text | Code[4] | — | not editable |
| 105 | SEPA Payment Method | Option | — | OptionCaption: CHK,TRF,TRA |
| 106 | SEPA Payment Method Text | Code[3] | — |  |
| 107 | SEPA Batch Booking | Boolean | — |  |
| 108 | SEPA Charge Bearer | Option | — | OptionCaption: DEBT,CRED,SHAR,SLEV |
| 109 | SEPA Charge Bearer Text | Code[4] | — |  |
| 120 | SEPA Direct Debit Mandate ID | Code[35] | — |  |
| 121 | SEPA Direct Debit Seq. Type | Option | — | OptionCaption: One Off,First,Recurring,Last |
| 122 | SEPA Direct Debit Seq. Text | Code[4] | — |  |
| 123 | SEPA DD Mandate Signed Date | Date | — |  |
| 124 | SEPA Partner Type | Enum "Partner Type" | — | enum [Enum 134 "Partner Type"](../enum/134.md) |
| 125 | SEPA Partner Type Text | Code[4] | — |  |
| 130 | Importing Code | Code[10] | — |  |
| 131 | Importing Date | Date | — |  |
| 132 | Importing Description | Text[250] | — |  |
| 133 | Costs Distribution | Text[30] | — |  |
| 134 | Message Structure | Text[30] | — |  |
| 135 | Own Address Info. | Text[30] | — |  |
| 170 | Creditor No. | Code[35] | — |  |
| 171 | Transit No. | Code[35] | — |  |
| 173 | Applies-to Ext. Doc. No. | Code[35] | — |  |
| 200 | Format Command | Code[4] | — |  |
| 201 | Format Remittance Info Type | Code[1] | — |  |
| 220 | Format Payment Type | Code[2] | — |  |
| 221 | Format Expense Code | Code[1] | — |  |
| 222 | Format Text Code | Code[3] | — |  |
| 283 | Format Form Type | Code[2] | — |  |

## Keys

- Key1: Entry No. (clustered)

## Events published

- `OnAfterGetSenderCreditorNo(PaymentExportData: Record "Payment Export Data"; var CreditorNo: Text)` (integration): Integration event raised after determining the sender creditor number for payment export. Enables custom logic to modify or override the creditor number used in payment files.
- `OnAfterSetBankAsSenderBank(BankAccount: Record "Bank Account")` (integration): Integration event raised after setting the bank account as sender bank for payment export. Enables custom processing after sender bank configuration.
- `OnAfterSetCustomerAsRecipient(var PaymentExportData: Record "Payment Export Data"; var Customer: Record Customer; var CustomerBankAccount: Record "Customer Bank Account")` (integration): Integration event raised after setting a customer as the payment recipient. Enables custom modifications to customer recipient data for payment export.
- `OnAfterSetEmployeeAsRecipient(Employee: Record Employee)` (integration): Integration event raised after setting an employee as the payment recipient. Enables custom processing after employee recipient configuration.
- `OnAfterSetVendorAsRecipient(var PaymentExportData: Record "Payment Export Data"; var Vendor: Record Vendor; var VendorBankAccount: Record "Vendor Bank Account")` (integration): Integration event raised after setting a vendor as the payment recipient. Enables custom modifications to vendor recipient data for payment export.
- `OnAfterSetBankAsRecipient(var PaymentExportData: Record "Payment Export Data"; var BankAccount: Record "Bank Account")` (integration): Integration event raised after setting a bank account as the payment recipient. Enables custom modifications to bank recipient data for payment export.

## Procedures

- `InitData(var GenJnlLine: Record "Gen. Journal Line")`
- `AddRemittanceText(NewText: Text[140])`
- `GetRemittanceTexts(var PaymentExportRemittanceText: Record "Payment Export Remittance Text")`
- `GetOrganizationID(): Text`
- `GetSenderCreditorNo(): Text`
- `AddGenJnlLineErrorText(GenJnlLine: Record "Gen. Journal Line"; NewText: Text)`
- `SetPreserveNonLatinCharacters(NewPreserveNonLatinCharacters: Boolean)`
- `GetPreserveNonLatinCharacters(): Boolean`
- `CompanyInformationConvertToLatin(var CompanyInformation: Record "Company Information")`
- `SetCustomerAsRecipient(var Customer: Record Customer; var CustomerBankAccount: Record "Customer Bank Account")`
- `SetVendorAsRecipient(var Vendor: Record Vendor; var VendorBankAccount: Record "Vendor Bank Account")`
- `SetEmployeeAsRecipient(var Employee: Record Employee)`
- `SetBankAsRecipient(var BankAccount: Record "Bank Account")`
- `SetBankAsSenderBank(BankAccount: Record "Bank Account")`
- `SetCreditorIdentifier(BankAccount: Record "Bank Account")`
- `SetCreditTransferIDs(MessageID: Code[20])`
- `IsFieldBlank(FieldID: Integer): Boolean`

Plus 3 local procedures.

## Triggers

OnInsert

## Relations

- Data Exch Entry No.: TableRelation [Table 1220 "Data Exch."](../table/1220.md)
- Recipient Bank Clearing Std.: TableRelation [Table 1280 "Bank Clearing Standard"](../table/1280.md)
- Sender Bank Clearing Std.: TableRelation [Table 1280 "Bank Clearing Standard"](../table/1280.md)
- General Journal Batch Name: TableRelation [Table 232 "Gen. Journal Batch"](../table/232.md)
- Sender Bank Account Code: TableRelation [Table 270 "Bank Account"](../table/270.md)
- Currency Code: TableRelation [Table 4 "Currency"](../table/4.md)
- Sender Bank Account Currency: TableRelation [Table 4 "Currency"](../table/4.md)
- General Journal Template: TableRelation [Table 80 "Gen. Journal Template"](../table/80.md)
- Recipient Bank Country/Region: TableRelation [Table 9 "Country/Region"](../table/9.md)
- Sender Bank Country/Region: TableRelation [Table 9 "Country/Region"](../table/9.md)

## Referenced by

1 fields in 1 objects relate to this table (TableRelation or CalcFormula).

- [Table 1229 "Payment Export Remittance Text"](../table/1229.md): Pmt. Export Data Entry No.

## Pages and codeunits on this table

- [Codeunit 1221 "SEPA CT-Fill Export Buffer"](../codeunit/1221.md) (codeunit runs on it)
- [Codeunit 1231 "SEPA DD-Fill Export Buffer"](../codeunit/1231.md) (codeunit runs on it)

## Extended by

- [Table extension 20108 "AMC Bank Paym. Exp. Data Ext"](../tableextension/20108.md)

## Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an `Object::"Name"` argument. Interface dispatch and calls through events are not counted, so the list is not complete.

- [Codeunit 47 "StringConversionManagement"](../codeunit/47.md) (2 calls: `ConvertFieldsToLatinCharacters → WindowsToASCII`, `ConvertToASCII → WindowsToASCII`)

## Recent changes

- 2026-10-05 [#10799 Remove OnPrem scope from Table 1226 "Payment Export Data".SetSwissExport](../../changes/bcapps/10799.md) (main, BC30, fix)
- 2026-08-17 [#10136 [CH][SEPA CT] Export requires both IBAN and Clearing No. for domestic payments and refunds](../../changes/bcapps/10136.md) (main, BC30, fix)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24, BC27

## Countries that replace it

[CH](../../localizations/ch.md), [IT](../../localizations/it.md), [NL](../../localizations/nl.md), [NO](../../localizations/no.md), [RU](../../localizations/ru.md)

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: `bcatlas_resolve_node(object_type: "table", object_name: "Payment Export Data")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.