Service Item

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

Table Type: Company

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

Table Number: 5940

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Serial No_]
   ,[Service Item Group Code]
   ,[Description]
   ,[Description 2]
   ,[Status]
   ,[Priority]
   ,[Customer No_]
   ,[Ship-to Code]
   ,[Item No_]
   ,[Unit of Measure Code]
   ,[Location of Service Item]
   ,[Sales Unit Price]
   ,[Sales Unit Cost]
   ,[Warranty Starting Date (Labor)]
   ,[Warranty Ending Date (Labor)]
   ,[Warranty Starting Date (Parts)]
   ,[Warranty Ending Date (Parts)]
   ,[Warranty _ (Parts)]
   ,[Warranty _ (Labor)]
   ,[Response Time (Hours)]
   ,[Installation Date]
   ,[Sales Date]
   ,[Last Service Date]
   ,[Default Contract Value]
   ,[Default Contract Discount _]
   ,[Vendor No_]
   ,[Vendor Item No_]
   ,[No_ Series]
   ,[Vendor Item Name]
   ,[Preferred Resource]
   ,[Variant Code]
   ,[Service Price Group Code]
   ,[Default Contract Cost]
   ,[Search Description]
   ,[Sales_Serv_ Shpt_ Document No_]
   ,[Sales_Serv_ Shpt_ Line No_]
   ,[Shipment Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Item].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Service Item].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Service Item].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Service Item].[Vendor No_] = [Vendor].[No_]

Show/hide columns in Service Item table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Serial No_ Searchnvarchar(100)
4Service Item Group Code Searchnvarchar(20)
5Description Searchnvarchar(200)
6Description 2 Searchnvarchar(100)
7Status Searchint
8Priority Searchint
9Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Service Item].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Service Item].[Customer No_] = [Customer].[No_]
10Ship-to Code Searchnvarchar(20)
11Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Service Item].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Service Item].[Item No_] = [Item].[No_]
12Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Service Item].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Service Item].[Unit of Measure Code] = [Unit of Measure].[Code]
13Location of Service Item Searchnvarchar(60)
14Sales Unit Price Searchdecimal(38,38)
15Sales Unit Cost Searchdecimal(38,38)
16Warranty Starting Date (Labor) Searchdatetime
17Warranty Ending Date (Labor) Searchdatetime
18Warranty Starting Date (Parts) Searchdatetime
19Warranty Ending Date (Parts) Searchdatetime
20Warranty _ (Parts) Searchdecimal(38,38)
21Warranty _ (Labor) Searchdecimal(38,38)
22Response Time (Hours) Searchdecimal(38,38)
23Installation Date Searchdatetime
24Sales Date Searchdatetime
25Last Service Date Searchdatetime
26Default Contract Value Searchdecimal(38,38)
27Default Contract Discount _ Searchdecimal(38,38)
28Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Service Item].[Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Service Item].[Vendor No_] = [Vendor].[No_]
29Vendor Item No_ Searchnvarchar(100)
30No_ Series Searchnvarchar(40)
31Vendor Item Name Searchnvarchar(200)
32Preferred Resource Searchnvarchar(40)
33Variant Code Searchnvarchar(20)
34Service Price Group Code Searchnvarchar(20)
35Default Contract Cost Searchdecimal(38,38)
36Search Description Searchnvarchar(200)
37Sales_Serv_ Shpt_ Document No_ Searchnvarchar(40)
38Sales_Serv_ Shpt_ Line No_ Searchint
39Shipment Type Searchint
40$systemId Searchuniqueidentifier
41$systemCreatedAt Searchdatetime
42$systemCreatedBy Searchuniqueidentifier
43$systemModifiedAt Searchdatetime
44$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Service Item table

Leave a Reply

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