Service Item Component

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

Table Type: Company

Table Name: Service Item Component
Database Table Name: CRONUS UK Ltd_$Service Item Component$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5941

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 Service Item Component can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Service Item Component$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Active]
   ,[Parent Service Item No_]
   ,[Line No_]
   ,[Type]
   ,[No_]
   ,[Date Installed]
   ,[Variant Code]
   ,[Serial No_]
   ,[Description]
   ,[Description 2]
   ,[Service Order No_]
   ,[From Line No_]
   ,[Last Date Modified]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Service Item Component$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Service Item Component table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Active Primary Key Searchtinyint
3Parent Service Item No_ Primary Key Searchnvarchar(40)
4Line No_ Primary Key Searchint
5Type Searchint
6No_ Searchnvarchar(40)
7Date Installed Searchdatetime
8Variant Code Searchnvarchar(20)
9Serial No_ Searchnvarchar(100)
10Description Searchnvarchar(200)
11Description 2 Searchnvarchar(100)
12Service Order No_ Searchnvarchar(40)
13From Line No_ Searchint
14Last Date Modified Searchdatetime
15$systemId Searchuniqueidentifier
16$systemCreatedAt Searchdatetime
17$systemCreatedBy Searchuniqueidentifier
18$systemModifiedAt Searchdatetime
19$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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