Diagrams

Table

Data Exch.

DynamicsDocs.comData Exch.«Table 1220»Data Exch.Entry No. [PK]File NameFile ContentData Exch. Def CodeData Exch. Line Def CodeTable FiltersIncoming Entry No.Related Record«Table 1214»Intermediate Data ImportID [PK]Data Exch. No. [NN]Table ID [NN]Record No.Field IDValueValidate OnlyParent Record No.«Table 1221»Data Exch. FieldData Exch. No. [PK,NN]Line No. [PK,NN]Column No. [PK,NN]ValueNode ID [PK]Data Exch. Line Def CodeParent Node IDData Exch. Def Code«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 1240»Positive Pay HeaderData Exch. Entry No. [PK]Company NameAccount NumberDate of File«Table 1241»Positive Pay DetailData Exch. Entry No. [PK]Entry No. [PK]Account NumberRecord Type CodeVoid Check IndicatorCheck NumberAmountIssue DatePayeeCurrency Code«Table 1242»Positive Pay FooterData Exch. Entry No. [PK]Data Exch. Detail Entry No.Account NumberCheck CountCheck TotalVoid CountVoid TotalTotal CountGrand Total«Table 1296»Posted Payment Recon. LineBank Account No. [PK]Statement No. [PK]Statement Line No. [PK]Document No.Transaction DateDescriptionStatement AmountDifferenceApplied AmountType; [Bank Account Ledger Entry,Check...Applied EntriesValue DateCheck No.Related-Party NameAdditional Transaction InfoData Exch. Entry No.Data Exch. Line No.Account Type; [G/L Account,Customer,Ve...Account No.Applied Document No.Applied Entry No.Transaction IDReconciled«Table 272»Check Ledger EntryEntry No. [PK]Bank Account No.Bank Account Ledger Entry No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionAmountCheck DateCheck No.Check Type; [Total Check,Partial Check...Bank Payment Type; [,Computer Check,Ma...Entry Status; [,Printed,Voided,Posted,...Original Entry Status; [,Printed,Voide...Bal. Account Type; [G/L Account,Custom...Bal. Account No.OpenStatement Status; [Open,Bank Acc. Entr...Statement No.Statement Line No.User IDExternal Document No.Data Exch. Entry No.Data Exch. Voided Entry No.Positive Pay ExportedRecord ID to Print«Table 274»Bank Acc. Reconciliation LineBank Account No. [PK]Statement No. [PK]Statement Line No. [PK]Document No.Transaction DateDescriptionStatement AmountDifferenceApplied AmountType; [Bank Account Ledger Entry,Check...Applied EntriesValue DateReady for ApplicationCheck No.Related-Party NameAdditional Transaction InfoData Exch. Entry No.Data Exch. Line No.Statement Type; [Bank Reconciliation,P...Account Type; [G/L Account,Customer,Ve...Account No.Transaction TextRelated-Party Bank Acc. No.Related-Party AddressRelated-Party CityShortcut Dimension 1 CodeShortcut Dimension 2 CodeMatch Confidence; [None,Low,Medium,Hig...Match QualitySorting OrderParent Line No....«Table 81»Gen. Journal LineJournal Template Name [PK]Line No. [PK]Account Type; [G/L Account,Customer,Ve...Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionVAT %Bal. Account No.Currency CodeAmountDebit AmountCredit AmountAmount [LCY]Balance [LCY]Currency FactorSales/Purch. [LCY]Profit [LCY]Inv. Discount [LCY]Bill-to/Pay-to No.Posting GroupShortcut Dimension 1 CodeShortcut Dimension 2 CodeSalespers./Purch. CodeSource CodeSystem-Created EntryOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.Due Date...«Table 1222»Data Exch. DefCode [PK,NN]NameType; [Bank Statement Import,Payment E...Reading/Writing XMLportHeader LinesHeader TagFooter TagColumn Separator; [,Tab,Semicolon,Comm...File Encoding; [MS-DOS,UTF-8,UTF-16,WI...File Type; [Xml,Variable Text,Fixed Te...Ext. Data Handling CodeunitReading/Writing CodeunitValidation CodeunitData Handling CodeunitUser Feedback Codeunit«Table 1227»Data Exch. Line DefData Exch. Def Code [PK,NN]Code [PK,NN]NameColumn CountData Line TagNamespaceParent CodeLine Type; [Detail,Header,Footer]«Table 130»Incoming DocumentEntry No. [PK]DescriptionCreated Date-TimeCreated By User IDCreated By User NameReleasedReleased Date-TimeReleased By User IDReleased By User NameLast Date-Time ModifiedLast Modified By User IDLast Modified By User NamePostedPosted Date-TimeDocument Type; [Journal,Sales Invoice,...Document No.Posting DateStatus; [New,Released,Rejected,Posted,...URL1URL2URL3URL4Vendor NameVendor VAT Registration No.Vendor IBANDocument DateVendor Bank Branch No.Vendor Bank Account No.Vendor No.Data Exchange TypeOCR Data Corrected...<Data Exch. Def Code><Data Exch. Line Def Code><Incoming Entry No.><Data Exch. No.><Data Exch. No.><Data Exch Entry No.><Data Exch. Entry No.><Data Exch. Entry No.><Data Exch. Entry No.><Data Exch. Entry No.><Data Exch. Entry No.><Data Exch. Voided Entry No.><Data Exch. Entry No.><Data Exch. Entry No.><Data Exch. Line Def Code><Data Exch. Detail Entry No.><Statement No.><Statement Line No.><Incoming Document Entry No.><Data Exch. Def Code><Parent Code>

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

Fields

# Name Type
1 Entry No. (Entry No.) Integer AutoIncrement: Yes
2 File Name (File Name) Text250
3 File Content (File Content) BLOB
4 Data Exch. Def Code (Data Exch. Def Code) Code20
5 Data Exch. Line Def Code (Data Exch. Line Def Code) Code20
6 Table Filters (Table Filters) BLOB
10 Incoming Entry No. (Incoming Entry No.) Integer
11 Related Record (Related Record) RecordID

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Data Exch. Def Code (Data Exch. Def Code) Data Exch. Def Code (Code) 1..n
Data Exch. Line Def Code (Data Exch. Line Def Code) Data Exch. Line Def Code (Code) 1..n
Incoming Entry No. (Incoming Entry No.) Incoming Document Entry No. (Entry No.) 1..n

Table Relations From Other Tables

From Table From Field
Bank Acc. Reconciliation Line Data Exch. Entry No. (Data Exch. Entry No.) 1..n
Check Ledger Entry Data Exch. Voided Entry No. (Data Exch. Voided Entry No.) 1..n
Data Exch. Field Data Exch. No. (Data Exch. No.) 1..n
Gen. Journal Line Data Exch. Entry No. (Data Exch. Entry No.) 1..n
Intermediate Data Import Data Exch. No. (Data Exch. No.) 1..n
Payment Export Data Data Exch Entry No. (Data Exch Entry No.) 1..n
Positive Pay Detail Data Exch. Entry No. (Data Exch. Entry No.) 1..n
Positive Pay Footer Data Exch. Entry No. (Data Exch. Entry No.) 1..1
Positive Pay Header Data Exch. Entry No. (Data Exch. Entry No.) 1..1
Posted Payment Recon. Line Data Exch. Entry No. (Data Exch. Entry No.) 1..n