Service Shipment Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SService Shipment Line

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

Table Type: Company

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

Table Number: 5991

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Document No_]
   ,[Line No_]
   ,[Customer No_]
   ,[Type]
   ,[No_]
   ,[Location Code]
   ,[Posting Group]
   ,[Description]
   ,[Description 2]
   ,[Unit of Measure]
   ,[Quantity]
   ,[Unit Price]
   ,[Unit Cost (LCY)]
   ,[VAT _]
   ,[Line Discount _]
   ,[Allow Invoice Disc_]
   ,[Gross Weight]
   ,[Net Weight]
   ,[Units per Parcel]
   ,[Unit Volume]
   ,[Appl_-to Item Entry]
   ,[Item Shpt_ Entry No_]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Customer Price Group]
   ,[Work Type Code]
   ,[Qty_ Shipped Not Invoiced]
   ,[Quantity Invoiced]
   ,[Order No_]
   ,[Order Line No_]
   ,[Bill-to Customer No_]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[VAT Calculation Type]
   ,[Transaction Type]
   ,[Transport Method]
   ,[Attached to Line No_]
   ,[Exit Point]
   ,[Area]
   ,[Transaction Specification]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Currency Code]
   ,[VAT Base Amount]
   ,[Unit Cost]
   ,[Dimension Set ID]
   ,[Time Sheet No_]
   ,[Time Sheet Line No_]
   ,[Time Sheet Date]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[Quantity (Base)]
   ,[Qty_ Shipped Not Invd_ (Base)]
   ,[Qty_ Invoiced (Base)]
   ,[Responsibility Center]
   ,[Item Category Code]
   ,[Nonstock]
   ,[Product Group Code]
   ,[Correction]
   ,[Appl_-to Warranty Entry]
   ,[Service Item No_]
   ,[Appl_-to Service Entry]
   ,[Service Item Line No_]
   ,[Service Item Serial No_]
   ,[Service Item Line Description]
   ,[Posting Date]
   ,[Order Date]
   ,[Needed by Date]
   ,[Ship-to Code]
   ,[Quantity Consumed]
   ,[Qty_ Consumed (Base)]
   ,[Service Price Group Code]
   ,[Fault Area Code]
   ,[Symptom Code]
   ,[Fault Code]
   ,[Resolution Code]
   ,[Exclude Warranty]
   ,[Warranty]
   ,[Contract No_]
   ,[Contract Disc_ _]
   ,[Warranty Disc_ _]
   ,[Component Line No_]
   ,[Spare Part Action]
   ,[Fault Reason Code]
   ,[Replaced Item No_]
   ,[Exclude Contract Discount]
   ,[Replaced Item Type]
   ,[Price Adjmt_ Status]
   ,[Line Discount Type]
   ,[Copy Components From]
   ,[Return Reason Code]
   ,[Price Calculation Method]
   ,[Allow Line Disc_]
   ,[Customer Disc_ Group]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Service Shipment 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 Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Shipment Line].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Service Shipment Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Service Shipment Line].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Shipment Line].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Service Shipment Line].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Service Shipment Line].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Service Shipment Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Service Shipment Line].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Service Shipment Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Service Shipment Line].[Product Group Code] = [Product Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
      ON
         [Service Shipment Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]

Show/hide columns in Service Shipment Line table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Document No_	nvarchar(40)
3	Line No_	int
4	Customer No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [Service Shipment Line].[Customer No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Service Shipment Line].[Customer No_] = [Customer].[No_]
5	Type	int
6	No_	nvarchar(40)
7	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Service Shipment Line].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Service Shipment Line].[Location Code] = [Location].[Code]
8	Posting Group	nvarchar(40)
9	Description	nvarchar(200)
10	Description 2	nvarchar(100)
11	Unit of Measure	nvarchar(100)
12	Quantity	decimal(38,38)
13	Unit Price	decimal(38,38)
14	Unit Cost (LCY)	decimal(38,38)
15	VAT _	decimal(38,38)
16	Line Discount _	decimal(38,38)
17	Allow Invoice Disc_	tinyint
18	Gross Weight	decimal(38,38)
19	Net Weight	decimal(38,38)
20	Units per Parcel	decimal(38,38)
21	Unit Volume	decimal(38,38)
22	Appl_-to Item Entry	int
23	Item Shpt_ Entry No_	int
24	Shortcut Dimension 1 Code	nvarchar(40)
25	Shortcut Dimension 2 Code	nvarchar(40)
26	Customer Price Group	nvarchar(20)
	Key to join to the Customer Price Group table. Show/hide example query SELECT [Service Shipment Line].[Customer Price Group] ,[Customer Price Group].[Code] FROM [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group] ON [Service Shipment Line].[Customer Price Group] = [Customer Price Group].[Code]
27	Work Type Code	nvarchar(20)
28	Qty_ Shipped Not Invoiced	decimal(38,38)
29	Quantity Invoiced	decimal(38,38)
30	Order No_	nvarchar(40)
31	Order Line No_	int
32	Bill-to Customer No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [Service Shipment Line].[Bill-to Customer No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Service Shipment Line].[Bill-to Customer No_] = [Customer].[No_]
33	Gen_ Bus_ Posting Group	nvarchar(40)
34	Gen_ Prod_ Posting Group	nvarchar(40)
35	VAT Calculation Type	int
36	Transaction Type	nvarchar(20)
37	Transport Method	nvarchar(20)
38	Attached to Line No_	int
39	Exit Point	nvarchar(20)
40	Area	nvarchar(20)
41	Transaction Specification	nvarchar(20)
42	Tax Area Code	nvarchar(40)
	Key to join to the Tax Area table. Show/hide example query SELECT [Service Shipment Line].[Tax Area Code] ,[Tax Area].[Code] FROM [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area] ON [Service Shipment Line].[Tax Area Code] = [Tax Area].[Code]
43	Tax Liable	tinyint
44	Tax Group Code	nvarchar(40)
	Key to join to the Tax Group table. Show/hide example query SELECT [Service Shipment Line].[Tax Group Code] ,[Tax Group].[Code] FROM [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group] ON [Service Shipment Line].[Tax Group Code] = [Tax Group].[Code]
45	VAT Bus_ Posting Group	nvarchar(40)
46	VAT Prod_ Posting Group	nvarchar(40)
47	Currency Code	nvarchar(20)
	Key to join to the Currency table. Show/hide example query SELECT [Service Shipment Line].[Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Service Shipment Line].[Currency Code] = [Currency].[Code]
48	VAT Base Amount	decimal(38,38)
49	Unit Cost	decimal(38,38)
50	Dimension Set ID	int
51	Time Sheet No_	nvarchar(40)
52	Time Sheet Line No_	int
53	Time Sheet Date	datetime
54	Variant Code	nvarchar(20)
55	Bin Code	nvarchar(40)
56	Qty_ per Unit of Measure	decimal(38,38)
57	Unit of Measure Code	nvarchar(20)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Service Shipment Line].[Unit of Measure Code] ,[Unit of Measure].[Code] FROM [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Service Shipment Line].[Unit of Measure Code] = [Unit of Measure].[Code]
58	Quantity (Base)	decimal(38,38)
59	Qty_ Shipped Not Invd_ (Base)	decimal(38,38)
60	Qty_ Invoiced (Base)	decimal(38,38)
61	Responsibility Center	nvarchar(20)
62	Item Category Code	nvarchar(40)
	Key to join to the Item Category table. Show/hide example query SELECT [Service Shipment Line].[Item Category Code] ,[Item Category].[Code] FROM [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category] ON [Service Shipment Line].[Item Category Code] = [Item Category].[Code]
63	Nonstock	tinyint
64	Product Group Code	nvarchar(20)
	Key to join to the Product Group table. Show/hide example query SELECT [Service Shipment Line].[Product Group Code] ,[Product Group].[Code] FROM [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group] ON [Service Shipment Line].[Product Group Code] = [Product Group].[Code]
65	Correction	tinyint
66	Appl_-to Warranty Entry	int
67	Service Item No_	nvarchar(40)
68	Appl_-to Service Entry	int
69	Service Item Line No_	int
70	Service Item Serial No_	nvarchar(100)
71	Service Item Line Description	nvarchar(200)
72	Posting Date	datetime
73	Order Date	datetime
74	Needed by Date	datetime
75	Ship-to Code	nvarchar(20)
76	Quantity Consumed	decimal(38,38)
77	Qty_ Consumed (Base)	decimal(38,38)
78	Service Price Group Code	nvarchar(20)
79	Fault Area Code	nvarchar(20)
80	Symptom Code	nvarchar(20)
81	Fault Code	nvarchar(20)
82	Resolution Code	nvarchar(20)
83	Exclude Warranty	tinyint
84	Warranty	tinyint
85	Contract No_	nvarchar(40)
86	Contract Disc_ _	decimal(38,38)
87	Warranty Disc_ _	decimal(38,38)
88	Component Line No_	int
89	Spare Part Action	int
90	Fault Reason Code	nvarchar(20)
91	Replaced Item No_	nvarchar(40)
92	Exclude Contract Discount	tinyint
93	Replaced Item Type	int
94	Price Adjmt_ Status	int
95	Line Discount Type	int
96	Copy Components From	int
97	Return Reason Code	nvarchar(20)
98	Price Calculation Method	int
99	Allow Line Disc_	tinyint
100	Customer Disc_ Group	nvarchar(40)
	Key to join to the Customer Discount Group table. Show/hide example query SELECT [Service Shipment Line].[Customer Disc_ Group] ,[Customer Discount Group].[No_] FROM [CRONUS UK Ltd_$Service Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group] ON [Service Shipment Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]
101	$systemId	uniqueidentifier
102	$systemCreatedAt	datetime
103	$systemCreatedBy	uniqueidentifier
104	$systemModifiedAt	datetime
105	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Service Shipment Line table

Currency Customer Customer Discount Group Customer Price Group Item Category Location Product Group Tax Area Tax Group Unit of Measure

Dynamics 365 BC Table Reference Tables Company Tables SService Shipment Line

Leave a Reply Cancel reply