Objects/Tables/Table 1226 Payment Export Data

Table 1226 Payment Export Data in 20

Jonas Paprotka, Base Application 20.5.45456.61928, checked 2026-09-20

App: Base Application

Fields, 88 Keys, 1 Procedures, 14 Events, 4

Versions17 18 192021 22 23 24 25 26 27 28 latest

Source29

Fields, 88

Id	Name	Type	Obsolete
1	Entry No.	Integer	-
2	Data Exch Entry No.	Integer	-
3	Line No.	Integer	-
4	Data Exch. Line Def Code	Code[20]	-
5	General Journal Template	Code[10]	-
6	General Journal Batch Name	Code[10]	-
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]	-
31	Sender Bank Account No.	Text[50]	-
32	Sender Bank Account Currency	Code[10]	-
33	Sender Bank Country/Region	Code[10]	-
34	Sender Bank BIC	Code[35]	-
35	Sender Bank Clearing Std.	Text[50]	-
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]	-
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]	-
46	Recipient ID	Code[20]	-
48	Recipient Bank Clearing Std.	Text[50]	-
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]	-
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]	-
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]	-
100	Payment Information ID	Text[50]	-
101	End-to-End ID	Text[50]	-
102	Message ID	Text[35]	-
103	SEPA Instruction Priority	Option	-
104	SEPA Instruction Priority Text	Code[4]	-
105	SEPA Payment Method	Option	-
106	SEPA Payment Method Text	Code[3]	-
107	SEPA Batch Booking	Boolean	-
108	SEPA Charge Bearer	Option	-
109	SEPA Charge Bearer Text	Code[4]	-
120	SEPA Direct Debit Mandate ID	Code[35]	-
121	SEPA Direct Debit Seq. Type	Option	-
122	SEPA Direct Debit Seq. Text	Code[4]	-
123	SEPA DD Mandate Signed Date	Date	-
124	SEPA Partner Type	Enum 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, 1

Name	Fields	Obsolete
Key1, clustered	Entry No.	-

Procedures, 14

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

Events, 4

Kind	Name	Parameters	Obsolete
Integration event	OnAfterSetBankAsSenderBank	(Record Bank Account)	-
Integration event	OnAfterSetCustomerAsRecipient	(var Record Payment Export Data, var Record Customer, var Record Customer Bank Account)	-
Integration event	OnAfterSetEmployeeAsRecipient	(Record Employee)	-
Integration event	OnAfterSetVendorAsRecipient	(var Record Payment Export Data, var Record Vendor, var Record Vendor Bank Account)	-