Maintenance Registration

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

Table Type: Company

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

Table Number: 5616

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[FA No_]
   ,[Line No_]
   ,[Service Date]
   ,[Maintenance Vendor No_]
   ,[Comment]
   ,[Service Agent Name]
   ,[Service Agent Phone No_]
   ,[Service Agent Mobile Phone]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Maintenance Registration$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Maintenance Registration$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Registration]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Maintenance Registration].[Maintenance Vendor No_] = [Vendor].[No_]

Show/hide columns in Maintenance Registration table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2FA No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Service Date Searchdatetime
5Maintenance Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Maintenance Registration].[Maintenance Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Maintenance Registration$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Registration]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Maintenance Registration].[Maintenance Vendor No_] = [Vendor].[No_]
6Comment Searchnvarchar(100)
7Service Agent Name Searchnvarchar(60)
8Service Agent Phone No_ Searchnvarchar(60)
9Service Agent Mobile Phone Searchnvarchar(60)
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Maintenance Registration table

Leave a Reply

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