Service Item Line

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

Table Type: Company

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

Table Number: 5901

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Document Type]
   ,[Document No_]
   ,[Line No_]
   ,[Service Item No_]
   ,[Service Item Group Code]
   ,[Item No_]
   ,[Serial No_]
   ,[Description]
   ,[Description 2]
   ,[Repair Status Code]
   ,[Priority]
   ,[Response Time (Hours)]
   ,[Response Date]
   ,[Response Time]
   ,[Starting Date]
   ,[Starting Time]
   ,[Finishing Date]
   ,[Finishing Time]
   ,[Service Shelf No_]
   ,[Warranty Starting Date (Parts)]
   ,[Warranty Ending Date (Parts)]
   ,[Warranty]
   ,[Warranty _ (Parts)]
   ,[Warranty _ (Labor)]
   ,[Warranty Starting Date (Labor)]
   ,[Warranty Ending Date (Labor)]
   ,[Contract No_]
   ,[Loaner No_]
   ,[Vendor No_]
   ,[Vendor Item No_]
   ,[Fault Reason Code]
   ,[Service Price Group Code]
   ,[Fault Area Code]
   ,[Symptom Code]
   ,[Fault Code]
   ,[Resolution Code]
   ,[Variant Code]
   ,[Actual Response Time (Hours)]
   ,[Serv_ Price Adjmt_ Gr_ Code]
   ,[Adjustment Type]
   ,[Base Amount to Adjust]
   ,[Contract Line No_]
   ,[Ship-to Code]
   ,[Customer No_]
   ,[Responsibility Center]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Release Status]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Service Item Line$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 Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Service Item Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Service Item Line].[Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Item Line].[Customer No_] = [Customer].[No_]

Show/hide columns in Service Item Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Document Type Primary Key Searchint
3Document No_ Primary Key Searchnvarchar(40)
4Line No_ Primary Key Searchint
5Service Item No_ Searchnvarchar(40)
6Service Item Group Code Searchnvarchar(20)
7Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Service Item Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Service Item Line].[Item No_] = [Item].[No_]
8Serial No_ Searchnvarchar(100)
9Description Searchnvarchar(200)
10Description 2 Searchnvarchar(100)
11Repair Status Code Searchnvarchar(20)
12Priority Searchint
13Response Time (Hours) Searchdecimal(38,38)
14Response Date Searchdatetime
15Response Time Searchdatetime
16Starting Date Searchdatetime
17Starting Time Searchdatetime
18Finishing Date Searchdatetime
19Finishing Time Searchdatetime
20Service Shelf No_ Searchnvarchar(20)
21Warranty Starting Date (Parts) Searchdatetime
22Warranty Ending Date (Parts) Searchdatetime
23Warranty Searchtinyint
24Warranty _ (Parts) Searchdecimal(38,38)
25Warranty _ (Labor) Searchdecimal(38,38)
26Warranty Starting Date (Labor) Searchdatetime
27Warranty Ending Date (Labor) Searchdatetime
28Contract No_ Searchnvarchar(40)
29Loaner No_ Searchnvarchar(40)
30Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Service Item Line].[Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Service Item Line].[Vendor No_] = [Vendor].[No_]
31Vendor Item No_ Searchnvarchar(100)
32Fault Reason Code Searchnvarchar(20)
33Service Price Group Code Searchnvarchar(20)
34Fault Area Code Searchnvarchar(20)
35Symptom Code Searchnvarchar(20)
36Fault Code Searchnvarchar(20)
37Resolution Code Searchnvarchar(20)
38Variant Code Searchnvarchar(20)
39Actual Response Time (Hours) Searchdecimal(38,38)
40Serv_ Price Adjmt_ Gr_ Code Searchnvarchar(20)
41Adjustment Type Searchint
42Base Amount to Adjust Searchdecimal(38,38)
43Contract Line No_ Searchint
44Ship-to Code Searchnvarchar(20)
45Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Service Item Line].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Service Item Line].[Customer No_] = [Customer].[No_]
46Responsibility Center Searchnvarchar(20)
47Shortcut Dimension 1 Code Searchnvarchar(40)
48Shortcut Dimension 2 Code Searchnvarchar(40)
49Release Status Searchint
50Dimension Set ID Searchint
51$systemId Searchuniqueidentifier
52$systemCreatedAt Searchdatetime
53$systemCreatedBy Searchuniqueidentifier
54$systemModifiedAt Searchdatetime
55$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Service Item Line table

Leave a Reply

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