Job Item Price

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

Table Type: Company

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

Table Number: 1013

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Job No_]
   ,[Job Task No_]
   ,[Item No_]
   ,[Variant Code]
   ,[Unit of Measure Code]
   ,[Currency Code]
   ,[Unit Price]
   ,[Unit Cost Factor]
   ,[Line Discount _]
   ,[Apply Job Price]
   ,[Apply Job Discount]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Job Item 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 Item Price$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Item Price]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Job Item Price].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Job Item Price].[Job Task No_] = [Job Task].[Job Task No_]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Job Item Price].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Job Item Price].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Job Item Price].[Currency Code] = [Currency].[Code]

Show/hide columns in Job Item 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 Item Price].[Job No_]
       ,[Job].[Job No_]
FROM
       [CRONUS UK Ltd_$Job Item Price$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Item Price]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Job Item 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 Item Price].[Job Task No_]
       ,[Job Task].[Job Task No_]
FROM
       [CRONUS UK Ltd_$Job Item Price$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Item Price]
LEFT JOIN
       [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
              ON
                     [Job Item Price].[Job Task No_] = [Job Task].[Job Task No_]
4Item No_ Primary Key Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Job Item Price].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Job Item Price$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Item Price]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Job Item Price].[Item No_] = [Item].[No_]
5Variant Code Primary Key Searchnvarchar(20)
6Unit of Measure Code Primary Key Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Job Item Price].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Job Item Price$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Item Price]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Job Item Price].[Unit of Measure Code] = [Unit of Measure].[Code]
7Currency Code Primary Key Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

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

Show/hide tables related from Job Item Price table

Leave a Reply

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