Payment Export Data #1226

Other table in Microsoft Dynamics 365 Business Central. 95 fields, 0 records in Cronus demo.

The Payment Export Data table (ID 1226) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 95 fields, with a primary key of Entry No.. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Entry No..

All fields (95)

Payment Export Data — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Entry No. PK	Integer	Normal
2	Data Exch Entry No.	Integer	Normal	→ Data Exch. #1220
3	Line No.	Integer	Normal
4	Data Exch. Line Def Code	Code	Normal
5	General Journal Template	Code	Normal	→ Gen. Journal Template #80
6	General Journal Batch Name	Code	Normal	→ Gen. Journal Batch #232
7	General Journal Line No.	Integer	Normal
28	Sender Bank Name - Data Conv.	Text	Normal
29	Sender Bank Name	Text	Normal
30	Sender Bank Account Code	Code	Normal	→ Bank Account #270
31	Sender Bank Account No.	Text	Normal
32	Sender Bank Account Currency	Code	Normal	→ Currency #4
33	Sender Bank Country/Region	Code	Normal	→ Country/Region #9
34	Sender Bank BIC	Code	Normal
35	Sender Bank Clearing Std.	Text	Normal	→ Bank Clearing Standard #1280
36	Sender Bank Clearing Code	Text	Normal
37	Sender Bank Address	Text	Normal
38	Sender Bank City	Text	Normal
39	Sender Bank Post Code	Code	Normal
40	Recipient Name	Text	Normal
41	Recipient Address	Text	Normal
42	Recipient City	Text	Normal
43	Recipient Post Code	Code	Normal
44	Recipient Country/Region Code	Code	Normal
45	Recipient Email Address	Text	Normal
46	Recipient ID	Code	Normal
48	Recipient Bank Clearing Std.	Text	Normal	→ Bank Clearing Standard #1280
49	Recipient Bank Clearing Code	Text	Normal
50	Recipient Reg. No.	Code	Normal
51	Recipient Acc. No.	Code	Normal
52	Recipient Bank Acc. No.	Text	Normal
53	Recipient Bank BIC	Code	Normal
54	Recipient Bank Name	Text	Normal
55	Recipient Bank Address	Text	Normal
56	Recipient Bank City	Text	Normal
57	Recipient Bank Country/Region	Code	Normal	→ Country/Region #9
58	Recipient Creditor No.	Code	Normal
59	Recipient Bank Post Code	Code	Normal
60	Message Type	Code	Normal
61	Letter to Sender	Code	Normal
63	Recipient Acknowledgement	Code	Normal
64	Short Advice	Text	Normal
65	Message to Recipient 1	Text	Normal
66	Message to Recipient 2	Text	Normal
80	Amount	Decimal	Normal
81	Currency Code	Code	Normal	→ Currency #4
82	Transfer Date	Date	Normal
83	Transfer Type	Code	Normal
84	Payment Type	Text	Normal
85	Document No.	Code	Normal
87	Recipient Reference	Code	Normal
88	Payment Reference	Code	Normal
89	Invoice Amount	Decimal	Normal
90	Invoice Date	Date	Normal
91	Recipient County	Text	Normal
92	Recipient Bank County	Text	Normal
93	Sender Bank County	Text	Normal
94	Sender Registration No.	Text	Normal
100	Payment Information ID	Text	Normal
101	End-to-End ID	Text	Normal
102	Message ID	Text	Normal
103	SEPA Instruction Priority	Option	Normal
104	SEPA Instruction Priority Text	Code	Normal
105	SEPA Payment Method	Option	Normal
106	SEPA Payment Method Text	Code	Normal
107	SEPA Batch Booking	Boolean	Normal
108	SEPA Charge Bearer	Option	Normal
109	SEPA Charge Bearer Text	Code	Normal
120	SEPA Direct Debit Mandate ID	Code	Normal
121	SEPA Direct Debit Seq. Type	Option	Normal
122	SEPA Direct Debit Seq. Text	Code	Normal
123	SEPA DD Mandate Signed Date	Date	Normal
124	SEPA Partner Type	Option	Normal
125	SEPA Partner Type Text	Code	Normal
130	Importing Code	Code	Normal
131	Importing Date	Date	Normal
132	Importing Description	Text	Normal
133	Costs Distribution	Text	Normal
134	Message Structure	Text	Normal
135	Own Address Info.	Text	Normal
170	Creditor No.	Code	Normal
171	Transit No.	Code	Normal
173	Applies-to Ext. Doc. No.	Code	Normal
200	Format Command	Code	Normal
201	Format Remittance Info Type	Code	Normal
220	Format Payment Type	Code	Normal
221	Format Expense Code	Code	Normal
222	Format Text Code	Code	Normal
283	Format Form Type	Code	Normal
20100	Recipient Bank Account Currency	Code	Normal	→ Currency #4
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Related tables (8)

Tables referenced by fields on the Payment Export Data table through TableRelation properties.

Data Exch.

#1220 · Other · via Data Exch Entry No.

Gen. Journal Template

#80 · Other · via General Journal Template

Gen. Journal Batch

#232 · Other · via General Journal Batch Name

Bank Account

#270 · Other · via Sender Bank Account Code

Currency

#4 · General Ledger · via Sender Bank Account Currency, Currency Code, Recipient Bank Account Currency

Country/Region

#9 · General Ledger · via Sender Bank Country/Region, Recipient Bank Country/Region

Bank Clearing Standard

#1280 · Other · via Sender Bank Clearing Std., Recipient Bank Clearing Std.