Job Resource Price

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

Table Type: Company

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

Table Number: 1012

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Job No_]
   ,[Job Task No_]
   ,[Type]
   ,[Code]
   ,[Work Type Code]
   ,[Currency Code]
   ,[Unit Price]
   ,[Unit Cost Factor]
   ,[Line Discount _]
   ,[Description]
   ,[Apply Job Price]
   ,[Apply Job Discount]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Job Resource Price$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 Resource Price$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Resource Price]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Job Resource Price].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Job Resource Price].[Job Task No_] = [Job Task].[Job Task No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Job Resource Price].[Currency Code] = [Currency].[Code]

Show/hide columns in Job Resource Price table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Job No_ Primary Key Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Job Resource Price].[Job No_]
       ,[Job].[Job No_]
FROM
       [CRONUS UK Ltd_$Job Resource Price$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Resource Price]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Job Resource Price].[Job No_] = [Job].[Job No_]
3Job Task No_ Primary Key Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

SELECT
       [Job Resource Price].[Job Task No_]
       ,[Job Task].[Job Task No_]
FROM
       [CRONUS UK Ltd_$Job Resource Price$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Resource Price]
LEFT JOIN
       [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
              ON
                     [Job Resource Price].[Job Task No_] = [Job Task].[Job Task No_]
4Type Primary Key Searchint
5Code Primary Key Searchnvarchar(40)
6Work Type Code Primary Key Searchnvarchar(20)
7Currency Code Primary Key Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Job Resource Price].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Job Resource Price$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Resource Price]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Job Resource Price].[Currency Code] = [Currency].[Code]
8Unit Price Searchdecimal(38,38)
9Unit Cost Factor Searchdecimal(38,38)
10Line Discount _ Searchdecimal(38,38)
11Description Searchnvarchar(200)
12Apply Job Price Searchtinyint
13Apply Job Discount Searchtinyint
14$systemId Searchuniqueidentifier
15$systemCreatedAt Searchdatetime
16$systemCreatedBy Searchuniqueidentifier
17$systemModifiedAt Searchdatetime
18$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Job Resource Price table

Leave a Reply

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