Service Shipment Item Line

Dynamics 365 BC Table ReferenceTablesCompany TablesSService Shipment Item Line

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

Table Type: Company

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

Table Number: 5989

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [No_]
   ,[Line No_]
   ,[Service Item No_]
   ,[Service Item Group Code]
   ,[Item No_]
   ,[Serial No_]
   ,[Description]
   ,[Description 2]
   ,[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)]
   ,[Service Price Adjmt_ Gr_ Code]
   ,[Adjustment Type]
   ,[Base Amount to Adjust]
   ,[Ship-to Code]
   ,[Customer No_]
   ,[Responsibility Center]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Service Shipment 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 Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
   [CRONUS UK Ltd_$Service Item Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Group]
      ON
         [Service Shipment Item Line].[Service Item Group Code] = [Service Item Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Fault Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fault Reason Code]
      ON
         [Service Shipment 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 Shipment 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 Shipment 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 Shipment Item Line].[Symptom Code] = [Symptom Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Resolution Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resolution Code]
      ON
         [Service Shipment Item Line].[Resolution Code] = [Resolution Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Service Shipment Item Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
      ON
         [Service Shipment Item Line].[Ship-to Code] = [Ship-to Address].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
      ON
         [Service Shipment Item Line].[Resource Filter] = [Resource].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Resource Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource Group]
      ON
         [Service Shipment Item Line].[Resource Group Filter] = [Resource Group].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
      ON
         [Service Shipment Item Line].[Responsibility Center] = [Responsibility Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Service Shipment Item Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Shipment Item Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Shipment Item Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Service Shipment Item Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_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 Shipment Item Line].[Service Item No_]
       ,[Service Item].[No_]
FROM
       [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
              ON
                     [Service Shipment 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 Shipment Item Line].[Service Item Group Code]
       ,[Service Item Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Service Item Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Group]
              ON
                     [Service Shipment 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 Shipment Item Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Service Shipment Item Line].[Item No_] = [Item].[No_]
6Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
7Description SearchDescriptionNormalText100Descriptionnvarchar(200)
8Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
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 Shipment Item Line].[Service Shelf No_]
       ,[Service Shelf].[No_]
FROM
       [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Service Shelf$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shelf]
              ON
                     [Service Shipment 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 Shipment Item Line].[Loaner No_]
       ,[Loaner].[No_]
FROM
       [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Loaner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Loaner]
              ON
                     [Service Shipment 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 Shipment Item Line].[Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Service Shipment 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 Shipment Item Line].[Fault Reason Code]
       ,[Fault Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Fault Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fault Reason Code]
              ON
                     [Service Shipment 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 Shipment Item Line].[Service Price Group Code]
       ,[Service Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Service Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Price Group]
              ON
                     [Service Shipment 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 Shipment Item Line].[Fault Area Code]
       ,[Fault Area].[Code]
FROM
       [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Fault Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fault Area]
              ON
                     [Service Shipment 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 Shipment Item Line].[Symptom Code]
       ,[Symptom Code].[Code]
FROM
       [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Symptom Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Symptom Code]
              ON
                     [Service Shipment 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 Shipment Item Line].[Resolution Code]
       ,[Resolution Code].[Code]
FROM
       [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Resolution Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resolution Code]
              ON
                     [Service Shipment Item Line].[Resolution Code] = [Resolution Code].[Code]
37Fault Comment SearchFault CommentFlowFieldBoolean4
38Resolution Comment SearchResolution CommentFlowFieldBoolean4
39Accessory Comment SearchAccessory CommentFlowFieldBoolean4
40Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Service Shipment Item Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Service Shipment Item Line].[Variant Code] = [Item Variant].[Code]
42Actual Response Time (Hours) SearchActual Response Time (Hours)NormalDecimal12Actual Response Time (Hours)decimal(38,38)
44Service Price Adjmt. Gr. Code SearchService Price Adjmt. Gr. CodeNormalCode10Service Price Adjmt_ Gr_ Codenvarchar(20)
Key to join to the Service Price Adjustment Group table.

Show/hide example query

SELECT
       [Service Shipment Item Line].[Service Price Adjmt_ Gr_ Code]
       ,[Service Price Adjustment Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Service Price Adjustment Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Price Adjustment Group]
              ON
                     [Service Shipment Item Line].[Service 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
64Ship-to Code SearchShip-to CodeNormalCode10Ship-to Codenvarchar(20)
Key to join to the Ship-to Address table.

Show/hide example query

SELECT
       [Service Shipment Item Line].[Ship-to Code]
       ,[Ship-to Address].[Code]
FROM
       [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
              ON
                     [Service Shipment 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 Shipment Item Line].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Service Shipment Item Line].[Customer No_] = [Customer].[No_]
91Date Filter SearchDate FilterFlowFilterDate4
92Resource Filter SearchResource FilterFlowFilterCode20
93Allocation Date Filter SearchAllocation Date FilterFlowFilterDate4
95Resource Group Filter SearchResource Group FilterFlowFilterCode20
97Responsibility Center SearchResponsibility CenterNormalCode10Responsibility Centernvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

SELECT
       [Service Shipment Item Line].[Responsibility Center]
       ,[Responsibility Center].[Code]
FROM
       [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
              ON
                     [Service Shipment Item Line].[Responsibility Center] = [Responsibility Center].[Code]
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Service Shipment Item Line].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Service Shipment 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 Shipment Item Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Shipment 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 Shipment Item Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Shipment Item Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Service Shipment Item Line table

Responsibility CenterShip-to Address
Dynamics 365 BC Table ReferenceTablesCompany TablesSService Shipment Item Line

Leave a Reply

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