Service Shipment Item Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SService 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	No.	No.	Normal	Code	20	No_	nvarchar(40)
2	Line No.	Line No.	Normal	Integer	4	Line No_	int
3	Service Item No.	Service Item No.	Normal	Code	20	Service 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_]
4	Service Item Group Code	Service Item Group Code	Normal	Code	10	Service Item Group Code	nvarchar(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]
5	Item No.	Item No.	Normal	Code	20	Item 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_]
6	Serial No.	Serial No.	Normal	Code	50	Serial No_	nvarchar(100)
7	Description	Description	Normal	Text	100	Description	nvarchar(200)
8	Description 2	Description 2	Normal	Text	50	Description 2	nvarchar(100)
10	Priority	Priority	Normal	Option	4	Priority	int
	Available options are: “Low” “Medium” “High”
11	Response Time (Hours)	Response Time (Hours)	Normal	Decimal	12	Response Time (Hours)	decimal(38,38)
12	Response Date	Response Date	Normal	Date	4	Response Date	datetime
13	Response Time	Response Time	Normal	Time	4	Response Time	datetime
14	Starting Date	Starting Date	Normal	Date	4	Starting Date	datetime
15	Starting Time	Starting Time	Normal	Time	4	Starting Time	datetime
16	Finishing Date	Finishing Date	Normal	Date	4	Finishing Date	datetime
17	Finishing Time	Finishing Time	Normal	Time	4	Finishing Time	datetime
18	Service Shelf No.	Service Shelf No.	Normal	Code	10	Service 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_]
19	Warranty Starting Date (Parts)	Warranty Starting Date (Parts)	Normal	Date	4	Warranty Starting Date (Parts)	datetime
20	Warranty Ending Date (Parts)	Warranty Ending Date (Parts)	Normal	Date	4	Warranty Ending Date (Parts)	datetime
21	Warranty	Warranty	Normal	Boolean	4	Warranty	tinyint
22	Warranty % (Parts)	Warranty % (Parts)	Normal	Decimal	12	Warranty _ (Parts)	decimal(38,38)
23	Warranty % (Labor)	Warranty % (Labor)	Normal	Decimal	12	Warranty _ (Labor)	decimal(38,38)
24	Warranty Starting Date (Labor)	Warranty Starting Date (Labor)	Normal	Date	4	Warranty Starting Date (Labor)	datetime
25	Warranty Ending Date (Labor)	Warranty Ending Date (Labor)	Normal	Date	4	Warranty Ending Date (Labor)	datetime
26	Contract No.	Contract No.	Normal	Code	20	Contract No_	nvarchar(40)
27	Location of Service Item	Location of Service Item	FlowField	Text	30
28	Loaner No.	Loaner No.	Normal	Code	20	Loaner 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_]
29	Vendor No.	Vendor No.	Normal	Code	20	Vendor 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_]
30	Vendor Item No.	Vendor Item No.	Normal	Text	50	Vendor Item No_	nvarchar(100)
31	Fault Reason Code	Fault Reason Code	Normal	Code	10	Fault Reason Code	nvarchar(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]
32	Service Price Group Code	Service Price Group Code	Normal	Code	10	Service Price Group Code	nvarchar(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]
33	Fault Area Code	Fault Area Code	Normal	Code	10	Fault Area Code	nvarchar(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]
34	Symptom Code	Symptom Code	Normal	Code	10	Symptom Code	nvarchar(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]
35	Fault Code	Fault Code	Normal	Code	10	Fault Code	nvarchar(20)
36	Resolution Code	Resolution Code	Normal	Code	10	Resolution Code	nvarchar(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]
37	Fault Comment	Fault Comment	FlowField	Boolean	4
38	Resolution Comment	Resolution Comment	FlowField	Boolean	4
39	Accessory Comment	Accessory Comment	FlowField	Boolean	4
40	Variant Code	Variant Code	Normal	Code	10	Variant Code	nvarchar(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]
42	Actual Response Time (Hours)	Actual Response Time (Hours)	Normal	Decimal	12	Actual Response Time (Hours)	decimal(38,38)
44	Service Price Adjmt. Gr. Code	Service Price Adjmt. Gr. Code	Normal	Code	10	Service Price Adjmt_ Gr_ Code	nvarchar(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]
45	Adjustment Type	Adjustment Type	Normal	Option	4	Adjustment Type	int
	Available options are: “Fixed” “Maximum” “Minimum”
46	Base Amount to Adjust	Base Amount to Adjust	Normal	Decimal	12	Base Amount to Adjust	decimal(38,38)
60	No. of Active/Finished Allocs	No. of Active/Finished Allocs	FlowField	Integer	4
64	Ship-to Code	Ship-to Code	Normal	Code	10	Ship-to Code	nvarchar(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]
65	Customer No.	Customer No.	Normal	Code	20	Customer 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_]
91	Date Filter	Date Filter	FlowFilter	Date	4
92	Resource Filter	Resource Filter	FlowFilter	Code	20
	Key to join to the Resource table. Show/hide example query SELECT [Service Shipment Item Line].[] ,[Resource].[No_] FROM [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line] LEFT JOIN [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource] ON [Service Shipment Item Line].[] = [Resource].[No_]
93	Allocation Date Filter	Allocation Date Filter	FlowFilter	Date	4
95	Resource Group Filter	Resource Group Filter	FlowFilter	Code	20
	Key to join to the Resource Group table. Show/hide example query SELECT [Service Shipment Item Line].[] ,[Resource Group].[No_] FROM [CRONUS UK Ltd_$Service Shipment Item Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Item Line] LEFT JOIN [CRONUS UK Ltd_$Resource Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource Group] ON [Service Shipment Item Line].[] = [Resource Group].[No_]
97	Responsibility Center	Responsibility Center	Normal	Code	10	Responsibility Center	nvarchar(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]
480	Dimension Set ID	Dimension Set ID	Normal	Integer	4	Dimension Set ID	int
	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	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Service Shipment Item Line table

Dynamics 365 BC Table Reference Tables Company Tables SService Shipment Item Line

Leave a Reply Cancel reply