Serial No. Information

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

Table Type: Company

Table Name: Serial No. Information
Database Table Name: CRONUS UK Ltd_$Serial No_ Information$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 6504

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 Serial No. Information can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Serial No_ Information$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Item No_]
   ,[Variant Code]
   ,[Serial No_]
   ,[Description]
   ,[Blocked]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Serial No_ Information$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Serial No_ Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Serial No. Information]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Serial No. Information].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Serial No. Information].[Location Filter] = [Location].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Serial No. Information].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Serial No. Information].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Serial No. Information table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
	       [Serial No. Information].[Item No_]
	       ,[Item].[No_]
	FROM
	       [CRONUS UK Ltd_$Serial No_ Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Serial No. Information]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
	              ON
	                     [Serial No. Information].[Item No_] = [Item].[No_]
2Variant Code Primary Key SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
	       [Serial No. Information].[Variant Code]
	       ,[Item Variant].[Code]
	FROM
	       [CRONUS UK Ltd_$Serial No_ Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Serial No. Information]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
	              ON
	                     [Serial No. Information].[Variant Code] = [Item Variant].[Code]
3Serial No. Primary Key SearchSerial No.NormalCode50Serial No_nvarchar(100)
10Description Primary Key SearchDescriptionNormalText100Descriptionnvarchar(200)
13Blocked SearchBlockedNormalBoolean4Blockedtinyint
14Comment SearchCommentFlowFieldBoolean4
20Inventory SearchQuantity on HandFlowFieldDecimal12
21Date Filter SearchDate FilterFlowFilterDate4
22Location Filter SearchLocation FilterFlowFilterCode10
Key to join to the Location table.

Show/hide example query

SELECT
	       [Serial No. Information].[]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Serial No_ Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Serial No. Information]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Serial No. Information].[] = [Location].[Code]
23Bin Filter SearchBin FilterFlowFilterCode20
24Expired Inventory SearchExpired InventoryFlowFieldDecimal12
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [Serial No. Information].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Serial No_ Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Serial No. Information]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Serial No. Information].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Leave a Reply

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