Record Buffer

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

Table Type: Company

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

Table Number: 6529

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Table No_]
   ,[Table Name]
   ,[Record Identifier]
   ,[Search Record ID]
   ,[Primary Key]
   ,[Primary Key Field 1 No_]
   ,[Primary Key Field 1 Value]
   ,[Primary Key Field 2 No_]
   ,[Primary Key Field 2 Value]
   ,[Primary Key Field 3 No_]
   ,[Primary Key Field 3 Value]
   ,[Level]
   ,[Serial No_]
   ,[Lot No_]
   ,[Item No_]
   ,[Variant Code]
   ,[Package No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Record Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Record Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Record Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Record Buffer].[Item No_] = [Item].[No_]

Show/hide columns in Record Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Table No_ Searchint
4Table Name Searchnvarchar(500)
5Record Identifier Searchvarbinary(448)
6Search Record ID Searchnvarchar(200)
7Primary Key Searchnvarchar(500)
8Primary Key Field 1 No_ Searchint
9Primary Key Field 1 Value Searchnvarchar(100)
10Primary Key Field 2 No_ Searchint
11Primary Key Field 2 Value Searchnvarchar(100)
12Primary Key Field 3 No_ Searchint
13Primary Key Field 3 Value Searchnvarchar(100)
14Level Searchint
15Serial No_ Searchnvarchar(100)
16Lot No_ Searchnvarchar(100)
17Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Record Buffer].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Record Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Record Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Record Buffer].[Item No_] = [Item].[No_]
18Variant Code Searchnvarchar(20)
19Package No_ Searchnvarchar(100)
20$systemId Searchuniqueidentifier
21$systemCreatedAt Searchdatetime
22$systemCreatedBy Searchuniqueidentifier
23$systemModifiedAt Searchdatetime
24$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Record Buffer table

Leave a Reply

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