Table 1226 "Payment Export Data"

Base Application · Microsoft.Bank.Payment · BC23-30 · source at ea08af5e · 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.” (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” (Gen. Journal Template)
6	General Journal Batch Name	Code[10]	—	TableRelation Table 232 “Gen. Journal Batch” (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” (Bank Account)
31	Sender Bank Account No.	Text[50]	—
32	Sender Bank Account Currency	Code[10]	—	TableRelation Table 4 “Currency”
33	Sender Bank Country/Region	Code[10]	—	TableRelation Table 9 “Country/Region” (Country/Region)
34	Sender Bank BIC	Code[35]	—
35	Sender Bank Clearing Std.	Text[50]	—	TableRelation Table 1280 “Bank Clearing Standard” (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 Δ BC24	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 Δ BC24	Text[80]	—	DataClassification EndUserIdentifiableInformation
46	Recipient ID	Code[20]	—
48	Recipient Bank Clearing Std.	Text[50]	—	TableRelation Table 1280 “Bank Clearing Standard” (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” (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 Δ BC27	Decimal	—
81	Currency Code	Code[10]	—	TableRelation Table 4 “Currency”
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 Δ BC27	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. + BC24	Text[50]	Sender Registration No. caption
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”
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) + BC24 (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") + BC24 (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 + BC24
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") + BC24
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.”
Recipient Bank Clearing Std.: TableRelation Table 1280 “Bank Clearing Standard”
Sender Bank Clearing Std.: TableRelation Table 1280 “Bank Clearing Standard”
General Journal Batch Name: TableRelation Table 232 “Gen. Journal Batch”
Sender Bank Account Code: TableRelation Table 270 “Bank Account”
Currency Code: TableRelation Table 4 “Currency”
Sender Bank Account Currency: TableRelation Table 4 “Currency”
General Journal Template: TableRelation Table 80 “Gen. Journal Template”
Recipient Bank Country/Region: TableRelation Table 9 “Country/Region”
Sender Bank Country/Region: TableRelation Table 9 “Country/Region”

Referenced by

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

Table 1229 “Payment Export Remittance Text”: Pmt. Export Data Entry No.

Pages and codeunits on this table

Codeunit 1221 “SEPA CT-Fill Export Buffer” (codeunit runs on it)
Codeunit 1231 “SEPA DD-Fill Export Buffer” (codeunit runs on it)

Extended by

Table extension 20108 “AMC Bank Paym. Exp. Data Ext”

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” (2 calls: ConvertFieldsToLatinCharacters → WindowsToASCII, ConvertToASCII → WindowsToASCII)

Recent changes

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

Countries that replace it

CH, IT, NL, NO, RU

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.