Sales Cycle Stage – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SSales Cycle Stage

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

Table Type: Company

Table Name: Sales Cycle Stage
Database Table Name: CRONUS UK Ltd_$Sales Cycle Stage$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5091

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 Sales Cycle Stage can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Sales Cycle Stage$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Sales Cycle Code]
   ,[Stage]
   ,[Description]
   ,[Completed _]
   ,[Activity Code]
   ,[Quote Required]
   ,[Allow Skip]
   ,[Date Formula]
   ,[Chances of Success _]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Sales Cycle Stage$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Sales Cycle Stage$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cycle Stage]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Cycle$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cycle]
      ON
         [Sales Cycle Stage].[Sales Cycle Code] = [Sales Cycle].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Activity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Activity]
      ON
         [Sales Cycle Stage].[Activity Code] = [Activity].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Sales Cycle Stage].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Sales Cycle Stage].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Sales Cycle Stage table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Sales Cycle Code	Sales Cycle Code	Normal	Code	10	Sales Cycle Code	nvarchar(20)
	Key to join to the Sales Cycle table. Show/hide example query SELECT [Sales Cycle Stage].[Sales Cycle Code] ,[Sales Cycle].[Code] FROM [CRONUS UK Ltd_$Sales Cycle Stage$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cycle Stage] LEFT JOIN [CRONUS UK Ltd_$Sales Cycle$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cycle] ON [Sales Cycle Stage].[Sales Cycle Code] = [Sales Cycle].[Code]
2	Stage	Stage	Normal	Integer	4	Stage	int
3	Description	Description	Normal	Text	100	Description	nvarchar(200)
4	Completed %	Completed %	Normal	Decimal	12	Completed _	decimal(38,38)
5	Activity Code	Activity Code	Normal	Code	10	Activity Code	nvarchar(20)
	Key to join to the Activity table. Show/hide example query SELECT [Sales Cycle Stage].[Activity Code] ,[Activity].[Code] FROM [CRONUS UK Ltd_$Sales Cycle Stage$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cycle Stage] LEFT JOIN [CRONUS UK Ltd_$Activity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Activity] ON [Sales Cycle Stage].[Activity Code] = [Activity].[Code]
6	Quote Required	Quote Required	Normal	Boolean	4	Quote Required	tinyint
7	Allow Skip	Allow Skip	Normal	Boolean	4	Allow Skip	tinyint
8	Comment	Comment	FlowField	Boolean	4
9	No. of Opportunities	No. of Opportunities	FlowField	Integer	4
10	Estimated Value (LCY)	Estimated Value ($)	FlowField	Decimal	12
11	Calcd. Current Value (LCY)	Calcd. Current Value ($)	FlowField	Decimal	12
12	Average No. of Days	Average No. of Days	FlowField	Decimal	12
13	Date Filter	Date Filter	FlowFilter	Date	4
14	Date Formula	Date Formula	Normal	DateFormula	32	Date Formula	varchar(32)
15	Chances of Success %	Chances of Success %	Normal	Decimal	12	Chances of Success _	decimal(38,38)
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 [Sales Cycle Stage].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Sales Cycle Stage$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cycle Stage] LEFT JOIN [User] AS [User] ON [Sales Cycle Stage].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier