Table 1226 Payment Export Data

Base Application, Microsoft.Bank.Payment

89 fields

IdNameTypeVersions
1Entry No.Integer17-29
2Data Exch Entry No.Integer17-29
3Line No.Integer17-29
4Data Exch. Line Def CodeCode[20]17-29
5General Journal TemplateCode[10]17-29
6General Journal Batch NameCode[10]17-29
7General Journal Line No.Integer17-29
28Sender Bank Name - Data Conv.Text[50]17-29
29Sender Bank NameText[100]17-29
30Sender Bank Account CodeCode[20]17-29
31Sender Bank Account No.Text[50]17-29
32Sender Bank Account CurrencyCode[10]17-29
33Sender Bank Country/RegionCode[10]17-29
34Sender Bank BICCode[35]17-29
35Sender Bank Clearing Std.Text[50]17-29
36Sender Bank Clearing CodeText[50]17-29
37Sender Bank AddressText[100]17-29
38Sender Bank CityText[50]17-29
39Sender Bank Post CodeCode[20]17-29
40Recipient NameText[100]17-29
41Recipient AddressText[100]17-29
42Recipient CityText[50]17-29
43Recipient Post CodeCode[20]17-29
44Recipient Country/Region CodeCode[10]17-29
45Recipient Email AddressText[80]17-29
46Recipient IDCode[20]17-29
48Recipient Bank Clearing Std.Text[50]17-29
49Recipient Bank Clearing CodeText[50]17-29
50Recipient Reg. No.Code[20]17-29
51Recipient Acc. No.Code[30]17-29
52Recipient Bank Acc. No.Text[50]17-29
53Recipient Bank BICCode[35]17-29
54Recipient Bank NameText[100]17-29
55Recipient Bank AddressText[100]17-29
56Recipient Bank CityText[50]17-29
57Recipient Bank Country/RegionCode[10]17-29
58Recipient Creditor No.Code[20]17-29
59Recipient Bank Post CodeCode[20]17-29
60Message TypeCode[1]17-29
61Letter to SenderCode[1]17-29
63Recipient AcknowledgementCode[1]17-29
64Short AdviceText[35]17-29
65Message to Recipient 1Text[140]17-29
66Message to Recipient 2Text[140]17-29
80AmountDecimal17-29
81Currency CodeCode[10]17-29
82Transfer DateDate17-29
83Transfer TypeCode[1]17-29
84Payment TypeText[50]17-29
85Document No.Code[20]17-29
87Recipient ReferenceCode[35]17-29
88Payment ReferenceCode[50]17-29
89Invoice AmountDecimal17-29
90Invoice DateDate17-29
91Recipient CountyText[30]17-29
92Recipient Bank CountyText[30]17-29
93Sender Bank CountyText[30]17-29
94Sender Reg. No.Text[50]new in 24
100Payment Information IDText[50]17-29
101End-to-End IDText[50]17-29
102Message IDText[35]17-29
103SEPA Instruction PriorityOption17-29
104SEPA Instruction Priority TextCode[4]17-29
105SEPA Payment MethodOption17-29
106SEPA Payment Method TextCode[3]17-29
107SEPA Batch BookingBoolean17-29
108SEPA Charge BearerOption17-29
109SEPA Charge Bearer TextCode[4]17-29
120SEPA Direct Debit Mandate IDCode[35]17-29
121SEPA Direct Debit Seq. TypeOption17-29
122SEPA Direct Debit Seq. TextCode[4]17-29
123SEPA DD Mandate Signed DateDate17-29
124SEPA Partner TypeEnum "Partner Type"17-29
125SEPA Partner Type TextCode[4]17-29
130Importing CodeCode[10]17-29
131Importing DateDate17-29
132Importing DescriptionText[250]17-29
133Costs DistributionText[30]17-29
134Message StructureText[30]17-29
135Own Address Info.Text[30]17-29
170Creditor No.Code[35]17-29
171Transit No.Code[35]17-29
173Applies-to Ext. Doc. No.Code[35]17-29
200Format CommandCode[4]17-29
201Format Remittance Info TypeCode[1]17-29
220Format Payment TypeCode[2]17-29
221Format Expense CodeCode[1]17-29
222Format Text CodeCode[3]17-29
283Format Form TypeCode[2]17-29