Job – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables JJob

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 ID	Column Name	Data Type
1	timestamp	timestamp
2	No_	nvarchar(40)
3	Search Description	nvarchar(200)
4	Description	nvarchar(200)
5	Description 2	nvarchar(100)
6	Bill-to Customer No_	nvarchar(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_]
7	Creation Date	datetime
8	Starting Date	datetime
9	Ending Date	datetime
10	Status	int
11	Person Responsible	nvarchar(40)
12	Global Dimension 1 Code	nvarchar(40)
13	Global Dimension 2 Code	nvarchar(40)
14	Job Posting Group	nvarchar(40)
15	Blocked	int
16	Last Date Modified	datetime
17	Customer Disc_ Group	nvarchar(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_]
18	Customer Price Group	nvarchar(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]
19	Language Code	nvarchar(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]
20	Picture	image
21	Bill-to Name	nvarchar(200)
22	Bill-to Address	nvarchar(200)
23	Bill-to Address 2	nvarchar(100)
24	Bill-to City	nvarchar(60)
25	Bill-to County	nvarchar(60)
26	Bill-to Post Code	nvarchar(40)
27	No_ Series	nvarchar(40)
28	Bill-to Country_Region Code	nvarchar(20)
29	Bill-to Name 2	nvarchar(100)
30	Reserve	int
31	Image	uniqueidentifier
32	WIP Method	nvarchar(40)
33	Currency Code	nvarchar(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]
34	Bill-to Contact No_	nvarchar(40)
35	Bill-to Contact	nvarchar(200)
36	WIP Posting Date	datetime
37	Invoice Currency Code	nvarchar(20)
38	Exch_ Calculation (Cost)	int
39	Exch_ Calculation (Price)	int
40	Allow Schedule_Contract Lines	tinyint
41	Complete	tinyint
42	Apply Usage Link	tinyint
43	WIP Posting Method	int
44	Over Budget	tinyint
45	Project Manager	nvarchar(100)
46	Sell-to Customer No_	nvarchar(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_]
47	Sell-to Customer Name	nvarchar(200)
48	Sell-to Customer Name 2	nvarchar(100)
49	Sell-to Address	nvarchar(200)
50	Sell-to Address 2	nvarchar(100)
51	Sell-to City	nvarchar(60)
52	Sell-to Contact	nvarchar(200)
53	Sell-to Post Code	nvarchar(40)
54	Sell-to County	nvarchar(60)
55	Sell-to Country_Region Code	nvarchar(20)
56	Sell-to Phone No_	nvarchar(60)
57	Sell-to E-Mail	nvarchar(160)
58	Sell-to Contact No_	nvarchar(40)
59	Ship-to Code	nvarchar(20)
60	Ship-to Name	nvarchar(200)
61	Ship-to Name 2	nvarchar(100)
62	Ship-to Address	nvarchar(200)
63	Ship-to Address 2	nvarchar(100)
64	Ship-to City	nvarchar(60)
65	Ship-to Contact	nvarchar(200)
66	Ship-to Post Code	nvarchar(40)
67	Ship-to County	nvarchar(60)
68	Ship-to Country_Region Code	nvarchar(20)
69	External Document No_	nvarchar(70)
70	Payment Method Code	nvarchar(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]
71	Payment Terms Code	nvarchar(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]
72	Your Reference	nvarchar(70)
73	Price Calculation Method	int
74	Cost Calculation Method	int
75	Id	uniqueidentifier
76	$systemId	uniqueidentifier
77	$systemCreatedAt	datetime
78	$systemCreatedBy	uniqueidentifier
79	$systemModifiedAt	datetime
80	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Job table

Currency Customer Customer Discount Group Customer Price Group Language Payment Method Payment Terms

Show/hide tables related to Job table

Deferral Posting Buffer Deferral Post_ Buffer Gen_ Journal Line G_L Entry Handled IC Inbox Purch_ Line Handled IC Inbox Sales Line Handled IC Outbox Purch_ Line Handled IC Outbox Sales Line IC Inbox Purchase Line IC Inbox Sales Line IC Outbox Purchase Line IC Outbox Sales Line Invoice Post_ Buffer Invt_ Posting Buffer Item Journal Line Item Ledger Entry Job Difference Buffer Job G_L Account Price Job Item Price Job Journal Line Job Ledger Entry Job Planning Line Job Planning Line – Calendar Job Planning Line Invoice Job Posting Buffer Job Resource Price Job Task Job Task Dimension Job Usage Link Job WIP Buffer Job WIP Entry Job WIP G_L Entry Job WIP Total Job WIP Warning My Job Office Job Journal Posted Gen_ Journal Line Prepayment Inv_ Line Buffer Purchase Line Purchase Line Archive Purch_ Cr_ Memo Line Purch_ Inv_ Line Purch_ Rcpt_ Line Res_ Journal Line Res_ Ledger Entry Return Receipt Line Return Shipment Line Sales Cr_Memo Line Sales Invoice Line Sales Line Sales Line Archive Sales Shipment Line Service Ledger Entry Service Line Standard General Journal Line Time Sheet Detail Time Sheet Detail Archive Time Sheet Line Time Sheet Line Archive Value Entry

Dynamics 365 BC Table Reference Tables Company Tables JJob

Leave a Reply Cancel reply