Coupling Record Buffer

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

Table Type: Company

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

Table Number: 5332

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[NAV Name]
   ,[CRM Name]
   ,[NAV Table ID]
   ,[CRM Table ID]
   ,[Sync Action]
   ,[NAV Record ID]
   ,[CRM ID]
   ,[Create New]
   ,[Saved Sync Action]
   ,[Saved CRM ID]
   ,[CRM Table Name]
   ,[CRM Option Id]
   ,[Saved CRM Option Id]
   ,[Is Option]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Coupling Record Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Coupling Record Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2NAV Name Primary Key Searchnvarchar(500)
3CRM Name Searchnvarchar(500)
4NAV Table ID Searchint
5CRM Table ID Searchint
6Sync Action Searchint
7NAV Record ID Searchvarbinary(448)
8CRM ID Searchuniqueidentifier
9Create New Searchtinyint
10Saved Sync Action Searchint
11Saved CRM ID Searchuniqueidentifier
12CRM Table Name Searchnvarchar(40)
13CRM Option Id Searchint
14Saved CRM Option Id Searchint
15Is Option Searchtinyint
16$systemId Searchuniqueidentifier
17$systemCreatedAt Searchdatetime
18$systemCreatedBy Searchuniqueidentifier
19$systemModifiedAt Searchdatetime
20$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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