Loaner

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

Table Type: Company

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

Table Number: 5913

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Description]
   ,[Description 2]
   ,[Unit of Measure Code]
   ,[Item No_]
   ,[Last Date Modified]
   ,[Blocked]
   ,[No_ Series]
   ,[Serial No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Loaner$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

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

Show/hide columns in Loaner table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Description Searchnvarchar(200)
4Description 2 Searchnvarchar(100)
5Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Loaner].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Loaner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Loaner]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Loaner].[Unit of Measure Code] = [Unit of Measure].[Code]
6Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Loaner].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Loaner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Loaner]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Loaner].[Item No_] = [Item].[No_]
7Last Date Modified Searchdatetime
8Blocked Searchtinyint
9No_ Series Searchnvarchar(40)
10Serial No_ Searchnvarchar(100)
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Loaner table

Leave a Reply

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