Standard Service Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SStandard Service Line

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

Table Type: Company

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

Table Number: 5997

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Standard Service Code]
   ,[Line No_]
   ,[Type]
   ,[No_]
   ,[Description]
   ,[Quantity]
   ,[Amount Excl_ VAT]
   ,[Unit of Measure Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Variant Code]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Standard Service 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_$Standard Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Service Line]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Standard Service Line].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Standard Service Line table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Standard Service Code	nvarchar(20)
3	Line No_	int
4	Type	int
5	No_	nvarchar(40)
6	Description	nvarchar(200)
7	Quantity	decimal(38,38)
8	Amount Excl_ VAT	decimal(38,38)
9	Unit of Measure Code	nvarchar(20)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Standard Service Line].[Unit of Measure Code] ,[Unit of Measure].[Code] FROM [CRONUS UK Ltd_$Standard Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Service Line] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Standard Service Line].[Unit of Measure Code] = [Unit of Measure].[Code]
10	Shortcut Dimension 1 Code	nvarchar(40)
11	Shortcut Dimension 2 Code	nvarchar(40)
12	Variant Code	nvarchar(20)
13	Dimension Set ID	int
14	$systemId	uniqueidentifier
15	$systemCreatedAt	datetime
16	$systemCreatedBy	uniqueidentifier
17	$systemModifiedAt	datetime
18	$systemModifiedBy	uniqueidentifier