Shpfy Log Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SShpfy Log Entry

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

Table Type: Company

Table Name: Shpfy Log Entry
Database Table Name: CRONUS UK Ltd_$Shpfy Log Entry$ec255f57-31d0-4ca2-b751-f2fa7c745abb

Table Number: 30115

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 Shpfy Log Entry can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Shpfy Log Entry$ec255f57-31d0-4ca2-b751-f2fa7c745abb]

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[Date and Time]
   ,[Time]
   ,[User ID]
   ,[Request]
   ,[Response]
   ,[Status Code]
   ,[Status Description]
   ,[URL]
   ,[Method]
   ,[Has Error]
   ,[Request Id]
   ,[Request Preview]
   ,[Response Preview]
   ,[Retry Count]
   ,[Query Cost]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Shpfy Log Entry$ec255f57-31d0-4ca2-b751-f2fa7c745abb]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Shpfy Log Entry$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Log Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Campaign Status$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign Status]
      ON
         [Shpfy Log Entry].[Status Code] = [Campaign Status].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Log Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Log Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Shpfy Log Entry table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	BigInteger	8	Entry No_	bigint
2	Date and Time	Date and Time	Normal	DateTime	8	Date and Time	datetime
3	Time	Time	Normal	Time	4	Time	datetime
4	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
6	Request	Request	Normal	BLOB	8	Request	image
7	Response	Response	Normal	BLOB	8	Response	image
8	Status Code	Status Code	Normal	Code	10	Status Code	nvarchar(20)
	Key to join to the Campaign Status table. Show/hide example query SELECT [Shpfy Log Entry].[Status Code] ,[Campaign Status].[Code] FROM [CRONUS UK Ltd_$Shpfy Log Entry$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Log Entry] LEFT JOIN [CRONUS UK Ltd_$Campaign Status$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign Status] ON [Shpfy Log Entry].[Status Code] = [Campaign Status].[Code]
9	Status Description	Status Description	Normal	Text	500	Status Description	nvarchar(1000)
10	URL	URL	Normal	Text	500	URL	nvarchar(1000)
11	Method	Method	Normal	Text	30	Method	nvarchar(60)
12	Has Error	Has Error	Normal	Boolean	4	Has Error	tinyint
13	Request Id	Request Id	Normal	GUID	16	Request Id	uniqueidentifier
14	Request Preview	Request Preview	Normal	Text	50	Request Preview	nvarchar(100)
15	Response Preview	Response Preview	Normal	Text	50	Response Preview	nvarchar(100)
16	Retry Count	Retry Count	Normal	Integer	4	Retry Count	int
17	Query Cost	Query Cost	Normal	Integer	4	Query Cost	int
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Shpfy Log Entry].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Shpfy Log Entry$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Log Entry] LEFT JOIN [User] AS [User] ON [Shpfy Log Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Shpfy Log Entry].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Shpfy Log Entry$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Log Entry] LEFT JOIN [User] AS [User] ON [Shpfy Log Entry].[$systemModifiedBy] = [User].[User Security ID]