Objects/Tables/Table 1226 Payment Export Data

Fields, 89

Jonas Paprotka, Base Application 28.5.54151.54365, versions 17-28, checked 2026-09-20

Id	Name	Type	Versions	Obsolete
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	-