Employee Relative

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

Table Type: Company

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

Table Number: 5205

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Employee No_]
   ,[Line No_]
   ,[Relative Code]
   ,[First Name]
   ,[Middle Name]
   ,[Last Name]
   ,[Birth Date]
   ,[Phone No_]
   ,[Relative_s Employee No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Employee Relative$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Employee Relative table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Employee No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Relative Code Searchnvarchar(20)
5First Name Searchnvarchar(60)
6Middle Name Searchnvarchar(60)
7Last Name Searchnvarchar(60)
8Birth Date Searchdatetime
9Phone No_ Searchnvarchar(60)
10Relative_s Employee No_ Searchnvarchar(40)
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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