Diagrams

Table

Payment Export Data

DynamicsDocs.comPayment Export Data«Table 1226»Payment Export DataEntry No. [PK]Data Exch Entry No.Line No.Data Exch. Line Def CodeGeneral Journal TemplateGeneral Journal Batch NameGeneral Journal Line No.Sender Bank Name - Data Conv.Sender Bank NameSender Bank Account CodeSender Bank Account No.Sender Bank Account CurrencySender Bank Country/RegionSender Bank BICSender Bank Clearing Std.Sender Bank Clearing CodeSender Bank AddressSender Bank CitySender Bank Post CodeRecipient NameRecipient AddressRecipient CityRecipient Post CodeRecipient Country/Region CodeRecipient Email AddressRecipient IDRecipient Bank Clearing Std.Recipient Bank Clearing CodeRecipient Reg. No.Recipient Acc. No.Recipient Bank Acc. No....«Table 1229»Payment Export Remittance TextPmt. Export Data Entry No. [PK]Line No. [PK]Text«Table 1220»Data Exch.Entry No. [PK]File NameFile ContentData Exch. Def CodeData Exch. Line Def CodeTable FiltersIncoming Entry No.«Table 80»Gen. Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportType; [General,Sales,Purchases,Cash Re...Source CodeReason CodeRecurringTest Report CaptionPage CaptionPosting Report CaptionForce Doc. BalanceBal. Account Type; [G/L Account,Custom...Bal. Account No.No. SeriesPosting No. SeriesCopy VAT Setup to Jnl. LinesAllow VAT DifferenceCust. Receipt Report IDCust. Receipt Report CaptionVendor Receipt Report IDVendor Receipt Report Caption«Table 232»Gen. Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeBal. Account Type; [G/L Account,Custom...Bal. Account No.No. SeriesPosting No. SeriesCopy VAT Setup to Jnl. LinesAllow VAT DifferenceAllow Payment ExportBank Statement Import FormatTemplate Type; [General,Sales,Purchase...Recurring«Table 270»Bank AccountNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Bank Account No.Transit No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameMin. BalanceBank Acc. Posting GroupCurrency CodeLanguage CodeStatistics GroupOur Contact CodeCountry/Region CodeAmountCommentBlockedLast Statement No.Last Payment Statement No.Last Date ModifiedDate FilterGlobal Dimension 1 Filter...«Table 4»CurrencyCode [PK,NN]Last Date ModifiedLast Date AdjustedUnrealized Gains Acc.Realized Gains Acc.Unrealized Losses Acc.Realized Losses Acc.Invoice Rounding PrecisionInvoice Rounding Type; [Nearest,Up,Dow...Amount Rounding PrecisionUnit-Amount Rounding PrecisionDescriptionAmount Decimal Places [NN]Unit-Amount Decimal Places [NN]Customer FilterVendor FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterCust. Ledg. Entries in FilterCustomer BalanceCustomer Outstanding OrdersCustomer Shipped Not InvoicedCustomer Balance DueVendor Ledg. Entries in FilterVendor BalanceVendor Outstanding OrdersVendor Amt. Rcd. Not InvoicedVendor Balance DueCustomer Balance [LCY]Vendor Balance [LCY]...«Table 9»Country/RegionCode [PK,NN]NameEU Country/Region CodeIntrastat CodeAddress Format; [Post Code+City,City+P...Contact Address Format; [First,After C...VAT Scheme«Table 1280»Bank Clearing StandardCode [PK]Description<Data Exch Entry No.><General Journal Template><General Journal Batch Name><Sender Bank Account Code><Sender Bank Account Currency><Currency Code><Sender Bank Country/Region><Recipient Bank Country/Region><Sender Bank Clearing Std.><Recipient Bank Clearing Std.><Pmt. Export Data Entry No.><Bal. Account No.><Journal Template Name><Bal. Account No.><Currency Code><Country/Region Code><Bank Clearing Standard>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Entry No. Integer AutoIncrement: Yes
2 Data Exch Entry No. Integer
3 Line No. Integer
4 Data Exch. Line Def Code Code20
5 General Journal Template Code10
6 General Journal Batch Name Code10
7 General Journal Line No. Integer
28 Sender Bank Name - Data Conv. Text50
29 Sender Bank Name Text50
30 Sender Bank Account Code Code20
31 Sender Bank Account No. Text50
32 Sender Bank Account Currency Code10
33 Sender Bank Country/Region Code10
34 Sender Bank BIC Code35
35 Sender Bank Clearing Std. Text50
36 Sender Bank Clearing Code Text50
37 Sender Bank Address Text50
38 Sender Bank City Text50
39 Sender Bank Post Code Code20
40 Recipient Name Text50
41 Recipient Address Text50
42 Recipient City Text50
43 Recipient Post Code Code20
44 Recipient Country/Region Code Code10
45 Recipient Email Address Text80
46 Recipient ID Code20
48 Recipient Bank Clearing Std. Text50
49 Recipient Bank Clearing Code Text50
50 Recipient Reg. No. Code20
51 Recipient Acc. No. Code30
52 Recipient Bank Acc. No. Text50
53 Recipient Bank BIC Code35
54 Recipient Bank Name Text50
55 Recipient Bank Address Text50
56 Recipient Bank City Text50
57 Recipient Bank Country/Region Code10
58 Recipient Creditor No. Code20
59 Recipient Bank Post Code Code20
60 Message Type Code1
61 Letter to Sender Code1
63 Recipient Acknowledgement Code1
64 Short Advice Text35
65 Message to Recipient 1 Text140
66 Message to Recipient 2 Text140
80 Amount Decimal (2:2)
81 Currency Code Code10
82 Transfer Date Date
83 Transfer Type Code1
84 Payment Type Text50
85 Document No. Code20
87 Recipient Reference Code35
88 Payment Reference Code50
89 Invoice Amount Decimal
90 Invoice Date Date
91 Recipient County Text30
92 Recipient Bank County Text30
93 Sender Bank County Text30
100 Payment Information ID Text50
101 End-to-End ID Text50
102 Message ID Text35
103 SEPA Instruction Priority Option
104 SEPA Instruction Priority Text Code4 Editable: No
105 SEPA Payment Method Option
106 SEPA Payment Method Text Code3
107 SEPA Batch Booking Boolean
108 SEPA Charge Bearer Option
109 SEPA Charge Bearer Text Code4
120 SEPA Direct Debit Mandate ID Code35
121 SEPA Direct Debit Seq. Type Option
122 SEPA Direct Debit Seq. Text Code4
123 SEPA DD Mandate Signed Date Date
124 SEPA Partner Type Option
125 SEPA Partner Type Text Code4
130 Importing Code Code10
131 Importing Date Date
132 Importing Description Text250
133 Costs Distribution Text30
134 Message Structure Text30
135 Own Address Info. Text30
170 Creditor No. Code35
171 Transit No. Code35
173 Applies-to Ext. Doc. No. Code35
200 Format Command Code4
201 Format Remittance Info Type Code1
220 Format Payment Type Code2
221 Format Expense Code Code1
222 Format Text Code Code3
283 Format Form Type Code2

Keys

# Fields
0 Entry No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Sender Bank Account Code Bank Account No. 1..n
Recipient Bank Clearing Std. Bank Clearing Standard Code 1..n
Recipient Bank Country/Region Country/Region Code 1..n
Currency Code Currency Code 1..n
Data Exch Entry No. Data Exch. Entry No. 1..n
General Journal Batch Name Gen. Journal Batch Journal Template Name 1..n
General Journal Template Gen. Journal Template Name 1..n

Table Relations From Other Tables

From Table From Field
Payment Export Remittance Text Pmt. Export Data Entry No. 1..n