Unit of Measure

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

Table Type: Company

Table Name: Unit of Measure
Database Table Name: CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 204

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 Unit of Measure can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Code]
   ,[Description]
   ,[International Standard Code]
   ,[Symbol]
   ,[Last Modified Date Time]
   ,[Coupled to CRM]
   ,[Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
LEFT JOIN
   [User] AS [User]
      ON
         [Unit of Measure].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Unit of Measure].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Unit of Measure table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode10Codenvarchar(20)
2Description SearchDescriptionNormalText50Descriptionnvarchar(100)
3International Standard Code SearchInternational Standard CodeNormalCode10International Standard Codenvarchar(20)
4Symbol SearchSymbolNormalText10Symbolnvarchar(20)
5Last Modified Date Time SearchLast Modified Date TimeNormalDateTime8Last Modified Date Timedatetime
720Coupled to CRM SearchCoupled to Dynamics 365 SalesNormalBoolean4Coupled to CRMtinyint
721Coupled to Dataverse SearchCoupled to Dynamics 365 SalesFlowFieldBoolean4
8000Id SearchIdNormalGUID16Iduniqueidentifier
27000SAT UofM Classification SearchSAT UofM ClassificationNormalCode10
27001SAT Customs Unit SearchSAT Customs UnitNormalCode10
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
       [Unit of Measure].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
LEFT JOIN
       [User] AS [User]
              ON
                     [Unit of Measure].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Unit of Measure].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
LEFT JOIN
       [User] AS [User]
              ON
                     [Unit of Measure].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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