Job G_L Account Price

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

Table Type: Company

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

Table Number: 1014

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

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

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

Show/hide example query

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

Show/hide example query

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

Show/hide tables related from Job G_L Account Price table

Leave a Reply

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