Diagrams


Table

Data Exch. Def

DynamicsDocs.comData Exch. Def«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 1200»Bank Export/Import SetupCode [PK,NN]NameDirection; [Export,Import,Export-Posit...Processing Codeunit IDProcessing Codeunit NameProcessing XMLport IDProcessing XMLport NameData Exch. Def. CodeData Exch. Def. NamePreserve Non-Latin CharactersCheck Export CodeunitCheck Export Codeunit Name«Table 1213»Data Exchange TypeCode [PK,NN]DescriptionData Exch. Def. CodeEntity Type; [Invoice,Credit Memo]«Table 1220»Data Exch.Entry No. [PK]File NameFile ContentData Exch. Def CodeData Exch. Line Def CodeTable FiltersIncoming Entry No.«Table 1223»Data Exch. Column DefData Exch. Def Code [PK,NN]Column No. [PK,NN]NameShowData Type; [Text,Date,Decimal,DateTime...Data FormatData Formatting CultureDescriptionData Exch. Line Def Code [PK,NN]LengthConstantPathNegative-Sign IdentifierText Padding RequiredPad Character«Table 1224»Data Exch. MappingData Exch. Def Code [PK,NN]Table ID [PK,NN]NameMapping CodeunitData Exch. No. Field IDData Exch. Line Field IDData Exch. Line Def Code [PK,NN]Pre-Mapping CodeunitPost-Mapping CodeunitUse as Intermediate Table«Table 1225»Data Exch. Field MappingData Exch. Def Code [PK,NN]Table ID [PK,NN]Column No. [PK,NN]Field ID [PK]OptionalUse Default ValueDefault ValueData Exch. Line Def Code [PK,NN]MultiplierTarget Table IDTarget Field IDTarget Table CaptionTarget Field CaptionTransformation Rule«Table 1227»Data Exch. Line DefData Exch. Def Code [PK,NN]Code [PK,NN]NameColumn CountData Line TagNamespaceParent CodeLine Type; [Detail,Header,Footer]«Table 1650»Curr. Exch. Rate Update SetupCode [PK,NN]DescriptionWeb Service URLEnabledService ProviderTerms of ServiceData Exch. Def Code«Table 98»General Ledger SetupPrimary Key [PK]Allow Posting FromAllow Posting ToRegister TimePmt. Disc. Excl. VATDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterCust. Balances DueVendor Balances DueUnrealized VATAdjust for Payment Disc.Mark Cr. Memos as CorrectionsLocal Address Format; [Post Code+City,...Inv. Rounding Precision [LCY]Inv. Rounding Type [LCY]; [Nearest,Up,...Local Cont. Addr. Format; [First,After...Bank Account Nos.Summarize G/L EntriesAmount Decimal PlacesUnit-Amount Decimal PlacesAdditional Reporting CurrencyVAT Tolerance %EMU CurrencyLCY CodeVAT Exchange Rate Adjustment; [No Adju...Amount Rounding PrecisionUnit-Amount Rounding PrecisionAppln. Rounding PrecisionGlobal Dimension 1 CodeGlobal Dimension 2 Code...<Data Exch. Def. Code><Data Exch. Def. Code><Data Exch. Def Code><Data Exch. Def Code><Data Exch. Def Code><Data Exch. Def Code><Data Exch. Def Code><Data Exch. Def Code><Payroll Trans. Import Format><Data Exch. Line Def Code><Data Exch. Line Def Code><Column No.><Data Exch. Line Def Code><Table ID><Data Exch. Line 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 Code Code20 NotBlank: Yes
2 Name Text100
3 Type Option
4 Reading/Writing XMLport Integer
5 Header Lines Integer
8 Header Tag Text250
9 Footer Tag Text250
10 Column Separator Option
11 File Encoding Option
13 File Type Option
14 Ext. Data Handling Codeunit Integer
15 Reading/Writing Codeunit Integer
16 Validation Codeunit Integer
17 Data Handling Codeunit Integer
18 User Feedback Codeunit Integer

Keys

# Fields
0 Code Clustered: Yes
1 Type

Table Relations To Other Tables

Field Related Table Related Field
User Feedback Codeunit AllObjWithCaption Object ID 1..n

Table Relations From Other Tables

From Table From Field
Bank Export/Import Setup Data Exch. Def. Code 1..n
Curr. Exch. Rate Update Setup Data Exch. Def Code 1..n
Data Exch. Data Exch. Def Code 1..n
Data Exch. Column Def Data Exch. Def Code 1..n
Data Exch. Field Mapping Data Exch. Def Code 1..n
Data Exch. Line Def Data Exch. Def Code 1..n
Data Exch. Mapping Data Exch. Def Code 1..n
Data Exchange Type Data Exch. Def. Code 1..n
General Ledger Setup Payroll Trans. Import Format 1..n