Capacity Constrained Resource – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCapacity Constrained Resource

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

Table Type: Company

Table Name: Capacity Constrained Resource
Database Table Name: CRONUS UK Ltd_$Capacity Constrained Resource$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 99000866

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 Capacity Constrained Resource can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Capacity Constrained Resource$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Capacity No_]
   ,[Capacity Type]
   ,[Name]
   ,[Critical Load _]
   ,[Dampener (_ of Total Capacity)]
   ,[Work Center No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Capacity Constrained Resource$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [] AS [Capacity Constrained Resource]
LEFT JOIN
   [CRONUS UK Ltd_$Work Shift$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Shift]
      ON
         [Capacity Constrained Resource].[Work Shift Filter] = [Work Shift].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Capacity Constrained Resource].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Capacity Constrained Resource].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Capacity Constrained Resource table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Capacity No.	Capacity No.	Normal	Code	20	Capacity No_	nvarchar(40)
2	Capacity Type	Capacity Type	Normal	Option	4	Capacity Type	int
	Available options are: “Work Center” “Machine Center”
3	Name	Name	Normal	Text	100	Name	nvarchar(200)
10	Critical Load %	Critical Load %	Normal	Decimal	12	Critical Load _	decimal(38,38)
11	Dampener (% of Total Capacity)	Dampener (% of Total Capacity)	Normal	Decimal	12	Dampener (_ of Total Capacity)	decimal(38,38)
14	Work Center No.	Work Center No.	Normal	Code	20	Work Center No_	nvarchar(40)
	Key to join to the Work Center table. Show/hide example query SELECT [Capacity Constrained Resource].[Work Center No_] ,[Work Center].[No_] FROM [CRONUS UK Ltd_$Capacity Constrained Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Constrained Resource] LEFT JOIN [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center] ON [Capacity Constrained Resource].[Work Center No_] = [Work Center].[No_]
39	Date Filter	Date Filter	FlowFilter	Date	4
40	Work Shift Filter	Work Shift Filter	FlowFilter	Code	10
	Key to join to the Work Shift table. Show/hide example query SELECT [Capacity Constrained Resource].[] ,[Work Shift].[Code] FROM [CRONUS UK Ltd_$Capacity Constrained Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Constrained Resource] LEFT JOIN [CRONUS UK Ltd_$Work Shift$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Shift] ON [Capacity Constrained Resource].[] = [Work Shift].[Code]
42	Capacity (Effective)	Capacity (Effective)	FlowField	Decimal	12
44	Prod. Order Need Qty.	Prod. Order Need Qty.	FlowField	Decimal	12
46	Work Center Load Qty.	Work Center Load Qty.	FlowField	Decimal	12
48	Prod. Order Need Qty. for Plan	Prod. Order Need Qty. for Plan	FlowField	Decimal	12
49	Work Center Load Qty. for Plan	Work Center Load Qty. for Plan	FlowField	Decimal	12
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 [Capacity Constrained Resource].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Capacity Constrained Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Constrained Resource] LEFT JOIN [User] AS [User] ON [Capacity Constrained Resource].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier