Service Item Line

Dynamics 365 BC Table ReferenceTablesCompany TablesSService 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

   [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)]
   ,[Document Type]
   ,[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_$Service Item Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Group]
      ON
         [Service Item Line].[Service Item Group Code] = [Service Item Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Repair Status$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Repair Status]
      ON
         [Service Item Line].[Repair Status Code] = [Repair Status].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Fault Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fault Reason Code]
      ON
         [Service Item Line].[Fault Reason Code] = [Fault Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Service Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Price Group]
      ON
         [Service Item Line].[Service Price Group Code] = [Service Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Fault Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fault Area]
      ON
         [Service Item Line].[Fault Area Code] = [Fault Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Symptom Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Symptom Code]
      ON
         [Service Item Line].[Symptom Code] = [Symptom Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Resolution Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resolution Code]
      ON
         [Service Item Line].[Resolution Code] = [Resolution Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Service Item Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Service Item Line].[Document Type] = [Sales Header].[Document Type]
      AND
         [Service Item Line].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Service Item Line].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Service Item Line].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
      ON
         [Service Item Line].[Ship-to Code] = [Ship-to Address].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
      ON
         [Service Item Line].[Resource Filter] = [Resource].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Repair Status$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Repair Status]
      ON
         [Service Item Line].[Repair Status Code Filter] = [Repair Status].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
      ON
         [Service Item Line].[Responsibility Center] = [Responsibility Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
      ON
         [Service Item Line].[Service Order Filter] = [Service Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Resource Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource Group]
      ON
         [Service Item Line].[Resource Group Filter] = [Resource Group].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Service Item Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Service Item Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Service Item Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Item Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Item Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Service Item Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Document No. Primary Key SearchDocument No.NormalCode20Document No_nvarchar(40)
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
3Service Item No. SearchService Item No.NormalCode20Service Item No_nvarchar(40)
Key to join to the Service Item table.

Show/hide example query

SELECT
       [Service Item Line].[Service Item No_]
       ,[Service Item].[No_]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
              ON
                     [Service Item Line].[Service Item No_] = [Service Item].[No_]
4Service Item Group Code SearchService Item Group CodeNormalCode10Service Item Group Codenvarchar(20)
Key to join to the Service Item Group table.

Show/hide example query

SELECT
       [Service Item Line].[Service Item Group Code]
       ,[Service Item Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Service Item Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Group]
              ON
                     [Service Item Line].[Service Item Group Code] = [Service Item Group].[Code]
5Item No. SearchItem No.NormalCode20Item No_nvarchar(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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Service Item Line].[Item No_] = [Item].[No_]
6Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
7Description SearchDescriptionNormalText100Descriptionnvarchar(200)
8Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
9Repair Status Code SearchRepair Status CodeNormalCode10Repair Status Codenvarchar(20)
Key to join to the Repair Status table.

Show/hide example query

SELECT
       [Service Item Line].[Repair Status Code]
       ,[Repair Status].[Code]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Repair Status$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Repair Status]
              ON
                     [Service Item Line].[Repair Status Code] = [Repair Status].[Code]
10Priority SearchPriorityNormalOption4Priorityint
Available options are:
  • “Low”
  • “Medium”
  • “High”
11Response Time (Hours) SearchResponse Time (Hours)NormalDecimal12Response Time (Hours)decimal(38,38)
12Response Date SearchResponse DateNormalDate4Response Datedatetime
13Response Time SearchResponse TimeNormalTime4Response Timedatetime
14Starting Date SearchStarting DateNormalDate4Starting Datedatetime
15Starting Time SearchStarting TimeNormalTime4Starting Timedatetime
16Finishing Date SearchFinishing DateNormalDate4Finishing Datedatetime
17Finishing Time SearchFinishing TimeNormalTime4Finishing Timedatetime
18Service Shelf No. SearchService Shelf No.NormalCode10Service Shelf No_nvarchar(20)
Key to join to the Service Shelf table.

Show/hide example query

SELECT
       [Service Item Line].[Service Shelf No_]
       ,[Service Shelf].[No_]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Service Shelf$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shelf]
              ON
                     [Service Item Line].[Service Shelf No_] = [Service Shelf].[No_]
19Warranty Starting Date (Parts) SearchWarranty Starting Date (Parts)NormalDate4Warranty Starting Date (Parts)datetime
20Warranty Ending Date (Parts) SearchWarranty Ending Date (Parts)NormalDate4Warranty Ending Date (Parts)datetime
21Warranty SearchWarrantyNormalBoolean4Warrantytinyint
22Warranty % (Parts) SearchWarranty % (Parts)NormalDecimal12Warranty _ (Parts)decimal(38,38)
23Warranty % (Labor) SearchWarranty % (Labor)NormalDecimal12Warranty _ (Labor)decimal(38,38)
24Warranty Starting Date (Labor) SearchWarranty Starting Date (Labor)NormalDate4Warranty Starting Date (Labor)datetime
25Warranty Ending Date (Labor) SearchWarranty Ending Date (Labor)NormalDate4Warranty Ending Date (Labor)datetime
26Contract No. SearchContract No.NormalCode20Contract No_nvarchar(40)
27Location of Service Item SearchLocation of Service ItemFlowFieldText30
28Loaner No. SearchLoaner No.NormalCode20Loaner No_nvarchar(40)
Key to join to the Loaner table.

Show/hide example query

SELECT
       [Service Item Line].[Loaner No_]
       ,[Loaner].[No_]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Loaner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Loaner]
              ON
                     [Service Item Line].[Loaner No_] = [Loaner].[No_]
29Vendor No. SearchVendor No.NormalCode20Vendor No_nvarchar(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_]
30Vendor Item No. SearchVendor Item No.NormalText50Vendor Item No_nvarchar(100)
31Fault Reason Code SearchFault Reason CodeNormalCode10Fault Reason Codenvarchar(20)
Key to join to the Fault Reason Code table.

Show/hide example query

SELECT
       [Service Item Line].[Fault Reason Code]
       ,[Fault Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Fault Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fault Reason Code]
              ON
                     [Service Item Line].[Fault Reason Code] = [Fault Reason Code].[Code]
32Service Price Group Code SearchService Price Group CodeNormalCode10Service Price Group Codenvarchar(20)
Key to join to the Service Price Group table.

Show/hide example query

SELECT
       [Service Item Line].[Service Price Group Code]
       ,[Service Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Service Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Price Group]
              ON
                     [Service Item Line].[Service Price Group Code] = [Service Price Group].[Code]
33Fault Area Code SearchFault Area CodeNormalCode10Fault Area Codenvarchar(20)
Key to join to the Fault Area table.

Show/hide example query

SELECT
       [Service Item Line].[Fault Area Code]
       ,[Fault Area].[Code]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Fault Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fault Area]
              ON
                     [Service Item Line].[Fault Area Code] = [Fault Area].[Code]
34Symptom Code SearchSymptom CodeNormalCode10Symptom Codenvarchar(20)
Key to join to the Symptom Code table.

Show/hide example query

SELECT
       [Service Item Line].[Symptom Code]
       ,[Symptom Code].[Code]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Symptom Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Symptom Code]
              ON
                     [Service Item Line].[Symptom Code] = [Symptom Code].[Code]
35Fault Code SearchFault CodeNormalCode10Fault Codenvarchar(20)
36Resolution Code SearchResolution CodeNormalCode10Resolution Codenvarchar(20)
Key to join to the Resolution Code table.

Show/hide example query

SELECT
       [Service Item Line].[Resolution Code]
       ,[Resolution Code].[Code]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Resolution Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resolution Code]
              ON
                     [Service Item Line].[Resolution Code] = [Resolution Code].[Code]
37Fault Comment SearchFault CommentFlowFieldBoolean4
38Resolution Comment SearchResolution CommentFlowFieldBoolean4
40Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Service Item Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Service Item Line].[Variant Code] = [Item Variant].[Code]
41Service Item Loaner Comment SearchService Item Loaner CommentFlowFieldBoolean4
42Actual Response Time (Hours) SearchActual Response Time (Hours)NormalDecimal12Actual Response Time (Hours)decimal(38,38)
43Document Type Primary Key SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • “Quote”
  • “Order”
  • “Invoice”
  • “Credit Memo”
44Serv. Price Adjmt. Gr. Code SearchServ. Price Adjmt. Gr. CodeNormalCode10Serv_ Price Adjmt_ Gr_ Codenvarchar(20)
Key to join to the Service Price Adjustment Group table.

Show/hide example query

SELECT
       [Service Item Line].[Serv_ Price Adjmt_ Gr_ Code]
       ,[Service Price Adjustment Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Service Price Adjustment Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Price Adjustment Group]
              ON
                     [Service Item Line].[Serv_ Price Adjmt_ Gr_ Code] = [Service Price Adjustment Group].[Code]
45Adjustment Type SearchAdjustment TypeNormalOption4Adjustment Typeint
Available options are:
  • “Fixed”
  • “Maximum”
  • “Minimum”
46Base Amount to Adjust SearchBase Amount to AdjustNormalDecimal12Base Amount to Adjustdecimal(38,38)
60No. of Active/Finished Allocs SearchNo. of Active/Finished AllocsFlowFieldInteger4
61No. of Allocations SearchNo. of AllocationsFlowFieldInteger4
62No. of Previous Services SearchNo. of Previous ServicesFlowFieldInteger4
63Contract Line No. SearchContract Line No.NormalInteger4Contract Line No_int
64Ship-to Code SearchShip-to CodeNormalCode10Ship-to Codenvarchar(20)
Key to join to the Ship-to Address table.

Show/hide example query

SELECT
       [Service Item Line].[Ship-to Code]
       ,[Ship-to Address].[Code]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
              ON
                     [Service Item Line].[Ship-to Code] = [Ship-to Address].[Code]
65Customer No. SearchCustomer No.NormalCode20Customer No_nvarchar(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_]
91Date Filter SearchDate FilterFlowFilterDate4
92Resource Filter SearchResource FilterFlowFilterCode20
93Allocation Date Filter SearchAllocation Date FilterFlowFilterDate4
94Repair Status Code Filter SearchRepair Status Code FilterFlowFilterCode10
96Allocation Status Filter SearchAllocation Status FilterFlowFilterOption4
97Responsibility Center SearchResponsibility CenterNormalCode10Responsibility Centernvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

SELECT
       [Service Item Line].[Responsibility Center]
       ,[Responsibility Center].[Code]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
              ON
                     [Service Item Line].[Responsibility Center] = [Responsibility Center].[Code]
98Service Order Filter SearchService Order FilterFlowFilterCode20
99Resource Group Filter SearchResource Group FilterFlowFilterCode20
100Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Service Item Line].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Service Item Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
101Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Service Item Line].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Service Item Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
130Release Status SearchRelease StatusNormalOption4Release Statusint
Available options are:
  • “Open”
  • “Released to Ship”
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Service Item Line].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Service Item Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Service Item Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Item Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Service Item Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Item Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Service Item Line table

Responsibility CenterSales HeaderSales Header ArchiveShip-to Address
Dynamics 365 BC Table ReferenceTablesCompany TablesSService Item Line

Leave a Reply

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