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: 167

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

   [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_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
      ON
         [Job].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
   [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
      ON
         [Job].[Person Responsible] = [Employee].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job].[Global Dimension 2 Code] = [Dimension].[Code]
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_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
      ON
         [Job].[Resource Filter] = [Resource].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Job].[Bill-to Name] = [Customer].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Job].[Bill-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Job].[Bill-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job WIP Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Method]
      ON
         [Job].[WIP Method] = [Job WIP Method].[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_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Job].[Invoice Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
      ON
         [Job].[Project Manager] = [User Setup].[User ID]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Job].[Sell-to Customer Name] = [Customer].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Job].[Sell-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Job].[Sell-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
      ON
         [Job].[Ship-to Code] = [Ship-to Address].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Job].[Ship-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Job].[Ship-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] 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]
LEFT JOIN
   [User] AS [User]
      ON
         [Job].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Job].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Job table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	No.	No.	Normal	Code	20	No_	nvarchar(40)
2	Search Description	Search Description	Normal	Code	100	Search Description	nvarchar(200)
3	Description	Description	Normal	Text	100	Description	nvarchar(200)
4	Description 2	Description 2	Normal	Text	50	Description 2	nvarchar(100)
5	Bill-to Customer No.	Bill-to Customer No.	Normal	Code	20	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_]
12	Creation Date	Creation Date	Normal	Date	4	Creation Date	datetime
13	Starting Date	Starting Date	Normal	Date	4	Starting Date	datetime
14	Ending Date	Ending Date	Normal	Date	4	Ending Date	datetime
	Key to join to the Inventory Period table. Show/hide example query SELECT [Job].[Ending Date] ,[Inventory Period].[Ending Date] FROM [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] LEFT JOIN [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period] ON [Job].[Ending Date] = [Inventory Period].[Ending Date]
19	Status	Status	Normal	Option	4	Status	int
	Available options are: “Planning” “Quote” “Open” “Completed”
20	Person Responsible	Person Responsible	Normal	Code	20	Person Responsible	nvarchar(40)
	Key to join to the Employee table. Show/hide example query SELECT [Job].[Person Responsible] ,[Employee].[No_] FROM [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] LEFT JOIN [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] ON [Job].[Person Responsible] = [Employee].[No_]
21	Global Dimension 1 Code	Global Dimension 1 Code	Normal	Code	20	Global Dimension 1 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Job].[Global Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Job].[Global Dimension 1 Code] = [Dimension].[Code]
22	Global Dimension 2 Code	Global Dimension 2 Code	Normal	Code	20	Global Dimension 2 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Job].[Global Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Job].[Global Dimension 2 Code] = [Dimension].[Code]
23	Job Posting Group	Job Posting Group	Normal	Code	20	Job Posting Group	nvarchar(40)
24	Blocked	Blocked	Normal	Option	4	Blocked	int
	Available options are: ” “ “Posting” “All”
29	Last Date Modified	Last Date Modified	Normal	Date	4	Last Date Modified	datetime
30	Comment	Comment	FlowField	Boolean	4
31	Customer Disc. Group	Customer Disc. Group	Normal	Code	20	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].[Code] 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].[Code]
32	Customer Price Group	Customer Price Group	Normal	Code	10	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]
41	Language Code	Language Code	Normal	Code	10	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]
49	Scheduled Res. Qty.	Scheduled Res. Qty.	FlowField	Decimal	12
50	Resource Filter	Resource Filter	FlowFilter	Code	20
	Key to join to the Resource table. Show/hide example query SELECT [Job].[] ,[Resource].[No_] FROM [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] LEFT JOIN [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource] ON [Job].[] = [Resource].[No_]
51	Posting Date Filter	Posting Date Filter	FlowFilter	Date	4
55	Resource Gr. Filter	Resource Gr. Filter	FlowFilter	Code	20
	Key to join to the Resource Group table. Show/hide example query SELECT [Job].[] ,[Resource Group].[No_] FROM [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] LEFT JOIN [CRONUS UK Ltd_$Resource Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource Group] ON [Job].[] = [Resource Group].[No_]
56	Scheduled Res. Gr. Qty.	Scheduled Res. Gr. Qty.	FlowField	Decimal	12
57	Picture	Picture	Normal	BLOB	8	Picture	image
58	Bill-to Name	Name	Normal	Text	100	Bill-to Name	nvarchar(200)
	Key to join to the Customer table. Show/hide example query SELECT [Job].[Bill-to Name] ,[Customer].[Name] 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 Name] = [Customer].[Name]
59	Bill-to Address	Address	Normal	Text	100	Bill-to Address	nvarchar(200)
60	Bill-to Address 2	Address 2	Normal	Text	50	Bill-to Address 2	nvarchar(100)
61	Bill-to City	City	Normal	Text	30	Bill-to City	nvarchar(60)
	Key to join to the Post Code table. Show/hide example query SELECT [Job].[Bill-to City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Job].[Bill-to City] = [Post Code].[City]
63	Bill-to County	State	Normal	Text	30	Bill-to County	nvarchar(60)
64	Bill-to Post Code	ZIP Code	Normal	Code	20	Bill-to Post Code	nvarchar(40)
	Key to join to the Post Code table. Show/hide example query SELECT [Job].[Bill-to Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Job].[Bill-to Post Code] = [Post Code].[Code]
66	No. Series	No. Series	Normal	Code	20	No_ Series	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Job].[No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Job].[No_ Series] = [No. Series].[Code]
67	Bill-to Country/Region Code	Country/Region Code	Normal	Code	10	Bill-to Country_Region Code	nvarchar(20)
68	Bill-to Name 2	Name 2	Normal	Text	50	Bill-to Name 2	nvarchar(100)
117	Reserve	Reserve	Normal	Option	4	Reserve	int
	Available options are: “Never” “Optional” “Always”
140	Image	Image	Normal	Media	16	Image	uniqueidentifier
1000	WIP Method	WIP Method	Normal	Code	20	WIP Method	nvarchar(40)
	Key to join to the Job WIP Method table. Show/hide example query SELECT [Job].[WIP Method] ,[Job WIP Method].[Code] FROM [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] LEFT JOIN [CRONUS UK Ltd_$Job WIP Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Method] ON [Job].[WIP Method] = [Job WIP Method].[Code]
1001	Currency Code	Currency Code	Normal	Code	10	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]
1002	Bill-to Contact No.	Bill-to Contact No.	Normal	Code	20	Bill-to Contact No_	nvarchar(40)
	Key to join to the Contact table. Show/hide example query SELECT [Job].[Bill-to Contact No_] ,[Contact].[No_] FROM [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] LEFT JOIN [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact] ON [Job].[Bill-to Contact No_] = [Contact].[No_]
1003	Bill-to Contact	Contact	Normal	Text	100	Bill-to Contact	nvarchar(200)
1004	Planning Date Filter	Planning Date Filter	FlowFilter	Date	4
1005	Total WIP Cost Amount	Total WIP Cost Amount	FlowField	Decimal	12
1006	Total WIP Cost G/L Amount	Total WIP Cost G/L Amount	FlowField	Decimal	12
1007	WIP Entries Exist	WIP Entries Exist	FlowField	Boolean	4
1008	WIP Posting Date	WIP Posting Date	Normal	Date	4	WIP Posting Date	datetime
1009	WIP G/L Posting Date	WIP G/L Posting Date	FlowField	Date	4
1011	Invoice Currency Code	Invoice Currency Code	Normal	Code	10	Invoice Currency Code	nvarchar(20)
	Key to join to the Currency table. Show/hide example query SELECT [Job].[Invoice 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].[Invoice Currency Code] = [Currency].[Code]
1012	Exch. Calculation (Cost)	Exch. Calculation (Cost)	Normal	Option	4	Exch_ Calculation (Cost)	int
	Available options are: “Fixed FCY” “Fixed LCY”
1013	Exch. Calculation (Price)	Exch. Calculation (Price)	Normal	Option	4	Exch_ Calculation (Price)	int
	Available options are: “Fixed FCY” “Fixed LCY”
1014	Allow Schedule/Contract Lines	Allow Budget/Billable Lines	Normal	Boolean	4	Allow Schedule_Contract Lines	tinyint
1015	Complete	Complete	Normal	Boolean	4	Complete	tinyint
1017	Recog. Sales Amount	Recog. Sales Amount	FlowField	Decimal	12
1018	Recog. Sales G/L Amount	Recog. Sales G/L Amount	FlowField	Decimal	12
1019	Recog. Costs Amount	Recog. Costs Amount	FlowField	Decimal	12
1020	Recog. Costs G/L Amount	Recog. Costs G/L Amount	FlowField	Decimal	12
1021	Total WIP Sales Amount	Total WIP Sales Amount	FlowField	Decimal	12
1022	Total WIP Sales G/L Amount	Total WIP Sales G/L Amount	FlowField	Decimal	12
1023	WIP Completion Calculated	WIP Completion Calculated	FlowField	Boolean	4
1024	Next Invoice Date	Next Invoice Date	FlowField	Date	4
1025	Apply Usage Link	Apply Usage Link	Normal	Boolean	4	Apply Usage Link	tinyint
1026	WIP Warnings	WIP Warnings	FlowField	Boolean	4
1027	WIP Posting Method	WIP Posting Method	Normal	Option	4	WIP Posting Method	int
	Available options are: “Per Job” “Per Job Ledger Entry”
1028	Applied Costs G/L Amount	Applied Costs G/L Amount	FlowField	Decimal	12
1029	Applied Sales G/L Amount	Applied Sales G/L Amount	FlowField	Decimal	12
1030	Calc. Recog. Sales Amount	Calc. Recog. Sales Amount	FlowField	Decimal	12
1031	Calc. Recog. Costs Amount	Calc. Recog. Costs Amount	FlowField	Decimal	12
1032	Calc. Recog. Sales G/L Amount	Calc. Recog. Sales G/L Amount	FlowField	Decimal	12
1033	Calc. Recog. Costs G/L Amount	Calc. Recog. Costs G/L Amount	FlowField	Decimal	12
1034	WIP Completion Posted	WIP Completion Posted	FlowField	Boolean	4
1035	Over Budget	Over Budget	Normal	Boolean	4	Over Budget	tinyint
1036	Project Manager	Project Manager	Normal	Code	50	Project Manager	nvarchar(100)
	Key to join to the User Setup table. Show/hide example query SELECT [Job].[Project Manager] ,[User Setup].[User ID] FROM [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] LEFT JOIN [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup] ON [Job].[Project Manager] = [User Setup].[User ID]
2000	Sell-to Customer No.	Sell-to Customer No.	Normal	Code	20	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_]
2001	Sell-to Customer Name	Sell-to Customer Name	Normal	Text	100	Sell-to Customer Name	nvarchar(200)
	Key to join to the Customer table. Show/hide example query SELECT [Job].[Sell-to Customer Name] ,[Customer].[Name] 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 Name] = [Customer].[Name]
2002	Sell-to Customer Name 2	Sell-to Customer Name 2	Normal	Text	50	Sell-to Customer Name 2	nvarchar(100)
2003	Sell-to Address	Sell-to Address	Normal	Text	100	Sell-to Address	nvarchar(200)
2004	Sell-to Address 2	Sell-to Address 2	Normal	Text	50	Sell-to Address 2	nvarchar(100)
2005	Sell-to City	Sell-to City	Normal	Text	30	Sell-to City	nvarchar(60)
	Key to join to the Post Code table. Show/hide example query SELECT [Job].[Sell-to City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Job].[Sell-to City] = [Post Code].[City]
2006	Sell-to Contact	Sell-to Contact	Normal	Text	100	Sell-to Contact	nvarchar(200)
2007	Sell-to Post Code	Sell-to ZIP Code	Normal	Code	20	Sell-to Post Code	nvarchar(40)
	Key to join to the Post Code table. Show/hide example query SELECT [Job].[Sell-to Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Job].[Sell-to Post Code] = [Post Code].[Code]
2008	Sell-to County	Sell-to State	Normal	Text	30	Sell-to County	nvarchar(60)
2009	Sell-to Country/Region Code	Sell-to Country/Region Code	Normal	Code	10	Sell-to Country_Region Code	nvarchar(20)
2010	Sell-to Phone No.	Sell-to Phone No.	Normal	Text	30	Sell-to Phone No_	nvarchar(60)
2011	Sell-to E-Mail	Email	Normal	Text	80	Sell-to E-Mail	nvarchar(160)
2012	Sell-to Contact No.	Sell-to Contact No.	Normal	Code	20	Sell-to Contact No_	nvarchar(40)
	Key to join to the Contact table. Show/hide example query SELECT [Job].[Sell-to Contact No_] ,[Contact].[No_] FROM [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] LEFT JOIN [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact] ON [Job].[Sell-to Contact No_] = [Contact].[No_]
3000	Ship-to Code	Ship-to Code	Normal	Code	10	Ship-to Code	nvarchar(20)
	Key to join to the Ship-to Address table. Show/hide example query SELECT [Job].[Ship-to Code] ,[Ship-to Address].[Code] FROM [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] LEFT JOIN [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address] ON [Job].[Ship-to Code] = [Ship-to Address].[Code]
3001	Ship-to Name	Ship-to Name	Normal	Text	100	Ship-to Name	nvarchar(200)
3002	Ship-to Name 2	Ship-to Name 2	Normal	Text	50	Ship-to Name 2	nvarchar(100)
3003	Ship-to Address	Ship-to Address	Normal	Text	100	Ship-to Address	nvarchar(200)
3004	Ship-to Address 2	Ship-to Address 2	Normal	Text	50	Ship-to Address 2	nvarchar(100)
3005	Ship-to City	Ship-to City	Normal	Text	30	Ship-to City	nvarchar(60)
	Key to join to the Post Code table. Show/hide example query SELECT [Job].[Ship-to City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Job].[Ship-to City] = [Post Code].[City]
3006	Ship-to Contact	Ship-to Contact	Normal	Text	100	Ship-to Contact	nvarchar(200)
3007	Ship-to Post Code	Ship-to ZIP Code	Normal	Code	20	Ship-to Post Code	nvarchar(40)
	Key to join to the Post Code table. Show/hide example query SELECT [Job].[Ship-to Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Job].[Ship-to Post Code] = [Post Code].[Code]
3008	Ship-to County	Ship-to State	Normal	Text	30	Ship-to County	nvarchar(60)
3009	Ship-to Country/Region Code	Ship-to Country/Region Code	Normal	Code	10	Ship-to Country_Region Code	nvarchar(20)
4000	External Document No.	External Document No.	Normal	Code	35	External Document No_	nvarchar(70)
4001	Payment Method Code	Payment Method Code	Normal	Code	10	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$ext] AS [Payment Method] ON [Job].[Payment Method Code] = [Payment Method].[Code]
4002	Payment Terms Code	Payment Terms Code	Normal	Code	10	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]
4003	Your Reference	Your Reference	Normal	Text	35	Your Reference	nvarchar(70)
7000	Price Calculation Method	Price Calculation Method	Normal	Option	4	Price Calculation Method	int
	Available options are: ” “ “Lowest Price”
7001	Cost Calculation Method	Cost Calculation Method	Normal	Option	4	Cost Calculation Method	int
	Available options are: ” “ “Lowest Price”
7300	Completely Picked	Completely Picked	FlowField	Boolean	4
8000	Id	Id	Normal	GUID	16	Id	uniqueidentifier
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Job].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] LEFT JOIN [User] AS [User] ON [Job].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Job table

Dynamics 365 BC Table Reference Tables Company Tables JJob

Leave a Reply Cancel reply