Employee – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables EEmployee

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

Table Type: Company

Table Name: Employee
Database Table Name: CRONUS UK Ltd_$Employee$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 Employee can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[No_]
   ,[First Name]
   ,[Middle Name]
   ,[Last Name]
   ,[Initials]
   ,[Job Title]
   ,[Search Name]
   ,[Address]
   ,[Address 2]
   ,[City]
   ,[Post Code]
   ,[County]
   ,[Phone No_]
   ,[Mobile Phone No_]
   ,[E-Mail]
   ,[Alt_ Address Code]
   ,[Alt_ Address Start Date]
   ,[Alt_ Address End Date]
   ,[Picture]
   ,[Birth Date]
   ,[Social Security No_]
   ,[Union Code]
   ,[Union Membership No_]
   ,[Gender]
   ,[Country_Region Code]
   ,[Manager No_]
   ,[Emplymt_ Contract Code]
   ,[Statistics Group Code]
   ,[Employment Date]
   ,[Status]
   ,[Inactive Date]
   ,[Cause of Inactivity Code]
   ,[Termination Date]
   ,[Grounds for Term_ Code]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Resource No_]
   ,[Last Date Modified]
   ,[Extension]
   ,[Pager]
   ,[Fax No_]
   ,[Company E-Mail]
   ,[Title]
   ,[Salespers__Purch_ Code]
   ,[No_ Series]
   ,[Last Modified Date Time]
   ,[Employee Posting Group]
   ,[Bank Branch No_]
   ,[Bank Account No_]
   ,[IBAN]
   ,[SWIFT Code]
   ,[Application Method]
   ,[Image]
   ,[Privacy Blocked]
   ,[Cost Center Code]
   ,[Cost Object Code]
   ,[Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Employee].[Country_Region Code] = [Country_Region].[Code]

Show/hide columns in Employee table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	No_	nvarchar(40)
3	First Name	nvarchar(60)
4	Middle Name	nvarchar(60)
5	Last Name	nvarchar(60)
6	Initials	nvarchar(60)
7	Job Title	nvarchar(60)
8	Search Name	nvarchar(500)
9	Address	nvarchar(200)
10	Address 2	nvarchar(100)
11	City	nvarchar(60)
12	Post Code	nvarchar(40)
13	County	nvarchar(60)
14	Phone No_	nvarchar(60)
15	Mobile Phone No_	nvarchar(60)
16	E-Mail	nvarchar(160)
17	Alt_ Address Code	nvarchar(20)
18	Alt_ Address Start Date	datetime
19	Alt_ Address End Date	datetime
20	Picture	image
21	Birth Date	datetime
22	Social Security No_	nvarchar(60)
23	Union Code	nvarchar(20)
24	Union Membership No_	nvarchar(60)
25	Gender	int
26	Country_Region Code	nvarchar(20)
	Key to join to the Country_Region table. Show/hide example query SELECT [Employee].[Country_Region Code] ,[Country_Region].[Code] FROM [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee] LEFT JOIN [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region] ON [Employee].[Country_Region Code] = [Country_Region].[Code]
27	Manager No_	nvarchar(40)
28	Emplymt_ Contract Code	nvarchar(20)
29	Statistics Group Code	nvarchar(20)
30	Employment Date	datetime
31	Status	int
32	Inactive Date	datetime
33	Cause of Inactivity Code	nvarchar(20)
34	Termination Date	datetime
35	Grounds for Term_ Code	nvarchar(20)
36	Global Dimension 1 Code	nvarchar(40)
37	Global Dimension 2 Code	nvarchar(40)
38	Resource No_	nvarchar(40)
39	Last Date Modified	datetime
40	Extension	nvarchar(60)
41	Pager	nvarchar(60)
42	Fax No_	nvarchar(60)
43	Company E-Mail	nvarchar(160)
44	Title	nvarchar(60)
45	Salespers__Purch_ Code	nvarchar(40)
46	No_ Series	nvarchar(40)
47	Last Modified Date Time	datetime
48	Employee Posting Group	nvarchar(40)
49	Bank Branch No_	nvarchar(40)
50	Bank Account No_	nvarchar(60)
51	IBAN	nvarchar(100)
52	SWIFT Code	nvarchar(40)
53	Application Method	int
54	Image	uniqueidentifier
55	Privacy Blocked	tinyint
56	Cost Center Code	nvarchar(40)
57	Cost Object Code	nvarchar(40)
58	Id	uniqueidentifier
59	$systemId	uniqueidentifier
60	$systemCreatedAt	datetime
61	$systemCreatedBy	uniqueidentifier
62	$systemModifiedAt	datetime
63	$systemModifiedBy	uniqueidentifier