Loaner Entry

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

Table Type: Company

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

Table Number: 5914

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Loaner No_]
   ,[Document No_]
   ,[Service Item Line No_]
   ,[Service Item No_]
   ,[Service Item Group Code]
   ,[Customer No_]
   ,[Date Lent]
   ,[Time Lent]
   ,[Date Received]
   ,[Time Received]
   ,[Lent]
   ,[Document Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Loaner Entry$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 Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Loaner Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Loaner Entry].[Customer No_] = [Customer].[No_]

Show/hide columns in Loaner Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Loaner No_ Searchnvarchar(40)
4Document No_ Searchnvarchar(40)
5Service Item Line No_ Searchint
6Service Item No_ Searchnvarchar(40)
7Service Item Group Code Searchnvarchar(20)
8Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Loaner Entry].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Loaner Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Loaner Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Loaner Entry].[Customer No_] = [Customer].[No_]
9Date Lent Searchdatetime
10Time Lent Searchdatetime
11Date Received Searchdatetime
12Time Received Searchdatetime
13Lent Searchtinyint
14Document Type Searchint
15$systemId Searchuniqueidentifier
16$systemCreatedAt Searchdatetime
17$systemCreatedBy Searchuniqueidentifier
18$systemModifiedAt Searchdatetime
19$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Loaner Entry table

Leave a Reply

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