XML Schema Element

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/9610

Table Type: Company

Table Name: XML Schema Element
Database Table Name: CRONUS UK Ltd_$XML Schema Element$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 9610

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how XML Schema Element can be queried.

Show/hide an example select of all columns

Show/hide an example select of all columns by name

Show/hide an example select of all columns including those from all joined tables

Show/hide columns in XML Schema Element table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1XML Schema Code SearchXML Schema CodeNormalCode20XML Schema Codenvarchar(40)
2ID Primary Key SearchIDNormalInteger4IDint
3Parent ID Primary Key SearchParent IDNormalInteger4Parent IDint
Key to join to the Shpfy Order Transaction table.

Show/hide example query

4Node Name SearchNode NameNormalText250Node Namenvarchar(500)
5Node Type SearchNode TypeNormalOption4Node Typeint
Available options are:
  • “Element”
  • “Attribute”
  • “Definition Node”
6Data Type SearchData TypeNormalText250Data Typenvarchar(500)
7MinOccurs SearchMinOccursNormalInteger4MinOccursint
8MaxOccurs SearchMaxOccursNormalInteger4MaxOccursint
9Choice SearchChoiceNormalBoolean4Choicetinyint
20Sort Key SearchSort KeyNormalText200Sort Keynvarchar(400)
21Indentation SearchIndentationNormalInteger4Indentationint
22Visible SearchVisibleNormalBoolean4Visibletinyint
23Selected SearchSelectedNormalBoolean4Selectedtinyint
24Simple Data Type SearchSimple Data TypeNormalText50Simple Data Typenvarchar(100)
25Defintion XML Schema Code SearchDefintion XML Schema CodeNormalCode20Defintion XML Schema Codenvarchar(40)
26Definition XML Schema ID SearchDefinition XML Schema IDNormalInteger4Definition XML Schema IDint
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *