Excel Buffer

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

Table Type: Company

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

Table Number: 370

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Row No_]
   ,[Column No_]
   ,[xlRowID]
   ,[xlColID]
   ,[Cell Value as Text]
   ,[Comment]
   ,[Formula]
   ,[Bold]
   ,[Italic]
   ,[Underline]
   ,[NumberFormat]
   ,[Formula2]
   ,[Formula3]
   ,[Formula4]
   ,[Cell Type]
   ,[Double Underline]
   ,[Cell Value as Blob]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Excel Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Excel Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Row No_ Primary Key Searchint
3Column No_ Primary Key Searchint
4xlRowID Searchnvarchar(20)
5xlColID Searchnvarchar(20)
6Cell Value as Text Searchnvarchar(500)
7Comment Searchnvarchar(500)
8Formula Searchnvarchar(500)
9Bold Searchtinyint
10Italic Searchtinyint
11Underline Searchtinyint
12NumberFormat Searchnvarchar(60)
13Formula2 Searchnvarchar(500)
14Formula3 Searchnvarchar(500)
15Formula4 Searchnvarchar(500)
16Cell Type Searchint
17Double Underline Searchtinyint
18Cell Value as Blob Searchimage
19$systemId Searchuniqueidentifier
20$systemCreatedAt Searchdatetime
21$systemCreatedBy Searchuniqueidentifier
22$systemModifiedAt Searchdatetime
23$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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