XML Buffer

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

Table Type: Company

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

Table Number: 1235

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 Buffer can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$XML Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Type]
   ,[Name]
   ,[Path]
   ,[Value]
   ,[Depth]
   ,[Parent Entry No_]
   ,[Is Parent]
   ,[Data Type]
   ,[Code]
   ,[Node Name]
   ,[Has Attributes]
   ,[Node Number]
   ,[Namespace]
   ,[Import ID]
   ,[Value BLOB]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$XML Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in XML Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Type Searchint
4Name Searchnvarchar(500)
5Path Searchnvarchar(500)
6Value Searchnvarchar(500)
7Depth Searchint
8Parent Entry No_ Searchint
9Is Parent Searchtinyint
10Data Type Searchint
11Code Searchnvarchar(40)
12Node Name Searchnvarchar(500)
13Has Attributes Searchtinyint
14Node Number Searchint
15Namespace Searchnvarchar(500)
16Import ID Searchuniqueidentifier
17Value BLOB Searchimage
18$systemId Searchuniqueidentifier
19$systemCreatedAt Searchdatetime
20$systemCreatedBy Searchuniqueidentifier
21$systemModifiedAt Searchdatetime
22$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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