I am trying to read an XML generated from microsoft dynamics ax 2009

Question

I am trying to read an XML generated from microsoft dynamics ax 2009

Navigation

#1 by (3 votes)

1

I am looking at the data in each table and I am trying to identify the primary key of each one. I am using a text editor (sublime text).

Can anyone tell me what this field is called in the XML, or how do I identify it? by fa,

This is a table:

<CloudTable Name="Currency" PhysicalName="aCurrency" Class="Table" Type="Base" OriginalName="CURRENCY" Schema="dbo" CreationTime="635870068771784760" LastUpdatedTime="635885477912288415" BuildBehavior="Sync" Guid="ae8354d54LQAace86LQAa4840LQAa8aabLQAa96018fea168c">
    <CloudTable.ConnectionProperties>
      <DatabaseConnectionProperties assembly="Prism.Libraries.QuestionComposition" type="Prism.Libraries.QuestionComposition.Databases.DatabaseConnectionProperties" TimeOut="30" Database="AX2012R2" Server="localhost" Port="-1" Schema="dbo" Table="CURRENCY" IsUsingDirectConnection="False" ServiceId="" Provider="sql" Culture="1045" />
    </CloudTable.ConnectionProperties>
    <CloudTable.Query>
      <TableWhereColumnQuery assembly="Prism.Libraries.QuestionComposition" type="Prism.Libraries.QuestionComposition.Databases.TableWhereColumnQuery" IsExecutingReader="True" IsUserDefined="False" ColumnName="" Operator="EqualTo" Schema="dbo" Table="CURRENCY" RowLimit="-1" />
    </CloudTable.Query>
    <CloudTable.Cols>
      <Columns>
        <Column Name="CURRENCYCODE" PhysicalName="aCURRENCYCODE" Type="Base" DataType="Text" DataSize="65536" NumericPrecision="0" NumericScale="0" OriginalName="CURRENCYCODE" OriginalDataType="NVarChar" IsDescriptive="False" IsVisible="True" IsAvailable="True" LastUpdatedTime="635870068903483941" CreationTime="0" OriginalDataSize="0" OriginalNumericPrecision="0" OriginalNumericScale="0" IsVirtuallyMerged="False" />
        <Column Name="CURRENCYCODEISO" PhysicalName="aCURRENCYCODEISO" Type="Base" DataType="Text" DataSize="65536" NumericPrecision="0" NumericScale="0" OriginalName="CURRENCYCODEISO" OriginalDataType="NVarChar" IsDescriptive="False" IsVisible="False" IsAvailable="False" LastUpdatedTime="635870068863531679" CreationTime="0" OriginalDataSize="0" OriginalNumericPrecision="0" OriginalNumericScale="0" IsVirtuallyMerged="False" />
        <Column Name="ISEURO" PhysicalName="aISEURO" Type="Base" DataType="Int" DataSize="4" NumericPrecision="10" NumericScale="0" OriginalName="ISEURO" OriginalDataType="Int" IsDescriptive="False" IsVisible="False" IsAvailable="False" LastUpdatedTime="635870068863531679" CreationTime="0" OriginalDataSize="0" OriginalNumericPrecision="0" OriginalNumericScale="0" IsVirtuallyMerged="False" />
        <Column Name="MODIFIEDDATETIME" PhysicalName="aMODIFIEDDATETIME" Type="Base" DataType="Timestamp" DataSize="8" NumericPrecision="0" NumericScale="0" OriginalName="MODIFIEDDATETIME" OriginalDataType="DateTime" IsDescriptive="False" IsVisible="False" IsAvailable="False" LastUpdatedTime="635870068863531679" CreationTime="0" OriginalDataSize="0" OriginalNumericPrecision="0" OriginalNumericScale="0" IsVirtuallyMerged="False" />
        <Column Name="PARTITION" PhysicalName="aPARTITION" Type="Base" DataType="BigInt" DataSize="8" NumericPrecision="19" NumericScale="0" OriginalName="PARTITION" OriginalDataType="BigInt" IsDescriptive="False" IsVisible="False" IsAvailable="False" LastUpdatedTime="635870068863541688" CreationTime="0" OriginalDataSize="0" OriginalNumericPrecision="0" OriginalNumericScale="0" IsVirtuallyMerged="False" />
        <Column Name="RECID" PhysicalName="aRECID" Type="Base" DataType="BigInt" DataSize="8" NumericPrecision="19" NumericScale="0" OriginalName="RECID" OriginalDataType="BigInt" IsDescriptive="False" IsVisible="False" IsAvailable="False" LastUpdatedTime="635870068863541688" CreationTime="0" OriginalDataSize="0" OriginalNumericPrecision="0" OriginalNumericScale="0" IsVirtuallyMerged="False" />
        <Column Name="RECVERSION" PhysicalName="aRECVERSION" Type="Base" DataType="Int" DataSize="4" NumericPrecision="10" NumericScale="0" OriginalName="RECVERSION" OriginalDataType="Int" IsDescriptive="False" IsVisible="False" IsAvailable="False" LastUpdatedTime="635870068863541688" CreationTime="0" OriginalDataSize="0" OriginalNumericPrecision="0" OriginalNumericScale="0" IsVirtuallyMerged="False" />
        <Column Name="ROUNDINGPRECISION" PhysicalName="aROUNDINGPRECISION" Type="Base" DataType="Decimal" DataSize="17" NumericPrecision="32" NumericScale="16" OriginalName="ROUNDINGPRECISION" OriginalDataType="Decimal" IsDescriptive="False" IsVisible="False" IsAvailable="False" LastUpdatedTime="635870068863541688" CreationTime="0" OriginalDataSize="0" OriginalNumericPrecision="0" OriginalNumericScale="0" IsVirtuallyMerged="False" />
        <Column Name="ROUNDOFFPRICE" PhysicalName="aROUNDOFFPRICE" Type="Base" DataType="Decimal" DataSize="17" NumericPrecision="32" NumericScale="16" OriginalName="ROUNDOFFPRICE" OriginalDataType="Decimal" IsDescriptive="False" IsVisible="False" IsAvailable="False" LastUpdatedTime="635870068863541688" CreationTime="0" OriginalDataSize="0" OriginalNumericPrecision="0" OriginalNumericScale="0" IsVirtuallyMerged="False" />
        <Column Name="ROUNDOFFPURCH" PhysicalName="aROUNDOFFPURCH" Type="Base" DataType="Decimal" DataSize="17" NumericPrecision="32" NumericScale="16" OriginalName="ROUNDOFFPURCH" OriginalDataType="Decimal" IsDescriptive="False" IsVisible="False" IsAvailable="False" LastUpdatedTime="635870068863541688" CreationTime="0" OriginalDataSize="0" OriginalNumericPrecision="0" OriginalNumericScale="0" IsVirtuallyMerged="False" />
        <Column Name="ROUNDOFFSALES" PhysicalName="aROUNDOFFSALES" Type="Base" DataType="Decimal" DataSize="17" NumericPrecision="32" NumericScale="16" OriginalName="ROUNDOFFSALES" OriginalDataType="Decimal" IsDescriptive="False" IsVisible="False" IsAvailable="False" LastUpdatedTime="635870068863541688" CreationTime="0" OriginalDataSize="0" OriginalNumericPrecision="0" OriginalNumericScale="0" IsVirtuallyMerged="False" />
        <Column Name="ROUNDOFFTYPEPRICE" PhysicalName="aROUNDOFFTYPEPRICE" Type="Base" DataType="Int" DataSize="4" NumericPrecision="10" NumericScale="0" OriginalName="ROUNDOFFTYPEPRICE" OriginalDataType="Int" IsDescriptive="False" IsVisible="False" IsAvailable="False" LastUpdatedTime="635870068863541688" CreationTime="0" OriginalDataSize="0" OriginalNumericPrecision="0" OriginalNumericScale="0" IsVirtuallyMerged="False" />
        <Column Name="ROUNDOFFTYPEPURCH" PhysicalName="aROUNDOFFTYPEPURCH" Type="Base" DataType="Int" DataSize="4" NumericPrecision="10" NumericScale="0" OriginalName="ROUNDOFFTYPEPURCH" OriginalDataType="Int" IsDescriptive="False" IsVisible="False" IsAvailable="False" LastUpdatedTime="635870068863541688" CreationTime="0" OriginalDataSize="0" OriginalNumericPrecision="0" OriginalNumericScale="0" IsVirtuallyMerged="False" />
        <Column Name="ROUNDOFFTYPESALES" PhysicalName="aROUNDOFFTYPESALES" Type="Base" DataType="Int" DataSize="4" NumericPrecision="10" NumericScale="0" OriginalName="ROUNDOFFTYPESALES" OriginalDataType="Int" IsDescriptive="False" IsVisible="False" IsAvailable="False" LastUpdatedTime="635870068863541688" CreationTime="0" OriginalDataSize="0" OriginalNumericPrecision="0" OriginalNumericScale="0" IsVirtuallyMerged="False" />
        <Column Name="SYMBOL" PhysicalName="aSYMBOL" Type="Base" DataType="Text" DataSize="65536" NumericPrecision="0" NumericScale="0" OriginalName="SYMBOL" OriginalDataType="NVarChar" IsDescriptive="False" IsVisible="False" IsAvailable="False" LastUpdatedTime="635870068863551696" CreationTime="0" OriginalDataSize="0" OriginalNumericPrecision="0" OriginalNumericScale="0" IsVirtuallyMerged="False" />
        <Column Name="CURRENCYNAME" PhysicalName="aCURRENCYNAME" Type="Base" DataType="Text" DataSize="65536" NumericPrecision="0" NumericScale="0" OriginalName="TXT" OriginalDataType="NVarChar" IsDescriptive="False" IsVisible="True" IsAvailable="True" LastUpdatedTime="635870147608634956" CreationTime="0" OriginalDataSize="0" OriginalNumericPrecision="0" OriginalNumericScale="0" IsVirtuallyMerged="False" />
      </Columns>
    </CloudTable.Cols>
    <CloudTable.AttachedData>
      <Default />
    </CloudTable.AttachedData>
    <CloudTable.Attachment>
      <TableViewModel assembly="Prism.Core.Abacus.UI" type="Prism.Core.Abacus.UI.Diagram.ViewModels.TableViewModel">
        <TableViewModel.DiagramHostViewModel>
          <vmLmnt assembly="Prism.Vizu" type="Prism.Vizu.ViewModels.vmLmnt" X="5970.76900593695" Y="-216.926148691612" W="220" H="413" />
        </TableViewModel.DiagramHostViewModel>
      </TableViewModel>
    </CloudTable.Attachment>
  </CloudTable>

xml dynamics-ax

asked by carlos palacios 19.10.2016 в 00:06

source

1 answer

How do you install an Apk and what does it look like afterwards? Is it possible to capture a segfault with try / catch?

score 3 · Answer 1

As far as I can see the table is Currency , you also mention that this is from AX 2009 . The Currency table AX 2009 has Primary key the CurrencyCode field. There is no such information in the XML. I do not think anyone changed the Primary key so your Primary key has to be the CurrencyCode field.