Job Journal Quantity

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

Table Type: Company

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

Table Number: 278

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 Job Journal Quantity can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Is Total]
   ,[Unit of Measure Code]
   ,[Line Type]
   ,[Work Type Code]
   ,[Quantity]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Job Journal Quantity$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Job Journal Quantity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Quantity]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Job Journal Quantity].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Job Journal Quantity table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Is Total Primary Key Searchtinyint
3Unit of Measure Code Primary Key Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Job Journal Quantity].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Job Journal Quantity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Quantity]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Job Journal Quantity].[Unit of Measure Code] = [Unit of Measure].[Code]
4Line Type Primary Key Searchint
5Work Type Code Primary Key Searchnvarchar(20)
6Quantity Searchdecimal(38,38)
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Job Journal Quantity table

Leave a Reply

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