Service 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
   [timestamp]
   ,[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_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Service Shipment Item Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Service Shipment Item Line].[Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Shipment Item Line].[Customer No_] = [Customer].[No_]

Show/hide columns in Service Shipment Item Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Service Item No_ Searchnvarchar(40)
5Service Item Group Code Searchnvarchar(20)
6Item No_ Searchnvarchar(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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Service Shipment Item Line].[Item No_] = [Item].[No_]
7Serial No_ Searchnvarchar(100)
8Description Searchnvarchar(200)
9Description 2 Searchnvarchar(100)
10Priority Searchint
11Response Time (Hours) Searchdecimal(38,38)
12Response Date Searchdatetime
13Response Time Searchdatetime
14Starting Date Searchdatetime
15Starting Time Searchdatetime
16Finishing Date Searchdatetime
17Finishing Time Searchdatetime
18Service Shelf No_ Searchnvarchar(20)
19Warranty Starting Date (Parts) Searchdatetime
20Warranty Ending Date (Parts) Searchdatetime
21Warranty Searchtinyint
22Warranty _ (Parts) Searchdecimal(38,38)
23Warranty _ (Labor) Searchdecimal(38,38)
24Warranty Starting Date (Labor) Searchdatetime
25Warranty Ending Date (Labor) Searchdatetime
26Contract No_ Searchnvarchar(40)
27Loaner No_ Searchnvarchar(40)
28Vendor No_ Searchnvarchar(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_]
29Vendor Item No_ Searchnvarchar(100)
30Fault Reason Code Searchnvarchar(20)
31Service Price Group Code Searchnvarchar(20)
32Fault Area Code Searchnvarchar(20)
33Symptom Code Searchnvarchar(20)
34Fault Code Searchnvarchar(20)
35Resolution Code Searchnvarchar(20)
36Variant Code Searchnvarchar(20)
37Actual Response Time (Hours) Searchdecimal(38,38)
38Service Price Adjmt_ Gr_ Code Searchnvarchar(20)
39Adjustment Type Searchint
40Base Amount to Adjust Searchdecimal(38,38)
41Ship-to Code Searchnvarchar(20)
42Customer No_ Searchnvarchar(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_]
43Responsibility Center Searchnvarchar(20)
44Dimension Set ID Searchint
45$systemId Searchuniqueidentifier
46$systemCreatedAt Searchdatetime
47$systemCreatedBy Searchuniqueidentifier
48$systemModifiedAt Searchdatetime
49$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Service Shipment Item Line table

Leave a Reply

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