Job

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

Table Type: Company

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

Table Number: 0

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Search Description]
   ,[Description]
   ,[Description 2]
   ,[Bill-to Customer No_]
   ,[Creation Date]
   ,[Starting Date]
   ,[Ending Date]
   ,[Status]
   ,[Person Responsible]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Job Posting Group]
   ,[Blocked]
   ,[Last Date Modified]
   ,[Customer Disc_ Group]
   ,[Customer Price Group]
   ,[Language Code]
   ,[Picture]
   ,[Bill-to Name]
   ,[Bill-to Address]
   ,[Bill-to Address 2]
   ,[Bill-to City]
   ,[Bill-to County]
   ,[Bill-to Post Code]
   ,[No_ Series]
   ,[Bill-to Country_Region Code]
   ,[Bill-to Name 2]
   ,[Reserve]
   ,[Image]
   ,[WIP Method]
   ,[Currency Code]
   ,[Bill-to Contact No_]
   ,[Bill-to Contact]
   ,[WIP Posting Date]
   ,[Invoice Currency Code]
   ,[Exch_ Calculation (Cost)]
   ,[Exch_ Calculation (Price)]
   ,[Allow Schedule_Contract Lines]
   ,[Complete]
   ,[Apply Usage Link]
   ,[WIP Posting Method]
   ,[Over Budget]
   ,[Project Manager]
   ,[Sell-to Customer No_]
   ,[Sell-to Customer Name]
   ,[Sell-to Customer Name 2]
   ,[Sell-to Address]
   ,[Sell-to Address 2]
   ,[Sell-to City]
   ,[Sell-to Contact]
   ,[Sell-to Post Code]
   ,[Sell-to County]
   ,[Sell-to Country_Region Code]
   ,[Sell-to Phone No_]
   ,[Sell-to E-Mail]
   ,[Sell-to Contact No_]
   ,[Ship-to Code]
   ,[Ship-to Name]
   ,[Ship-to Name 2]
   ,[Ship-to Address]
   ,[Ship-to Address 2]
   ,[Ship-to City]
   ,[Ship-to Contact]
   ,[Ship-to Post Code]
   ,[Ship-to County]
   ,[Ship-to Country_Region Code]
   ,[External Document No_]
   ,[Payment Method Code]
   ,[Payment Terms Code]
   ,[Your Reference]
   ,[Price Calculation Method]
   ,[Cost Calculation Method]
   ,[Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Job$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$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Job].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
      ON
         [Job].[Customer Disc_ Group] = [Customer Discount Group].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Job].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Job].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Job].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Job].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Job].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Job].[Payment Terms Code] = [Payment Terms].[Code]

Show/hide columns in Job table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Search Description Searchnvarchar(200)
4Description Searchnvarchar(200)
5Description 2 Searchnvarchar(100)
6Bill-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Job].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Job].[Bill-to Customer No_] = [Customer].[No_]
7Creation Date Searchdatetime
8Starting Date Searchdatetime
9Ending Date Searchdatetime
10Status Searchint
11Person Responsible Searchnvarchar(40)
12Global Dimension 1 Code Searchnvarchar(40)
13Global Dimension 2 Code Searchnvarchar(40)
14Job Posting Group Searchnvarchar(40)
15Blocked Searchint
16Last Date Modified Searchdatetime
17Customer Disc_ Group Searchnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
       [Job].[Customer Disc_ Group]
       ,[Customer Discount Group].[No_]
FROM
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
              ON
                     [Job].[Customer Disc_ Group] = [Customer Discount Group].[No_]
18Customer Price Group Searchnvarchar(20)
Key to join to the Customer Price Group table.

Show/hide example query

SELECT
       [Job].[Customer Price Group]
       ,[Customer Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
              ON
                     [Job].[Customer Price Group] = [Customer Price Group].[Code]
19Language Code Searchnvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
       [Job].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Job].[Language Code] = [Language].[Code]
20Picture Searchimage
21Bill-to Name Searchnvarchar(200)
22Bill-to Address Searchnvarchar(200)
23Bill-to Address 2 Searchnvarchar(100)
24Bill-to City Searchnvarchar(60)
25Bill-to County Searchnvarchar(60)
26Bill-to Post Code Searchnvarchar(40)
27No_ Series Searchnvarchar(40)
28Bill-to Country_Region Code Searchnvarchar(20)
29Bill-to Name 2 Searchnvarchar(100)
30Reserve Searchint
31Image Searchuniqueidentifier
32WIP Method Searchnvarchar(40)
33Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Job].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Job].[Currency Code] = [Currency].[Code]
34Bill-to Contact No_ Searchnvarchar(40)
35Bill-to Contact Searchnvarchar(200)
36WIP Posting Date Searchdatetime
37Invoice Currency Code Searchnvarchar(20)
38Exch_ Calculation (Cost) Searchint
39Exch_ Calculation (Price) Searchint
40Allow Schedule_Contract Lines Searchtinyint
41Complete Searchtinyint
42Apply Usage Link Searchtinyint
43WIP Posting Method Searchint
44Over Budget Searchtinyint
45Project Manager Searchnvarchar(100)
46Sell-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Job].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Job].[Sell-to Customer No_] = [Customer].[No_]
47Sell-to Customer Name Searchnvarchar(200)
48Sell-to Customer Name 2 Searchnvarchar(100)
49Sell-to Address Searchnvarchar(200)
50Sell-to Address 2 Searchnvarchar(100)
51Sell-to City Searchnvarchar(60)
52Sell-to Contact Searchnvarchar(200)
53Sell-to Post Code Searchnvarchar(40)
54Sell-to County Searchnvarchar(60)
55Sell-to Country_Region Code Searchnvarchar(20)
56Sell-to Phone No_ Searchnvarchar(60)
57Sell-to E-Mail Searchnvarchar(160)
58Sell-to Contact No_ Searchnvarchar(40)
59Ship-to Code Searchnvarchar(20)
60Ship-to Name Searchnvarchar(200)
61Ship-to Name 2 Searchnvarchar(100)
62Ship-to Address Searchnvarchar(200)
63Ship-to Address 2 Searchnvarchar(100)
64Ship-to City Searchnvarchar(60)
65Ship-to Contact Searchnvarchar(200)
66Ship-to Post Code Searchnvarchar(40)
67Ship-to County Searchnvarchar(60)
68Ship-to Country_Region Code Searchnvarchar(20)
69External Document No_ Searchnvarchar(70)
70Payment Method Code Searchnvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Job].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
              ON
                     [Job].[Payment Method Code] = [Payment Method].[Code]
71Payment Terms Code Searchnvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Job].[Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Job].[Payment Terms Code] = [Payment Terms].[Code]
72Your Reference Searchnvarchar(70)
73Price Calculation Method Searchint
74Cost Calculation Method Searchint
75Id Searchuniqueidentifier
76$systemId Searchuniqueidentifier
77$systemCreatedAt Searchdatetime
78$systemCreatedBy Searchuniqueidentifier
79$systemModifiedAt Searchdatetime
80$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Job table

Show/hide tables related to Job table

Leave a Reply

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